Reading an Aged Receivables Report

How the buckets work

An aged receivables report sorts every unpaid invoice into columns by how overdue it is — typically current, 1–30, 31–60, 61–90 and 90-plus days. Each customer is a row, so you can read both how much a single debtor owes and how old that balance is.

The shape of the report tells the story. A book weighted to the current and 1–30 columns is healthy. Balances drifting into the 60-plus columns are cash that is slipping away, and once an invoice passes ninety days the probability of collecting it falls sharply. As an adviser, the buckets give you an objective basis for advice that does not depend on the owner's optimism about who will 'pay soon'.

Spotting concentration and drift

Two patterns deserve immediate attention. The first is concentration: a single customer making up an outsized share of the overdue total. If that account stalls, it can take the client's cashflow with it. The second is drift — the same balances appearing one bucket older each month, which signals a customer managing the client as a free line of credit.

Both are easier to see across time than in a single snapshot. Pulling the report monthly and watching the totals migrate is more revealing than any one report. Where concentration is the issue — one debtor dominating the overdue total — the client needs the diversification and monitoring response rather than routine follow-up.

Disputes versus slow payers

Not every aged balance is the same problem. Some are disputed — a credit owed, a delivery query, a pricing disagreement — and will never be paid until the underlying issue is resolved. Others are simply slow payers who have the money and are choosing not to part with it. The two need different responses, and conflating them wastes effort.

Encourage clients to annotate the report so the genuinely overdue accounts stand out from administrative hold-ups. The slow payers are where collection discipline and, eventually, escalation belong; the disputes need resolving by the business before any recovery step makes sense.

From report to action list

The report is only useful if it drives action. Work the oldest and largest balances first, since they carry the most risk and the most cash. Quantify the stakes for the client with the Merion calculator suite, which shows what the overdue total is costing in financing terms.

Set a standing rule with the client — for instance, anything over ninety days and not in dispute gets escalated — so the oldest balances do not simply keep ageing while everyone hopes. For accounts that have aged past internal reminders and are not in genuine dispute, escalating to a recovery partner converts a frozen balance back into cash without upfront cost — see refer a debt. This is general information, not advice for a particular client situation.