.svg)
As a specialist ecommerce accountant UK sellers rely on, the most common panicked question I get from new D2C founders is: "Where has all my money gone?"
You log into your dashboard, see a massive top-line sales figure, but the cash actually hitting your bank account is significantly lighter. If you do not understand how to track and account for this difference, your financial records will be a mess, your profit margins will be fiction, and HMRC will eventually come knocking.
In this guide, I will walk you through exactly how to handle your Shopify bookkeeping, ensure your tax records are bulletproof, and explain why your bank deposits never match your dashboard.
Shopify payouts represent your net cash, not your gross revenue. Before Shopify transfers your money, they automatically deduct payment gateway fees, refunds, chargebacks, and occasionally rolling reserves.
When you look at your Shopify analytics dashboard, you are looking at your gross sales. This is the total amount your customers paid. However, the cash that lands in your bank account is the net payout.
If you simply record those net bank deposits as your total revenue in accounting software like Xero, you are severely underreporting your sales and failing to account for your expenses.
You must account for the missing money. Every time you receive a settlement, you need to break it down into gross revenue, subtract the fees, account for any refunds, and match the final number to the cash received.
Effective Shopify reconciliation is the backbone of your ecommerce accounting. If you cannot reconcile Shopify payments accurately, you cannot trust your profit and loss statement.
To do this correctly, you must map the settlement data to your accounting software. Here is the standard procedure we use for our clients:
By doing this, your revenue stays accurate, and you claim tax relief on the fees Shopify charged you.
When dealing with Shopify payment fees accounting, things can get complicated quickly. It is rarely just a flat percentage fee. You will encounter several variables that skew your numbers:
If you do not split these out during reconciliation, your accounting software will simply view the missing cash as unearned revenue. As a dedicated Shopify accountant UK brands trust, I always advise isolating FX fees in particular, as these can severely eat into your margins without you realising.
This is where D2C brands make their most expensive mistakes. If you take one thing away from this guide, let it be this: HMRC requires you to report and pay VAT on your gross sales, not your net payouts.
If you are a VAT-registered business, calculating your Shopify VAT return based solely on the cash that hits your bank account is a major compliance breach. HMRC expects to see the full amount the customer paid. The fees Shopify deducts are a separate business expense.
When you are reporting HMRC Shopify sales, you must also be acutely aware of your zero-rated and standard-rated products, especially if you sell a mix of adult clothing (standard-rated) and children's clothing or certain foods (zero-rated). Proper categorisation at the checkout level is vital so your reconciliation process pulls the correct VAT liability.
For standard Shopify stores, automation software like A2X or Dext Commerce is brilliant. These tools sit between Shopify and Xero, automatically pulling your settlement reports, splitting out the fees, and posting a neat journal entry that matches your bank feed perfectly.
However, modern ecommerce is rarely that simple. If you are a brand leveraging multi-channel sales—perhaps combining Shopify with Amazon FBA, or driving massive volume through TikTok Shop affiliates—standard automation breaks down. As of right now, seamless integration software for creators and multi-tier affiliate structures does not really exist. It requires manual, expert intervention.
If you are doing low volume, you can manage this yourself. But once you scale to six or seven figures, the time spent untangling FX fees and affiliate payouts is time stolen from growing your brand. That is when you need to partner with an ecommerce accountant UK specialists run, who understands the specific mechanics of modern social commerce.
Sam Hoye is the founder of Social Commerce Accountants, a modern, specialist accounting firm built for the new era of retail. With years of lived experience helping TikTok Shop sellers, Amazon FBA brands, and high-growth Shopify stores scale profitably, Sam provides clear, no-nonsense financial strategies for modern ecommerce founders.
Disclaimer: This guide is not financial advice. All content is for educational purposes only. Please consult a qualified accountant or financial advisor to discuss how these strategies apply to your specific business circumstances before making any financial decisions.
COPYRIGHT © 2025 SOCIAL COMMERCE ACCOUNTANTS | SOCIAL COMMERCE ACCOUNTANTS LIMITED IS REGISTERED IN ENGLAND UNDER 13802919. REGISTERED ADDRESS: UNIT D2 OFFICE 2, STATION ROAD, SAWBRIDGEWORTH, ENGLAND, CM21 9JX. VAT REGISTRATION NO: GB 400 3244 64
Forget generic templates. Answer a few quick questions and our AI will generate a custom 12-month Excel profit engine tailored to your specific marketplace and supply chain.
Logic that adapts to your setup—whether you sell on Shopify, Amazon FBA, or TikTok Shop.
We bake in the hard stuff: UK VAT, EU OSS, and complex landed cost calculations automatically.
A professional-grade dashboard delivered instantly. See your real margins and forecast with confidence.
