Development guides

Why orders and bank deposits differ, and how to check them

Bank deposits may already have fees and refunds deducted. A useful reconciliation explains the difference and identifies transactions still needing attention.

ProApp editorialPublished and checked
Black-and-white still life of receipts, a ledger and pen
AI-generated illustration of the article’s setting.

The workflow illustrates a possible design and is not a client case study.

Illustrative workflow
  1. Match references
  2. Explain differences
  3. Review exceptions

Why do sales totals differ from bank deposits?

A single bank deposit can cover several orders after fees and refunds have been deducted. It may therefore differ from gross sales without anything being wrong. Before investigating, check each report’s date basis, currency and payout batch. Otherwise, routine timing or reporting differences can look like missing money.

Can existing reports trace back to orders?

Begin with reports from the payment platform and accounting software. Stripe’s payout reconciliation report applies to particular payout arrangements, so check whether it fits your account. Add a matching process when those reports cannot link back to orders, sales channels or your review procedure.

Reconcile one settlement period

Take one sales channel, one currency and a full settlement period. Match the transaction references and show fees and refunds separately, keeping the original reports. Put unmatched items on a list for staff to investigate. A balancing adjustment should not be created just to make the totals agree.

Check timing differences and refunds

Use month-end payouts and partial refunds to check whether the matched records explain the difference. Then try repeated imports, changed fees and missing references. Have the accounts owner approve the matching rules. This verifies the records and the traceability of differences; accounting and tax treatment remain decisions for the appropriate person.

Bring reports and manual adjustments

Prepare order, payout and bank reports with personal details removed, plus a list of manual adjustments. Agree who can view them and how long the records should be kept.

Working through a similar problem?

Tell us how you work today, which tools you use and what you want to improve. We can discuss changes to your current system, connecting tools or developing something new.