Skip to content
Hypamoon

For teams that run on WooCommerce

WooCommerce OSS report per EU country and rate

The WooCommerce taxes report lists tax per tax code for a period. For the EU One Stop Shop return you need sales without VAT and the VAT per country and rate, with refunds in the right quarter, so sellers export the orders and split them in a spreadsheet.

How it goes today

  1. Export the orders of the quarter.
  2. Sort them by the customer's country.
  3. Split sales and VAT per rate and take off refunds.
  4. Type the totals into the OSS return.

How it can go

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

After each quarter you get a file per EU country: sales without VAT and the VAT per rate, shipping on its own line, refunds of that quarter taken off, and the orders behind each total. Goods count by country of delivery and digital products by the billing country. Sales to your own country stay apart, and so do orders that were charged no VAT.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your WooCommerce key in the portal, never in the chat.

Your request

With Hypamoon, after each quarter, total our WooCommerce orders to other EU countries per country and VAT rate: sales without VAT and the VAT, shipping on its own line, with that quarter's refunds taken off. Use the delivery country for goods and the billing country for digital products. Keep orders with no VAT apart and email me and my accountant the file.

You create the WooCommerce key yourself under WooCommerce, Settings, Advanced, REST API. It stays yours.

More for teams on WooCommerce