Help
How VATquarter builds your return
What each part of a return means, how orders are sorted, and how to file with the figures. The names here are the ones you see in the app.
Settings
For a store with an address in the EU, the app starts on a first return when you install it, taking the two countries below from your store address. Open Settings to check them.
- EU country where you are registered for OSS: for an EU business, your home country. Tax authorities call it the “Member State of identification”. A business outside the EU that uses IOSS through an intermediary chooses the intermediary’s country.
- Country your goods usually ship from: used when an order does not say which location shipped it. Orders shipped from a Shopify location in another country use that location’s country automatically.
- Country whose VAT return you file and Your VAT periods: only for the domestic VAT figures, described below.
- An order belongs to the period in which it was “Paid” (recommended) or “Created”. “Paid” uses the date Shopify processed the order, in your store’s time zone.
- Count deliveries to Northern Ireland as EU sales, reported under the code XI: goods sent to Northern Ireland follow EU VAT rules. The app recognises them from the order’s UK region. It does not read postcodes, so a UK order with no region is treated as outside the EU and the return asks you to check it.
Building a return
On Reports, choose the Type of return and the period, then press Build the OSS return. The types are “OSS — sales between EU countries (quarterly)”, “IOSS — imports up to €150 (monthly)” on Pro, and “Domestic VAT” when Settings names the country whose VAT return you file. The Free plan covers the OSS return for the latest completed quarter and the current one; IOSS and earlier periods are part of Pro.
The period still in progress is listed first, marked “(in progress)”, as a preview of the figures so far. File from a period that has ended, so late refunds and the final exchange rate are included. VATquarter asks Shopify for the orders processed by the end of the period and updated since its start, which covers the period’s orders and any earlier orders refunded during it. Large stores take a minute or two; the page refreshes itself.
If orders older than 60 days are missing from a return, email support@vatquarter.com with your store name and the period.
Reading the return
The Summary shows the VAT to pay, the date to file and pay by, and the totals. Below it, Return rows — by country and VAT rate has these columns:
| Column | Meaning |
|---|---|
| Shipped from | The country of the Shopify location that shipped the order, or the country in your settings. Tax portals call it the “Member State of dispatch”. Shown in an OSS return when its rows are split by the country the goods shipped from. |
| Customer’s country | Where the goods were delivered: the order’s shipping address. Tax portals call it the “Member State of consumption”. Orders without a shipping address (pickup, in-person, digital) are listed under “Orders left out”; the billing address is never used instead. |
| VAT rate | The rate Shopify charged, with a label: standard or reduced when it is a known rate of the customer’s country, unrecognised when it is not. A rate that exists only for one region of the country (Austria’s 19% applies only in Jungholz and Mittelberg, for example) is flagged for review unless the order was delivered there. The label is a check, not a calculation: the figures always show what was charged. (The free tool on this site marks the same thing “check rate”.) |
| Sales before VAT (EUR) | What the customer paid for goods and shipping after discounts, without the VAT. Tax portals call it the “taxable amount”. Converted to euros at the European Central Bank rate for the last day of the period, or the next day a rate is published. Orders paid in euros through Shopify Markets are reported in the euro amounts charged. Refunds made in the same period are already taken off. Lines charged at 0% are left out and counted in an item to review. |
| VAT (EUR) | The VAT charged, converted the same way. |
| Orders | The number of orders behind the row. |
Refund corrections for earlier periods lists refunds given this period for orders that were reported in an earlier return, under the period each one belongs to. OSS wants them in the current return as a correction, not as a change to the old return; the return itself asks only for the VAT amount per period and country. Totals per country adds the rows up for each customer’s country.
VAT to pay is the sum for the countries whose balance (VAT on sales plus corrections) is positive. A country with a negative balance pays that amount back to you directly; it does not reduce what you pay the others.
On Free, a return with more than 100 orders, an earlier period or an IOSS return shows the totals and the VAT by country table in place of the rows.
The XLSX download (Pro) has four sheets: Return (what you file), By country, Audit (one row per order or refund with amounts in your currency and in euros) and Excluded orders, which is the “Orders left out” list.
Orders left out, and why
Every order in the period that is not in the return is listed under Orders left out with the reason in the column “Why it was left out”.
| Reason shown | What it means |
|---|---|
| Domestic sale — goes on your regular VAT return | Shipped and delivered in the same country. Not part of OSS. |
| Delivered outside the EU | Delivered to a non-EU country. That includes Great Britain, but not Northern Ireland. |
| Delivered to a territory outside the EU VAT area | The Canary Islands, Ceuta, Melilla, Åland and similar territories belong to an EU country but are outside the EU VAT area, so EU VAT rules do not apply to sales delivered there. |
| Business or tax-exempt customer; Business customer (VAT number on the order) | The customer was tax-exempt, the order was a company order, or a VAT number was on it. These orders are left out only when no VAT was charged; if VAT was charged, the order is in the return and appears in the items to review. |
| No VAT was charged | An order to an EU consumer with an amount and no tax. Usually a gap in the store’s tax settings; check before filing. |
| Shipped from outside the EU (belongs in IOSS); Shipped from inside the EU (belongs in OSS) | The order belongs to the other type of return. |
| Goods worth more than €150 | IOSS only: the goods are worth more than the limit for IOSS, so import VAT is collected at the border. |
| Marketplace collects the VAT | A marketplace is responsible for the VAT on the order, not you. |
| Test order; Cancelled or not paid | Test orders, and orders that were voided or cancelled without payment. |
| Not paid yet | Orders still pending or only authorised (bank transfer, invoice, manual capture). They keep their original period; build the return again after they are paid. |
| No delivery address (pickup, in-person or digital); In-person sale or pickup | The goods were not sent to the customer, so the order is not a distance sale. |
Items to review
A return with something to check carries a banner, “items to review before filing”. The most common ones:
- A rate labelled “unrecognised”: Shopify charged a rate that is not a known VAT rate for the customer’s country, usually a manual tax override or an outdated rate. Check Settings → Taxes and duties in your Shopify admin and fix it there before filing.
- The VAT on an order’s lines differs from its total tax, or the order was edited after payment. Compare with the order in Shopify.
- A business customer was charged VAT: the order is included because the VAT was charged. Check whether it should have been sold without VAT.
- A line that looks like a duty or fee charged to the customer: it is counted in the sales before VAT at the line’s rate. Confirm the customer really paid it.
- Refunds were larger than sales for a country and rate this period. An OSS return cannot hold a negative row; ask your adviser how to report it (usually as a correction).
- No exchange rate yet: the period has not ended or the European Central Bank has not published the rate. Build the return again after the period ends.
- Northern Ireland and Monaco: for information. Northern Ireland is reported under XI and Monaco under France.
Filing with the figures
- Build the return after the period has ended, so the exchange rate and late refunds are final.
- Read the items to review and the orders left out.
- Log in to your tax authority’s OSS portal and enter each return row: country, VAT rate, sales before VAT, VAT. In the Union OSS return, goods shipped from the country where you are registered go in part 2b, and goods shipped from another EU country go in part 2d under that country. (Parts 2a and 2c are for services.) See the Commission’s OSS guidelines.
- Enter the refund corrections under the earlier period each one belongs to (part 3).
- Submit and pay the VAT to pay by the last day of the month after the period, for example 31 January for the October to December quarter.
- Keep the figures with your records for ten years, as the OSS rules require. The XLSX download on Pro is made for that.
If you are registered for OSS and had no sales to report in a quarter, you still have to submit a return for it (a “nil return”) in your OSS portal.
Figures for your own VAT return (domestic VAT)
For a store in the United Kingdom or an EU country, VATquarter can also add up the sales delivered in your own country: one line per VAT rate with the sales before VAT, the VAT and the total, after the refunds made in the period. Choose the country in Settings, then “Domestic VAT” as the type of return under Reports, your VAT periods and a period.
- United Kingdom: the figures are matched to the two VAT return boxes they support, Box 1 (VAT due on sales) and Box 6 (total value of sales excluding VAT, which includes zero-rated sales and exports). The other boxes need your purchases and other records, which are not in Shopify.
- Refunds are taken off in the period the money went back to the customer.
- Currency: amounts stay in your store currency. If that is not the currency of your VAT return, the page says so and leaves the conversion to you.
- Not covered: purchases and input VAT, sales outside Shopify, the Flat Rate Scheme, cash accounting, margin and retail schemes, reverse charges, imports, and goods moving between Northern Ireland and the EU.
These are figures to support your return. VATquarter does not produce a complete domestic VAT return and does not file it.
FAQ
Why don’t my totals match my Shopify sales report? Shopify’s sales reports include domestic, non-EU and business orders and are in your store currency, with VAT included. The OSS return covers sales to consumers in other EU countries only, before VAT, in euros.
The return is empty. Then no order in that period was shipped from your country to a consumer in another EU country with VAT charged. Check the two countries in Settings, and use the €10,000 threshold page to see whether OSS applies to you yet.
My store is under the €10,000 threshold. Do I need this? Check the €10,000 EU threshold page in the app. A business established in one EU country whose sales to consumers in other EU countries stay under the threshold may charge its home-country VAT and does not file OSS. Once you pass it in a calendar year, the customer’s country’s VAT applies from that sale.
Can my accountant use it? Yes. Add them as a staff member with Apps access in Shopify, or send them the XLSX (Pro).
What is free and what is Pro? Free shows the complete return on screen (every country and rate row, refund corrections, orders left out with reasons, items to review) for the latest completed quarter and the current one, for up to 100 in-scope orders a period, plus the €10,000 threshold tracker. Above 100 orders Free shows totals and VAT per country. Pro, at $9 a month or $79 a year with a 14-day free trial, adds unlimited orders, the XLSX and CSV download with the per-order audit sheet, earlier periods, IOSS monthly returns and the split by the country goods shipped from.
I have an orders export and don’t want to install anything yet. The free OSS tool builds the country and rate rows from a Shopify orders CSV in your browser.
Something looks wrong. Email support@vatquarter.com with the store name and period. Include the order name if it’s a specific order.