
An aged debtors report lists every invoice your customers have not yet paid, sorted by how long each one has been outstanding. It tells you who owes what, who is drifting late, and which balances may never come in. Read monthly, it is the simplest early warning a small business has for cash flow problems.
The report itself takes seconds to run in any accounting package. The value comes from reading it properly, checking that its total agrees with your books, and acting on what it shows before a slow payer becomes a write-off.
Key takeaways
- The report groups unpaid customer invoices into age bands, usually current, 1โ30, 31โ60, 61โ90 and over 90 days.
- Its total should equal the trade debtors figure on your balance sheet for the same date.
- Unallocated payments and credit notes are the main reasons it looks wrong.
- Each band calls for a different action, from a polite reminder to a formal claim.
- Debts over six months overdue may qualify for VAT bad debt relief if you use standard VAT accounting.
What is an aged debtors report?
An aged debtors report, also called aged receivables, is a schedule of money owed to your business by customers on a particular date, broken down by the age of each unpaid invoice. The total represents your trade debtors. Its counterpart, aged creditors, shows what you owe suppliers.
The report is only as good as the sales ledger behind it. If invoices are raised late or payments are not matched to them, the ageing becomes unreliable. Our guide to sales and purchase ledgers explains how the ledger feeds it.
Worked example: reading a real-looking report
Illustrative example. An invented commercial cleaning company, customer names replaced with letters, figures made up. Report date 31 October 2026, aged by due date.
| Customer | Not yet due | 1โ30 days | 31โ60 days | 61โ90 days | 90+ days | Total |
|---|---|---|---|---|---|---|
| Customer A | 3,600 | 3,600 | 0 | 0 | 0 | 7,200 |
| Customer B | 1,150 | 0 | 0 | 0 | 0 | 1,150 |
| Customer C | 0 | 840 | 840 | 840 | 0 | 2,520 |
| Customer D | 0 | 0 | 0 | 0 | 1,980 | 1,980 |
| Customer E | -300 | 0 | 0 | 0 | 0 | -300 |
| Total | 4,450 | 4,440 | 840 | 840 | 1,980 | 12,550 |
Here is how a practitioner would read it:
- Customer A is the biggest balance, but only one month is overdue. A friendly reminder is enough, though concentration risk is worth noting: over half the total sits with one client.
- Customer C has paid nothing for three months in a row. That pattern, rather than the amount, is the warning sign. Pause further work until the account is brought up to date.
- Customer D is over 90 days and probably needs formal action, or a decision on whether it is recoverable.
- Customer E shows a credit. Either they overpaid, or a payment has not been matched to an invoice. Investigate before the next month-end.
Overall, about 29% of the balance is more than 30 days overdue (ยฃ3,660 of ยฃ12,550). Tracking that percentage each month tells you more than the total alone.
Why does the report total not match the balance sheet?
The aged debtors total and the trade debtors line on the balance sheet should agree on the same date. When they do not, the cause is almost always one of a few bookkeeping gaps rather than a software fault, and each one can be found by a quick check.
- Unallocated receipts. A payment posted to the customer but not matched to an invoice leaves the invoice showing as overdue.
- Loose credit notes. A credit note not applied to the invoice it relates to sits as a separate negative line.
- Date mismatch. The report and balance sheet were run for different dates, or an invoice is dated after the report date.
- Journals to debtors. A manual journal posted straight to the debtors control account will not appear against any customer.
What should you do with each age band?
Each band calls for a different response. Early bands need routine reminders; later bands need decisions about stopping work, adding interest or writing the debt off. Writing these steps down once saves arguing with yourself every month.
| Age band | Typical action | Bookkeeping or tax point |
|---|---|---|
| Not yet due | None; make sure invoices went out promptly | Check invoice dates match the work done |
| 1โ30 days | Polite reminder with a copy invoice | Match any part payments straight away |
| 31โ60 days | Phone call; agree a payment date in writing | Note disputes so they are not double-counted |
| 61โ90 days | Consider pausing work; final reminder; mention statutory interest | Review whether a provision is needed at year end |
| 90+ days | Letter before action, small claim or debt agency | Decide whether to write off; diary VAT bad debt relief at six months overdue |
Business-to-business debts can carry statutory interest and fixed compensation under the late payment rules; GOV.UK explains how to charge interest on late commercial payments, and our guide on chasing late payments shows how to use it without wrecking a good relationship.
How does the report connect to VAT bad debt relief?
If you use standard VAT accounting, you pay VAT on invoices whether or not the customer pays. Once a debt is more than six months overdue, you have paid that VAT and written the debt off in your records, you can usually claim the VAT back. Your aged debtors report is the natural place to spot these debts.
HMRC sets out the conditions and record-keeping in VAT Notice 700/18 on bad debt relief. If you are on the VAT cash accounting scheme, unpaid invoices were never included in a return, so there is nothing to reclaim. For the accounting side, our guide on writing off a bad debt covers the entries.
A monthly aged debtors routine
- Post all sales invoices and credit notes up to the month-end date.
- Reconcile the bank, then match every customer receipt to the invoice it pays.
- Run the aged debtors report and the balance sheet for the same date and compare the totals.
- Explain any difference using the four checks above.
- Work through the bands from oldest to newest, deciding the next action for each customer.
- Record promised payment dates and disputes in the customer notes.
- Flag any debt approaching six months overdue for a VAT and write-off review.
- Note the overdue percentage and compare it with last month.
Common mistakes
- Ignoring negative balances. Credits on customer accounts usually mean the ledger is wrong somewhere else too.
- Switching between invoice-date and due-date ageing. The bands change and month-on-month comparisons stop working.
- Leaving dead debts on the report. A balance you will never collect overstates your assets and your profit.
- Chasing only the largest balances. A small customer three months behind can be a bigger risk than a large one a week late.
- Missing the VAT angle. Under standard accounting, VAT already paid on unpaid invoices can often be recovered once the six-month point passes.
Want a clean aged debtors report every month, with receipts matched and problem accounts flagged? Our bookkeeping service starts from ยฃ150 a month, and all fees are on our pricing page. Get in touch to see how it would work for your business.
Frequently Asked Questions
What is an aged debtors report?
It is a list of every unpaid customer invoice on a chosen date, grouped by how long each one has been outstanding, usually in 30-day bands. It shows who owes you money, how much, and how late they are, so you can decide who to chase first and spot debts that may never be paid.
Should invoices be aged from the invoice date or the due date?
Due date is more useful for chasing, because it shows how overdue a customer actually is. Invoice date is useful for judging your credit terms. Most software lets you choose. Whatever you pick, use the same setting every month, otherwise the bands will shift and trends become meaningless.
Why doesn't my aged debtors total match the balance sheet?
The usual causes are customer payments not matched to invoices, credit notes left unallocated, invoices dated after the report date, or journals posted straight to the debtors account. Run the report and the balance sheet for the same date, then work through those four checks until the gap is explained.
When can I claim VAT bad debt relief on an unpaid invoice?
Under standard VAT accounting, you can usually claim once the debt is more than six months overdue, you have already paid the VAT on the sale to HMRC, and you have written the debt off in a refunds-for-bad-debts account. Cash accounting users do not need the relief, because unpaid invoices never went into a return.
How often should a small business run an aged debtors report?
At least monthly, as part of month-end. Businesses with many customers or tight cash flow often check it weekly. Running it before each VAT return is also worth doing, because it shows any debts approaching the six-month point for VAT bad debt relief.
Related reading
How Berber Accounts & Tax helps
We are a London-based, specialist gig-economy and MTD accounting practice working with fixed monthly fees. If you would like this handled for you rather than doing it yourself, we can help.
Schedule a consultation โWritten by the Berber Accounts & Tax team, 124 City Road, London EC1V 2NX, United Kingdom.
Last reviewed: 19 November 2026.
This article is general information, not personal tax advice. Speak to a qualified accountant about your own circumstances before acting on it.
