Invoice Tracker & Generator
Every invoice, from sent to paid, nothing falls through.
An invoice tracking spreadsheet for freelancers and small businesses who do the work, send the invoice, and then lose track of who actually paid.
Invoice Tracker & Generator is an 8-tab Excel and Google Sheets workbook. 3 you type into, 3 calculated from those and 2 you set once. No macros, so it opens without a security warning.
- Dashboard What is overdue, what was paid this period, your average days to pay, and sales tax billed.
- Dashboard (Dark) The same dashboard in a dark theme, for screens that are easier on the eyes at night.
- Invoice Log Invoice number, client, issue date, terms in days, type, payment method, location, net amount and tax rate.
Filed under invoicing & clients.
7 of the 8 tabs, exactly as they look in the file. Click a tab to look inside.
Sound familiar?
What's inside, tab by tab
You only ever type in the highlighted input cells. Everything else is calculated from what you type.
| Tab | What you do | What it does |
|---|---|---|
| Tab 1Start Here | Set once, never again | A one-page setup guide inside the workbook. Enter your basics once, in about 5 to 10 minutes. |
| Tab 2Dashboard | Calculated for you | What is overdue, what was paid this period, your average days to pay, and sales tax billed. |
| Tab 3Dashboard (Dark) | Calculated for you | The same dashboard in a dark theme, for screens that are easier on the eyes at night. |
| Tab 4Invoice Log | You type here | Invoice number, client, issue date, terms in days, type, payment method, location, net amount and tax rate. |
| Tab 5Invoice Lines | You type here | Invoice number, description, quantity and unit price. Line totals calculate. |
| Tab 6Invoice Builder | You type here | Type an invoice number and it assembles that invoice from the log and the lines. |
| Tab 7Clients | Calculated for you | Total invoiced, total outstanding, number of invoices and last invoice date, per client. |
| Tab 8Settings & Lists | Set once, never again | The dropdown lists and defaults the rest of the workbook reads. Change them once and every sheet follows. |
Want one quick number first? The free freelance rate calculator works back to the hourly rate you need to charge. It runs in your browser, no sign-up.
Built like software, priced like a spreadsheet
Enter your data; totals, flags and the dashboard update instantly.
Checked cell by cell before release. Find one and we will fix it.
Formula cells are protected. You can only type where typing is safe.
Both versions in every purchase. No converting, no broken references.
Clean report pages for your records, your accountant, or your next meeting.
Delivered by Etsy the moment you pay. Free updates to this template forever.
How it works
Secure checkout through Etsy, no account needed here.
The Excel file and the Google Sheets link arrive immediately.
Type into the highlighted cells and every total is calculated from what you typed.
Questions, answered
Do I need a paid Excel version?
Any desktop Excel from 2016 onward works, including Microsoft 365. If you don’t have Excel at all, use the included Google Sheets version. It’s free.
Does it fully work in Google Sheets?
Yes. The Google Sheets version is made from the same file as the Excel one and checked in Google Sheets before release. Every formula uses functions that work the same in both.
Is this a one-time purchase?
Yes. One payment, no subscription. You keep the files forever and get free updates to this template.
What does it not do?
It cannot email, remind or notify anyone; it shows what is due when you open it. It does not know any state's or country's sales tax rules, so you enter the rate. None of it is legal or tax advice.
What’s the refund policy?
Refunds follow Etsy’s rules for digital downloads. If a template doesn’t work as described, email support@elecart.us and we will fix it.
What if I get stuck?
Email support@elecart.us and the person who built the template answers, usually within one business day. Etsy Messages works too.
How much data can it handle?
Input tabs are sized generously and tested with full sample data: enough for years of typical use. Need more room? Duplicate the file per year, or email support for an extended version.
Every invoice, from sent to paid, nothing falls through.
$2.99, once, 70% off until Nov 28. Yours forever, with free updates.
Get it on Etsy →
