Aged receivables: reading it and chasing payments well

Quick answer. The aged receivables report breaks down your customer debts by age: not yet due, then late-payment brackets. Read monthly, it reveals your DSO (average collection period), flags the overdue items to chase first, and prepares year-end impairments. It is the core tool for managing trade receivables.

A profitable business owner can still run short of cash for one reason: the money is sitting with customers. The income statement shows a profit, but the bank account stays tight because issued invoices have not been collected. The aged receivables report makes this visible, invoice by invoice, late bracket by late bracket. The skill is reading it and turning it into concrete actions.

This article explains how to decode an aged receivables report, how to derive your DSO from it, and how to build a graduated reminder process that genuinely reduces late payments without damaging the commercial relationship. It is aimed at owners of small and mid-sized companies, freelancers and finance managers who want to regain control of their trade receivables.

The aged receivables report, also called an aged trial balance of customers, is an accounting statement that classifies all your trade receivables by age. For each customer and each invoice, it shows the amount due and places it in a column according to the time elapsed since the due date.

The usual structure distinguishes the not yet due balance (invoices whose payment date has not arrived) from several late-payment brackets: 1 to 30 days, 31 to 60 days, 61 to 90 days, and more than 90 days. This breakdown turns a mass of invoices into an immediate risk map.

It serves four management purposes:

1. Monitoring trade receivables as a whole and tracking how they evolve over time.
2. Spotting late payments and concentrations of risk on a given customer.
3. Prioritising reminders by focusing on the largest and oldest amounts.
4. Preparing impairments of doubtful debts at year-end, in line with the prudence principle of the French general chart of accounts.

Reading a concrete example#

Here is a simplified aged receivables report. Amounts are in euros including tax, as on a standard statement.

A ten-second read says the essential. Customer D pays on time. Customer A has a slight recent delay, nothing serious. Customer B is sliding towards a structural delay that is settling in. Customer C is the real alert: 12,000 euros over 90 days, a receivable whose recovery is becoming uncertain and which will probably need to be classified as a doubtful debt.

Our take. The figure that should hold your attention is not the report total, it is the "over 90 days" column. An old receivable is rarely collected by chance: the older it gets, the lower the probability of collection. It is far better to deal early with a 4,500 euro delay than to wait for it to reach the far-right column.

The aged report shows the snapshot. DSO gives the quantified summary. DSO, or Days Sales Outstanding, is the average time your customers take to pay, expressed in days. It answers a simple question: on average, how long does my turnover stay locked up as receivables before being collected?

The formula is as follows:

Take a 30-day month. A company generates 90,000 euros of turnover including tax and shows 46,500 euros of trade receivables including tax. Its DSO works out at (46,500 / 90,000) × 30, around 15.5 days. Over a 90-day quarter with 270,000 euros of turnover and the same 46,500 euros of receivables, DSO would be (46,500 / 270,000) × 90, also around 15.5 days: the ratio stays comparable as long as you match receivables to the turnover of the same period.

The higher the DSO, the more your cash finances your customers in your place. Every extra day of DSO is cash tied up that cannot pay your suppliers, fund investment or build a safety buffer. This is why DSO is one of the financial ratios a business owner should track and forms, with the supplier payment period, one of the two engines of the cash cycle.

To track both periods together and measure their combined effect on your financing need, you can use our DSO, DPO and cash cycle simulator. The gap between what your customers owe you and what you owe your suppliers feeds your working capital requirement directly, which you can size with the working capital and cash simulator.

The underestimated risk. Many owners look at their overall DSO and judge it acceptable. The problem hides in the spread: an average DSO of 20 days can mask half the customers paying cash and a minority paying at 90 days. The average reassures, the aged report alerts. The two tools are read together, never one without the other.

An effective reminder is not an isolated burst of pressure. It is a predictable sequence, applied on fixed dates, identical for every customer. Consistency matters as much as tone: a customer who knows you chase systematically pays faster than one who has learned your invoices can wait.

