What Is Ecommerce Sales Reconciliation for Online UK Sellers

Ecommerce sales reconciliation is the process of matching what a marketplace reports it paid you against what actually lands in your bank account, and then checking both against your accounting records. For a seller trading across Amazon, Shopify, eBay and Etsy, this means comparing settlement or payout reports, bank deposits and bookkeeping entries for every single channel, every period, until all three agree.

Each platform pays out on a different schedule and structures its reports differently. Amazon typically settles every two weeks with a three to five day delay before funds arrive, Shopify Payments can pay out daily or on a rolling basis within two to three days, and Etsy usually pays weekly, or daily for eligible shops. eBay follows a similar payout cycle to Shopify through its managed payments system. Without a consistent reconciliation process, these differing schedules make it easy to lose track of what has actually been received versus what is still pending.

Why Reconciliation Matters for Multi Channel Sellers

A seller running four channels is really running four separate mini ledgers that need to be pulled into one coherent set of accounts. Gross sales, marketplace fees, refunds, chargebacks and reserve holdbacks all move differently on each platform, and treating them the same way risks misstating both revenue and profit.

Reconciliation also matters because HMRC increasingly cross checks marketplace data against declared turnover. Online marketplaces already report seller data to HMRC, and under deemed supplier rules the tax authority can compare what a platform reported against what a seller declared on their VAT return. Sellers who cannot produce a clean reconciliation between marketplace reports and their VAT return are the ones most likely to be flagged for a compliance check, and least likely to have a ready answer when asked.

The Three Way Match Explained

Every accurate reconciliation depends on matching three sources of data for each platform:

• Platform settlement or payout report, showing gross sales, fees deducted, refunds processed and the resulting net payout
• Bank deposit, showing what actually arrived in the business bank account
• Accounting records, showing what the bookkeeping software says happened for that period

All three figures must agree before a period can be considered closed. A mismatch anywhere in this chain, whether from a delayed deposit, a misclassified fee or a missed settlement, will eventually surface as an unexplained variance on the balance sheet or an incorrect VAT return.

Amazon Reconciliation

Amazon settlement reports are the most detailed and the most complex of the four platforms. A typical settlement bundles product sales, sales tax collected, referral fees, FBA fulfilment fees, storage fees, advertising spend, refunds and reimbursements into one net figure.knightfrank+1

The recommended process is straightforward once the categories are understood:

• Download the settlement report from Seller Central under Payments, then All Statements, for the relevant period
• Break the settlement into categories: gross revenue, referral fees, FBA fulfilment fees, storage fees, advertising costs and refundsknightfrank+1
• Match the net settlement total exactly to the bank deposit, investigating any variance rather than assuming it will resolve itselfknightfrank+1
• Post each fee type to its own expense account, since referral fees, FBA fees and advertising all behave differently and need separate visibility for margin analysis

Amazon reserves are a common source of confusion. A reserve is a temporary holdback, often applied to new sellers or accounts with elevated claim rates, and it is not an expense. It should be recorded as a receivable, since Amazon owes that money back to you once the reserve is released in a future settlement.

Shopify Reconciliation

Shopify’s frequent payout schedule, often daily, makes reconciliation less about individual transactions and more about matching aggregated totals over a period. Shopify Payments deposits typically arrive two to three business days after the sale, while other gateways connected to a Shopify store, such as PayPal, need to be reconciled separately from the core Shopify Payments feed.

The practical steps for Shopify are to verify that every payout for the month has posted correctly to the accounting system, match the aggregate payout total to the aggregate bank deposits for the same period, and reconcile any third party payment gateway deposits as a distinct stream rather than folding them into the Shopify Payments total. Because Shopify processes far more deposits per month than Amazon or Etsy, doing this weekly rather than only at month end prevents a large backlog building up.

eBay Reconciliation

eBay’s managed payments system pays out on a schedule similar to Shopify, and the same fee categories apply: final value fees, listing fees, promoted listings costs and any payment processing charges need to be separated from gross sales rather than netted off informally. Refunds and returns need particular attention on eBay, since a return processed after a payout has already been received creates a negative adjustment in a later period that must be traced back to the correct month for accurate revenue recognition.

