5 min read Collections

Why what you collected never matches what reached the bank

Five reasons the month's receipts total and the bank deposit don't match. None of them is an arithmetic error.

The difference always has an explanation

You close the month, add up what you collected and compare it with what came into the accounts. It doesn't match. And because it's off by a little, the temptation is to adjust and move on.

The difference is hardly ever a calculation error. There are five specific causes, and each is handled differently.

The five causes

  • The cheque is collected but not deposited, or deposited and not credited. The receipt exists, the money doesn't yet. Until the bank credits it, that amount is in transit and has to be visible as such.
  • The bank fee. The customer paid 10,000 and 9,970 came in. The difference isn't a partial payment: it's an expense, and it goes to its own account.
  • The customer's withholding. In several countries the customer withholds a percentage and hands you a certificate. If it isn't recorded as a withholding, it looks like they underpaid and the invoice is left with a balance nobody will ever collect.
  • The exchange difference. You invoiced at one rate and collected at another. The difference is a result, not a mismatch. We cover it in where the margin gets lost.
  • A payment that reached the bank without a receipt. A transfer from a customer who didn't say. The money is there and nobody knows which invoice it's for: it ends up as an unidentified item that ages.

The common pattern

Looking at all five together, the pattern shows: in every one there's an amount that exists and isn't recorded as what it is. A fee booked as a partial payment, a withholding treated as non-payment, an exchange difference buried in revenue.

And they all produce the same end symptom: invoices with small balances that never close, and a customer who thinks they paid in full while your system says they owe 30.

Those tiny balances cost more than they look: they dirty the ageing report, send collectors chasing amounts that don't exist, and end up written off as bad debt having never been a debt at all.

What the system should do

  • Tell collection apart from deposit, with money in transit kept in plain sight.
  • Record fee, withholding and exchange difference as their own items, each to its own account.
  • Close the invoice when the sum of all those items covers the amount, not just the cash received.
  • Keep a tray of unidentified receipts, so a payment with no owner is visible instead of dissolving.

Collections and customer credit

On the same topic

Let collected and deposited reconcile themselves

Zyntello separates collection from deposit, records fees and withholdings as what they are, and calculates the exchange difference at collection.