An online store reports sales of 8,000 for the week. The payment provider deposits 7,620 into the bank. It is easy to wonder whether 380 has gone missing.
Often it has not. Payouts can reflect fees, refunds, adjustments, timing differences and transactions from more than one sales day. The amounts here are an illustration, not a standard fee pattern.
The store shows activity; the bank shows settlement
Your ecommerce platform may record orders when customers place them. Your payment provider processes transactions and releases payouts on its own schedule. The bank sees the final deposit.
Those are three views of related activity, not three reports that will necessarily display the same number on the same date.
If you compare weekly sales directly with a single bank deposit, you can end up investigating a difference that only exists because the periods or reporting bases are different.
Build the bridge between orders and payouts
The reconciliation usually needs a reliable sales report and the payment provider’s settlement details. Those details can show gross collections, deductions, refunds, chargebacks and the net amount paid.
A straightforward bridge could look like this:
- Gross card collections included in a payout: 8,000
- Less payment processing fees: 160
- Less refunds settled in that payout: 220
- Net deposit: 7,620
The accounting treatment of each component depends on the business’s policies and circumstances. The key operational point is that every deduction should have a supporting record.
Returns and refunds need their own attention
A returned order may be recorded in the store on one date while the refund appears in a later settlement. Gift cards, marketplace adjustments, shipping income and promotional discounts can introduce further differences.
Keep the original sale, return and settlement information connected. That makes it easier to understand why reported revenue, payment activity and cash movements do not line up at first glance.
Watch for duplicate sales entries
A common risk is importing individual orders and also posting a sales summary without checking whether they overlap. The result can be overstated sales or duplicated receivables.
Before connecting systems or changing an import routine, map what each integration creates. Decide which records are authoritative and how exceptions will be handled.
A monthly habit that helps
Reconcile at the level of payouts or settlement batches, investigate unexplained differences and keep a list of transactions that cross the reporting period. Review the list again next month until the items clear.
Ecommerce bookkeeping needs context from both the store and its payment channels. Bahulya Fintech can support transaction organisation and reconciliation preparation for online businesses, using the reports and responsibilities agreed for each platform.