E-commerce payout reconciliation explains how channel activity becomes a bank deposit. Gross receipts, refunds, fees, reserves and settlement timing can all matter. Use channel reports and opening/closing processor balances alongside the bank statement; recording only the net deposit as sales can hide important components.
Get help with your monthly booksPractical records guidance · Updated October 8, 2026 · Fictional examples
A sales report by order date and a payout report by settlement date may cover different activity. Confirm the channel, currency, dates and included transaction types before comparing totals. Do not assume a monthly bank deposit total equals the month’s orders.
Holds, reserves or unsettled funds may remain outside the bank. The reconciliation should explain the processor’s balance as well as deposits, with the applicable accounting treatment agreed. Inventory and sales-tax work are separate issues from matching the payout.
Illustrative example · Fictional data
Illustrative settlement: $10,000 of collections less $500 of refunds and $300 of fees produces $9,200 deposited if there are no holds, taxes or other adjustments. Recording $9,200 as gross collections would omit the refund and fee explanations. This arithmetic does not establish inventory profit.
Usually each channel’s records and settlement flow need to be identified. Your engagement lists included channels and accounts.
Not by default. Existing exports may support the work; any new integration requires assessment and separate scope.
Discuss your monthly records, missing months or incorrect balances. We’ll agree the work, records and price before starting.
Talk about your bookkeeping