What it means
A customer pays two invoices in one bank transfer but puts only one invoice number in the reference, so the cash application team must identify both balances and split the payment accurately, because a quick automatic match can still be wrong. NetSuite documentation describes bank-line matching, invoice suggestions and adjusting applied amounts, and it also distinguishes applied and unapplied balances, but these product functions illustrate the control, not a universal accounting policy.
Start with a real receipt, matching the bank transaction to a payment record without duplicating it, since a screenshot of a remittance is not proof funds arrived. Identify the customer, since names can be similar and a group may have several legal entities, and check bank details, reference and approved mapping rules.
Read remittance details, because the customer may specify several invoices, deductions or a credit note, and preserve the document and its source. Confirm currency, as an invoice in a different currency may require separate handling and an amount should not be applied across currencies without the proper accounting process.
Check open balances, since an invoice could already have a pending allocation, and separate exact matches from suggestions, because an algorithm may propose the oldest invoice or closest amount and cases without a reliable reference deserve review. Define accuracy: a payment is correctly allocated only when the right customer, invoice and amount match the valid remittance and records.
Track partial payments, as a customer may pay part of an invoice because of an agreed instalment or a dispute and the remaining balance should stay visible. Handle deductions carefully, since a short payment can represent a dispute, discount, tax withholding or simple error, and a credit should not be created automatically without evidence.
Link credit notes, because an approved credit can reduce a balance but is not new cash, and keep unapplied cash visible by holding the receipt in a controlled unapplied state rather than guessing when the target invoice cannot be confirmed. Ask for clarification through an authorised channel, naming the payment reference and question without exposing unrelated account details.
Use a second review for material exceptions, since a large, complex or manual allocation can deserve independent approval, with thresholds set by risk, and record the audit trail of bank line, payment ID, remittance, applied invoice, amount and editor so a reviewer can reconstruct the decision. Reconcile totals, because applied plus unapplied amounts should equal the receipt after documented adjustments, and measure an error rate by sampling allocations against remittance and invoice records, since a match confirmed by software is not necessarily a verified correct match.
Check reversals too, as a bounced or recalled payment can invalidate an earlier allocation and the receivable must be restored under the accounting process. Watch customer statements, since a wrong allocation can make a paid invoice look overdue and prompt an awkward collection notice, and review mapping rules, because one mistaken persistent rule can misallocate future payments.
Separate speed from quality, since a high auto-match percentage may conceal systematic errors, handle privacy by limiting bank and customer information to staff who reconcile or resolve it, and look for root causes such as poor invoice references, confusing group accounts and late credit notes. Close with evidence by updating collections and customer records so the same invoice is not chased again; for owners, payment allocation accuracy is a trust and cash-control measure, because getting the money in the bank is only the first step and it must land on the right obligation.
In practice
Real-world examples.
Example
One transfer covers two invoices and is split under the remittance. The cash application clerk attaches the remittance to the receipt and applies each amount to the invoice named. Both invoices leave the collections list.
Example
A payment with no reliable invoice reference stays unapplied for review. The clerk asks a verified customer contact for a breakdown. The balance remains visible rather than being guessed onto the oldest invoice.
Example
A mistaken customer mapping is corrected before it affects future receipts. A review finds that a rule linked two group companies to one account. The rule is fixed, and recent receipts are rechecked.
Formula
Calculation
Allocation accuracy = verified correct allocations / reviewed allocations x 100. Ninety-eight correct of one hundred reviewed = 98% for that sample.
Worked example (fictional figures). The 100 reviewed allocations total $400,000, and the 2 incorrect ones total $60,000. By count, accuracy is 98%. By value, accuracy is ($400,000 - $60,000) / $400,000 x 100 = $340,000 / $400,000 x 100 = 85%. The gap shows that the errors were concentrated in large payments.
Reconciliation check. A receipt of $10,000 is applied $6,000 to invoice A and $3,400 to invoice B. Applied plus unapplied must equal the receipt, so the unapplied balance is $10,000 - $6,000 - $3,400 = $600, which stays visible until the customer explains it.Case study
Seen in the real world.
This entirely fictional example follows Maple Services. A bank transfer was assigned to the oldest invoice, but the remittance specified two newer invoices. The team reversed the allocation, linked the evidence and checked the automatic mapping rule. The customer's statement had shown the two newer invoices as overdue, and a collection reminder had already been drafted.
Collections paused it until the ledger was corrected, and the customer received an apology and an updated statement. The case does not imply every missing reference can be resolved automatically. Maple now samples allocations each month and reports corrections and unapplied cash alongside its auto-match rate.
Watch out
Common mistakes.
- Treating a suggested invoice as a proven match.
- Creating a second payment from an already recorded bank receipt.
- Leaving a paid invoice in collections after correcting the allocation.
Questions
People also ask.
What is being checked?
Customer identity, invoice, currency and applied amount against evidence.
What if the reference is unclear?
Keep funds controlled as unapplied and investigate rather than guess.
Is auto-match rate enough?
No. Verify accuracy, corrections and unapplied balances.
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