Cash application
How to match bank deposits to invoices without guessing
SettlePair Editorial · Published August 29, 2026 · 3 min read
Matching deposits to invoices is straightforward when the reference is clean and difficult when it is not. This article sets out the signals worth trusting, in what order, and what to do when the bank description tells you almost nothing.
Key takeaways
- Rank evidence: an exact invoice reference beats an exact amount, and an exact amount beats a name resemblance.
- One strong signal is rarely enough on its own when the same amount appears more than once in the ageing.
- Batched deposits should be split against the remittance advice, not forced onto the closest single invoice.
- Record why a match was accepted; a match without evidence cannot be reviewed by anyone else.
The signals, in order of reliability
Ambiguity should reduce confidence, not be ignored. If two open invoices could equally explain a deposit, neither match is safe until something distinguishes them.
From strongest to weakest:
- Invoice number present in the payment reference or description — near-conclusive when it is an exact token match.
- Amount equal to the invoice total to the cent — strong, unless the same amount is open more than once.
- Amount within a small tolerance — covers transfer fees and rounding, weaker than an exact figure.
- Payer name overlapping the customer name — useful corroboration, unreliable alone because payers trade under other names.
- A plausible date, after the invoice was issued and near the due date — supporting evidence only.
The cases that take the time
Expect these every period:
- Batched deposits: one transfer covering many invoices, sometimes across several weeks.
- Part payments: a customer pays what they have approved and holds the rest.
- Short payments: a deduction for a discount, a dispute or a return.
- Payer aliases: payments arriving from a parent company, a factoring provider, or a payment processor.
- Descriptions with no reference at all — the hardest cases, resolvable only through remittance advice or a call.
A workable method
Sort the deposits by value and take the largest first: they carry the most risk and often resolve several invoices at once. Match everything with a clean reference before touching anything ambiguous, because each confirmed allocation removes candidates from the pool and makes the remainder easier.
Then work through the amount matches, checking that the payer is plausible and the date sits after the invoice was issued. Whatever is left is genuinely exceptional, and belongs on a short list to chase with the customer rather than in the reconciliation.
Bank 2026-03-18 ACH HARBORLINE STUDIO 4,120.00 INV-1042 1,240.00 ref found in remittance INV-1051 1,880.00 ref found in remittance INV-1057 1,000.00 part payment of 1,450.00 unapplied 0.00
Reduce the exceptions at source
- Put the invoice number in a field the customer's payment system will carry through to the reference.
- Ask for remittance advice by email for any batched payment, and keep it with the allocation.
- Avoid re-using invoice numbers or issuing round-number invoices that collide in the ageing.
- Record the trading name your customer actually pays from, once you learn it.
Doing this in SettlePair
SettlePair applies these signals deterministically. Each suggestion carries a 0–100 score built from named components — reference match, amount agreement, name overlap, date plausibility, less a penalty when another transaction could match equally well — and every component is visible in the row. Identical inputs always produce identical scores; there is no model and no learned behaviour.
Automatic suggestions are strictly one payment to one invoice. Batched deposits, part payments and remainders are allocated by you in the allocation sheet, in integer cents, and can never exceed the invoice's remaining balance or the payment's unapplied balance.
Common questions
- What if the bank description has no invoice number?
- Fall back to amount agreement plus payer name and date plausibility, and treat the match as provisional until the remittance advice or the customer confirms it. If two invoices fit equally well, leave the payment unapplied rather than guessing.
- Should I match on amount alone?
- Only when that amount is open exactly once. Round amounts and recurring monthly fees frequently appear several times in an ageing, and a wrong allocation there is difficult to find later.
Sources
- J.P. Morgan — The cash application process: a how-to guide
- Atlar — Bank reconciliation: a practical guide for finance and accounting teams
- Quadient — 5 common cash application problems and how to solve them
- Zone & Co — Automated cash application glossary
General guidance only, not accounting, tax or legal advice. Confirm treatment with your accountant and your own policies.