The columns and statuses
In a QuickBooks survey of US small businesses, more than half were owed money on unpaid invoices. Most of it is not refusal; it is invoices nobody followed up. Track invoices you send here, and keep bills you pay in a separate list.
| Column | Example | Note |
|---|---|---|
| Invoice | INV-1049 | Unique; the key for everything |
| Client | Brightline Physio | The company you billed |
| [email protected] | The accounts address, not your contact | |
| Amount | 1,250 | Add currency if you bill in several |
| Sent and Due | Tuesday 3rd, Tuesday 17th | Due is sent date plus terms |
| Status | Sent | Draft, Sent, Reminded, Paid, Written off |
| Notes | Promised payment Friday | One line per contact |
How to build an invoice tracker, step by step
Step 1: Create the list
The columns above, in a sheet or a no-code app. Make Status a dropdown.
Step 2: Bring in every open invoice
Export from your invoicing or accounting app as CSV, or type them in. Open ones first; paid history can wait.
Step 3: Add a Late view
Filter: status not Paid or Written off, due date before today. Sort by due date, oldest first.
Tip. In a sheet, a Days late column does this: =IF(AND(G2<>"Paid",F2<TODAY()),TODAY()-F2,"").
Do this step in 50agents
Chase my unpaid invoices
Build itCaptain builds this tracker as an app, with To collect, Late and All invoices views, the three totals, and an AI agent that drafts a reminder for your yes. See the ready-made version.
Step 4: Add three totals
Still to collect (everything Sent or Reminded), Late, and Paid this month. Three numbers you can read in a second.
Step 5: Update it the day money lands
Check the bank or payment app and mark Paid.
Watch out. A tracker a week behind the bank sends you chasing clients who already paid.
Step 6: Decide what happens to late ones
Set a reminder schedule: see how to automate invoice reminders.
What can go wrong
Part payments marked Paid
Half arrives, the row turns green, and the rest is forgotten. Add a Part paid status and the amount still due.
Duplicate invoice numbers
Two invoices called INV-1049 after a template copy. Make the number unique and check before adding.
Receivables and bills in one list
Money in and money out get mixed up. Keep two trackers.
Due dates from the wrong terms
Net 30 for a client on Net 14. Store terms per client and compute the due date from them.
Questions people ask
What should an invoice tracker include?
Invoice number, client, billing email, amount, sent date, due date, status and notes. Add currency and amount paid if you need them.
How do I track unpaid invoices in Excel or Google Sheets?
One row per invoice with a Status dropdown, a Days late formula, and a filter view of everything not Paid with a due date before today, sorted oldest first.
Should I use my accounting app instead?
If every invoice is raised there, yes: it already tracks payments. A separate tracker earns its place when invoices come from several places or you want reminders drafted for you.
What statuses should an invoice have?
Five cover most cases: Draft, Sent, Reminded, Paid and Written off. Make Status a dropdown so the Late view and the totals stay correct.
How do I record a part payment?
Do not mark it Paid. Add the amount still due and a status for part payments, so the Late view and your reminders show what is really owed.
Should bills I pay go in the same tracker?
No. Keep invoices you send and bills you pay in separate lists. Mixed together, the totals stop meaning anything.