Reading an aged receivables report like a risk map
An aged receivables report is the single richest early-warning document a client produces. Read properly, it tells you where cash is stuck and why.
What this play helps you do
- Interpret the ageing buckets as a map of where cash is stuck
- Spot concentration risk hiding behind a healthy total
- Distinguish a slow payer from a genuinely impaired debt
- Turn the report into a prioritised collection action list
7 min read
The signal
Most owners read the aged receivables report as a single number — the total owed — and stop there. The early warning lives in the shape of that total, not its size. A book where ninety per cent sits in the current and 30-day columns is healthy; an identical total weighted into the 60, 90 and 90-plus columns is a slow-motion cash problem.
The other signal is concentration. A total that looks comfortable can hide the fact that a single customer represents half the balance and most of the overdue amount.
What it means
Each ageing bucket carries a different probability of being collected. Money in the 90-plus column is statistically far less likely to be recovered than money at 30 days, and it deteriorates further with every week it stays there. So the report is really a probability-weighted view of how much of the stated asset is real.
Concentration changes the risk profile entirely. If one debtor dominates the overdue columns, the client does not have a collections problem — they have a single-customer exposure that could take the business down if that customer fails. Reading the report this way reframes it from an accounting artefact into a risk map.
Run the play (steps)
- Calculate the proportion of the total sitting beyond 60 days; rising month-on-month is your trend line.
- Sort debtors by overdue value and look at the top three — concentration usually hides here.
- Flag any single debtor representing more than roughly a quarter of the book.
- For each old balance, ask the client one question: is it disputed, forgotten, or unable to be paid? The answers point to very different actions.
- Convert the findings into a ranked list: chase, escalate, or write down.
What to say to the client
Translate the buckets into plain consequences: "You're showing forty thousand owed, but nearly half of it is past ninety days and most of that is one customer. That's not forty thousand of cash — it's a risk you're carrying." Owners respond to that framing far more than to a column of figures.
For the genuinely stuck balances, recommend they stop spending their own time and refer the account. You can show them how a debt referral works so they understand the older columns can still turn into cash.
When to bring in Merion
The natural trigger is a balance that has aged past 90 days despite the client's own reminders, or a concentrated exposure the client cannot resolve directly. Those are precisely the accounts where a recovery partner adds value, because they are past the point where another polite email will move them. This is general information, not legal or financial advice.
Key takeaways
- The shape of the ageing matters more than the total.
- Concentration risk hides behind comfortable-looking totals.
- Each bucket carries a different probability of collection.
- Older columns are exactly where a recovery partner earns its keep.
FAQ
Which bucket should worry me most?
Anything beyond 90 days, and especially a 90-plus balance that is growing month-on-month while the current column shrinks.
How do I judge concentration risk?
Sort debtors by value and check whether any single customer represents an outsized share — roughly a quarter of the book is a useful flag.
When is an old debt effectively impaired?
When the client confirms the customer cannot pay rather than will not — at that point it is a recovery or write-down decision, not a collections one.
Run the play — we'll handle recovery
Commission-only recovery your clients can trust. No recovery, no fee.