What it means
A customer pays, but finance cannot confidently match the receipt to a customer account and invoice. Customer cash application exception aging shows how long such unresolved payment-matching cases have remained open, and the cash may be in the bank even while the receivable ledger still appears unpaid.
It is a prompt to investigate, and a lower old-balance bucket is useful only when receipts are applied accurately and the remaining queue is visible. Define an exception (an unidentified payer, missing invoice reference, short payment, overpayment or mismatch across currencies) and state which cases enter the queue.
Set the start using bank receipt, lockbox file acceptance or the first failed automated match according to the process, because different starts yield different ages. Set the end: a receipt is resolved when valid application, authorised on-account posting, refund or other disposition is recorded and reviewed, not when a guess is entered.
Distinguish unapplied from unidentified, because money linked to a customer but not an invoice differs from money whose payer is unknown, and each needs its own evidence path. Check bank evidence, since a customer remittance advice alone does not prove cash arrived, and verify legal entity and customer reference because similar company names and shared payment services can cause misapplication.
A payment may cover several invoices or deduct a disputed amount, so reconcile the total rather than forcing a one-to-one match, using invoice numbers, payment references and customer statements to narrow the candidates while checking amounts and dates. Watch duplicate receipts, because a bank feed and a lockbox import may each represent the same payment, and track currency, since a bank amount after conversion may not match the invoice face amount under documented exchange and fee rules.
Do not send an overdue notice merely because an internal application exception makes a paid invoice look open. APQC measures the percentage of receipts automatically applied to invoices without manual intervention, whereas aging focuses on the exceptions left behind, and Oracle describes unapplied, unidentified and on-account receipts as distinct categories with a register for review, which illustrates why aging definitions matter.
Use aged buckets (0-2, 3-7 and over 7 days only as an internal example, since the right thresholds depend on close and customer needs) and show both count and amount, because one old large receipt can be more material than many small new ones. Include open and resolved cohorts but do not blend them, since the current open age and the time-to-resolution of closed exceptions answer different questions.
Review write-offs and adjustments carefully: an unexplained short payment should not be cleared by a write-off simply to reduce the queue, and credit notes and deductions can explain a difference only if their authorisation and accounting status are verified. Set ownership, since cash application may need help from collections, sales or the customer and the queue should record who is waiting for what.
Do not assume customer fault, because missing references may stem from invoice design, bank truncation or poor internal matching logic, and a recurring missing invoice number in one channel may be fixed by payment instructions or parsing changes. Guard sensitive bank and customer information through approved access rather than broad exception emails, and assess close risk, since old exceptions can distort customer balances, aging reports and collection decisions even if total bank cash is correct.
In practice
Real-world examples.
Example
A bank payment of $8,400 arrives on Monday but lacks an invoice reference. By Thursday it is three calendar days old in the exception queue and moves into the 3-7 day bucket. The analyst contacts the payer's accounts team for a remittance breakdown.
Example
A customer payment covers three invoices and a disputed deduction. Finance checks the remittance, posts only the valid allocations and leaves the deduction in a separate dispute status. The total received is reconciled to the sum of the allocations plus the open deduction.
Example
An invoice appears overdue despite a payment already received. Collections places a hold on the reminder while cash application investigates, so the customer does not receive an inaccurate demand. The hold is lifted once the receipt is posted.
Formula
Calculation
Illustrative open-exception age = report timestamp - declared receipt or first-exception timestamp for each unresolved payment. Summarise by age bucket and amount. Closed-case resolution time uses actual verified disposition time instead.
Worked example. On 30 September three receipts are unresolved: $4,000 first flagged 2 days ago, $12,500 first flagged 6 days ago, and $30,000 first flagged 11 days ago.
- By age bucket, the 0-2 day bucket holds one receipt worth $4,000, the 3-7 day bucket holds one worth $12,500, and the over-7 day bucket holds one worth $30,000.
- Total open value is $4,000 + $12,500 + $30,000 = $46,500.
- By count the old bucket is 1 of 3 (33%), but by amount it is $30,000 / $46,500 = 65%, so the old receipt deserves first attention.
- Report open age and closed-case resolution time separately, so clearing many small items does not hide the oldest one.Case study
Seen in the real world.
This entirely fictional case follows Harbor Supplies, an invented distributor. Its oldest unapplied payments came from one bank feed that truncated invoice references, so dozens of paid invoices still looked open. Finance traced the payers and invoices using remittance files, corrected the matching rule and suspended misleading collection prompts until balances were repaired.
The aging report was then split into count and amount, which showed that three large receipts made up most of the old balance. The weekly review began with those three items and a named owner for each. The case does not authorise any real account adjustment or customer contact and describes a process only.
Watch out
Common mistakes.
- Treating cash in the bank as if it were already applied to the correct invoice.
- Clearing a queue with guessed allocations or unsupported write-offs.
- Sending a past-due notice based on an account balance known to have an unapplied receipt.
Questions
People also ask.
Is unapplied cash the same as unpaid invoices?
No. The money may have arrived but not been matched to the receivable.
Should on-account receipts count?
Only under the stated exception definition; some on-account postings are valid final dispositions.
Why show amount as well as age?
Aging alone can hide a material old receipt among many small cases.
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