As with Amazon and Shopify, the net payout shown in eBay’s reports should match the bank deposit precisely. Any shortfall usually points to an unreconciled fee, a delayed refund adjustment or a dispute resolution that has not yet been reflected in the accounting records.

Etsy Reconciliation

Etsy shops typically see weekly payouts, or daily payouts for shops that qualify, alongside a distinct set of charges that do not appear on other platforms in quite the same way, most notably Offsite Ads fees, which can spike unpredictably when Etsy chooses to promote a listing externally. Listing fees, transaction fees and payment processing fees also need to be broken out individually rather than bundled into one generic marketplace fee line.

Because Offsite Ads charges are outside the seller’s direct control and can vary significantly month to month, they deserve their own line in the chart of accounts so that sudden increases in marketing cost are visible immediately rather than buried inside a general fees total.

Common Reconciliation Errors

• Recording revenue on deposit date rather than order date, which distorts which month a sale actually belongs to and misstates monthly profit.
• Treating reserves and holdbacks as expenses, which understates revenue and creates a fresh reconciliation problem when the reserve is eventually released.
• Blending fee types into one generic expense line, which removes the ability to see whether referral fees, fulfilment costs or advertising spend are driving margin erosion on a specific channel.
• Failing to separate payment gateways within one platform, such as Shopify Payments against PayPal, which causes deposits to be matched incorrectly
• Ignoring currency conversion adjustments on international marketplace sales, which can create a small but persistent variance between settlement figures and bank deposits.
• Not reconciling inventory alongside cash, since COGS should be checked against actual units sold across all channels multiplied by landed cost, not assumed from revenue alone

VAT and Tax Implications of Poor Reconciliation

Marketplace VAT treatment already varies depending on where stock is held and whether the seller is UK established, and this makes clean reconciliation essential rather than optional. Since 1 January 2021, marketplaces can be treated as the deemed supplier for certain sales, meaning the platform, not the seller, accounts for VAT to HMRC, while UK established sellers shipping UK held stock generally remain responsible for their own VAT.

A seller trading across four platforms therefore needs to reconcile each platform’s sales report separately, confirm which transactions had VAT accounted for by the marketplace and which did not, and only then apply the correct VAT treatment to the remainder. Getting this wrong, or simply not checking it, is one of the most common triggers for an HMRC compliance check, since HMRC already holds marketplace transaction data and will compare it directly against the seller’s declared turnover.

Building a Repeatable Monthly Process

A structured monthly close, rather than a rushed exercise at year end, keeps reconciliation manageable across four channels. A practical approach follows three phases within the month: reconciling each platform individually in the first week, cross checking totals across all channels in the second week, and producing management accounts and key metrics by channel in the third week.

This includes checking total revenue across all platforms against total accounting entries, verifying that cost of goods sold matches units sold multiplied by landed cost, and confirming inventory balances match actual stock counts. Only once these checks are complete should a period be treated as closed for VAT and management reporting purposes.

How UK Ecommerce Accountants Can Help

Reconciling sales, fees, refunds and reserves across Amazon, Shopify, eBay and Etsy by hand takes hours every month and leaves plenty of room for costly errors. Here’s how we support multi channel sellers through this process.

• We set up automated reconciliation between each of your marketplaces and your accounting software, so settlements, fees and refunds are categorised correctly without manual CSV imports
• We reconcile net payouts from Amazon, Shopify, eBay and Etsy against your bank deposits every period, flagging any variance before it becomes a bigger problem
• We separate fee types, referral fees, FBA costs, Offsite Ads charges and payment processing fees, into distinct accounts so you can see true margin by channel
• We track Amazon reserves and holdbacks correctly as receivables, not expenses, so your revenue figures stay accurate
• We confirm which of your marketplace sales had VAT accounted for by the platform under deemed supplier rules and apply the correct treatment to the remainder
• We reconcile your marketplace and settlement reports to your VAT return before filing, reducing the risk of an HMRC compliance check
• We produce monthly management accounts broken down by channel, so you know which platform is actually driving profit
• We reconcile inventory and cost of goods sold across all channels to keep your balance sheet and margins accurate

Frequently Asked Questions