An e-commerce business selling across Amazon, Shopify, eBay and Etsy has four different payout cycles, four different fee structures, four different VAT treatments, and four different refund conventions, all landing in the same bank account. Without a reconciliation system, the month-end close is either wrong or takes days. The target for a well-run e-commerce business is a close that completes within five working days of month-end, with every bank deposit tied back to a reconciled payout journal.
Summary sync vs order-level sync
Native marketplace connectors in Xero and QuickBooks will happily import every single order as an individual sales invoice. For a Shopify store doing 2,000 orders a month, that is 2,000 transactions per month per channel, with no gain in accounting accuracy and a noticeable cost in performance.
Summary sync, the approach taken by A2X and Link My Books, posts one journal per payout period (usually fortnightly on Amazon, daily on Shopify Payments). The journal breaks the payout into: gross sales by tax jurisdiction, each individual fee type, refunds, reserves, and the net that hits the bank. This matches the bank deposit to the penny and collapses the transaction count by ~99%.
| Approach | Transactions / Month | Reconcilable? |
|---|---|---|
| Order-level sync (native) | ~2,000 per channel | Only in theory. Fee timings mean orders rarely match deposits. |
| Summary sync (A2X, LMB) | ~2 per channel | Yes, each journal matches the bank deposit exactly. |
What a good payout journal contains
A two-week Amazon settlement containing £14,500 of gross sales might net down to £9,400 in the bank. The journal should lay this out so each line maps to a management-accounts category:
| Line | Amount | DR / CR |
|---|---|---|
| Gross sales, UK (VAT standard rate) | £11,200 | CR Revenue |
| Gross sales, EU (OSS) | £3,300 | CR Revenue (OSS) |
| VAT collected | (£2,250) | CR VAT liability |
| Referral fees | (£2,100) | DR Marketplace fees |
| FBA fulfilment | (£1,450) | DR Fulfilment |
| Advertising (PPC) | (£1,200) | DR Marketing |
| Refunds | (£600) | DR Revenue |
| Reserves (held by Amazon) | (£700) | DR Marketplace reserve (asset) |
| Net deposit to bank | £9,400 | DR Bank |
The reserve line is the one most often missed. Amazon commonly holds back a percentage of the settlement, that is your money sitting on Amazon's balance sheet, not a deduction from revenue. It belongs as a short-term asset (marketplace reserve) and clears against a future payout.
Channel-specific considerations
Amazon
Fortnightly settlement cycle. Marketplace-deemed-supplier rules mean some EU sales have VAT collected by Amazon, the journal must split VAT-collected-by-Amazon revenue from VAT-collected-by-you revenue. FBA fees, storage, PPC, and long-term storage surcharges all need their own GL lines if you want honest channel margin.
Shopify
Shopify Payments deposits daily, net of Shopify transaction fees. Orders paid via PayPal or Klarna arrive in separate deposits from separate providers, each needs its own reconciliation stream. Shopify also does not collect VAT on your behalf unless you are using Shopify Tax with Markets Pro; for most UK sellers, VAT accounting still runs through your own books.
eBay
eBay Managed Payments settles to your bank on a configurable schedule (daily, weekly, fortnightly). Final value fees are deducted before deposit. Promoted Listings appear as a separate monthly invoice which is fine to post straight to marketing but must not be double-counted against the per-order fees already deducted.
Etsy
Etsy deposits weekly. Listing fees, transaction fees, payment processing fees and Etsy Ads all appear on the payout. Etsy collects and remits VAT on many EU sales as a deemed supplier, similar to Amazon, the journal must reflect this rather than treating the full gross as your taxable supply.
The month-end checklist
- Every payout journal for the month has posted and reconciled to a bank deposit.
- Marketplace reserve balances agree to the platform statement at month-end.
- Inventory is adjusted for the month's stock receipts and sales, valued at landed cost.
- Gross margin per channel has been calculated and reviewed against prior months.
- UK VAT liability agrees to the total of the per-payout VAT lines, excluding marketplace-collected VAT.
- OSS and IOSS returns have been prepared for the periods they cover, see our OSS/IOSS guide.
- PPC / advertising spend has been matched to the revenue it generated, not the period it was billed.
- Refunds have been posted against the original revenue account, not a generic contra.
- FX differences on foreign-currency payouts have been recognised.
- A channel-level P&L is produced and reviewed before the books close.
FAQs
Should I sync every order into Xero or QuickBooks?
No. Order-level sync wrecks performance and never reconciles cleanly to the bank deposit. Use a summary-sync bridge, A2X or Link My Books, that posts one journal per payout.
A2X or Link My Books?
Both produce accurate summary journals. A2X is more established and covers more marketplaces; Link My Books is newer and typically cheaper. Either beats native connectors comfortably.
How do I reconcile Shopify Payments to my bank?
Use a bridge that posts a daily journal breaking each payout into gross sales, fees, refunds, and tax components. The net of the journal will match the bank deposit to the penny.
What should a month-end check include?
Every payout reconciled, inventory updated, gross margin by channel reviewed, VAT across UK/OSS/IOSS agreed, and a channel-level P&L produced, all inside five working days of the period end.