The nine boxes of a VAT return, explained for Shopify sellers

A UK VAT return is nine boxes. That is the whole thing. Once you’ve seen what each box is asking for, the return stops feeling like a form and starts feeling like a short summary of what your business did over the quarter.

This is a plain walk through all nine, written for a Shopify seller rather than an accountant. For each box, it’s worth knowing two things: what the box means, and where the figure comes from — your Shopify order data, or somewhere else entirely.

The sales side: boxes 1, 6 and 8

Box 1 — VAT due on your sales. This is the VAT you charged customers over the period. For a Shopify store, most of this comes straight from your orders: the VAT element of each sale, added up by rate. Standard-rated, reduced-rate and zero-rated sales all sit inside this total, and refunds reduce it. It is the box your Shopify data feeds most directly, provided the VAT is separated out correctly from your tax-inclusive prices.

Box 6 — total sales, excluding VAT. The net value of everything you sold. Again, largely derivable from orders, once the VAT has been backed out and refunds netted off. Box 6 trips people up because it’s the net figure, not the gross amount the customer paid.

Box 8 — goods supplied to the EU. The value of certain goods moved to the EU. For most UK-based Shopify sellers this is often nil, but it depends on what and where you sell. It’s worth checking rather than assuming.

The purchase side: boxes 4, 7 and 9

Box 4 — VAT you can reclaim on purchases. The VAT on what your business bought — supplier invoices, software, shipping materials, ad spend, and so on. This is the box Shopify generally cannot tell you about, because Shopify knows your sales, not your expenses. Box 4 usually needs input from your bookkeeping or your purchase records.

Box 7 — total purchases, excluding VAT. The net value of those purchases. Same source as Box 4, and same point: this comes from your expense records, not your store.

Box 9 — goods acquired from the EU. The mirror of Box 8, on the purchase side. Often nil for a simple UK store, but, again, worth confirming for your situation rather than guessing.

The totals: boxes 2, 3 and 5

These three are mostly arithmetic — they fall out of the boxes above.

Box 2 — VAT due on acquisitions from EU member states. A narrower box that applies in specific circumstances. For many UK Shopify sellers it’s nil, but, like boxes 8 and 9, don’t assume without checking how it applies to you.

Box 3 — total VAT due. Box 1 plus Box 2. The total VAT you owe before reclaims.

Box 5 — the net VAT to pay or reclaim. Box 3 minus Box 4. This is the number that decides whether you pay HMRC or HMRC pays you. It’s calculated, not entered from scratch.

Which boxes Shopify can fill, and which it can’t

Pulling the threads together, here’s the rough split for a typical UK Shopify merchant:

• Derivable from Shopify order data: the sales-side figures behind Box 1 and Box 6, once VAT is separated by rate and refunds are netted off correctly.
• Calculated automatically: boxes 3 and 5 follow from the others.
• Need input from outside Shopify: boxes 4 and 7, which come from your purchase and expense records.
• Need checking against your circumstances: boxes 2, 8 and 9, which are nil for many sellers but not all.

This is the crux of why a Shopify export on its own isn’t a finished VAT return — there’s more on that in why your Shopify tax export isn’t your VAT return. Shopify holds the sales side; the purchase side lives elsewhere; and even the sales side needs care to split VAT by rate and handle refunds, which is the same gap that Making Tax Digital was built around.

A note on responsibility

Knowing what each box means doesn’t change who’s accountable. Whichever way you arrive at the figures, you remain responsible for the accuracy of your VAT return. A clear, box-by-box breakdown makes it easier to check your own numbers — it doesn’t do the checking for you, and no tool can promise a perfect return.

VATloop is built to work out the sales-side figures of the nine-box return from your Shopify orders, refunds and tax data, splitting VAT by rate so each total lands in the right box for you to review. The purchase side stays yours to supply, and you sign off every return before anything is sent. The aim is a return you can read and understand, one box at a time.