Why is my bank deposit less than my invoice?
Compare the invoice, the customer's payment, any payment service's settlement breakdown and the bank entry. If a customer pays a $1,000 invoice in full and the service keeps a documented $50 fee, the bank receives $950; nothing is owed. If the customer paid $950 with no agreed reduction, $50 is still due. Without a payment record, the cause stays open.
Principle and explanation
An invoice says $1,000. The bank shows $950. The missing $50 might be a fee, an unpaid balance or a recording problem. The bank amount alone cannot tell you which.
A difference needs an explanation
Reconciliation connects records of the same financial activity and accounts for the differences between them. Records can disagree because an entry is missing or wrong, or because the same event appears on different dates. The aim is an explanation supported by the records, rather than changing an amount until two totals happen to match.
The right explanation matters because different causes lead to different conclusions. A fee charged to the business is not automatically money still owed by the customer. A payment waiting to reach the bank is not the same as a customer who has not paid. An entry matched to the wrong invoice does not become correct because its amount looks plausible.
One sale can leave several records
An invoice describes an amount due. A customer payment records money received to settle it. When a payment service is involved, the payout records what the service transfers to the bank. These records describe connected events, not interchangeable amounts.
A payout can combine several payments and subtract fees, refunds or other adjustments. Its arrival date can also differ from the payment date. The payment service's settlement breakdown connects the gross activity to the net bank deposit; trying to match every invoice directly to a bank line can miss that middle record.
A cleared difference is not a verdict on the whole business
An explained difference can establish how the records connect, but it does not by itself prove that the underlying sale was genuine, that every obligation was recorded or that the job was profitable. In the illustration, $950 is a net bank receipt after one stated fee. It says nothing about the cost of doing the customer's work.
An unexplained remainder should remain visible as a question. Depending on the evidence, it might be a partial payment, a timing item, an omitted fee, a duplicate entry or a wrong match. Those possibilities should not be collapsed into an invented discount or a fee that no supporting record shows.
Worked example
The customer paid in full, but the bank received less
A studio sends a $1,000 invoice. The customer pays $1,000 to its payment service. The service keeps a documented $50 fee and sends $950 to the bank. The customer owes nothing: the fee belongs to the studio.
But if the customer paid only $950, with no fee or agreed reduction, $50 is still due. The same bank amount can mean something different. Check the payment and settlement records before deciding who owes what.
Now suppose the system says “Paid” and the bank shows $950, but the payment and settlement records are missing. Those two observations do not establish whether the customer still owes money. Check the missing records and how the Paid status was set before sending a reminder or treating the difference as a fee. “Not yet established” is the correct conclusion while that evidence is missing.
- The invoice total is $1,000. The example adds no separate tax entries, exchange differences, refunds or credit notes.
- The $50 fee, where shown, is charged to the studio and supported by the settlement record.
- The part-payment scene has no agreed discount or write-off. The pending scene shows the bank position at the comparison date.
- In the missing-evidence scene, Paid is an unverified system label. No customer payment amount, fee or remaining balance is assumed.
Try it with your own numbers
The amount billed to the customer, as on the invoice. The calculator adds no tax, refund, credit note or exchange difference.
The amount the payment record shows the customer paid. If you have no payment record, find it first; the calculator cannot stand in for it.
Only a fee that a payment or settlement record shows. Enter 0 if none is documented.
What has reached the bank for this payment. Enter 0 if nothing has arrived yet, for example a payout or transfer still in transit. If one bank line combines several payments, enter only this payment's part, using the settlement breakdown or deposit record. Check separately that the parts add up to that bank line.
Your result
Fill in every field to see the result.
Your numbers stay in this browser. Nothing you type is sent or saved.
Common misconceptions
- The bank received $950, so the customer owes $50.
- That follows only if the evidence shows an underpayment. A documented fee deducted after a full customer payment gives a different explanation.
- Every bank line should equal one invoice.
- A payout may combine several transactions and adjustments. The settlement record explains the grouping.
- A matching total means the records are correct.
- The wrong invoices or duplicate records can still produce a convincing total. Amount, identity and timing must make sense together.
- The system says Paid, so the customer owes nothing.
- A status without its supporting record is not proof of full payment. Check the payment evidence and which record or person set the status; until then, do not infer either a debt or a fee.
First step
Check the records before chasing the customer
Compare the invoice reference and amount, the customer's payment, the payment service's settlement breakdown if one was used, and the bank entry and date. If the system says Paid, check which record or person set that status. Identify any documented fee, unpaid balance or transfer still in transit. If a record is missing, leave the difference unexplained until you have evidence; do not invent a fee or discount to make the totals match.
Sources
- ACCA: FA2 examiner’s report, January–June 2013 (page 4) (opens in a new tab)Distinguishing errors or omissions from timing differences when reconciling bank and accounting records.
- Stripe: Payout reconciliation report (opens in a new tab)Connecting gross transactions, fees and net payouts, including payout timing and transactions awaiting payout.
- Xero: View bank reconciliation details (opens in a new tab)A bank statement line can relate to one or more transactions; incorrect reconciliations require correction.