Receivables measurement
Why an ageing report does not tell you when cash will arrive
An ageing report measures one thing: the days elapsed since an invoice was issued or fell due. That number is a fact about your calendar, not about the account. Two invoices can share a bucket while one is a day from settling and the other will never be paid in its current form.
What bears on arrival is the invoice’s operating state — whether a payment date was committed and by whom, what happened last, what happens next and who owns it, whether the invoice is disputed, and whether the customer has everything they need to pay it. Holding those facts gives you a better-informed expectation. It does not give you a forecast, and nobody can honestly sell you one.
What an ageing bucket measures — and what it cannot contain.
An ageing report is arithmetic on a single field. It takes an invoice date or a due date, subtracts it from today, and drops the balance into a column. Every invoice in the 61–90 column arrived there the same way, which is the difficulty: the calculation has no access to anything that happened between issue and this morning.
The report is still worth producing. It is a reasonable measure of exposure — how much is outstanding, how concentrated it is in a few customers, and how far past terms the balance has drifted. It is a poor instrument for the question owners actually put to it, which is when the money lands.
| Same age | Invoice A | Invoice B |
|---|---|---|
| Days outstanding | 47 | 47 |
| Ageing bucket | 31–60 | 31–60 |
| What happened last | Finance confirmed in writing it sits in this week’s payment run | Three reminders sent, none answered |
| Committed date | Friday, given by someone with authority to give it | None |
| Dispute | None raised | Scope queried verbally last month, never resolved |
| Still needed from them | Nothing | A purchase-order reference the invoice was never issued against |
| Honest expectation | Likely to settle this week | Will not be paid in its current form |
Six facts that move an invoice from “overdue” to “expected”.
None of these is exotic and none requires new software to capture. What they require is that somebody writes them down against the invoice at the moment they become known, rather than leaving them in the conversation where they occurred.
- A commitment, with its provenance. Not “they said soon” but a date, an amount where one was stated, the person who gave it, and where it was said. A commitment from an accounts clerk and one from a finance director are different instruments.
- What happened last, and when. An invoice that had a real exchange four days ago is in a different condition from one nobody has touched since it was issued, whatever their ages.
- What happens next, on what date, owned by a name. An open invoice with no scheduled next action is not being collected. It is being watched.
- Dispute state, held separately from collection state. An invoice can be overdue and disputed at once. The second condition makes the first irrelevant until it is resolved.
- What is blocking the customer’s own process. A missing reference, an unapproved timesheet, a portal submission never completed, an invoice addressed to a legal entity that does not exist. These are the cheapest problems in receivables and the most commonly invisible.
- The account’s own observed behaviour. Whether this customer has paid on these terms before, on which day of their cycle, and whether they have ever broken a commitment.
Only the last of those touches likelihood, and it should be handled with care. A pattern observed in your own records — the same customer settling on the same terms, on the same day of their month, repeatedly — is evidence you can point at. A percentage attached to an invoice by software that has never spoken to your customer is not. The first can be explained to the person who asks. The second cannot be defended when it is wrong.
Sometimes the bucket is wrong about the amount, not the timing.
An ageing report is only as true as the ledger beneath it, and receivables ledgers drift in specific, recurring ways. Before an ageing total is read as a picture of what is owed, it is worth knowing which of these it may be carrying.
- Cash already received but unallocated. The money is in the bank and the invoice is still ageing, because nobody could establish which invoices the transfer covered.
- Credit notes never applied to the invoices they relate to, so a balance that was reduced weeks ago still shows in full.
- Invoices the customer never received — sent to somebody who left, blocked by a supplier portal, or issued to the wrong entity in a group. Fully aged, never seen.
- Duplicates raised for the same piece of work, usually after a proforma or a revised version.
- Amounts conceded verbally and never recorded, so the ledger is chasing a figure the customer has no intention of paying and has already said so.
- Deductions the customer will always make — a tax withheld at source, a platform or processor fee, a contractual retention. The invoice settles short by design and the remainder ages indefinitely.
Each of these makes the ageing report overstate what is genuinely collectable. Which means the total at the bottom is not a cash figure and should not be handed to anyone as one.
A quick diagnostic on any ageing report: how much of the oldest column has had a real action against it in the last thirty days? If the answer is very little, that column is not a receivables position. It is a backlog with a date attached.
A well-informed expectation — and what nobody can promise.
The useful output is not a predicted date against every invoice. It is a receivables position sorted by state rather than by age, in which each open balance sits in one of a small number of honest categories.
- Committed. A specific date was given by somebody with the authority to give it, recorded with when and where it was said.
- In process. Approved on the customer’s side and inside their own payment cycle, with a known cycle date.
- Blocked. Something specific is missing — a reference, a document, an approval — and until it is supplied the invoice cannot pay, whatever its age.
- Disputed. A commercial question is open, and no volume of routine follow-up will close it.
- Unanswered. Contact has been attempted and nothing has come back. This is the category that most deserves a decision from the owner, and the one age hides most effectively.
Sorted that way, the report reads in a different order: not oldest first, but least resolved first. It also becomes honest about its own limits. A committed invoice is more likely to arrive than an unanswered one — that is a statement about the quality of your information, not a prediction. The customer can still change their mind, and a proportion of them will.
Where At Par fits — and the limits.
At Par keeps the receivables record in the condition described above as part of ordinary bookkeeping: the invoice register current, commitments captured as dated facts with their provenance, broken ones surfaced rather than absorbed back into the ageing, dispute and evidence status held separately from collection status, and payment evidence reconciled before an invoice is treated as settled.
That work sits alongside bookkeeping and month-end close and management reporting, so the receivables position in your reports is the same one being worked, rather than a separate spreadsheet that agrees with nothing. Where the underlying records are held, and how they are protected, is documented on its own page. The wider question — which parts of a receivables process can be handed over at all, and which should stay under your control — is covered in our guide to accounts receivable outsourcing.
Asked by owners reading an ageing report and wanting a date.
Can an ageing report predict when an invoice will be paid? +
No. An ageing report is arithmetic on a single date — it reports how long a balance has been outstanding and nothing about what has happened since. Two invoices in the same bucket can have completely different prospects: one confirmed in a payment run, the other blocked because the customer never received it. Prediction needs operating facts the report does not hold — a committed date, the last action, an open dispute, a missing reference. Age describes the calendar; those facts describe the account.
What is the difference between an ageing report and an expected payment date? +
Ageing is produced automatically from the invoice date and today. An expected payment date is a claim about the future, and it is only worth recording when something supports it: a commitment from somebody with authority to give one, a known customer payment cycle, or an approval that has already cleared. An expected date with no stated source is a guess with a date on it. Where the expectation came from matters as much as the date, because it determines what to do when the date passes.
Why do two invoices of the same age behave completely differently? +
Because age is not caused by anything. An invoice reaches sixty days for unrelated reasons — a customer paying on a monthly cycle, an unanswered query, a purchase-order reference the invoice was never issued against, an invoice sent to somebody who has left, or a decision not to pay. The bucket records elapsed time and discards the cause. Until the cause is written against the invoice, every item in a column looks identical and none of them can be prioritised sensibly.
Does days sales outstanding tell you when cash will arrive? +
No. Days sales outstanding is a backward-looking average across a portfolio. It summarises how long money took to arrive over a past period, which is useful for spotting a trend and useless for a single invoice. An average cannot say whether the balance in front of you today is committed, blocked or disputed. It is also easily distorted by one large invoice or by billing timing, so a movement in it often says more about the month than about customer behaviour.
Can an accounting provider forecast when customers will pay? +
Not honestly, because payment is decided by the customer. What a provider can do is shrink the guesswork around it: record every commitment as a dated fact with its source, surface the ones that were not kept, keep dispute and evidence status visible, and make sure nothing sits untouched. That produces a better-informed expectation and a shorter list of unknowns. Anyone offering a collection forecast, or a specific reduction in days outstanding, is making a claim about your customers they cannot support.
Why does an ageing report show invoices that have already been paid? +
Usually because cash arrived that could not be allocated. A customer pays several invoices in one transfer with no remittance advice, so the money sits in the bank while the invoices continue to age. Credit notes never applied, invoices raised twice for the same work, and payments received net of a standing deduction do the same thing. The balance is real in the ledger and not real commercially, which is why an ageing total should never be read across as expected cash.
Should overdue invoices be prioritised by age? +
Age is a weak sorting order. A ninety-day balance blocked on a reference number needs one email; a thirty-day balance from a customer who has stopped replying may need a decision from the owner. Sorting by state — committed, in process, blocked, disputed, unanswered — puts the invoices that need a person first and leaves the ones already moving alone. Age is worth keeping as a second sort within each state, where it genuinely indicates severity.
Is the total on an ageing report the cash we can expect? +
No, on two counts. It says nothing about timing, and it usually overstates what is collectable. Ageing balances routinely include cash already received but unallocated, credit notes never applied, invoices raised twice for the same work, invoices the customer never received, amounts conceded verbally and never recorded, and standing deductions the customer will always make. A collectable position is what remains once those have been removed and every balance carries a state — and even then it comes with no date attached.
Send us your ageing report. We’ll tell you what it isn’t telling you.
Export it however it comes out — a spreadsheet is fine. We will mark up which balances have a real next action behind them, which are stuck on something specific and cheap to fix, and which are already settled in cash and still ageing.
Prefer to reach us directly? Tell us a little and we'll come back with a time.
Review our ageingWe use your details only to prepare for and hold this call. No spam, ever.
Reviewed by an ACCA on the At Par team · Last updated 29 July 2026 · This page describes what receivables information can and cannot support; it makes no claim about how quickly your customers pay. See what we actually do.