VAT Reporting for Shopify Stores Selling to the EU and UK

A Shopify store selling into the EU and the UK needs three things in view: VAT collected by country and by rate, a One Stop Shop summary for cross-border EU sales, and UK VAT as its own figure. Shopify calculates the tax on each order, but a return is prepared from totals, and the totals have to be grouped the way the return asks for them. This guide covers what the report should show, how the EU and UK views differ, and where the figures tend to go wrong. It is not tax advice: your accountant or VAT adviser decides what you file and where.

What should a VAT report show?

One row for each combination of country and VAT rate, over a period you choose. Each row needs:

• the net sales the VAT was charged on;
• the VAT collected;
• the rate that applied;
• refunds in the period, so the figures reflect money you gave back.

The same country appears on more than one row when your products are taxed at different rates there. That is the reason to group by rate and not only by country: a single total for 'VAT collected in France' hides which rate produced it, and whoever prepares the return has to split it again by hand.

Keep Shopify's sales definitions in mind while you read it. Net sales leave out shipping and tax, and total sales include them, so a VAT figure will not reconcile if you set it against the wrong one. Our guide to gross, net and total sales on Shopify sets out the order.

What is the One Stop Shop summary for?

It is the working paper for the EU return. For sellers established in the EU, sales to consumers in other member states are taxed at the buyer's country rate once those sales pass €10,000 a year across the EU. The One Stop Shop lets you report all of it through one return, and that return needs sales by country and VAT rate.

That gives the summary two jobs:

1. Before the threshold, it shows your running total of cross-border EU consumer sales for the year, so that passing €10,000 is something you see coming.
2. After it, it lists each destination country and rate with the sales and VAT for the period, ready to hand over.

That rule is written for EU-established sellers shipping to consumers. If your set-up is different, for example you are based outside the EU or you sell to businesses, ask an adviser which arrangements apply to you. Our guide to cross-border VAT, OSS and IOSS goes further into how the schemes fit together.

Why is UK VAT kept separate?

Because the UK is not part of the EU return. UK VAT is reported separately, with its own return, so UK sales need their own summary and should never be folded into a 'Europe' total.

In practice, check that the report splits by destination country, so UK orders sit in their own section. If you sell to UK shoppers in pounds and to EU shoppers in euros, agree with your accountant which currency each summary is read in, and keep to it.

How does VAT change your margin by country?

When your prices include tax, a higher rate leaves you with less of the same price.

Here is an example with made-up rates. Say you sell a product for $60 including VAT in two countries, one charging 20% and the other 25%. At 20%, $10 of the price is VAT and you keep $50. At 25%, $12 is VAT and you keep $48. The shopper pays the same amount and your margin differs by $2 a unit.

This is why VAT by country belongs next to your sales figures, not in a folder you open only at filing time. A market that looks strong on total sales can be weaker on what you keep. Read it alongside sales by city, region and country before deciding where the next round of ad spend goes.

Where do the figures usually go wrong?

In the inputs, more often than in the arithmetic.

• Refunds. A refund often lands in a later period than its order. Make sure the report shows refunds clearly, with their dates, and ask your accountant how they should be treated.
• Product tax settings. A row with sales and no VAT, in a country where you expect to charge it, is worth checking: it can point to a product or market set up wrongly in Shopify. If so, fix the setting, not the report.
• Shipping. If you charge for delivery, find out whether the report counts tax on shipping in the VAT column and whether the taxable amount includes the shipping charge.
• Sales outside Shopify. Marketplace and wholesale orders that never pass through your store are not in a Shopify report. They have to come from those channels' own records.

Is a VAT report the same as a filing?

No. A report gathers what Shopify recorded on your orders. A return is a statement you or your accountant make to a tax authority, and it may need adjustments that no order report knows about. The value of the report is that tax stays visible between filings, and that the person preparing the return starts from clean, grouped numbers.

Marka Metrics shows VAT by country and rate, with One Stop Shop and UK VAT summaries, on its Growth and Pro plans. The reports keep tax in view from your Shopify orders; they are not a tax filing or tax advice.

A short checklist

1. Group VAT by country and by rate, not by country alone.
2. If you are established in the EU, watch cross-border consumer sales against the €10,000 threshold through the year.
3. Keep UK VAT in its own summary, apart from the EU.
4. Check refunds, shipping and zero-VAT rows before you hand figures over.
5. Add sales from channels outside Shopify from their own records.
6. Give the grouped report to your accountant, and do not treat it as the return.

VAT is one of several things Shopify's standard reports leave you to assemble yourself; our guide to what Shopify analytics covers and leaves out lists the others. If you also sell into the United States, tracking sales tax nexus is the equivalent job there. To keep VAT by country and rate in front of you between filings, take a look at Marka Metrics.