Install on Shopify

Free tool · no sign-up

OSS return rows from a Shopify orders export

Drop in the CSV you export from Shopify’s Orders page. You get the table an OSS return asks for: taxable amount and VAT for each EU country and rate in the quarter, and a list of the orders left out, with the reason.

Your file is read by your browser and never leaves your computer. Nothing is uploaded, and this page makes no network requests after it has loaded.

Calculator

Choose your orders export

or drop it here

No file to hand? (an invented German store, 67 orders) or download it to see the format.

What this tool can’t see.

An orders export is a flat file. It leaves out things an OSS return needs, so treat the result as a careful first pass and check it before you file.

Net amount per rate
The export gives the VAT per tax line but not the net amount behind it. The tool takes each order’s total minus tax; when one order carries two rates it splits the net by dividing each VAT amount by its rate. That can be a few cents off per order.
Refund dates
The file has one “Refunded Amount” per order and no date. The tool reduces a partly refunded order in proportion, as if the refund happened in the same quarter. A refund made this quarter for an order from an earlier quarter belongs in this return as a correction to that quarter, and the file can’t show that. The tool tells you which orders to look up.
Dates in a re-saved file
Shopify writes dates as year-month-day. A file re-saved by a spreadsheet may have 3/8/2026, which is 3 August in one country and 8 March in another. The tool works out the order from all the dates in the file and tells you when it cannot be sure.
Which lines were refunded
If a refund covered only the reduced-rate item of a mixed order, the tool still spreads it over both rates.
Where the goods shipped from
The export doesn’t record the warehouse. The tool assumes every order left from the one country you pick. If you also ship from a warehouse in another EU country, those rows go in a separate part of the return.
Business customers
There is no VAT-number column. EU orders with no tax are left out and listed for you to check; orders with a company name and tax are included and counted in a note.
The exchange rate
The return is in euros at the ECB rate for the last day of the quarter. The tool makes no network requests, so it can’t fetch that rate. You enter it.
IOSS
This tool builds the quarterly Union OSS return for goods shipped from an EU country. It doesn’t apply the €150 consignment test of the monthly IOSS return.

The VATquarter app reads orders, refunds and fulfilment locations through Shopify’s API, so it works per line and per refund, reports corrections under their original quarter, splits by dispatch country and applies the ECB rate itself. Neither the tool nor the app files a return or gives tax advice.

How to get the file from Shopify.

The export has one row per line item. Leave it as Shopify made it; the tool reads the standard columns.

  1. Open Orders and choose Export

    In your Shopify admin, go to Orders and click Export.

  2. Pick the quarter’s dates

    Choose “Orders by date” and set the range to the quarter, for example 1 October to 31 December. A wider range is fine: the tool only counts the quarter you select.

  3. Export as CSV

    Under “Export as”, choose a CSV format (the plain CSV file if the dialog offers one) and export the orders, not the transaction histories. Large exports arrive by email. Then drop the file above, unchanged: opening and re-saving it in a spreadsheet can rewrite its dates and numbers.

Questions about the tool.

The full manual method is in the guide How to prepare your OSS return from Shopify orders.

Is my orders file uploaded anywhere?
No. The page reads the file with your browser’s file reader and does the sums in the page. It sends nothing to VATquarter or anyone else, sets no cookies and loads no scripts from other sites: every script on the page is served from vatquarter.com. The page is also served with a content security policy (connect-src 'none') that makes the browser refuse any attempt by its scripts to send data. You can load the page, disconnect from the internet, and it still works.
Which columns does it read?
Name, Financial Status, Paid at, Created at, Cancelled at, Currency, Subtotal, Shipping, Taxes, Total, Refunded Amount, Shipping Country, Shipping Province, Shipping Zip, the company columns, and Tax 1 to Tax 5 Name and Value. Customer names, emails and street addresses in the file are ignored.
Why is an order missing from the rows?
Every order in the quarter that isn’t counted appears under “Left out of the return” with its reason: delivered in your home country, delivered outside the EU or outside the EU VAT area (the Canary Islands, for example), no tax charged, no shipping address, not paid, cancelled, or refunded in full.
What does “check rate” mean?
The rate charged on those orders is not a VAT rate that applies throughout the country they were delivered to: a German 19% on an order to Spain or Austria, say. That usually means the store’s tax settings charge home-country VAT where the customer’s country’s VAT is due. A few countries have special rates for one region (Austria’s 19% applies only in Jungholz and Mittelberg; Portugal has special rates for the Azores and Madeira, France for Corsica, Greece for some Aegean islands). The file does not show that an order went to such a region, so those rates are marked “check rate” too, with the region named in the note above the table. The figures still show what was charged. The app labels the same thing “unrecognised”.
My store is under the €10,000 threshold. Do I need this?
Probably not yet. An EU business established in one Member State with under €10,000 a year of cross-border sales to consumers can charge its home VAT and doesn’t file OSS. The tool will then show your cross-border orders at your home rate, flagged “check rate”.
Can I file from these figures?
You can use them as your working figures once you have dealt with the notes above the table, above all refunds of earlier quarters. You file the return yourself in your national OSS portal. This is software, not tax advice.