Your aged debtor report is the list of money you've earned but haven't been paid yet, sorted by how long each customer has owed it. It matters because it shows which customers are starting to slip while you can still do something about it, how much of your cash rests on a few names, and what a lender, buyer or your accountant will look at first. It also tells you when an old debt is due a write-off decision.
In this article
The short version
- Your aged debtor report lists money you've earned but haven't been paid yet.
- It shows customers drifting into older columns while you can still act.
- Sorting it by balance shows how much of your cash depends on a few customers.
- Lenders and buyers ask to see it, because invoice finance is provided against your debtor book.
- It also tells you when an old debt is due a write-off and a VAT bad debt relief conversation with your accountant.
Money you've earned but don't have
Your profit and loss counts a sale on the day you invoice it. Your bank balance counts it on the day the customer pays. Everything that falls between those two days is on your aged debtor report, customer by customer and invoice by invoice.
That money has already cost you the work, the materials and the wages. Until it arrives, you're in effect lending it to your customers, without interest and often without agreeing to. A good month of sales sitting alongside a tight bank balance is usually explained by this report: the sales happened and the cash hasn't followed.
Looking at it regularly tells you how much is coming in, from whom and roughly when. It's hard to build a cash flow forecast you'd rely on without it, and it's often the quickest way to see whether next month's wages and VAT bill are covered.
An early warning on customers who are slipping
Customers rarely go from paying on time to not paying at all in one step. They drift. An invoice that used to clear in 30 days takes 40, then 55, and a second invoice joins the first in an older column. On the report, you'll see one name moving to the right month by month.
Catching it at that stage leaves you options you lose later. You can ask what's changed, agree an instalment plan, ask for payment before the next job or pause work until the balance comes down. Leave it until the debt is three months old and the choices narrow to statutory interest, a letter before action, a collection agency or writing it off. By then the customer may have other suppliers chasing the same money.
Adfin's aged debtors view gives you a live view of what each customer owes, broken down by age, and lets you give each debtor an owner and add the next action, so a slipping customer gets a named person and a plan. From the same screen you can change how that customer is chased, send them a statement or set up an instalment plan.
How much depends on a few customers
The report also shows concentration. Sort it by total owed and look at the top three names. If one customer accounts for a large part of everything you're owed, your cash flow depends on their payment run, their approval process and their own finances. A big customer paying a month late can hurt more than ten small ones paying a week late.
Concentration isn't always avoidable, particularly if you've built the business around one or two anchor clients. Seeing it plainly lets you plan for it. You can confirm large invoices are approved well before they fall due, agree staged payments on big jobs, and keep enough in reserve to ride out a late payment from your largest customer.
Who else will want to see it
Lenders and buyers will both ask for your aged debtor report. Invoice finance is provided against your debtor book, so a provider will want to see who owes you what and for how long. Anyone buying or investing in the business will look at it too, and the quality of the debt matters to all of them. A report full of old balances nobody has followed up is hard to explain in that conversation.
Your accountant uses it at year end to judge which debts are still collectable, and it tells you when a write-off is worth discussing. If you're VAT registered, you can usually reclaim the VAT on a bad debt once it's been unpaid for six months after the later of the due date and the date of supply, as long as you've already paid that VAT to HMRC and written the debt off in your VAT records. There's a time limit on claiming, so a dated record of each debt stops the relief slipping past. Check the details with your accountant before you claim.
A report is only useful if it reflects what's in the bank. When customers pay through Adfin, the invoice is marked paid in Xero or QuickBooks automatically, and its collection agents can chase the newer debts within rules you approve, which leaves your time for the customers who need a conversation.
Common questions
What is an aged debtor report? A list of what each customer owes you, sorted into columns by how long it's been outstanding. It's also called an aged receivables report.
Is the aged debtor report the same as debtor days? No. Debtor days is a single average of how long customers take to pay, while the aged debtor report shows the balances behind it, customer by customer.
When does an invoice count as late? When the agreed payment date passes. If you never agreed terms, a business invoice is late 30 days after the customer receives it or the goods or services are delivered, whichever is later.
Do lenders look at the aged debtor report? Yes. Invoice finance is provided against your debtor book, so a provider will ask to see it, and buyers will look at it during due diligence.
Can I reclaim VAT on a customer who never pays? Usually, once the debt has been unpaid for six months after the later of the due date and the date of supply, you've paid the VAT to HMRC and you've written the debt off in your VAT records. Ask your accountant before you claim.
Who in the business should see the report? At least the owner and whoever chases payments. It also helps if account managers can see which of their customers are overdue before they agree new work.
Sources
- GOV.UK - Late commercial payments: when a payment becomes late (accurate as of October 2026) https://www.gov.uk/late-commercial-payments-interest-debt-recovery/when-a-payment-becomes-late
- HMRC - Relief from VAT on bad debts (VAT Notice 700/18) (accurate as of October 2026) https://www.gov.uk/government/publications/vat-notice-70018-relief-from-vat-on-bad-debts/vat-notice-70018-relief-from-vat-on-bad-debts
- Better Business Finance - Invoice finance (accurate as of October 2026) https://www.betterbusinessfinance.co.uk/types-business-finance/invoice-finance
- Adfin - Changelog (accurate as of October 2026) https://adfin.com/resources/changelog
