Here is something we see almost every week. A Shopify seller hands us their books, the bank reconciles perfectly in Xero, and yet their revenue, fees and VAT are all wrong. How does that happen?
Shopify pays you in lump sums. The deposit lands in your account days after the sale. Match the deposit to a journal that reads “Sales”, tick the bank rec, and move on. The numbers underneath that deposit are doing something completely different to what your books are showing.
What is Actually Inside a Shopify Payout
A single payout is not a single sale. It is the net of everything that happened in a settlement period. Gross sales. Transaction fees. Refunds. Chargebacks. Gift card redemptions. Tips. Currency adjustments.
The bank deposit you see is what is left after Shopify nets it all off. Record that deposit as revenue and you have understated your turnover and hidden the fees as missing expenses. Your gross margin will be wrong. Your VAT working will be wrong. Your year-end accounts will be wrong.
Why Manual Reconciliation Falls Over Fast
For very small stores doing under £20,000 a year, we have seen people get away with manual journals. Read the payout report, work out gross sales, fees, refunds and taxes, then post one journal per payout. It is slow but workable.
Once you are running multiple payouts a week, multiple payment processors (Shopify Payments, PayPal, Klarna), and international sales, manual entries stop working. They take hours. They accumulate errors. Most sellers either give up and post one rough journal that papers over the detail, or they go years without realising their books are wrong.
The Two Connectors Worth Knowing About
For UK Shopify to Xero reconciliation, two tools dominate: A2X and Link My Books. Both pull payout data straight from Shopify, break it down into the right categories (sales, fees, refunds, gift cards, taxes), and post a clean summary journal into Xero for every payout.
The bank deposit then matches the journal exactly. Reconciliation goes from hours to seconds. They differ on pricing, depth, and how they handle inventory. Either does the core job well.
A Shopify payout is a net settlement, not a gross sale. If you record the final bank deposit directly as revenue without splitting out the hidden fees, refunds, and taxes, your margins and VAT returns will be entirely incorrect.
Setting Up the Chart of Accounts Properly
Here is where most setups fail before they even start. Before you connect a tool, your Xero chart of accounts needs lines for each thing the payout splits into. You need lines for Shopify gross sales (split by tax rate if you sell across VAT bands), Shopify transaction fees, payment processor fees, refunds, gift card liability, sales tax collected, and shipping income.
Without these lines in place, the connector posts everything into a generic catchall and you lose all the visibility you set the tool up to get. Get this right once and the rest is automatic.
Gift Cards: The Most Commonly Mishandled Item
When a customer buys a gift card, that is a liability. You owe them goods later. It is not revenue yet. Revenue only gets recognised when the gift card is redeemed against a purchase.
Most sellers we onboard have been posting gift card sales straight to revenue, inflating turnover and creating a phantom tax bill. Both A2X and Link My Books handle this correctly if you configure the gift card account as a liability on the balance sheet, not as an income line. It is a five-minute setup decision that affects every year of accounts that follows.
Refunds and Chargebacks Are Not the Same Thing
Refunds appear inside the payout as negative entries. The correct treatment is to reduce sales by the refund and remove the original transaction fees that were charged on the refunded sale.
Chargebacks are different. They come with a separate fee from the card network and they tend to indicate a different operational problem. Each needs its own account in Xero so you can track them as separate metrics instead of lumping them into a single refunds line and hiding the trend.
The Monthly Review That Catches Everything
Even with a connector running well, monthly review is essential. Compare what the connector posted against the Shopify finance report for the period. Check that gross sales reconcile. Check that fees match Shopify’s totals. Check that anything unusual (gift card redemptions, currency adjustments, manual order changes) is recorded correctly.
We catch issues every month for clients who would otherwise have rolled the problem into year-end. A specialist Shopify accountant handles this review as part of the monthly bookkeeping cycle so you do not have to think about it.
Stop manually reconciling payouts and worrying about hidden VAT errors. Book a free consultation with our team. We will set up your automated connectors, clean up your Xero chart of accounts, and manage your monthly compliance so you can focus entirely on growing your store.
