What Is an Aged Debt Report and How Should Business Owners Use It?

An aged debt report is a snapshot of all the money owed to your business, organised by how long each debt has been outstanding. It is one of the most important financial management tools available to a business owner — and one of the most underused. Used correctly, it tells you not just who owes you money, but who presents the greatest risk and where your credit control effort should be focused.

What Does an Aged Debt Report Show?

An aged debt report — sometimes called an aged receivables report — lists every outstanding invoice owed to your business, grouped into time bands that show how old each debt is. The standard groupings used by most UK accounting software packages are: current (not yet due), zero to thirty days overdue, thirty-one to sixty days overdue, sixty-one to ninety days overdue, and ninety days or more overdue.

For each customer, the report will typically show the customer name, each outstanding invoice number and value, the date it was due, and which time band it falls into. The report will also show a total for each time band across all customers, giving you an immediate picture of the overall health of your debtor book.

Most major accounting platforms — including Xero, QuickBooks, Sage, and FreeAgent — produce aged debt reports as a standard feature. The format varies slightly between platforms, but the underlying logic is consistent: the older the debt, the further right it appears on the report, and the more urgent the action required.

How to Read Your Aged Debt Report Effectively

Reading an aged debt report is straightforward; using it well requires a slightly more analytical approach. Start with the total of each time band. A healthy debtor book should have the large majority of its value in the current and zero-to-thirty-day columns. If more than fifteen to twenty per cent of your total outstanding receivables sits in the sixty-days-plus column, that is a signal that your credit control process needs attention.

Next, look at the composition of the overdue columns. Are the overdue balances concentrated in a small number of customers, or spread widely? A large overdue balance from one customer represents a concentrated risk and should be a priority. A pattern of small balances across many customers suggests a systemic process issue — invoices are not being followed up consistently — rather than a specific customer problem.

Pay particular attention to the ninety-days-plus column. Research suggests that invoices unpaid at ninety days have a significantly lower recovery rate than those chased consistently from the point they became due. Any debt in this column should already be subject to a formal collection process — if it is not, the probability of recovery is declining with each week that passes.

How Frequently Should You Review Your Aged Debt Report?

For most businesses, a weekly review of the aged debt report is appropriate — particularly for companies with a significant volume of invoices or customers with a history of late payment. A weekly review takes only a few minutes once you know what to look for, and it allows you to identify problems while they are still manageable rather than after they have aged into the higher-risk categories.

At a minimum, the aged debt report should be reviewed at the end of each month, as part of the month-end financial close process. Many businesses also review it at quarter-end and use it as an input to financial planning conversations — understanding the cash that is expected to flow in over the coming weeks is an essential part of managing working capital effectively.

The review frequency should increase when the business is under cash flow pressure, when there are known high-risk debtors on the ledger, or when a specific large invoice is approaching its due date and has not yet been confirmed for payment.

Using Your Aged Debt Report to Prioritise Credit Control Activity

The real power of an aged debt report is as a prioritisation tool. Not all overdue invoices are equally urgent, and a professional credit control function uses the report to direct effort where it will have the greatest impact. The general principle is to address the highest-value debts in the oldest time bands first, while maintaining consistent follow-up across the rest of the ledger.

However, value is not the only prioritisation criterion. A smaller invoice from a customer with a history of disputed debts or deteriorating payment behaviour may require more urgent attention than a larger invoice from a reliable customer who is simply running a few days late. Understanding the history behind each debtor, not just the number on the report, is what separates effective credit management from mechanical invoice chasing.

When a debt moves into the sixty-one to ninety-day bracket without resolution, it is generally time to escalate beyond the standard reminder process. This might mean a more senior conversation with the customer, a formal letter referencing your rights under the Late Payment of Commercial Debts Act, or, in cases where recovery looks genuinely unlikely, a referral to a debt recovery specialist.

Frequently Asked Questions

Q: What is the difference between an aged debt report and a debtor ledger?

A: A debtor ledger is the complete record of all amounts owed to your business by customers, including transaction history, credit limits, and payment records. An aged debt report is a specific output from the debtor ledger — a snapshot at a point in time showing outstanding balances grouped by age. The debtor ledger is the underlying database; the aged debt report is the management view that makes it actionable.

Q: What is considered a healthy aged debt position for a UK SME?

A: A generally healthy position is one where the large majority of outstanding receivables — typically eighty per cent or more — sit in the current or zero-to-thirty-day columns, with less than fifteen per cent in the sixty-days-plus categories. This will vary by industry: construction, for example, tends to have longer payment cycles than professional services. The most meaningful benchmark is your own historical average — the trend direction matters as much as the absolute figure.

Q: Can my accounting software produce an aged debt report?

A: Yes — all major UK accounting platforms produce aged debt reports as a standard feature. In Xero, it is found under Reports > Aged Receivables Summary or Detail. In QuickBooks, it is under Reports > Who Owes You > Accounts Receivable Aging. In Sage, it is under Customers > Aged Debtors. The format differs slightly between platforms, but the underlying data is the same.

Q: At what point should I escalate a debt that is not being paid?

A: As a general guide: invoices in the thirty-one to sixty-day bracket should be receiving active follow-up by telephone and email. Invoices in the sixty-one to ninety-day bracket warrant a formal written reminder referencing your statutory interest rights. Invoices beyond ninety days should be subject to a formal collection process — either through escalated direct negotiation, a letter before action, or referral to a specialist if internal resolution has failed.

Get in Touch

At that credit control, we use your aged debt report as the starting point for every client engagement — reviewing the full ledger, identifying priority accounts, and implementing a structured follow-up process that addresses both the immediate backlog and the underlying process gaps. Get in touch to find out how we can help.