Debtors Age Analysis: A Practical Guide for SA Businesses
Read and report a debtors age analysis: ageing buckets, days sales outstanding, which accounts to chase first, and how to turn the export into a monthly report.
· 5 min read · Summarix team
A debtors age analysis lists what each customer owes you, split by how long it has been outstanding: current, 30, 60, 90 and 120-plus days. It tells you who to chase first and whether your debtors book is getting healthier or worse. Read it with days sales outstanding (DSO), focus collections on the largest and oldest balances, and track the totals in each bucket month by month.
What an age analysis shows
Most accounting packages produce an aged debtors report straight from your invoices and payments. Each row is a customer, and the balance is split by the age of the unpaid invoices. Check how your system measures age: from the invoice date or from the due date. Thirty days from the invoice date is a different thing from thirty days overdue.
| Customer | Current | 30 days | 60 days | 90+ days |
|---|---|---|---|---|
| Customer A | R85,000 | R40,000 | R0 | R0 |
| Customer B | R12,000 | R15,000 | R18,000 | R22,000 |
| Customer C | R0 | R0 | R0 | R64,000 |
| Total | R97,000 | R55,000 | R18,000 | R86,000 |
The figures are illustrative, but the pattern is typical. Customer A is fine. Customer B is drifting: every bucket has a balance, which often means they pay something each month but never catch up. Customer C has stopped paying altogether. Those are three different conversations.
Days sales outstanding: one number for the whole book
DSO = trade debtors ÷ credit sales for the period × days in the period. If you have R256,000 owing and made R300,000 of credit sales in the last 30 days, DSO is 256,000 ÷ 300,000 × 30 ≈ 26 days. On 30-day terms that is healthy. A DSO of 50 on 30-day terms means customers take, on average, nearly three weeks longer than agreed, and that is cash you are lending them.
DSO moves with sales, so a big sales month can make it look better or worse than it is. Track it alongside the percentage of the book that is over 60 days; together they are hard to fool. Both belong on the list in our guide to cash flow and financial KPIs.
Which accounts should you chase first?
- The largest balances over 90 days: the most cash, and the highest risk of never being paid.
- Customers still buying while their older invoices are unpaid: consider holding new orders until they catch up.
- Accounts that moved into an older bucket this month for the first time: a call now is easier than a letter later.
- Disputed invoices: sort out the dispute (a missing delivery note, a pricing error) so the customer can pay.
- Small old balances: often a short payment or bank charge; write off or credit them deliberately rather than letting them sit.
South African context
- Many business customers pay on 30 days from statement, so a February invoice may not be due until the end of March. Report against your actual terms.
- Month-end and the 25th are common paydays for individuals, so consumer collections tend to cluster around them.
- Expect December and early January to be slow, as many businesses close for the holidays. Chase November invoices before the shutdown.
- A debtors list holds personal information when your customers are individuals or sole proprietors, so share it only with the people who need it.
Turning the export into a monthly report
Export the aged debtors report from your accounting system as CSV or Excel, with one row per customer and one column per bucket. Remove columns you do not need for the report, such as email addresses and phone numbers; Summarix masks sensitive-looking columns before any AI call anyway, but the less personal information you upload, the less there is to protect. Then upload the file and use a focus such as:
Summarix calculates each total from the column itself, so the KPIs match the export, as long as the amounts are plain numbers without an R in the cells. Charts list the largest values first, which suits 'who owes the most over 90 days'. For a trend, keep each month's export in one sheet with a `Month` column, so the report can chart the 90+ total month by month. Make it part of your month-end reporting checklist, next to the budget vs actual report.
A simple report layout
- Headline: total owed, DSO and the share over 60 days, compared with last month.
- Bucket totals as a bar chart.
- Top 10 customers by 90+ days, with the action agreed for each.
- Customers who moved into an older bucket this month.
- Notes: disputes, unallocated payments, write-offs proposed.
Upload your aged debtors export and get a collections report you can act on this week.
Free plan: 5 AI reports a month, no card needed.
Frequently asked questions
What is the difference between an age analysis and a statement?
A statement goes to one customer and lists their invoices and payments. An age analysis is your internal view of all customers at once, split by how old the unpaid amounts are. You use the age analysis to decide who to send statements and reminders to.
How often should we run a debtors age analysis?
At least monthly, after payments for the month have been allocated. Businesses with many credit customers often check it weekly during collections, focusing on the oldest and largest balances.
What is a good DSO?
One close to your payment terms. On 30-day terms, a DSO in the low thirties is reasonable; a figure far above your terms means customers are paying late on average. Compare your own DSO over time rather than with other industries.
Should we stop supplying customers with overdue accounts?
It is a business decision, and your terms of trade should say when you may hold orders. Many businesses put accounts over 60 or 90 days on hold until they pay, and tell the customer clearly before doing so.