One table, one view
Anyone who invoices customers eventually asks the same question: who owes me money, and for how long? A receivables ageing table answers it at a glance. It groups outstanding amounts by how overdue they are, so older, riskier items stand out from the recent ones.
It can be built in a spreadsheet or a notes document in half an hour, and updated weekly in minutes.
The five columns
| Customer | Not yet due | 1-30 days late | 31-60 days late | Over 60 days late |
|---|---|---|---|---|
| Customer A | 12,000 | 0 | 0 | 0 |
| Customer B | 0 | 8,500 | 0 | 0 |
| Customer C | 0 | 0 | 15,000 | 4,000 |
| Total | 12,000 | 8,500 | 15,000 | 4,000 |
All figures are invented. Each row is a customer, each column is an age band, and each cell sums the invoices in that band. The total row shows the overall picture.
Building it from your records
List open invoices with the customer, number, amount and due date. For each, compute days past due as of today. Assign it to a band and add up. If you record invoices in your tracking app with due dates, this is mostly a matter of filtering.
Refresh the table on a fixed day each week. The date should be at the top, so that anyone reading it knows when it was true.
Reading the table
Items in the first column are normal; your task is to ensure they are paid on time. Items in the second column deserve a gentle reminder. The third column calls for firm contact. The fourth demands a decision: escalate, restructure or consider whether the amount will ever be collected.
The shape matters as much as the numbers. A table in which most money sits in the not-yet-due column is healthy. One where the right side keeps growing signals a collection problem.
Using it for planning
The ageing table feeds cash forecasting. Expect receipts from the not-yet-due column on their due dates, perhaps with some delay. Treat amounts in the later columns with caution, and do not count on them for upcoming obligations.
If a large share of your money sits in older columns, adjust your terms: shorter payment periods, deposits up front, or limits for customers with a history of delay.
Concentration risk
Check whether a single customer accounts for a large share of the total. If so, their delay has an outsized effect on you. The table shows this clearly and prompts a conversation about diversification.
Keeping it honest
Resist the temptation to leave old items unchanged because they are uncomfortable. When an item is paid, remove it and note the payment. When it is disputed, mark it. When it is written off, record it as described in the bad debt article.
Sharing with an adviser
An up-to-date ageing table is something an adviser or lender may ask for. Having it ready, with a note of the date, shows that you manage your collections with care.
A tiny worked reading
Suppose the table shows 36,000 in total, of which 12,000 is not yet due, 8,500 is up to a month late and 15,500 is further behind. Nearly half the money is overdue. Without the table, the same total would feel like 36,000 of expected income.
With it, you can see that two customers account for most of the late money, and you can decide to call them this week rather than wait for the end of the month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

