Shopify bookkeeping is the process of turning Shopify's sales, fee, refund and payout data into accounts that reconcile to the bank and satisfy HMRC. Shopify records transactions; it does not perform double-entry bookkeeping, calculate your VAT liability, or separate revenue from the fees and chargebacks bundled into each payout. Get the controls wrong and the gap between what Shopify's dashboard calls "sales" and what actually lands in your bank account, often called the Cash Gap, becomes one of the most common reasons ecommerce founders run out of cash.

This article sets out the specific controls a UK Shopify store should have in place, where Shopify's own reports fall short, and where the rules genuinely differ if you also sell on Amazon, Etsy or TikTok Shop alongside your own store.

Does Shopify have a bookkeeping system?

No. Shopify has a reporting system, not a bookkeeping system, and the difference matters more than most sellers realise. The Analytics and Finance sections of the admin show gross sales, refunds, shipping and a payout summary, but there is no chart of accounts, no VAT return, no fixed asset register, and no way to record cost of goods sold against a specific accounting period unless you connect a proper ledger.

  • What Shopify shows you: gross sales by channel, order counts, refund totals, and the Shopify Payments payout schedule.
  • What it does not show you: VAT owed, true margin after ad spend and processing fees, multi-currency gains or losses, or accruals for stock and returns.

This is why most of the UK Shopify store owners we work with run Xero or QuickBooks alongside Shopify rather than relying on its native reports for anything beyond a quick sales check.

The core controls every UK Shopify store should have

Five controls separate a Shopify store with clean books from one that discovers a VAT bill or a cash shortfall too late.

  1. Settlement reconciliation of every payout, not just the net figure.
  2. Rolling 12-month VAT threshold monitoring.
  3. Correct treatment of import VAT on stock bought from overseas suppliers.
  4. Clean separation between Shopify's own-store sales and any marketplace channels.
  5. A monthly close that accrues for ad spend, cost of goods and a refunds reserve.

Settlement reconciliation: why the payout figure isn't your sales figure

Settlement reconciliation is the process of matching the net amount Shopify pays into your bank account back to the three things it's made up of: gross sales, refunds, and processing fees. Say a two-week period shows gross sales of £9,650, refunds of £310, Shopify Payments processing fees of £289, and a £45 chargeback. The net payout landing in the bank is £9,006. If a bookkeeper records that £9,006 as revenue, turnover is understated by roughly £644, fees never appear as a cost, and the VAT calculation on the return is wrong. The correct entry books gross sales as revenue, refunds as a contra-revenue line, fees as a processing expense, and the payout as the cash movement, three ledger lines instead of one.

VAT threshold monitoring: the rolling 12-month trap

UK businesses must register for VAT once taxable turnover exceeds £90,000 in any rolling 12-month period, as of 2024, not the tax year or calendar year. That distinction catches out more Shopify sellers than any other rule on this list: a store trading comfortably below the threshold since April can still tip over mid-quarter after a strong Black Friday month, and registration is required within 30 days of crossing it. Checking turnover once a year at your accounting date is not enough; it needs checking monthly.

Import VAT and Postponed VAT Accounting (PVA)

If you import stock for resale, for example from a manufacturer in China, import VAT is due at the border on the full value of the goods. That's a different rule from the £135 threshold, which applies to low-value goods sold directly to UK consumers by overseas sellers, not to stock you buy in for your own store. Most VAT-registered Shopify stores should use Postponed VAT Accounting (PVA) to declare and reclaim import VAT on the same VAT return rather than paying it upfront at the border, which protects cash flow. You'll also need to keep the monthly import VAT certificate to support the reclaim.

Does Shopify declare to HMRC?

Shopify itself does not report your sales data to HMRC in the way that Amazon, eBay and Etsy are required to under the OECD-aligned digital platform reporting rules that took effect from January 2024, because Shopify is classified as a software provider that lets you run your own store, rather than a marketplace connecting buyers and sellers on shared inventory. That distinction is real but it doesn't make Shopify income invisible to HMRC. Your VAT returns, Self Assessment or Corporation Tax filings, and the bank and payment records behind them, remain fully discoverable in an enquiry, and from April 2026 sole traders and landlords with qualifying income above £50,000 must also file quarterly under Making Tax Digital for Income Tax (MTD ITSA). If you sell through a marketplace alongside your Shopify store, that channel's sales data is reported to HMRC every January regardless.

Do I need QuickBooks or Xero if I use Shopify?

For almost every trading Shopify store, yes. Shopify's reports cannot produce a VAT return, a profit and loss account, or the digital records HMRC requires under Making Tax Digital, so a proper system, typically Xero or QuickBooks connected via a Shopify-specific app such as A2X or Link My Books, stops being optional once you're VAT registered or incorporated. The narrow exception is a genuinely hobby-level seller trading under the £1,000 Trading Allowance, who may not need to register as self-employed at all. Once you're past that, the integration matters as much as the software: a poorly configured sync that posts the net payout instead of the gross sales, refunds and fee lines separately reproduces the exact settlement reconciliation problem described above, just automated.

Why do so many Shopify stores running Facebook ads fail?

I've reviewed enough failed Shopify stores to see the same pattern repeat. Founders scale ad spend against a ROAS figure that ignores Shopify Payments fees, refunds, VAT and true cost of goods, so a campaign that looks profitable on the ads dashboard is quietly loss-making once the books are done properly. Take a product selling for £30 including VAT: strip out £5 of VAT, £8 of cost of goods, roughly £1.20 of Shopify Payments fees, and a realistic returns allowance of £1.50, and the true contribution before ad spend is around £14.30, not £30. A £10 cost per acquisition that looked fine against a headline 3x ROAS suddenly leaves very little margin.

The second failure mode is timing rather than margin: ad spend is charged daily on a card, but Shopify Payments payouts land every two to three days and card processors can hold funds for refund reserves. A store can be genuinely profitable on paper and still run out of working capital funding ads ahead of the cash arriving. This is the exact pattern we see most often in the Shopify sellers we support, and it's almost always fixed with better cash flow forecasting rather than cutting ad spend.

Final word

Shopify gives you good sales visibility and weak financial control. The stores that avoid VAT surprises and cash shortfalls are the ones that treat settlement reconciliation, VAT threshold monitoring and import VAT treatment as non-negotiable monthly habits, not year-end clean-up jobs. If you'd rather have an accountant who already understands Shopify Payments payouts, multi-channel reconciliation and the current HMRC rules, get your personalised proposal and we'll show you exactly what needs fixing first.