What it means
A customer pays an invoice, but the transfer arrives without a reference and remains unallocated while a reminder says the bill is overdue. This metric measures how long an identified payment-to-invoice matching problem remains unresolved.
Define an allocation exception as money received or recorded but not confidently matched to the intended customer and obligation. Stripe's cash-balance reconciliation guidance describes automatic and manual matching of transfers to invoices, including reference-based and amount-based paths, though a system guess can still need review.
The age starts when the exception is first identifiable under the reporting rule, not when someone later opens a work item. The endpoint is a verified allocation, authorised return or documented other disposition, and assigning an owner does not close it.
Check payer identity, bank reference, amount, currency, date and potential invoices before applying funds, and if several invoices have the same amount do not allocate to the first one solely because the numbers match. For a group payment, request or recover remittance advice and preserve the breakdown by invoice.
If the payment belongs to a related legal entity, verify whether cross-entity application is authorised, because similar names do not establish permission. If a transfer is still pending settlement, distinguish it from received unapplied cash, since the clock may begin at a different event, and keep processor delays separate from internal allocation work.
Where an invoice was credited or cancelled, do not automatically apply an incoming transfer to a different charge without checking intent. For a partial payment, allocate the verified portion and show the remaining balance honestly, and for multi-currency accounts preserve currency and conversion details rather than matching nominal amounts.
If the customer reports paying, use available transaction references through a secure channel without asking for a full bank statement when a smaller proof suffices. Pause inaccurate overdue messaging under the applicable policy while a plausible payment is investigated, and preserve the due date and any later correction to late-fee treatment when a payment arrived on time but was allocated late.
If a payment is returned, record the reason and date, do not count it as a successfully applied receipt, and inform the verified payer through an approved route; for refunds of unidentified money verify the original source and fraud controls, since a request from an unverified third party is not enough to redirect funds. Define whether age uses calendar or business days and report the age of still-open exceptions at the cut-off, because a median closed-case age can look good while one high-value payment remains stranded.
Classify causes as missing remittance, ambiguous amount, wrong entity, duplicate transfer, processor mismatch or invoice error, and audit a sample from receipt to allocation and customer statement, since a ledger credit in the wrong place is not resolution. Pair exception age with unapplied cash balance and complaints, keep a traceable record of the original bank event and final invoice posting, and if the customer asks for a receipt while allocation is pending, acknowledge the payment state without claiming the invoice is settled and give a next check time and owner.
In practice
Real-world examples.
Example
A bank transfer without a reference arrives Monday and is matched to the correct invoice Thursday. The exception age at close is three days, and the overdue flag is removed.
Example
Two customers owe the same amount. Billing checks payer identity rather than allocating solely by amount, and records the evidence used.
Example
The transfer is still pending settlement. The team reports that external state separately from received unapplied cash, because the allocation clock has not yet started.
Formula
Calculation
Illustrative age = verified disposition timestamp - first identifiable allocation-exception timestamp. Show open exception age at the reporting cut-off.
Worked example: a transfer arrives on Monday without a reference and is matched on Thursday, so the exception age at close is 3 days. Across five closed cases, an invented team records ages of 1, 2, 3, 4 and 20 days; the median is 3 days and the mean is (1 + 2 + 3 + 4 + 20) / 5 = 30 / 5 = 6 days. A further $12,000 transfer has been unallocated for 9 days at the cut-off, so it is reported in the open tail.
Allocation itself is simple arithmetic once the remittance is known. A single $10,000 transfer covering invoices of $2,000, $3,000 and $5,000 is posted as $2,000 + $3,000 + $5,000 = $10,000, leaving no unapplied balance.Case study
Seen in the real world.
This fictional case follows Northshore Billing, an invented supplier. A corporate customer sent one transfer for three invoices without remittance detail. The team obtained a breakdown, posted each amount and removed an incorrect overdue flag while preserving the original receipt reference.
It then listed other unreferenced transfers older than a week and contacted each payer through a known billing contact. Two more were matched the same day, and the team set a weekly review of the open tail. The case is invented.
Watch out
Common mistakes.
- Matching equal amounts without confirming the payer.
- Stopping the clock when a ticket is assigned instead of when funds are allocated.
- Sending collection reminders while a plausible payment remains under review.
Questions
People also ask.
Is received cash automatically applied?
Not always. Verify the correct customer and invoice match.
Should open exceptions count?
Yes. Report their age separately from completed-case lag.
Can a payment be returned?
Yes, under the authorised process if it cannot or should not be applied.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%Related