Ecommerce Bookkeeping: Sales, Fees & Payout Reconciliation

A bank deposit is the end of a payment process. To understand your sales and profit, trace it back through orders, refunds, fees and amounts still held by the platform. This guide brings the bookkeeping setup, expense tracking and multi-channel close into one workflow.

Set up accounts around the records you receive

• Use a separate clearing account for each material platform or payment provider.
• Separate sales, customer refunds, platform fees, fulfilment, advertising and finance charges.
• Use consistent channel tracking where you need comparisons; do not create a new account for every product.
• Assign one import route for each type of data so a connector and bank feed do not record the same sale twice.

Gather the complete period

Collect order and settlement reports, fee invoices, refunds, bank statements and supplier bills. Record the time zone, currency and date range of each export. Keep the original files as well as the entries posted to the accounting system. A payout spanning month end will not necessarily match that month’s orders.

Bridge orders to deposits

This is an illustration, not a platform fee schedule. Match the closing £1,000 to identified unsettled orders, reserves or other supported items. Do not write off a timing difference simply to make the bank reconcile. The settlement timing guide covers periods that straddle a month end.

Handle exceptions before posting adjustments

• Refunds: identify the original order and whether the platform reversed its fee.
• Chargebacks and holds: distinguish a disputed sale from money temporarily unavailable.
• Currency: reconcile in the settlement currency, then explain conversion charges and exchange differences.
• BNPL: use the provider’s contract and invoice; do not assume all charges have reclaimable VAT.
• Gift cards and store credit: assess accounting and VAT treatment separately; receiving cash does not always mean revenue has been earned.

Use the detailed guides to payment holds and disputes and multi-currency differences. A marketplace relationship alone does not make a seller an agent; assess the contract before deciding gross or net presentation.

Close the month and review the business

• Reconcile each bank and clearing account, recording an owner and explanation for unresolved items.
• Check purchase invoices and the business share of mixed expenses; avoid deducting fees twice.
• Apply the stock and cost-of-sales adjustments appropriate to your accounting method.
• Review channel margins using the same definitions, alongside the balance sheet and cash position.
• Run the applicable VAT-turnover check and prepare the records needed for filings.

For the financial statements behind the close, see financial reporting for online businesses. For implementation, compare A2X and Link My Books or read the Shopify-to-Xero reconciliation guide.

Detailed reconciliation problems

Part 1

Best Practices for Reconciling Chargebacks, Disputes and Payment Holds

Chargebacks, disputes, and payment holds each move or lock up cash on their own timelines. Recording them correctly is what keeps the bank reconciliation honest and the VAT return accurate.

Part 2

Consolidating Omni-Channel Revenue Across Shopify, Etsy, TikTok Shop and Amazon

Selling across Shopify, Etsy, TikTok Shop, and Amazon means four settlement structures and four fee models feeding one set of accounts. Consolidating them correctly gives a single P&L without losing per-channel margin visibility.

Part 3

Gross vs Net Revenue Recognition and the Payout Accounting Trap

Recording the net payout from a processor as revenue is the most common e-commerce accounting mistake. It under-states turnover, hides fees, and can leave a brand wrongly believing it is below the VAT threshold.

Part 4

The Settlement Timing Gap Between a Sale and a Stripe or Shopify Payout

A customer pays on the 30th; the cash lands in your bank on the 4th of the next month, net of fees. That few-day gap means the sale and its payout fall in different periods, and at a month or year end it quietly understates both your revenue and the money owed to you. A cut-off that recognises the in-transit balance puts it right.

Part 6

Multi-Currency Sales and the Exchange Rate Variances That Distort Your Accounts

A dollar sale is worth one sterling figure when the customer checks out and another when the payout lands, and a third if the balance is still sitting with the processor at your year end. Those differences are exchange rate variances, they are real numbers your accounts have to carry, and getting them wrong quietly misstates both profit and the VAT you owe.

Part 6

Why TikTok Shop Payouts Don’t Match Sales: Co-Funded Discounts Explained

Trace a TikTok order through discounts, fees and settlement. Includes an illustrative co-funded voucher calculation and a month-end reconciliation.

Need the monthly process handled? See multi-channel bookkeeping and pricing and scope. Agree the channels, reporting dates and tax filings included before work starts.