Selling on Shopify? Trying to make sense of the numbers? You’re in the right place.
You’ve built a Shopify store. The brand looks great, orders are coming in, and things are moving. But when you look at the Finance Summary, it doesn’t match what’s in the bank — and you’re not quite sure why.
Here’s the thing: most Shopify store owners are doing their accounts wrong without even realising it. Not because they’re careless — but because Shopify bookkeeping is genuinely more complicated than it looks. Here are the four mistakes we see most often.
Mistake 1: Using Shopify’s Dashboard as Your Accounts
One of the most common questions we hear from Shopify sellers is: “Why doesn’t my Shopify dashboard match what’s in Xero?” The answer is simple — they’re not the same thing, and they’re not supposed to be.
Shopify shows you sales. It does not show you your actual financial position. It doesn’t account for payment processor fees, it doesn’t reconcile with your bank, and it doesn’t handle VAT correctly.
For example: your bank statement shows a deposit of £3,412, but Shopify shows £4,109 in sales. Both are technically correct — but until someone reconciles them properly, you don’t actually know your profit.
And if you’re VAT registered and selling to customers in the UK, EU, and beyond, different VAT rates apply to different orders. Applying a blanket rate to everything is one of the most common — and costly — bookkeeping errors we see.
The Fix: An ecommerce integration using A2X (we’re A2X Partners) does all the heavy lifting — automatically pulling the right data from Shopify into Xero or QuickBooks. We set it up once, and you never have to think about it again.
Mistake 2: Recording Shopify Payouts as Sales
This one’s surprisingly common — and it silently distorts your entire set of accounts.
Your Shopify payout is not your income. It’s a net figure — your sales, minus Shopify’s fees, minus refunds, minus VAT collected. When you record the payout directly to Sales, you’re understating your actual revenue and understating your costs at the same time. The result? A profit figure you can’t trust.
Gross sales, fees, refunds, and VAT need to be recorded separately. That’s what gives you an accurate P&L — and an accurate idea of what your business is actually making.
Mistake 3: Ignoring Payment Processor Fees
Before your payout hits the bank, payment processors like Shopify Payments, PayPal, and Klarna have already taken their cut. These aren’t small amounts — and if you’re not recording them as business expenses, your profit looks healthier than it actually is.
It’s not just about accuracy — unrecorded fees mean you’re potentially overpaying tax on income you never actually received.
Mistake 4: Getting the VAT Wrong
VAT is where Shopify bookkeeping gets complicated fast — particularly for sellers shipping to the EU, USA, and beyond.
Different rules apply depending on the destination country, the product type, and whether you’re selling B2B or B2C. Many sellers apply UK VAT to everything and assume that’s fine. It’s not.
We’ve seen sellers submit VAT returns based purely on their Shopify totals, only to end up with a surprise bill and a lengthy conversation with HMRC trying to unpick what went wrong.
Mistake 5: Not Reconciling Properly (or at all…)
When Shopify deposits a lump sum into your bank account, it’s tempting to record it all as sales at 20% VAT. But that’s wrong on several counts. The payout may span multiple months, include refunds, and contain transactions at different VAT rates.
Without proper reconciliation between Shopify, PayPal, Klarna, and your bank, your books won’t balance — and your VAT won’t be right.
Reconciling is a dull job – but it’s crucial. Its like taking the trash out – let it build up it can get seriously messy and a turn into a major issue. An ecommerce bookkeeper can do these reconciliations in a flash and keep things tidy.
What We Do
Fox Clever Bookkeeping are award-winning ecommerce bookkeeping specialists. We work exclusively with UK online sellers — and we know Shopify inside out.
Our monthly bookkeeping package takes the whole thing off your plate. We handle your Shopify reconciliation, connect your store to Xero or QuickBooks using A2X, keep your VAT clean across all sales channels, and make sure your numbers actually make sense — every single month, without you having to think about it.
You focus on the store. We’ll handle what’s going on behind it.
