Help CenterContact support
All Columna: Order Export & Sheets articles

How do I export an EU OSS or IOSS VAT report?

Updated

On this page
  1. Export the report
  2. What each row means
  3. What is left out
  4. Limits to check by hand
  5. Troubleshooting

Shopify collects EU VAT at checkout, but its tax report only shows the tax collected, not the taxable amount per country. The EU OSS / IOSS VAT report preset adds both up for the period you file.

The report is a worksheet for you or your accountant. It is not a filed return. Before you file, compare the VAT totals with Shopify’s taxes report.

Export the report

  1. Open Templates in the app, then the Accounting tab.
  2. On EU OSS / IOSS VAT report, click Export report. The Orders page opens with the report selected.
  3. Set the date range to the period you file: a quarter for OSS (for example 2026-07-01 to 2026-09-30), or a month for IOSS.
  4. Click Export, choose CSV or Excel, and click Export again.

Orders are read and summed in your browser. They are not stored by the app.

What each row means

The report has one row per scheme, member state of consumption, VAT rate, and sales or refunds:

Column Meaning
Scheme OSS when your store address is in the EU. IOSS when it is outside the EU.
Member state of consumption Country code of the shipping address. When an order has no shipping address, the billing address is used.
VAT rate (%) The rate Shopify charged on the item or shipping line. Shipping is reported at the rate charged on it.
Type Sales for orders placed in the period. Refunds for refunds made in the period, as negative amounts, even when the order was placed earlier.
Taxable amount Amount without VAT, after discounts. When your prices include tax, the VAT is taken off.
VAT amount VAT charged, or VAT refunded as a negative amount.
Currency Your store currency. Amounts are not converted. If it is not EUR, convert them with the ECB rate for the last day of the period before you file.
Orders Number of orders in the row.

What is left out

  • Orders shipped to your own store’s country (domestic sales are not reported under OSS).
  • Orders shipped outside the EU.
  • Tax-exempt orders, such as B2B orders where a valid VAT number was entered and the reverse charge applies.
  • Test orders, and orders whose payment was voided or expired.
  • Gift cards, because no VAT is due when a gift card is sold.
  • For IOSS: orders whose goods are worth more than 150 EUR before VAT and shipping, because import VAT is then due at the border. The value is checked in euros when the customer paid in EUR or your store currency is EUR. Otherwise the row is marked IOSS (check 150 EUR limit) so you can check it yourself.

Limits to check by hand

  • The scheme comes from your store address in Settings > Store details. If you ship from a warehouse in another country, check the scheme yourself.
  • Northern Ireland is not detected separately from the rest of the United Kingdom.
  • Refunds that are not linked to an item or to shipping (for example a goodwill amount) are not included.
  • Each order reads up to 5 refunds with up to 10 refunded items each.

Troubleshooting

  • “Add your store address in Settings > Store details.”: the report needs your store country to tell domestic sales from OSS sales. Add the address in Shopify, then export again.
  • The report is empty: check that the date range covers the period and that the order filters (payment status, tags, search) do not hide the orders.

Built and supported by StoreFleet, Shopify app developers since 2021.