An aged debt report lists unpaid customer invoices and groups their outstanding balances by age. It helps a finance team identify which amounts are current, which are overdue and which need a specific review. You may also see the terms aged debtors report, aged receivables report or accounts receivable ageing report.
For a telecoms reseller, the useful detail is the connection between each balance and the account behind it: the services supplied, payment arrangements, disputes and previous contact. The ageing bands help prioritise work, while that context determines the next action.
Key Takeaways
- Check whether ageing is measured from the invoice date or the due date.
- Keep current invoices separate from overdue balances.
- Review older debt with its payment, dispute and correspondence history.
- Explain changes through receipts, credits and write-offs separately.
How to Read an Aged Debt Report
Start with the report date and ageing basis. A report measured from invoice date describes how long a balance has existed. One measured from due date describes how late it is. These can produce different categories for the same invoice.
For example, an invoice raised on 1 June and due on 1 July is 30 days old on 1 July, but is not yet overdue that day. Treating all invoice age as payment delay would overstate the work needed from credit control.
The following bands illustrate a report measured by days overdue. Exact boundaries depend on the system and configuration.
| Age band | What to review |
|---|---|
| Current | Invoice delivery, agreed collection method and any query before payment falls due |
| 1–30 days overdue | Recent reminders, failed payments and contact details |
| 31–60 days overdue | Customer response, any payment promise and unresolved disputes |
| 61–90 days overdue | Reasons for continued delay and the next authorised action |
| More than 90 days overdue | Evidence supporting the balance, recovery prospects and accounting review |
Read both the totals and the individual invoices. A large current balance might reflect a recent billing run, while a much smaller overdue amount can need urgent attention because the customer is disputing the service or has stopped responding.
Payments, Credits and the Outstanding Amount
An ageing report should show the amount still outstanding rather than the original invoice value. Partial payments and allocated credits change that figure. Unallocated receipts or credits can also make the account total differ from the sum of invoices selected for chasing.
Before contacting a customer, reconcile the report with the current ledger. A payment recorded after the report was produced may have settled the balance. A pending collection is useful context, but it is not the same as confirmed receipt.
Where figures do not agree, check the report scope, date, currency and treatment of credits. Keep currencies separate unless the report explicitly applies a consistent conversion policy. Adding balances in pounds and euros produces a total that cannot support a collection decision.
Reviewing Debt More Than 90 Days Overdue
Ninety days is a useful review point, not a rule that makes a balance uncollectable. Age needs to be considered alongside the evidence: the contract, invoices, service records, correspondence and any acknowledgement or dispute.
An older balance can remain open for different reasons. A customer may be paying under an arrangement, a credit may be awaiting approval, or the debt may need recovery advice. Each calls for a different action, so repeated generic reminders are unlikely to address the full problem.
Assign an owner and record the decision for each material balance. If a write-off is proposed, it needs the appropriate accounting approval and tax treatment. HMRC’s guidance on VAT bad-debt relief sets out conditions that are separate from simply deciding to stop chasing.
What the Ageing Bands Cannot Explain Alone
A report organised only by invoice age does not tell you why payment is late. Review it alongside information about:
- Disputes: which charges are questioned and who is investigating them.
- Promises and arrangements: the amount expected, its date and whether earlier commitments were met.
- Collection attempts: payments pending, failed or returned.
- Service and customer circumstances: issues that affect the appropriate contact or escalation.
A disputed invoice and an undisputed invoice may occupy the same ageing band. That does not make the next action the same. A shared account history helps staff make that distinction without repeating the investigation.
Setting a Review Routine
Choose a frequency that reflects the size of the ledger and the volume of changes. A weekly operational review can identify newly overdue invoices, while a consistent month-end report supports comparison over time. Higher-volume teams may work from live queues each day.
Record the opening balance in each band and explain movements. Cash receipts, new invoices, credits, write-offs and balances moving into older bands all contribute to the closing position. A reduction in older debt is more useful when the report shows how it happened.
Use debtor days for a summary indicator and the ageing detail to investigate changes. Neither a lower ratio nor a smaller overdue total proves that the reminder process caused the improvement.
Using the Report to Improve Credit Control
An ageing report supports a credit control process when each account has a responsible person, a recorded next step and a review date. Start by checking delivery failures, payment status and disputes before deciding how to follow up.
For qualifying commercial invoices, GOV.UK explains the statutory-interest route. Our late payment interest calculator helps assess a particular debt. A financial remedy should form part of the account decision, rather than being applied solely because an invoice entered an older band.
Where funding services in advance is appropriate, pre-pay and automatic top-up offer another way to manage exposure. Failed collections and other outstanding invoices still need monitoring.
Frequently Asked Questions
Is an aged debtors report different from an aged debt report?
These names usually refer to the same report: unpaid customer invoices grouped by age. Check the report’s ageing basis and scope, because systems can use different definitions even when their labels are similar.
What is a good aged debt profile?
It depends on payment terms, billing cycles and the customer base. Compare like-for-like periods and investigate material overdue balances. A report with most amounts still within terms has a different interpretation from one dominated by older unpaid invoices, even where the total is identical.
Should I write off old aged debt?
Age alone is not sufficient. Review the evidence, collectability and accounting treatment with the authorised person or adviser. Keep write-offs separate from receipts when reporting recovery, and do not assume that closing a chase case removes the debt from the ledger.
SAFE CRM connects Credit Control worklists with billing records and account history. Contact us to review how the reports and follow-up process would work for your customer base.