A Simple Invoice Tracker in Google Sheets (and What to Edit)
For freelancers and solo operators who send a handful of invoices a month and just need to see what's been paid, what's due, and what's overdue.
On this page
If you send a handful of invoices a month and keep losing track of what's actually been paid, you don't need invoicing software yet. You need one clean tab that answers a single question: what is unpaid right now?
A working invoice tracker is one tab with these columns: Invoice #, Client, Amount, Sent date, Due date, Status, Paid date — plus one formula that flags anything overdue. Keep the status list fixed (Draft · Sent · Overdue · Paid) so totals stay reliable. It is a tracker, not accounting software: it won't file taxes or process payments.
This is for you if…
- You send roughly 1–30 invoices a month
- You mostly need to see what's unpaid and what's overdue
- You want a free, no-setup-fee starting point
- You're comfortable editing a few columns
Skip it if…
- You need automatic payment processing or reminders
- You handle payroll, sales tax, or audited books here
- Multiple people need different reporting and permissions
- You already pay for invoicing software that works
The columns that actually earn their place#
Most free invoice templates fail because they're built for generic products, not how you bill. Start with the smallest set of columns that answers "who owes me money?":
| Column | What goes in it | Notes |
|---|---|---|
| Invoice # | Your own sequence, e.g. 2026-014 | Keep it consistent and sortable |
| Client | Client or company name | Match the spelling you use elsewhere |
| Amount | The invoice total | Format the column as currency |
| Sent date | When you sent it | A real date, not text |
| Due date | When payment is due | Drives the overdue flag below |
| Status | Draft · Sent · Overdue · Paid | Use a dropdown, not free text |
| Paid date | When the money landed | Leave blank until paid |
| Notes | Anything human | Free text is fine here |
A status formula that flags overdue invoices#
You shouldn't mark invoices "Overdue" by hand — you'll forget. Add a helper column that compares the due date to today, but only for invoices that aren't paid yet:
=IF(F2="Paid","Paid",IF(AND(E2<>"",E2<TODAY()),"Overdue","On track"))Reading it plainly: if the Status in F2 is already Paid, show Paid. Otherwise, if there's a due date in E2 and it's before today, show Overdue. If not, show On track. Drag it down the column — TODAY() updates every day the sheet opens.
Want the total you owe yourself?
Add a one-line total for everything still unpaid with =SUMIF(F2:F,"<>Paid",C2:C) — it sums the Amount column for every row whose Status isn't Paid. Put it on your dashboard tab, not in the middle of the data.
What to edit, and what not to touch#
| Safe to edit | Leave it alone |
|---|---|
| Column headers and order | The status helper formula (until you understand it) |
| The Status dropdown values (in your Lookup tab) | Any cell showing a calculated total |
| Currency and date formatting | The TODAY() reference inside the formula |
| Adding a Notes or PO-number column | Merged cells (they break sorting and filters) |
The rule: don't delete a formula cell until you know what total it feeds. If a number looks wrong after an edit, check version history before rebuilding anything.
When a tracker isn't enough#
When to consider real invoicing software
A spreadsheet tracker is fine until you need things a spreadsheet shouldn't do:
- You want clients to pay from the invoice — you need payment processing, not a sheet.
- You're chasing payment constantly — automated reminders save real time.
- Tax or bookkeeping depends on these numbers — use accounting software or a professional; this tracker is for organisation only.
If none of those apply, you don't need to buy anything yet. Compare the upgrade thresholds before you pay for a tool.
Build it in the next five minutes#
Make a copy of your workbook, add the eight columns above to a fresh Invoices tab, and enter one real invoice as a sample row. Then read the small-business setup guide to connect it to the rest of your workbook.
Questions people ask
Is a Google Sheets invoice tracker the same as invoicing software?
How do I automatically mark invoices overdue?
Can I use this for taxes?
We aim to keep this accurate and date-stamp it when product steps change. We don't claim hands-on product testing we haven't done, and we'll always point to the free, native route first. How we work.