Getting paid

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.

A dashboard listing paid, due and overdue 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:

FieldExample
Invoice numberINV-0042
ClientHarbour Cafe
Issue date / due date6 Nov / 20 Nov
Amount and currencyUSD 1,420.00
StatusSent
Last follow-upReminder 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.

BucketMeaningAction
CurrentNot yet dueNone, or a friendly heads-up
1–30 daysRecently overduePolite reminder
31–60 daysSeriously overdueFirm notice and phone call
61–90 daysAt riskFinal notice, pause work
90+ daysLikely troubleEscalate or consider collections

Step 4: Set a weekly routine

  1. Pick a fixed time each week, for example Monday morning.
  2. Update statuses: mark anything newly paid.
  3. Check your bank account against the list.
  4. Send reminders for anything due soon or overdue, using templates.
  5. 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.

Frequently asked questions

How do I keep track of unpaid invoices?
Keep a single list of every invoice with its number, client, amount, due date and status, and review it once a week.
What is an accounts receivable ageing report?
A summary of unpaid invoices grouped by how overdue they are, typically current, 1–30, 31–60, 61–90 and 90+ days.
What is DSO?
Days sales outstanding: the average number of days it takes to collect payment after a sale. Lower is better.
When should I write off an unpaid invoice?
Only after reasonable collection efforts have failed. Speak to an accountant about the tax treatment of bad debts in your country.
Xinf