Reconcile gross ecommerce sales to one net bank payout

Start with one bank deposit and obtain the processor report that explains that specific payout. Record the payout identifier, currency, settlement period, and bank arrival date. A store's sales report for the same calendar day may cover a different population of orders.

The bank deposit is the amount transferred after adjustments. It may include several days of sales, refunds from older orders, fees, and reserve movements. Recording the entire deposit as sales hides those components and can leave revenue, expenses, and liabilities wrong even when the bank account reconciles.

The following example assumes all listed amounts belong to the same settlement batch, with no opening balance or other adjustments. It illustrates payout arithmetic, not the journal entries required for every store. Use the actual report categories and verify their definitions.

Keep taxes and refunds detailed enough to distinguish the merchant's obligations from amounts collected or remitted by a marketplace. Do not create a tax liability merely because a report contains a tax column; confirm who is responsible for that amount.

A withheld reserve has not disappeared merely because it was excluded from the deposit. Track it separately with evidence of the processor balance and applicable release terms. Likewise, a payout initiated before month-end but received afterward needs a documented timing explanation.

Reconcile the processor's opening balance, new activity, payouts, and closing balance. This broader check catches items that cannot be explained by a single bank deposit, such as a chargeback applied between payout batches or a manual adjustment with no order reference.

Find out whether an ecommerce connector already recorded sales and fees. If it did, the bank-feed deposit may need to match a transfer from the processor clearing account rather than create new income. Posting both the connector summary and the deposit as sales doubles the same activity.

After the entry is approved, retain the payout report, bank match, and unresolved differences together. For the next close, use the same account and currency boundaries. Investigate changes in report definitions or connector mapping before forcing a new deposit to fit last month's worksheet.