How to Match Customer Payments to Invoices When Amounts Do Not Agree

Payment matching becomes difficult when a customer pays several invoices together, deducts a credit, sends less than the billed amount or makes a bank transfer without a clear reference. If these differences are posted incorrectly, customer balances become unreliable and collection work becomes harder. A consistent investigation process helps preserve accurate records.

Start with the payment evidence

Before assigning a payment, collect the bank transaction, remittance advice, customer email, payment reference and any related credit notes. Confirm the payment date, amount, currency and payer name. Do not assume that the name on the bank statement is the same as the legal customer name; some payments come from parent companies, payment agents or shared accounts.

• 1. Search for the customer’s open invoices using the payment reference, customer name, purchase order number and amount. Check recent invoices first, but also review older overdue items because customers sometimes settle the oldest balance without following the agreed allocation.

• 2. Compare the payment amount with the invoices the customer appears to be settling. Look for common causes of differences, including approved credits, early-payment reductions, delivery claims, withholding deductions, bank charges, duplicate payments and arithmetic errors.

• 3. Request or verify a remittance statement when the payment cannot be allocated confidently. Ask the customer to list each invoice, credit note and deduction included in the transfer. Keep the request factual and include the payment date and amount so the customer can respond quickly.

• 4. Separate confirmed amounts from disputed amounts. Apply the undisputed portion to the correct invoices, but keep an unresolved deduction identifiable rather than silently writing it off or spreading it across unrelated invoices.

• 5. Record the reason for every difference and assign an owner and follow-up date. For example, a damaged-goods deduction may require an operations review, while a bank charge may need confirmation from the payment terms or customer agreement.

Handling short payments

A short payment should not automatically be treated as a bad debt or an approved discount. First determine whether the customer had permission to deduct the amount. If the deduction is valid, link it to the supporting credit or adjustment. If it is disputed, keep the remaining amount visible for collection and document the correspondence.

Handling overpayments

An overpayment may relate to another invoice, a duplicate transfer or an advance for future work. Contact the customer before applying it to an invoice that was not identified in the remittance advice. If no allocation is confirmed, record it as an unapplied customer balance and review it regularly rather than using it to conceal overdue accounts.

Handling unidentified payments

Do not assign an unidentified deposit to the largest overdue customer simply to clear the bank transaction. Check payment references, payer details, customer statements and recent sales activity. If the payer cannot be confirmed, retain the amount in a clearly labelled suspense or unidentified balance and escalate it for investigation.

Preventing repeat problems

At the end of each review period, summarize recurring causes by customer and payment type. Frequent deductions may indicate unclear billing terms, missing delivery evidence or poor communication about credits. Set a standard remittance request, encourage references that identify invoices and review unresolved balances at least weekly. A payment is fully reconciled only when its source, purpose, allocation and any difference are supported by evidence.