Skip to content
Hypamoon

For teams that run on Shopify

Shopify OSS report per country and VAT rate

Shopify charges VAT per country and has tax reports, such as total sales by order, that you can export. Each report in the admin shows up to 1,000 rows. Sellers who file the EU One Stop Shop return, or need sales per rate, split the export by country and rate themselves.

How it goes today

  1. Export the orders of the quarter with their taxes.
  2. Sort them by the country they were shipped to.
  3. Split the amounts per VAT rate and take off refunds.
  4. Copy the totals into the return or send them to the accountant.

How it can go

Sales per country and VAT rate each quarter, without the spreadsheet.

After each quarter, and each month if you want, you get a file per country of delivery: sales without VAT and the VAT per rate, with refunds from that period taken off, shipping on its own line, and the orders behind each total. Orders from business customers with a VAT number in their company profile are kept apart.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. Shopify works with a sign-in instead of a key: you sign in to Shopify once to give access, never in the chat.

Your request

With Hypamoon, after each quarter, take the Shopify orders shipped to other EU countries and total them per country of delivery and VAT rate: sales without VAT and the VAT, with refunds in that quarter taken off and shipping on its own line. Keep orders from business customers with a VAT number in their company profile apart. Email me and my accountant the file with the orders behind each total.

You create your own app in the Shopify Dev Dashboard and install it on your store once, with the access you approve. Shopify's help says apps that use customer names, emails or addresses need the Grow plan or higher. It stays yours.

More for teams on Shopify