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.
Tell it what the file can’t
Orders delivered in this country are domestic and left out.
Dates are taken as written in the file (your store’s time zone).
The ECB reference rate for the last day of the quarter (or the next day one was published). Look it up on the ECB reference rates page.
Your OSS return rows
| Country of delivery | VAT rate | Taxable | VAT | Orders |
|---|
Left out of the return
Next quarter, skip the export.
The VATquarter app does this in one click each quarter from your live orders, with refunds of earlier quarters as corrections and an audit sheet that traces every figure to its order.
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.
Open Orders and choose Export
In your Shopify admin, go to Orders and click Export.
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.
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?
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.