Install on Shopify

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.

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:

ColumnMeaning
Shipped fromThe 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 countryWhere 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 rateThe 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.
OrdersThe 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 shownWhat it means
Domestic sale — goes on your regular VAT returnShipped and delivered in the same country. Not part of OSS.
Delivered outside the EUDelivered to a non-EU country. That includes Great Britain, but not Northern Ireland.
Delivered to a territory outside the EU VAT areaThe 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 chargedAn 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 €150IOSS only: the goods are worth more than the limit for IOSS, so import VAT is collected at the border.
Marketplace collects the VATA marketplace is responsible for the VAT on the order, not you.
Test order; Cancelled or not paidTest orders, and orders that were voided or cancelled without payment.
Not paid yetOrders 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 pickupThe 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:

Filing with the figures

  1. Build the return after the period has ended, so the exchange rate and late refunds are final.
  2. Read the items to review and the orders left out.
  3. 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.
  4. Enter the refund corrections under the earlier period each one belongs to (part 3).
  5. 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.
  6. 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.

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.