Accounting & Tax · 7 min read

Aged receivables: reading your invoice ledger for cash flow

Chasing invoices one at a time is reactive. Looking at all of them together tells you which to chase, which clients are quietly costing you, and how much cash you can actually expect this month.

Unpaid invoices grouped into age bands with totals for each

Most small businesses know roughly what they are owed and have a vague sense of who is slow. That vagueness is expensive. The specific version — how much, by whom, how old — takes about twenty minutes to build and usually changes what you do next.

Worked example

A studio reviews its ledger at the end of September. Total owed: 62,400.

Not yet due: 31,000 across five invoices
1–30 days: 18,200, of which 16,000 is one invoice to a long-standing client
31–60 days: 4,900 across three small invoices to one client
Over 90 days: 8,300, one invoice, client unresponsive since June

Original diagram

Aged receivables: reading your invoice ledger for cash flow workflow

1Building the view
2The number worth tracking
3Deciding what to chase
4Using the ledger to forecast

Building the view

You need six columns and nothing else:

Every unpaid row is a receivable. Group them by how far past the due date they are:

Total each band. The shape of that distribution matters more than the headline figure: 40,000 owed with almost everything in the not-yet-due band is a healthy business, while 40,000 with half of it over 60 days is a problem that has been accumulating for months.

Invoice number
Client
Issue date
Due date
Amount
Date paid (blank if unpaid)
Not yet due — expected income, no action
1–30 days overdue — usually administrative; a reminder normally resolves it
31–60 days — something is actually wrong; find out what
61–90 days — recovery is getting harder and needs a deliberate decision
Over 90 days — assume nothing will happen without escalation

The number worth tracking

Your stated payment terms are an intention. Your average days to payment is what actually happens. Calculate it simply: for every invoice paid in the last three months, count days from issue to payment, then average.

The gap between that figure and your terms is the thing you can work on. Some common causes and what each points to:

Track the average monthly. The trend tells you more than any single month's value.

A large gap across all clients — your terms are being ignored generally. Look at how quickly you invoice and whether due dates are stated as calendar dates.
A large gap driven by two or three clients — this is a client problem, not a process problem. Deal with those relationships specifically.
Consistent payment at a fixed interval unrelated to your terms — you are on a payment run. Find out the cut-off date and submit before it.

Deciding what to chase

Age alone is a poor priority order. Sort by value within each band and ask two questions about each invoice: how much is at risk, and how likely is it to be recovered with the effort available?

Set a fixed slot — an hour, once a week — and work the list in that order. Receivables work done in scattered moments of frustration is both less effective and more unpleasant than the same work done on a schedule.

Large, recently overdue, good payer — one short, specific message. This is usually an administrative block.
Large, long overdue, responsive client — get a person on a call. Written threads stall; conversations do not.
Large, long overdue, unresponsive — the highest-value use of your time. Escalate deliberately.
Small, long overdue — decide whether to pursue or close it. Leaving it open indefinitely costs attention every month for no return.

Using the ledger to forecast

A simple forecast beats no forecast. For each unpaid invoice, estimate a realistic payment date based on that client's actual history rather than the stated due date. A client who always pays at 45 days will pay at 45 days.

Add up expected receipts by week, set your known outgoings against them, and you have a usable picture four to six weeks ahead. The value is in seeing a shortfall while you still have options — invoicing something early, asking a client to pay ahead of schedule, or deferring a purchase — rather than discovering it on the day.

What the ledger reveals about clients

Reviewed over a few months, patterns become obvious: who pays on time, who always needs two reminders, who disputes something on every third invoice. That information should feed back into how you price and structure work. A client who reliably pays 40 days late is more expensive to serve than one who pays on time, and the difference can reasonably be reflected in deposits, terms or rates.

Common questions

Helpful clarifications

What is an aged receivables report?

It is a list of every unpaid invoice grouped by how long it has been outstanding, typically in bands such as not yet due, 1 to 30 days overdue, 31 to 60, and over 60. It tells you at a glance how much money is owed, how stale it is, and which clients account for the oldest balances. For most small businesses it is the single most useful financial view they can maintain.

How do I work out my average payment time?

For a simple version, take every invoice paid in the last few months, calculate the days between the issue date and the payment date for each, and average them. Compare that number with your stated terms. A business on 14-day terms averaging 38 days does not have a terms problem; it has a process problem, and the gap is what you can actually work on.

Which overdue invoices should I chase first?

Not simply the oldest. Rank by amount at risk and by how recoverable each one looks. A large invoice that is a week overdue with a client who always pays usually needs one short message. A small invoice that is four months old with an unresponsive client may need a decision about whether to keep spending time on it. Sorting by value within each age band gets you to the right order quickly.

When should I write an invoice off as bad debt?

When the realistic cost of recovery, including your time, exceeds what you expect to collect. That is a commercial judgement rather than a fixed period. The accounting and tax treatment of a written-off debt varies by jurisdiction and is worth confirming with an accountant, because in some systems relief depends on specific conditions being met and documented.

Do I need accounting software for this?

No. A spreadsheet with invoice number, client, issue date, due date, amount and date paid gives you everything described here. Software helps once volume grows or once you want the report generated automatically, but the discipline of updating the record matters far more than the tool you keep it in.