Making Tax Digital for VAT: what Shopify sellers need

If you run a VAT-registered Shopify store in the UK, you have to file your VAT returns digitally. That is the short version of Making Tax Digital. The longer version has a few corners worth understanding, especially because Shopify’s numbers don’t map cleanly onto a VAT return on their own.

This is a plain guide to what MTD for VAT actually asks of you, where the usual spreadsheet approach goes wrong, and what a submission tool does to close the gap.

What Making Tax Digital for VAT is

Making Tax Digital (MTD) is HMRC’s programme to move tax record-keeping and filing into software. For VAT, it means two things:

• You keep your VAT records digitally.
• You submit your VAT return to HMRC through software that connects to HMRC’s MTD VAT system, rather than by typing figures into the old online form.

The return itself hasn’t changed. It is still the familiar nine boxes — VAT on sales, VAT on purchases, the net figures, and so on. What has changed is the route the figures take to get there. Under MTD, that route has to be a digital one, with the figures flowing from your records to HMRC without being re-keyed by hand along the way.

Who it applies to

MTD for VAT applies to VAT-registered businesses in the UK. If you are registered for VAT, you are within its scope, regardless of your turnover.

For a Shopify merchant, that usually means: once you’re VAT-registered, every quarterly return needs to go to HMRC through compatible software. The familiar manual route through the HMRC website is no longer the path for VAT-registered traders.

If you are not VAT-registered, none of this applies to you yet. It becomes relevant the moment you register — which is worth keeping in mind if your sales are climbing towards the registration threshold.

Why exporting Shopify numbers into a spreadsheet goes wrong

Most merchants start the same way: export orders to CSV, open a spreadsheet, add up the totals, and copy the result across. It feels straightforward. It rarely is, and here is where it tends to break.

Tax-inclusive pricing

UK Shopify stores usually show prices with VAT included. So a £30 product is really £25 of goods plus £5 of VAT. Your VAT return needs both figures separated out, and it needs them per VAT rate. Pulling a single “total sales” column from a CSV gives you the gross figure with the VAT baked in. Backing the VAT out by hand, line by line, is exactly the kind of repetitive arithmetic where a rounding choice or a missed rate quietly throws the numbers off.

Refunds

A refund is not just a negative sale. It has to reduce the right box, at the VAT rate the order was originally charged at. If a customer returns a reduced-rate item, the refund needs to come off the reduced-rate total, not the standard one. In a spreadsheet, refunds often sit in a separate export, get matched up by hand, and are an easy thing to miss entirely when you’re working to a deadline.

Zero-rated, reduced-rate, and goods that leave the UK

Not everything you sell is standard-rated. Children’s clothing, most food, some printed matter — these can be zero-rated or reduced-rate. Goods sold to customers outside the UK have their own treatment again. Each of these needs to land in the correct box. Lumping everything into one VAT-on-sales figure is the most common way a return ends up wrong without anyone noticing until much later.

The re-keying problem

Even when the spreadsheet maths is right, copying a final figure from a cell into HMRC by hand is the kind of step MTD was designed to move away from. It is also the step where a transposed digit does the most damage.

None of this means a spreadsheet can’t be made to work. It means it takes care, time, and a steady hand every quarter — and that the cost of a small slip is paid to HMRC.

What a VAT submission tool does

This is the gap that bridging and submission software is built to fill. A tool of this kind sits between your sales data and HMRC, and its job is to do the awkward parts for you:

• Read your sales data at source. Instead of a CSV export, it pulls your orders, refunds, and tax breakdowns directly, so the figures it works from are the figures in your store.
• Separate VAT from the gross totals correctly. It splits out the VAT by rate, so standard, reduced, and zero-rated sales each land where they should.
• Handle refunds at the original rate. Returns reduce the right box automatically, rather than being matched up by hand.
• Submit through HMRC’s MTD VAT system. Once you’ve checked the figures, the return goes to HMRC over the official MTD VAT connection — no re-keying into a separate website.

The point of all this is not to take the work off your hands entirely. You still review the return and you still confirm it before anything is sent. What changes is that the error-prone middle — the export, the spreadsheet, the per-rate arithmetic, the manual re-typing — is handled by software built for it.

A note on responsibility

It is worth being clear about one thing: whichever route you use, you remain responsible for the accuracy of your VAT return. Good software reduces the manual steps where mistakes creep in, and gives you a clear set of figures to check. It does not replace your judgement, and no tool can promise you a perfect return. The goal is a calmer quarter and fewer places for an error to hide, not a guarantee.

Where VATloop fits

VATloop is built for exactly the merchant this guide describes: a UK Shopify seller who is VAT-registered, files quarterly, and doesn’t want a full accounting platform sitting between them and one VAT return.

It reads your Shopify orders, refunds, and tax data, works out the sales-side figures of your nine-box return by rate, and submits through HMRC’s MTD VAT system once you’ve reviewed and confirmed them. It is built to HMRC’s MTD VAT specification. You stay in control of the figures and sign off every return before it goes.

If that sounds like the part of running your shop you’d happily hand to software, that’s the part we built.