The principle is the graduated reminder: firmness rises gradually as the delay sets in.

The preventive reminder is the most profitable and the most neglected. A simple email a few days before the due date removes half the future excuses: invoice not received, wrong department, missing purchase order. You turn a potential dispute into a simple confirmation.

The points to structure in your process:

• Set clear due dates on every invoice and restate them in your terms of sale.
• Fix a steady reminder frequency rather than ad hoc chasing.
• Log each exchange (date, contact, commitment obtained) to keep the history.
• Distinguish the customer's cash-flow delay, a dispute over the service and an administrative oversight: each calls for a different response.
• Reserve the formal notice for cases where the amicable reminder has failed, neither too early nor too late.

For the full methodological framework of collection, from the first reminder to legal action, see our dedicated debt collection guide.

In practice. Recently, a small business showed us its aged receivables: a quarter of trade receivables sat beyond 60 days, with no written reminder ever logged. By introducing a systematic preventive reminder and an amicable reminder on day one of the delay, the average overdue balance shrank over several billing cycles, with no litigation. The lever was not legal, it was organisational.

Reminders do not happen in a legal vacuum. Between professionals, the payment term is governed by the French Commercial Code. The principle is settlement within 30 days of receipt of the goods or completion of the service. The contract may extend this to 60 days from the invoice date, or 45 days end of month, provided the clause is expressly agreed and not abusive.

Exceeding these terms is not neutral. Any late payment between professionals gives rise, as of right:

• to late-payment penalties, calculated at a rate at least equal to the European Central Bank reference rate plus 10 points, that is 12.15% in the first half of 2026;
• to a flat recovery indemnity of 40 euros per invoice paid late, added to the penalties.

These statements must appear in your terms of sale and on your invoices. They are not just a reminder argument: their absence is sanctioned by the DGCCRF. For the detail of the rules, thresholds and applicable fines, see our analysis of inter-company payment terms and penalties.

Hayot Expertise advice. Show the penalty rate and the 40 euro indemnity on every invoice, and recall them in your first amicable reminder. The aim is less to charge them than to signal to the customer that your terms are tracked. In most cases, simply recalling these rights is enough to release a payment, without having to apply them.

The single customer who weighs too much. When one customer represents a large share of your trade receivables, their delay becomes a systemic risk. The aged report must then be read customer by customer, not just in aggregate. A concentrated exposure justifies close monitoring, even a request for a deposit or a formalised payment schedule.

The receivable turning doubtful. When a receivable shows a real risk of non-collection (customer insolvency proceedings, serious dispute, prolonged silence), it is classified as a doubtful debt and impaired in the accounts at year-end. This entry reflects the prudence principle: the probable loss is anticipated without waiting for it to be certain. The aged report is the starting point of this review.

The dispute disguised as a delay. A customer who does not pay is not always a bad payer. Sometimes they are tacitly contesting the service, a quantity, a price. Mechanically chasing a dispute makes things worse. The first phone reminder is precisely there to separate a cash-flow delay from a genuine disagreement.

Deposits and partial invoices. On long assignments, age-based tracking gets complicated: one project may include a collected deposit, an overdue interim invoice and a not-yet-due balance. The aged report then benefits from being cross-checked with tracking by project.

• The penalty rate moves with the ECB. The 12.15% rate used in the first half of 2026 depends on the reference rate. Check the rate applicable to your period before stating it on your commercial documents.
• E-invoicing generalises traceability. With the ongoing reform, invoicing flows become more standardised. An up-to-date aged report assumes clean invoicing upstream: the quality of customer tracking starts at invoice issuance.
• DSO is steered, not merely observed. Tracking it monthly and comparing it to your cash cycle is more useful than an annual calculation. To link customer tracking to overall management, see how to read a cash flow statement and which financial ratios to track first.