Understanding Aged Debtors Reports and Why They Matter
Understanding aged debtors reports is about answering two questions: how much money do you have outstanding, and how long has it been sitting there? If your business invoices clients, you almost certainly have money in accounts receivable — invoices sent but not yet paid. Most small businesses don't look at this number closely until they run out of cash on a Friday afternoon. That's backwards.
An aged debtors report (also called an accounts receivable aging report) gives you the full picture. It lists every outstanding invoice, grouped by how long it's been unpaid. It's one of the most useful reports in your accounting toolkit, and reviewing it regularly is genuinely one of the simplest ways to improve your cash flow.
What is an aged debtors report?
An aged debtors report organises your outstanding invoices into time buckets. The standard aging buckets are:
- Current — Not yet due
- 1–30 days overdue
- 31–60 days overdue
- 61–90 days overdue
- 90+ days overdue
Each customer appears as a row. Their outstanding amounts spread across the aging buckets. The totals at the bottom show your overall receivables position — how much you are owed, and where it's stuck.
Here's what one looks like:
| Customer | Current | 1–30 | 31–60 | 61–90 | 90+ | Total |
|---|---|---|---|---|---|---|
| ABC Ltd | £2,000 | £1,500 | — | — | — | £3,500 |
| XYZ Corp | — | £3,000 | £2,000 | — | — | £5,000 |
| Smith & Co | — | — | — | £1,000 | £500 | £1,500 |
| Totals | £2,000 | £4,500 | £2,000 | £1,000 | £500 | £10,000 |
At a glance: you're owed £10,000 total. £2,000 is healthy (not yet due). £4,500 needs gentle reminding. £3,500 needs firmer action. Smith & Co has an invoice that's over 90 days old — that's a problem.
Why the aged debtors report actually matters
Cash flow isn't about invoices sent — it's about cash received
Your bank balance tells you what you have today. Your aged debtors report tells you what's coming — and when. If half your receivables are in the 60+ day buckets, you have a cash flow problem waiting to happen. A client promising to pay and actually paying are two different things.
It's an early warning system
A client creeping into the 31–60 day bucket every month isn't being forgetful — they're developing a pattern. You can address it now through a conversation about terms or tighter processes, rather than waiting until they're threatening your overdraft.
You can't chase what you don't see
When you have time to chase only three clients, the aged debtors report tells you which three will give you the fastest return. Large amounts in older buckets represent the highest risk and the biggest cash problem.
Bad debt identification gets specific
Invoices in the 90+ day bucket are candidates for bad debt write-off. The longer something sits unpaid, the less likely you'll ever collect it. If you're VAT-registered and you've already paid VAT to HMRC on that invoice, you may be able to reclaim it under VAT bad debt relief. The report flags these cases clearly.
Client patterns become obvious
The report reveals which clients always pay on time, which ones take an extra week, and which ones are chronic late payers. Once you know this, you can set appropriate terms for each relationship and plan your cash accordingly.
How to actually use the report
Review it weekly (or at minimum, monthly)
For businesses with significant receivables, weekly review keeps you sharp. At the very least, look at it monthly. Most accounting software — including Relentify's accounting module — generates these reports in seconds.
Watch the trend, not the snapshot
A single report is useful. The trend is what matters. Is your total receivables balance growing? Is the proportion in older buckets increasing? These trends tell you whether your collection performance is improving or deteriorating.
Set clear collection triggers
Define what you do at each threshold:
- Current — No action
- 1–30 days overdue — Automated reminder (email or SMS)
- 31–60 days overdue — Personal follow-up (phone call, not another email)
- 61–90 days overdue — Escalate to a senior contact, or formal notice
- 90+ days overdue — Start debt recovery or write it off
Consistency matters. Clients learn what they can get away with.
Calculate your DSO (Days Sales Outstanding)
DSO measures how many days it takes, on average, to collect payment:
DSO = (Total accounts receivable ÷ Total credit sales) × Number of days
If your DSO is 45 days but your terms are Net 30, clients are paying 15 days late. Track it monthly and aim to reduce it. A lower DSO means faster cash in the door.
Compare terms to reality
If you promise Net 30 but collect in 45, you have two choices: enforce your terms more strictly or adjust your cash flow forecast to reality. Most small businesses do the second. Either way, make it intentional.
Common patterns and what they tell you
Concentration risk
If two clients represent 40% of your receivables, you have a problem. If either one pays late or defaults, your cash flow takes a serious hit. Diversifying your client base reduces this risk.
Seasonal spikes
Some businesses see receivables spike after a busy season, over holiday periods, or at financial quarter-ends. Recognise these patterns and plan ahead — don't get surprised by cash shortfalls.
Chronic late payers
If the same clients live in the 60+ day buckets month after month, they either have their own cash problems or they've learned you don't enforce your terms. Address this with honest conversation and firmer boundaries. Change their terms to Net 14 or require deposits.
Sudden aging
If a reliable client suddenly appears 60+ days overdue, something has changed. It could be an invoice dispute they haven't mentioned, an internal process change, or cash stress. Call them. A conversation beats months of guessing.
Improving your aged debtors position
Invoice correctly the first time
Invoices with missing PO numbers, wrong addresses, or incorrect amounts give clients a reason to delay. Get it right first time — it removes friction.
Make payment easy
Online payment links, card payments, direct debit options — the easier you make it to pay, the faster it happens. Friction is your enemy.
Automate reminders
Sending automated payment reminders before and after the due date consistently improves collection rates. Remove the manual work of chasing.
Require deposits for new clients
Until a client has proven they pay on time, require a deposit or use shorter terms. De-risk the relationship upfront.
Tighten terms for repeat offenders
If a client consistently pays 15 days late on Net 30, move them to Net 14 or ask for upfront payment. Your terms should reflect how they actually behave, not how you'd like them to behave.
Consider invoice factoring
If cash flow is tight, you can sell your receivables to a factoring company at a discount (typically 2–5%). It costs money, but it converts aged debtors into immediate cash. Useful as a short-term strategy, not a long-term one.
Frequently Asked Questions
What's the difference between an aged debtors report and an accounts receivable report? They're the same thing. "Aged debtors report," "accounts receivable aging report," and "receivables aging analysis" all describe the same document — your outstanding invoices grouped by age. Different software uses different names.
How often should I look at this report if I'm a sole trader? At minimum, monthly. If you have more than five regular clients, weekly review pays for itself in recovered cash. Most small-business owners find the Goldilocks zone is twice a month — enough to catch patterns without obsessing.
Can I write off a bad debt before 90 days? Legally, yes. Practically, give yourself 60–90 days and give the client a clear final notice before writing it off. Document everything — you may need evidence if the client disputes it later or if HMRC questions your bad debt claim.
What's a "good" DSO for a small business? It depends on your industry and terms. If your terms are Net 30, your DSO should be 30–40 days (allowing for some late payers without penalising the good ones). If it's consistently over 50 days, your collection process needs work.
Should I charge interest on overdue invoices? In the UK, yes — you can charge statutory interest and compensation on overdue B2B invoices under the Late Payment of Commercial Debts Act. The statutory rate is currently 8% plus the Bank of England base rate. Spell it out in your invoice payment terms upfront, and enforce it consistently — it's a powerful incentive.
Is there a point where I should stop chasing a debt? Yes. After 120 days with no response and no payment arrangement, the cost of chasing usually exceeds the likely recovery. Document your chasing attempts, consider bad debt write-off (and VAT recovery if applicable), and move on. Some money isn't worth the time.
How does aging affect my financial accounts? Your aged debtors report is the detail behind the "Trade Receivables" line on your balance sheet. Anything in the 90+ day bucket should trigger a bad debt provision in your accounts (reducing your profit and assets). Your accountant will help calculate this, but the aged debtors report is where the information starts.
Can I use aged debtors reports to forecast cash flow? Absolutely. If you assume that 70% of the 1–30 day bucket will pay within a week, 50% of the 31–60 day bucket will pay within two weeks, and 20% of the 60+ day bucket will ever pay, you can forecast realistic cash arrival. Adjust these percentages based on your actual client behaviour.
Your next step
The aged debtors report isn't just an accounting document — it's a cash flow management tool. Used properly, it keeps your cash flowing, your clients accountable, and your business financially healthy.
Start reviewing yours weekly. Most accounting software (including Relentify) generates it automatically. If you see patterns developing in the older buckets, address them now. The cost of a phone call today beats the cost of a cash flow crisis in three months.