The aged balance is one of the most important tools for managing accounts receivable.
It makes it possible to see, at a given moment, how much money the company expects from its customers, for how long, from which customers, and with what level of aging.
It gives a snapshot of the stock of receivables.
But like any snapshot, it does not tell the whole story.
It shows what is open. It shows what has reached due date. It shows what is aging. It makes it possible to prioritize. But it does not always say why invoices are not paid.
An invoice overdue by more than 90 days may be a real non-payment risk. It may also be a technical dispute being resolved, a payment received but not matched, an expected credit note, an invoice rejected by a portal, or an internal error never corrected.
Reading an aged balance therefore does not only mean looking at aging columns.
It means understanding what the amounts are telling.
The aged balance is a prioritization tool. To become a decision tool, it must be enriched with the causes of delay.
The Aged Balance as a Snapshot of Accounts Receivable
The aged balance presents customer receivables open at a given date.
It answers several simple questions.
Which customers owe us money?
For what amounts?
Which invoices are not yet due?
Which invoices are already overdue?
For how many days?
Which amounts are becoming old?
Which customers concentrate exposure?
This view is essential for Collections, Credit Management, Finance, Treasury and sometimes Sales.
Without an aged balance, the company does not clearly see its stock of receivables.
It may know its revenue. It may know its available cash. But it does not precisely see the cash expected from customers.
The aged balance makes this expected cash visible.
It turns many open invoices into a readable structure.
Not Yet Due: Cash Normally Expected
The first important category is invoices not yet due.
An invoice not yet due is an invoice whose contractual payment date has not yet arrived.
It is not overdue.
It represents cash expected in the future according to the terms granted to the customer.
This part of the aged balance is sometimes underestimated because it is not yet a collection problem. Yet it already represents tied-up capital.
If a company has 5 million euros of invoices not yet due, this means that 5 million euros of sales have been made but not yet collected.
This amount is normal in a credit activity, but it must be financed.
Invoices not yet due must therefore be reviewed carefully.
Are they consistent with the level of activity?
Do they correspond to the expected payment terms?
Are they concentrated on a few customers?
Do they include very long due dates?
Are they linked to recent sales or to invoices whose due date was incorrectly set?
An invoice not yet due is not a delay. But it is already exposure.
Overdue Invoices: The Delay Begins
Overdue invoices are invoices whose payment date has passed.
They are at the center of Collections attention.
But not all overdue invoices should be treated in the same way.
An invoice overdue by two days with a reliable customer does not mean the same thing as an invoice overdue by 75 days with a fragile customer.
An invoice overdue because a payment is in progress does not mean the same thing as an invoice overdue with no response from the customer.
An invoice overdue because of an internal dispute does not mean the same thing as an invoice overdue because the customer lacks cash.
The aged balance generally separates overdue invoices by age: 0-30 days, 31-60 days, 61-90 days, more than 90 days.
This segmentation is useful because the older a receivable becomes, the more it deserves to be examined.
But age is only one criterion.
The cause of the delay remains essential.
0-30 Days Overdue: The First Alert Level
The 0-30 days overdue bucket groups invoices recently overdue.
This area is very important because it makes it possible to act early.
A recent delay is often easier to resolve than an old delay.
The customer still remembers the invoice. Documents are available. Contacts can be identified. The problem has not yet had time to settle.
In this bucket, typical actions include simple chasing, checking receipt, confirming status, requesting a payment date, quickly detecting a blockage or correcting an obvious error.
Invoices must not be allowed to slide mechanically into the next bucket.
An invoice that moves from 0-30 to 31-60 days has often lacked action or resolution.
The 0-30 bucket is therefore a prevention area.
It makes it possible to treat delays before they become heavy files.
31-60 Days Overdue: The Delay Settles In
The 31-60 days bucket signals that the delay is starting to settle in.
At this stage, a standard reminder is not always enough.
The company must know why the invoice is still not paid.
Has the customer promised payment?
Was this promise kept?
Is the invoice blocked in a portal?
Is a dispute open?
Is a document missing?
Is a credit note expected?
Is the customer going through cash tension?
In this bucket, qualification becomes essential.
If the cause is simple, it must be resolved quickly.
If the customer does not respond, escalation is needed.
If a promise has been missed, the action must be strengthened.
If a dispute exists, it must be assigned an owner and a target date.
The 31-60 bucket is often the moment when the company must move from a reminder logic to a resolution logic.
61-90 Days Overdue: Risk Increases
The 61-90 days bucket deserves strong attention.
At this stage, the delay is no longer recent. The invoice has probably already been chased. If it remains open, it means that a blockage persists or that the customer does not pay despite the actions taken.
These receivables must be examined in a more structured way.
Is the amount significant?
Is the invoice disputed?
Does the customer recognize the debt?
Does a payment promise exist?
Has it been respected?
Does an internal action plan exist?
Is a new order in progress?
Should the company block, reduce the limit or request partial payment?
Should the case be escalated to sales or financial management?
In this bucket, time starts to reduce the quality of the receivable.
Evidence may be harder to find. Discussions may repeat. The customer may get used to the delay. Internal teams may lose track.
The 61-90 bucket must therefore be managed with rigor.
An invoice that reaches this area must not remain without a cause, without an owner and without a next action.
More Than 90 Days: The Critical Area
Invoices overdue by more than 90 days are often considered critical.
This does not mean that they will all be lost. But they require serious analysis.
After more than 90 days, several risks appear.
The customer may be in difficulty.
The dispute may be getting stuck.
The invoice may have become old in the customer’s process.
Chances of collection may decrease.
The file may have to be provisioned.
The blockage may require strong escalation.
The cases must therefore be distinguished.
An invoice over 90 days linked to a payment received but not matched must be cleaned quickly.
An invoice over 90 days linked to an approved credit note must be corrected.
An invoice over 90 days linked to a dispute with no owner must be escalated.
An invoice over 90 days undisputed with a customer that no longer responds may move toward pre-litigation or litigation.
The over 90 days bucket must not become a parking lot.
Each amount must have an explanation and an expected decision.
Reading the Balance by Customer
An aged balance can be read invoice by invoice. But it must also be read by customer.
A customer may have a few recent overdue invoices without the situation being concerning.
Another customer may accumulate old invoices, broken promises, disputes and new orders.
Reading by customer makes it possible to understand total exposure.
How much does the customer owe in total?
What share is not yet due?
What share is overdue?
What share is old?
Are delays concentrated on one invoice or spread across the whole account?
Does the customer pay some invoices but not others?
Are there recurring disputes?
Have recent payments been received?
This reading is essential for credit decisions.
An order should not be blocked based on a single invoice without looking at the whole account.
A limit should not be increased without understanding the quality of outstanding balance.
The aged balance must therefore be read as a customer portfolio, not only as a list of invoices.
Reading the Balance by Amount
Age is important, but amount is important too.
An invoice of 1,000 euros overdue by more than 120 days does not have the same cash impact as an invoice of 300,000 euros overdue by 20 days.
Collections must prioritize significant amounts.
This does not mean ignoring small amounts. Small balances can clutter accounts, distort reminders, hide process problems or create significant volumes when they are numerous.
But effort must be proportionate.
Large amounts must be followed closely, even when they are recent.
A large invoice overdue by 10 days may deserve more attention than a very old small invoice.
Effective reading combines amount and age.
Cash is managed in value, not only by number of invoices.
Reading the Balance by Customer Risk
Two invoices with the same amount and the same age can have very different risk levels.
A solid, long-standing, responsive customer, with an invoice blocked because of a missing document, presents a different risk from a fragile, silent customer with several broken promises.
The aged balance must therefore be enriched by customer risk reading.
Is the customer solvent?
Is its payment behavior stable?
Has it respected previous commitments?
Is its limit exceeded?
Does credit insurance cover the exposure?
Is the sector or country deteriorating?
Are there weak signals?
This reading makes it possible to prioritize actions.
A delay with a risky customer must be treated more quickly and more firmly.
A delay with a healthy customer but an administrative blockage must be resolved differently.
The aged balance shows the delay. Customer risk helps decide the intensity of the action.
Disputes in the Aged Balance
Disputes must be clearly identified in the aged balance or in the tools that support it.
A disputed amount is not treated in the same way as an undisputed amount.
But the “dispute” category is not enough.
The cause must be known: price, quality, quantity, delivery, service, contract, penalty, credit note, deduction, VAT, missing document.
The amount actually disputed must be known.
The owner must be known.
The target resolution date must be known.
The company must know whether the undisputed amount has been requested or collected.
Without this information, the dispute becomes a grey area.
In the aged balance, it can age month after month without real action.
Disputes must therefore be visible, but also qualified.
An enriched aged balance distinguishes payment delays from amounts blocked by disputes.
This distinction is essential for managing cash.
Payment Promises
Payment promises are key information when reading an aged balance.
A customer may have overdue invoices but may have given a clear promise: amount, date, invoices concerned, contact person.
This promise must be visible.
It makes it possible to forecast cash.
It also makes it possible to follow the customer’s behavior.
A promise kept strengthens trust.
A broken promise weakens the customer profile.
The aged balance should therefore be enriched with promises: promised date, promised amount, status, history.
A vague note saying “payment expected” is not enough.
The company must be able to know whether payment is expected tomorrow, next week, after a customer cycle, or without a precise date.
A usable promise is precise.
In management, invoices with a credible promise are not treated like invoices without response or with repeated broken promises.
Payments Received but Not Matched
An aged balance can contain invoices that appear open even though the customer has already paid.
This happens when payment is received but not matched.
Grouped payment without detail.
Payment without reference.
Payment allocated to the wrong account.
Offset not understood.
Deduction not qualified.
Credit note not applied.
These situations distort the reading.
The customer seems late, but cash has arrived.
If the company chases, it may damage the relationship.
If it blocks, it makes a poor decision.
If it calculates DSO on these open invoices, the indicator is distorted.
Payments received but not matched must therefore be identified and treated quickly.
A useful aged balance must be reconciled with suspense accounts, unallocated payments and remittance advices.
Accounts receivable is reliable only if cash received is correctly applied.
Non-Payable Invoices
Some invoices appear overdue because they are not payable.
They cannot be integrated into the customer’s process: missing PO, portal rejected, receipt not validated, wrong entity, missing contract reference, missing supporting document, VAT disputed, incorrect currency.
The aged balance does not always show this information.
It says that the invoice is overdue. It does not say that it has been blocked since day one because the portal rejected it.
It is therefore important to add a payability reading.
Has the invoice been received?
Accepted?
Validated?
Scheduled for payment?
Rejected?
Waiting for a document?
Waiting for receipt?
This information changes the action.
A non-payable invoice must be corrected or completed.
A payable and unpaid invoice must be chased more firmly.
The aged balance must be connected to the real processing status on the customer side when this information is available.
Risky Customers
The aged balance must highlight risky customers.
A risky customer is not only a customer with old invoices.
It is a customer whose behavior or situation may threaten collection.
Broken promises.
Delays that lengthen.
Silence.
Known financial difficulties.
Recurring disputes.
Frequent deductions.
Limit exceeded.
Reduced insurance coverage.
Sector or country under tension.
Requests for additional time.
New orders while overdue invoices increase.
These signals must be visible.
They make it possible to prioritize actions and avoid worsening exposure.
An aged balance enriched with customer risk becomes a decision tool for limits, blocks, down payments, guarantees and escalations.
Without this reading, the company may treat truly dangerous accounts too late.
Expected Credit Notes
Expected credit notes can explain part of the delays.
The customer withholds payment because it is waiting for a correction, discount, return, accepted penalty or adjustment.
In the aged balance, the invoice appears open.
But the cause is sometimes an internal decision not made.
Is the credit note approved?
By whom?
For what amount?
On which invoice?
When will it be issued?
Can the customer pay the balance?
Expected credit notes must be monitored rigorously.
A small credit note can block a much larger invoice.
An enriched aged balance must therefore identify invoices withheld because a credit note is expected.
Otherwise, they age as simple customer delays even though they depend on an internal action.
Deductions and Small Balances
The aged balance often contains residual balances.
A customer has paid almost everything, but 50 euros, 200 euros, 1,000 euros, sometimes more, remain open.
These balances can come from bank fees, foreign exchange differences, early payment discounts, rounding, deductions, penalties, unmatched credit notes, payment errors or partial disputes.
They may seem minor, but they clutter the balance.
They create useless reminders.
They reduce account readability.
They consume processing time.
The company must have rules for small balances: chasing, justification, offset, credit note, difference posting, write-off approval, grouping, analysis of recurring causes.
Good management of the aged balance includes clean-up.
A balance full of old small amounts becomes less readable and less useful.
Orders Blocked by the Balance
The aged balance often influences block or release decisions.
A customer with significant overdue invoices may have new orders blocked.
But the decision must not be automatic without analysis.
Are overdue invoices linked to real delays?
To disputes?
To unmatched payments?
To non-payable invoices?
To an expected credit note?
To a credible promise?
To financial difficulty?
The aged balance gives the alert, but the cause guides the decision.
Blocking a customer for an invoice already paid but not matched would be a mistake.
Releasing a customer that accumulates broken promises would be dangerous.
The link between aged balance and order block must therefore be intelligent.
The age of the receivable triggers analysis. It must not replace judgment.
Prioritizing with the Aged Balance
The aged balance is a prioritization tool.
It makes it possible to decide where to act first.
Large overdue amounts.
Invoices approaching old buckets.
Risky customers.
Significant disputes with no owner.
Broken promises.
Non-payable invoices to correct quickly.
Unmatched payments that distort the account.
Old balances to clean.
Good prioritization combines several criteria: amount, age, risk, cause, probability of resolution, impact on orders and cash impact.
The raw aged balance classifies by time.
The enriched aged balance classifies by action.
This difference is what makes management effective.
The Limits of Reading by Buckets
Age buckets are practical, but they can create threshold effects.
An invoice overdue by 29 days appears in the 0-30 bucket. The next day, it moves to 31-60 and suddenly seems more concerning.
In reality, the risk has not changed sharply in one day.
Buckets are reading conventions.
They help organize, but they must not make the analysis rigid.
The company must avoid treating an invoice only because it changes bucket, or ignoring an important invoice because it is still in a recent bucket.
The reading must remain dynamic.
What is the amount?
Who is the customer?
What is the cause?
What is the next action?
What is the risk if nothing happens?
Buckets provide structure. They must not lock the reasoning.
Cleaning the Aged Balance
An aged balance must be cleaned regularly.
This means resolving unmatched payments, applying credit notes, treating small balances, closing resolved disputes, correcting errors, posting necessary entries, removing written-off or provisioned receivables according to applicable rules.
An aged balance that is not cleaned loses value.
It mixes real delays, false delays, residual amounts, old errors, closed disputes not treated, unapplied credit notes and pending payments.
Teams lose trust in the tool.
Salespeople challenge blocks.
Customers are wrongly chased.
Management receives a distorted image.
Clean-up is not a secondary task.
It is a condition for quality management.
A clean balance makes it possible to decide faster and more fairly.
Reading Trends
The aged balance must not only be read at a given moment.
Its evolution must be followed.
Are overdue invoices increasing?
Are invoices over 90 days decreasing?
Are disputes aging?
Are promises being respected?
Are unmatched payments accumulating?
Are risky customers concentrating more outstanding balance?
Are invoices not yet due increasing with growth?
Are delays moving from one activity to another?
The trend is often more important than the snapshot.
An aged balance with 1 million euros overdue can be concerning or reassuring depending on whether it was 2 million the previous month or 300,000 euros.
Managing means observing the trajectory.
The aged balance must therefore be analyzed over time.
Building an Enriched Balance
An enriched aged balance is not limited to aging columns.
It adds management information.
Invoice status: payable, rejected, disputed, promised, waiting for document, paid but not matched.
Cause of delay.
Action owner.
Next action date.
Payment promise date.
Disputed amount.
Undisputed amount.
Customer risk level.
Credit limit.
Blocked orders.
Collection comment.
Target resolution date.
This richness transforms the tool.
The balance is no longer only an accounting statement.
It becomes a list of prioritized actions.
Each line must be able to answer three questions: why is this amount open, who is acting, and when is the next decision expected?
Example: Raw Reading and Enriched Reading
An aged balance shows an invoice of 100,000 euros overdue by 75 days.
Raw reading: invoice very late, customer to chase firmly, possible block.
Enriched reading: invoice linked to a service, partial dispute of 20,000 euros on a deliverable, 80,000 euros undisputed, owner Operations, acceptance report expected Friday, customer committed to paying the undisputed amount after receipt of the report.
The action becomes different.
The acceptance report must be accelerated, payment of the 80,000 euros must be obtained, the 20,000 euro dispute must be followed and the promise must be checked.
Enriched reading turns a general alert into an action plan.
Example: Old Invoice but Payment Received
An invoice of 45,000 euros appears over 90 days.
The raw balance seems to indicate high risk.
After analysis, payment was received three weeks earlier in a grouped transfer, but it remained unmatched because there was no remittance advice.
The priority action is to handle cash application, not to chase the customer.
The raw balance said “delay.”
The real cause was “payment received but not allocated.”
Without enrichment, the company could have chased wrongly and distorted its indicators.
Example: Risky Customer Despite Recent Age
An invoice of 200,000 euros is overdue by only 12 days.
It is therefore in the 0-30 bucket.
But the customer is in difficulty, its insurance coverage has been reduced, it has missed two recent promises and it requests a major new order.
Reading by bucket could minimize the issue.
Enriched reading shows high risk.
Action must be fast: escalation, limit review, conditioning of new orders, request for partial payment.
A recent invoice can be a priority if customer risk is high.
Example: Small Balances Polluting the Balance
A company has hundreds of small balances over 180 days.
Most come from foreign exchange differences, bank fees, rounding or poorly matched credit notes.
Each balance is small, but together they make the balance hard to read.
Teams waste time filtering real issues.
The solution is to define a clean-up policy: thresholds, approval, reasons, postings, analysis of recurring causes.
A useful aged balance must remain readable.
Cleaning small balances improves management quality.
The Aged Balance as a Collective Tool
The aged balance does not only concern Collections.
It also concerns Sales, because delays can block orders and influence the customer relationship.
It concerns Sales Administration, because causes may come from orders, POs, data and documents.
It concerns Operations, because evidence, receipts and disputes influence payment.
It concerns Billing, because rejected or incorrect invoices age.
It concerns cash application, because unmatched payments distort the reading.
It concerns Finance, because the aged balance impacts cash, WCR, provisions and forecasts.
The aged balance is therefore a collective Quote-to-Cash management tool.
It shows where cash is tied up.
But each function may hold part of the solution.
Key Takeaways
The aged balance makes it possible to read the stock of customer receivables.
It distinguishes invoices not yet due, overdue invoices, and aging buckets: 0-30, 31-60, 61-90 and more than 90 days. It helps see amounts, customers, delays and exposures.
It is an essential prioritization tool.
But it must be enriched.
A raw aged balance shows the age of receivables. It does not always say why they are open.
To decide correctly, the causes of delay must be added: disputes, payment promises, payments received but not matched, non-payable invoices, expected credit notes, deductions, risky customers, missing documents, internal actions in progress.
Good reading combines age, amount, risk, cause, owner and next action.
A useful aged balance must not become a simple table of figures.
It must become a management tool: why is cash blocked, who must act, and when must the situation be resolved?
Reading an aged balance is not only about looking at the past of invoices.
It is about organizing the actions that will turn the stock of receivables into cash.