#Expert advice

The ageing balance sheet, a key indicator of accounts receivable

Securing cash flow is not an option: it is a prerequisite for sustainability. Managing cash flow means knowing when receipts and disbursements will occur, which positions are subject to delays and what decisions to take: follow up, renegotiate, smooth out a payment or even activate short-term financing.

In this system, the aged balance sheet plays a central role: it shows, on a given date, outstanding customer receivables and supplier payables, sorted by age. It provides an overview that immediately clarifies future cash flow management and the priority of actions in customer account management and debt collection.

What is an aged balance and what is it used for? 

The aged balance is a summary statement based on the due date of invoices. It groups together ‘due’ and ‘overdue’ amounts by age (recently overdue, long overdue, very long overdue) to quickly identify third-party accounts that are likely to become unpaid and, conversely, to prioritise payments that need to be made. A distinction is usually made between:

  • The customer ageing balance, which supports collection: it qualifies delays, structures reminders and secures collection (DSO, outstanding amounts).
  • The supplier ageing balance, which supports payment management: it helps to plan cash outflows without damaging relationships with key partners.

We refer to ‘ageing balance’ because the tool places the time axis at the heart of the reading: receivables and payables are staggered by age, which facilitates operational decisions (remind, spread, escalate).

How can you organise your ageing balance to make it truly useful?

Operationally, the tool serves three purposes: anticipating cash flow pressures, prioritising reminders and objectifying the sequence of payments. Coupled with a collection system (process, tools, KPIs), the aged balance sheet becomes a living dashboard of customer/supplier accounts.

How can you develop a reliable aged balance sheet?

A useful aged balance sheet is based first and foremost on clean data: for each invoice, a correct due date (distinct from the invoice date if the terms vary), an actual balance due, and regular reconciliation to avoid unallocated credit notes and misleading balances. The breakdown by age must remain consistent from one period to the next; it is this stability that makes comparisons relevant and allows trends to be identified.

According to the Belgian Minimum Standard Chart of Accounts (PCMN), short-term receivables and payables—that is, those due within twelve months—are generally recorded in Class 4. Trade receivables from customers are recorded in the accounts under heading 40, and trade payables to suppliers in the accounts under heading 44. The aging report lists these open balances and classifies them by age as of a reference date, thereby facilitating the tracking of collections, payments, and year-end closing procedures.

Finally, the report must be regular (at a frequency adapted to your cycles): it is better to have a short and frequent balance sheet than an exhaustive but outdated statement.

How can you make the best use of the aged balance sheet?

Reading it is a two-step process. First, detect weak signals: a customer who is usually punctual but is now falling behind, an item that has just become overdue, a dispute that is dragging on. Then, prioritise: focus your efforts on significant outstanding amounts and established delays, combining graduated reminders, direct dialogue and, if necessary, a clearance plan. Documenting each interaction (promises, disputes, follow-up dates) transforms the balance sheet into a truly predictive management tool. The same logic on the supplier side helps to organise payments without undermining strategic relationships, while respecting agreed deadlines.

To enrich your analyses or contextualise a customer/supplier risk, the annual accounts filed with the Central Balance Sheet Office of the National Bank of Belgium (BNB) can be consulted. This is a useful supplement for objectifying a decision on a sensitive account or a new partner (financial analysis, solvency).

General ledger or aged ledger: how do they differ?

The general ledger lists all accounts (balance sheet and income statement) and movements for the period, resulting in end-of-period balances. It is exhaustive and essential for closing the books.

The aged balance sheet focuses on third parties (customers/suppliers) and emphasises time, isolating the age of outstanding positions. It is a management tool rather than a reporting document: it is used to make decisions (reminders, escalation, cash flow forecasts) rather than to draw up an inventory.

A tool for measuring collection performance

On the customer side, the aged balance sheet makes it possible to track the evolution of delays, measure the duration of outstanding amounts by tranche, evaluate the effectiveness of reminders and, if necessary, feed into provisions for doubtful debts. It also serves as a basis for cross-functional KPIs (proportion of established delays, promise fulfilment rate, DSO) and can be integrated into credit management or credit insurance solutions to speed up collection and reduce the risk of non-payment.