Shopify and Xero: reconciling payouts, fees, refunds and VAT
Why your Shopify sales never equal your bank deposits — and how to set the books up so they reconcile to the penny.
The short answer
- Shopify pays you the net of a settlement period — gross sales, less fees, refunds, chargebacks and adjustments. The deposit is never the sales figure.
- Don't code deposits straight to sales. Post a settlement summary journal per payout and clear it through a Shopify clearing account.
- A connector such as A2X or Link My Books does that automatically and keeps VAT rates per line; the raw Shopify–Xero app alone usually doesn't.
- Gross profit only means anything once COGS and stock are posted — not when you look at revenue less ad spend.
Why the payout never matches the sales
A single Shopify Payments deposit bundles several things together: gross order value for the payout period, minus Shopify Payments processing fees, minus refunds issued in that window, minus chargebacks and their fees, plus or minus adjustments and any reserve being held or released. Orders paid by PayPal, Klarna, Amazon Pay or a separate Stripe account land on their own timetables entirely.
So if you code the bank deposit to "Sales", three things break at once: turnover is understated by the fees, the fees themselves never appear as a cost, and the VAT on the sale is calculated on a net figure. It also makes the VAT return wrong, because output VAT is due on the gross order value, not on what Shopify chose to send you.
How to set it up in Xero
- 1
Create a Shopify clearing account
A bank-type or current-asset account in Xero that represents money Shopify owes you. Every sale goes in; every payout comes out. Its balance should equal your Shopify pending payouts at any date.
- 2
Post one settlement summary per payout
A journal or invoice showing gross sales by VAT rate, shipping income, discounts, refunds, processing fees, chargebacks and gift-card movements — netting to the exact deposit amount.
- 3
Reconcile the bank line to the settlement
The deposit in the bank feed matches the settlement total exactly, so reconciliation is a one-click match rather than a guess.
- 4
Map VAT rates per line, not per payout
UK standard, zero-rated, exports and EU OSS sales each need their own line. One blended rate across a payout will not survive an HMRC review.
- 5
Post COGS and stock movements
Either periodically from a stock count, or per order if your inventory system supports it. Without this, gross margin in Xero is fiction.
- 6
Automate with a connector
A2X or Link My Books generate the settlement summaries and push them into Xero on a schedule. Dext Commerce covers multi-channel sellers. Configure the account and tax mapping once, then review it monthly.
The VAT points that catch Shopify sellers out
VAT is due on gross, not net
Output VAT follows the order value your customer paid, before Shopify's fees are deducted.
Shipping usually follows the goods
Delivery charged as part of a single supply generally takes the VAT liability of the items being sold.
Exports and EU sales
Zero-rated exports need evidence of removal; B2C sales into the EU may fall under OSS or IOSS depending on value and where the goods ship from.
Refunds reduce output VAT
Credit the VAT in the period the refund is issued — settlement summaries handle this if the mapping is right.
Gift cards
A single-purpose voucher is taxed on issue; a multi-purpose voucher on redemption. Sale of the card is not automatically revenue.
Marketplace and app fees
Many are supplied from overseas and fall under the reverse charge — they still need to appear on your VAT return correctly.
HMRC's rules on selling goods to EU customers and online marketplace sales are the starting points, and Making Tax Digital applies to the return itself — see our guide to Making Tax Digital.
A quick health check on your current setup
Open Xero and look for three things: a Shopify clearing account with a balance that ties to pending payouts, a processing-fees expense account with real numbers in it, and a cost-of-sales figure that moves with revenue. If any of those is missing, your margin reporting is not telling you the truth — and neither is your VAT return.
Want your Shopify and Xero set up properly?
We do this for online sellers every month — see our ecommerce accounting service.
Free: 2026/27 Tax Deadline Calendar
Every key HMRC date for the tax year — self-assessment, corporation tax, VAT, payroll, and more. Sent straight to your inbox as a PDF.
No spam. Unsubscribe anytime.
Related Articles
Common Questions
Why doesn't my Shopify payout match my sales?
Shopify pays the net of a settlement period: gross sales less processing fees, refunds, chargebacks, adjustments and any reserve. The deposit will almost never equal the order value for the same dates.
Should I use the free Shopify app for Xero or A2X?
For anything beyond very low volume, a settlement-based connector such as A2X or Link My Books is far more reliable: it posts a summary per payout with VAT split by line, so the bank reconciles exactly.
Do I pay VAT on the gross sale or after Shopify fees?
On the gross order value. Shopify's fees are a separate cost to your business, not a reduction of your sale.
How should Shopify Payments fees be recorded?
As an expense within the settlement summary, so both turnover and fees show at full value. Netting them off understates revenue and hides the real cost of processing.
How do I get accurate gross margin from Shopify in Xero?
Post cost of goods sold and stock movements — either per order from your inventory system or periodically from a stock count. Revenue less ad spend is not gross margin.
What about PayPal, Klarna and a separate Stripe account?
Each gateway settles on its own schedule and needs its own clearing account and reconciliation. Treat them the same way as Shopify Payments rather than lumping them together.
Last reviewed September 2026. General guidance for UK businesses, not advice on your specific circumstances.