How to Track Unpaid Invoices
If you can’t say at a glance who owes you money, you will be paid late. Here is a simple system for tracking unpaid invoices.

Most businesses don’t go under because they have no sales. They struggle because cash arrives late. The simplest way to protect yourself is to know, at any moment, exactly which invoices are unpaid and how overdue they are.
Why tracking matters
- You chase sooner. The earlier you follow up, the more likely you are to be paid.
- You forecast cash. Know what is coming in and when.
- You spot problem clients before they cost you more.
- You stay organised for tax and bookkeeping.
Step 1: Record every invoice
Whether you use a spreadsheet or invoicing software, record these fields for each invoice:
| Field | Example |
|---|---|
| Invoice number | INV-0042 |
| Client | Harbour Cafe |
| Issue date / due date | 6 Nov / 20 Nov |
| Amount and currency | USD 1,420.00 |
| Status | Sent |
| Last follow-up | Reminder sent 21 Nov |
Step 2: Use clear statuses
- Draft: not yet sent.
- Sent: issued, not yet due.
- Due soon: within the next few days.
- Overdue: past due date.
- Partially paid: some money received.
- Paid: fully settled.
- Disputed or written off.
Step 3: Build an ageing report
An ageing (or aging) report groups unpaid invoices by how long they have been outstanding, so you can see where the risk is.
| Bucket | Meaning | Action |
|---|---|---|
| Current | Not yet due | None, or a friendly heads-up |
| 1–30 days | Recently overdue | Polite reminder |
| 31–60 days | Seriously overdue | Firm notice and phone call |
| 61–90 days | At risk | Final notice, pause work |
| 90+ days | Likely trouble | Escalate or consider collections |
Step 4: Set a weekly routine
- Pick a fixed time each week, for example Monday morning.
- Update statuses: mark anything newly paid.
- Check your bank account against the list.
- Send reminders for anything due soon or overdue, using templates.
- Note promised payment dates and follow up on the day.
Our late payment reminder email templates make step 4 fast.
Step 5: Watch a few key numbers
- Total outstanding: the sum of all unpaid invoices.
- Overdue amount: how much is past due.
- Average days to pay: across your last ten invoices.
- DSO (days sales outstanding): a rough measure is outstanding receivables divided by credit sales, multiplied by the days in the period.
- Concentration: how much of the money owed comes from one client.
Step 6: Reconcile payments
When money arrives, match it to the invoice using the reference. If a client pays several invoices at once or pays a different amount, note which invoices it covers. If they underpay, record the difference and follow up. Clear references help: ask clients to quote the invoice number. See invoice numbering best practices.
Step 7: Learn from late payers
If a client is repeatedly late, change how you work with them: shorter terms, a deposit, direct debit, or a pause until they catch up. Include these in your payment terms for new projects.
Mistakes to avoid
- Tracking in your head or your inbox.
- Not recording partial payments.
- Waiting more than a week after the due date to follow up.
- Ignoring small overdue amounts that add up.
Tools
A spreadsheet works for a handful of invoices. Beyond that, invoicing software that shows status, sends reminders and keeps a clean history saves time. Make sure your invoices are right the first time with our guide on invoicing mistakes to avoid.
Create your next invoice in about a minute. InvoiceKit is a free invoice maker that works in your browser: add your details, choose a template and download a PDF. Works in any currency, with tax options for GST, VAT and sales tax.


