Why your Shopify tax export isn’t your VAT return

Shopify gives you tax reports and finance summaries, and at a glance they look like everything a VAT return needs. It’s a reasonable assumption — the numbers are right there, broken down, ready to copy. The trouble is that a tax export and a VAT return are answering slightly different questions, and the gaps between them are exactly the places a return goes wrong.

This is a plain look at why the export isn’t the return, and what sits in the gap.

What a Shopify export is good at

Credit where it’s due: Shopify’s reports are a genuinely useful starting point. They show your sales, the tax collected, often a breakdown by rate, and they’re drawn from the same orders your customers actually placed. If you want a quick sense of how much VAT you’ve charged this quarter, the export will get you most of the way there.

The problem isn’t accuracy. It’s that a VAT return asks for a few things a sales-focused export doesn’t set out to give you.

Refunds have to reduce the period

A VAT return covers a period, and within that period a refund isn’t simply a negative sale sitting in a separate report. It has to come off the right figure, at the rate the order was originally charged at. If a customer returns a reduced-rate item, the refund reduces the reduced-rate total — not the standard-rated one.

In a typical export workflow, sales and refunds often live in separate places and get matched up by hand. That manual matching is slow, and it’s easy to miss a refund entirely when you’re working to a deadline. Get it wrong and the period’s VAT is overstated or understated, depending on which way the slip falls.

Period boundaries and timing

Your VAT period has a start date and an end date, and an order belongs to the period its tax point falls in. An export run with slightly different date boundaries — or one that counts an order on a different date than the return should — quietly pulls orders in or pushes them out.

The orders around the edges of the quarter are where this bites. An order placed late on the last day of the period, a refund processed the morning after, a payment that settles a day later than it was placed: each one raises the question of which period it belongs to. A generic export doesn’t answer that question with VAT periods in mind. It just gives you what fell between the dates you picked.

Net versus gross

UK Shopify stores usually show prices with VAT included, so a £30 product is £25 of goods plus £5 of VAT. The VAT return wants both figures separated, by rate. An export that hands you a single gross “total sales” column leaves you to back the VAT out by hand, line by line — the kind of repetitive arithmetic where one rounding choice, applied across thousands of orders, drifts the total off.

The nine boxes themselves make this split explicit; the nine boxes of a VAT return, explained walks through which box wants the net figure and which wants the VAT.

Currency

If you sell to customers abroad, or price in more than one currency, your store may record some orders in a currency other than sterling. A VAT return is filed in pounds. Somewhere between the order and the return, those figures need converting at the right basis — and an export that lists amounts in mixed currencies, or converts on a basis that doesn’t match what the return needs, adds another quiet source of drift.

Closing the gap

None of this means the Shopify export is wrong or useless. It means it’s a sales report, not a VAT return, and the distance between the two is made of refunds, timing, net-versus-gross and currency. Those gaps are precisely what Making Tax Digital pushed towards software to handle, and they’re why a calendar reminder alone won’t carry you over the line — there’s more on the deadlines side in how the quarterly cycle works.

Whichever route you use, you remain responsible for the accuracy of your VAT return; software reduces the manual steps where mistakes creep in, it doesn’t remove your sign-off. VATloop is a tool that reads your Shopify orders, refunds and tax data directly, nets refunds at their original rate, separates VAT from the gross totals, and works to your VAT period rather than to whatever dates an export happened to use. You still review the figures and confirm the return before it goes. The point is to close the gap between a tidy-looking export and the return it isn’t quite.