How to Read an Aged Debt Report, and What to Do Next

The aged debt report is the single most useful page in credit control. In the UK it is usually called the aged debt or aged debtors report; in the US and Canada it is the AR aging report. Whatever you call it, it shows who owes you money and how long they have owed it, and reading it well tells you exactly where to spend your time this week.

What the report shows

Every aged debt report groups unpaid invoices by how far past the due date they are. Most accounting software uses the same standard buckets:

• Current: not yet due.
• 1 to 30 days overdue.
• 31 to 60 days overdue.
• 61 to 90 days overdue.
• 90+ days overdue.

Each row is usually a customer, with their total balance spread across those columns. A grand total at the bottom shows how your whole ledger is split.

Before you read anything, check one setting: is the report aged by due date or by invoice date? Aging by invoice date makes everything look older than it is, because a 30-day invoice lands in the “31 to 60” column the day after it falls due. For collection work you want aging by due date, so that “current” really means “not yet due.”

What to look at first

A long report can feel overwhelming. Work through it in this order and you will find the problems that matter in a few minutes.

1. Concentration in your top customers

Sort by total balance and look at the top ten customers. Add up what they owe as a share of the whole ledger. If a handful of accounts make up most of your receivables, any one of them paying late (or failing) has an outsized effect on your cash flow.

High concentration is not a problem in itself, but it changes how you manage risk. Those accounts deserve regular contact, up-to-date credit checks and a named owner on your team.

2. Movement between buckets month on month

A single report is a snapshot. The real story is in the movement. Put this month’s report next to last month’s and ask:

• Which customers have moved balances into an older bucket?
• Is the 61 to 90 day column growing as a share of the total?
• Did invoices that were in “1 to 30” last month get paid, or did they roll forward?

Say a customer owed $20,000 in the 1 to 30 day column last month and now has $18,000 in the 31 to 60 day column. They paid almost nothing. That account needs a call today, not another automated reminder.

3. Old small balances

Scan the 90+ column for small amounts: a few pounds or dollars here, a short-paid invoice there. Individually they look unimportant. Together they clutter the report, distort your metrics and hide the large balances that need attention.

Most small old balances are one of three things: a bank charge or currency difference the customer deducted, a short payment linked to a minor dispute, or a genuine error on your side. Investigate them in a batch, then either collect them, resolve the dispute, or write them off under your policy’s approval limits.

4. Credits and unapplied cash

Look for negative balances and unallocated payments. A credit note that has not been matched to an invoice, or a payment sitting “on account,” makes the customer’s position look worse than it is. Chasing a customer for an invoice they have already paid is the fastest way to damage the relationship.

Allocate cash and credits before you start chasing. If you cannot tell what a payment was for, ask the customer for a remittance advice, then apply it.

An action plan for each bucket

Once the report is clean, use the buckets to decide what happens next. A simple plan looks like this.

Current (not yet due)

The goal here is to prevent overdue debt before it starts.

• Confirm large invoices have been received and approved, especially for new customers.
• Send a friendly pre-due reminder a few days before the due date on high-value invoices.
• Check that each invoice carries the customer’s purchase order number if they require one.

1 to 30 days overdue

Most late payments in this bucket are oversights, not refusals.

• Send a polite reminder on the day after the due date.
• Follow up by phone for larger balances within a week.
• Ask directly whether there is any problem with the invoice. Surfacing a dispute now saves weeks later.

31 to 60 days overdue

At this point the delay is no longer accidental.

• Make personal contact with the accounts payable team and get a specific payment date.
• Log every promise to pay and check it the day after it is due.
• Escalate unresolved disputes internally so sales or operations can fix them quickly.
• Review whether to keep supplying on normal terms.

61 to 90 days overdue

This is where the risk of non-payment starts to rise sharply.

• Escalate to a more senior contact at the customer, such as the finance manager or owner.
• Put the account on hold for new orders until payment arrives, if your terms allow it.
• Agree a payment plan in writing if the customer genuinely cannot pay in full.
• Send a formal final notice that explains what happens next.

90+ days overdue

Balances this old need a decision, not more reminders.

• Decide whether to refer the debt to a collection agency, start legal action, or write it off.
• Check whether you hold any security, such as a personal guarantee or retention of title.
• Review the bad debt provision with your finance team.

Escalation routes differ between the UK, US and Canada, and so do the rules on formal demands and court claims. Confirm the right process with a qualified adviser for your jurisdiction before you take legal steps.

Turn the report into a weekly habit

Reading the aged debt report once a month at close is useful. Reading it every week is what actually moves cash. A simple routine:

1. Monday: run the report aged by due date and allocate any unapplied cash.
2. Pick your focus list: the top ten balances, anything that moved into an older bucket, and every promise to pay due this week.
3. Act on it: calls first for the largest balances, then reminders for the rest.
4. Note the outcome on each account so the next person can pick it up.

At month end, compare the bucket totals with the previous month and track the trend alongside your days sales outstanding. Our article on DSO and how to reduce it explains how the two measures fit together.

Key takeaways

• Age the report by due date, not invoice date, so “current” really means not yet due.
• Start with concentration in your top customers, then look at movement between buckets month on month.
• Clean up small old balances, credits and unapplied cash before you chase anyone.
• Give every bucket a clear action, and make the 90+ column a place for decisions, not reminders.
• Review the report weekly, not just at month end, and focus on what has moved.