How to investigate an unmatched customer payment

01

Collect the evidence

Start with the bank receipt and its date. Note the amount and currency, along with the payer name. Look for remittance advice, invoice references and the customer account. Compare the payment with open invoices and existing unapplied receipts or credits. A payer's bank name may differ from the customer name, so confirm the relationship rather than matching on name alone.

Record the receipt as unapplied under the business's accounting procedures while it is investigated. Give it an owner and a review date. Do not allocate it to the oldest invoice merely because the amount appears to fit. A customer may be paying selected invoices or withholding a disputed amount.

02

Work through a split payment

In this hypothetical case, a customer owes invoice A for $1,200 and invoice B for $800. A $1,500 payment arrives with advice saying $1,200 is for A and $300 is for B. After confirming the receipt and advice, the authorized allocation closes A and leaves $500 open on B. Cash received is $1,500. The $500 is an invoice balance, not another receipt.

If the advice identifies only A, apply the supported $1,200 and leave the remaining $300 unapplied until the customer or another reliable record clarifies it. The $800 invoice remains open in the invoice report, while the separate unapplied $300 must remain visible when reviewing the customer account. Do not present their sum as a new amount owed.

03

Resolve exceptions before contacting the customer

Check bank fees, currency conversion, duplicate postings and payment reversals when amounts differ. A short payment may reflect a credit, withholding or a dispute. It does not establish which explanation is correct. Ask for remittance details where needed and route disputed or tax-related differences to the appropriate person.

Never overwrite the bank receipt to force a match. An authorized person should record any correction or adjustment according to company policy and applicable accounting and tax rules. A credit note, when approved and applied to the invoice, reduces the amount due. It is not cash received. Keep the evidence linking the receipt to its allocations. Include any adjustment.

04

Keep the queue manageable

Review unapplied cash by age, value and owner alongside the aging report. Record the date of the last inquiry and the next action. Before collection outreach, check whether an unapplied receipt or pending bank transaction may belong to the account.

At period end, reconcile the receivables subledger with the general ledger and investigate differences under the established close process. Compare the number and value of unresolved receipts over time. A small count can still matter if one payment is large. This procedure supports investigation. It does not replace accounting advice for the transaction.

05

Spot a duplicate bank-feed import

Hypothetical example: the same $1,500 bank transaction appears twice after a feed is imported again. The bank statement shows one receipt, not $3,000 of cash. Match the bank transaction ID and date against the existing posting before creating or allocating another receipt. If the entries are duplicates, ask an authorized person to correct the duplicate under the accounting system’s procedures and retain the explanation.