Unallocated Cash Checklist
Unallocated cash is money you have received but not yet matched to an invoice. Left to build up, it overstates open AR and breaks reconciliation. This checklist clears it down to a defensible minimum.
What this checklist covers
- Locate every receipt sitting unallocated or on account
- Trace payments to the correct invoice and customer
- Resolve duplicates, overpayments and refundable balances
- Reduce the unallocated balance before reconciliation
- Document anything that genuinely cannot be cleared yet
6 min
Before you start
You cannot clear what you cannot see, so first build a complete list of unallocated receipts. Have your remittances and bank data ready to investigate them.
- Run a report of all unapplied and on-account balances by customer.
- Gather remittance advices and bank narrations to identify what each receipt relates to.
- Have the open aged trial balance ready so you can match against live invoices.
- Note the age of each unallocated item — the oldest are usually the hardest to resolve.
Step 1 — Trace each receipt
- For each unallocated amount, find the matching open invoice using the remittance or bank reference.
- Where it pays several invoices, split and apply it across them.
- Contact the customer for a remittance where the allocation is genuinely unclear.
- Apply the receipt and confirm the customer balance now makes sense.
Step 2 — Resolve the awkward balances
- Overpayment: apply to open invoices, then arrange to carry forward or refund the residue.
- Duplicate payment: confirm with the customer and refund or hold against future invoices as agreed.
- Wrong customer: reverse and reallocate to the correct account so both balances are right.
- Truly unidentified: keep it on a holding account with a note, and keep chasing the source.
Step 3 — Reduce and document
- Re-run the unallocated report and confirm the balance has fallen to a defensible minimum.
- List any remaining items with the reason, the next action and an owner.
- Confirm the cleared receipts now show against the right invoices on the aged report.
- Hand the tidied ledger to reconciliation.
A persistent unallocated pile often points to a remittance or terms problem. The getting-paid-faster guide covers fixes, and our free tools help standardise how customers pay and remit.
Common mistakes
- Letting it age. Old unallocated cash is far harder to identify once the context is lost.
- Treating it as income. Money on account is owed back to the customer until matched — it is not revenue.
- Guessing allocations. A wrong guess distorts two accounts and is harder to unwind than asking.
- No holding-account discipline. Genuinely unidentified cash needs a tracked home, not a quiet corner of the ledger.
Key takeaways
- Unallocated cash overstates open AR and breaks reconciliation
- Trace each receipt with the remittance before applying it
- Resolve overpayments and duplicates by refund or carry-forward, as agreed
- Keep any truly unidentified cash on a tracked holding account with notes
Frequently asked questions
Why is unallocated cash a problem at month-end?
Because it sits as a credit on the customer's account, it makes your total open AR look lower than the invoices actually outstanding, and it causes a difference between cash banked and cash applied. That difference is exactly what trips up reconciliation.
What should I do with cash I cannot identify at all?
Hold it on a clearly labelled holding or suspense account with a note of what you know, and keep investigating — check the bank reference, contact likely customers, and review around the receipt date. Do not write it off or treat it as income until you have genuinely exhausted the trail.
How do I stop unallocated cash building up?
Encourage customers to send remittance advice, give them a clear reference to quote, and apply cash frequently rather than in a month-end rush. The less context that is lost, the easier every receipt is to match.
Work the checklist, then get paid
Use the free Invoice Generator, then let Merion recover anything that goes unpaid — commission-only.