Home › Articles

When a Bank Deposit Does Not Match an Invoice

A bank deposit can represent several invoices, fees, or a payment you have yet to identify.

Published

Paper invoice and bank deposit slip beside a calculator on a small office desk.
Reconcile what the customer paid separately from what reached the bank.

Reconciling customer payments means checking that the amount recorded against an invoice matches what the customer actually paid. A bank deposit is one piece of evidence. A deposit can combine several payments, arrive after the original transaction, or be reduced by fees. Matching by amount alone can clear the wrong invoice.

Follow the reference from receipt to invoice

For a direct bank transfer, compare the amount, currency, date, sender and payment reference with the outstanding invoices. Use a remittance advice or written confirmation if a customer has several open invoices. A matching amount helps narrow the search, especially when the sender uses a different trading name, but it does not establish which invoice they intended to pay.

For a card payment, start with the processor transaction or payout report. It can show the gross customer payments, deductions and payout reference. Keep that reference alongside the invoice payment record so someone can trace the bank deposit later.

Worked example: a 727.50 deposit pays 750 in invoices

Two customers pay invoices of 500 and 250 in the same currency. The processor deducts 22.50 in fees and sends a single payout of 727.50. If the transaction report confirms both payments, the invoice records show payments of 500 and 250. The payout reconciliation shows gross receipts of 750, fees of 22.50 and net cash of 727.50. The missing 22.50 is explained by fees rather than an outstanding customer balance.

Give unmatched payments a place to wait

If a bank transfer has no usable reference, leave the invoice open while you ask the customer what it covers. Record the deposit reference, the amount and the person following up in your reconciliation list. Once the match is confirmed, attach the payment to the correct invoice and close the exception. This is especially useful when two invoices share a total.

  • One transfer covers several invoices: Keep the allocation amounts and verify that they add up to the transfer.
  • The customer paid less than expected: Ask whether it is an instalment, a disputed charge or an agreed deduction. Review the balance after recording the confirmed receipt.
  • A payout includes a reversal: Use the processor record to trace the reversal to the original transaction before adjusting anything.

Review the invoice and the deposit separately

At the end of the week, you should be able to explain both why each invoice has its current balance and why each bank payout has its net amount. A colleague should be able to retrace the match without asking the person who originally entered it.

For invoices settled in several payments, see how to preserve the history behind a remaining balance. The VELQRA feature catalogue describes the app's invoice and payment records.