Aged receivables report: how to read it and act on it

An aged receivables report (often called a debtors age analysis in South Africa) lists every customer who owes you money and splits their balance into buckets by how long it has been outstanding: current, 30, 60, 90 and 120+ days. It tells you at a glance who is behind, by how much, and which debts are at risk of never being paid.

Reading it well, and acting on it every week, is one of the simplest ways to protect cash flow. This guide explains the layout, what the numbers are telling you, and a follow-up routine for each bucket.

What an aged receivables report looks like

Illustrative example (balances as at 31 August 2026, including VAT):

(Names and amounts are made up.)

How the ageing buckets work

Two things decide which bucket an amount falls into:

• Ageing basis. Most systems age by invoice date (how long since you billed) or by due date (how long since payment was due). Due-date ageing is more useful for collections because "current" then means "not yet due". Check which your system uses; it changes how you read the report.
• Bucket boundaries. Usually 30-day steps. On invoice-date ageing with 30-day terms, "30 days" means the invoice is due or just overdue; on due-date ageing, "30 days" means up to 30 days past due.

Payments should be allocated to specific invoices. If a customer pays R8,050.00 without a reference and it's left unallocated, the report may show both an unpaid old invoice and an unallocated credit, which overstates what's overdue.

Reading the report: what to look for

The shape of the total

Most of your book should sit in "current". As balances move right, the chance of collection generally falls. In the example, 47.7% is current and 13.6% is 90 days or older. Whether that's healthy depends on your terms and industry, so compare against your own history rather than a generic benchmark.

Customers moving right

Karoo Fresh has an unpaid invoice in each of the current, 30 and 60 day buckets. That pattern (paying nothing, while you keep billing) is more worrying than a single late invoice. It often means a cash flow problem at the customer, a dispute nobody has told you about, or invoices going to the wrong person.

Old, small balances

Seaside Guesthouse owes R2,300.00 at 120+ days. Small old balances are easy to ignore, but they add up and they rarely pay themselves. Decide: chase properly, agree a settlement, or write off after following your process.

Concentration

If one customer makes up a big share of the overdue total, that's a specific risk worth a phone call from someone senior.

A follow-up routine for each bucket

A few practical points:

• Send a statement with the ageing. A customer statement of account showing exactly which invoices are overdue answers most "which invoice?" replies.
• Make paying easy. Every reminder should include a pay-now link and bank details with the reference to use. Our payment reminder email templates include wording for each stage.
• Record every contact. Note who you spoke to and what was promised. It helps if the debt ends up with a collector.
• Stop supply if appropriate. For ongoing services, pausing service is often more effective than more emails. Make sure your terms allow it.

Useful measures from the report

Beyond the table itself, track a few numbers monthly:

• Percentage overdue: overdue balances ÷ total receivables.
• Percentage over 90 days: the part most at risk.
• Days sales outstanding (DSO): roughly, receivables ÷ credit sales for the period × days in the period. If you had R50,600.00 in receivables and R92,000.00 of credit sales in a 31-day month, DSO is about 17 days.

A rising DSO or a growing 90+ bucket is an early warning, even when revenue looks fine.

Prevent balances from ageing in the first place

The report shows problems; these habits stop them occurring:

1. Clear payment terms agreed at sign-up and printed on every invoice. See invoice payment terms.
2. Invoice immediately after supply, to the right contact, with a purchase order number if the customer uses them.
3. Offer ways to pay that don't rely on memory: card on file, debit order or a pay link.
4. Reconcile bank payments promptly so the report reflects reality.
5. Credit checks before extending terms to new customers with large orders.

How CentraPoint helps

CentraPoint includes standard reports and a report builder, so you can save the invoice views your team uses for follow-up and schedule them by email, with CSV and XLSX export for deeper ageing analysis in a spreadsheet. Invoices can be paid by link through your enabled gateways, and statement import and reconciliation auto-match collections, unpaids and fees so the report isn't full of payments that have already arrived. For recurring customers, collecting by saved card token or Netcash debit order reduces the number of invoices that age at all. See the reconciliation documentation.

Frequently asked questions

What is the difference between an aged receivables report and a debtors age analysis?

They're the same report. "Debtors age analysis" is the term many South African accountants use; "aged receivables" or "accounts receivable ageing" are common elsewhere.

How often should I run an aged receivables report?

Weekly for collections follow-up, and at month-end for management reporting and reconciliation to your accounting system.

Should ageing be based on invoice date or due date?

Due-date ageing is usually more useful for collections because it shows how far past due each amount is. Invoice-date ageing is common in accounting systems, so check which basis your report uses.

When should I write off an overdue invoice?

When you've followed your collection process and recovery looks unlikely or uneconomic. Speak to your accountant about the accounting and tax treatment before writing off.