---
title: "WooCommerce OSS report per EU country and rate · Hypamoon"
description: "Splitting WooCommerce sales per EU country and VAT rate each quarter? Get the totals per country and rate, refunds taken off, ready for your OSS return."
url: https://hypamoon.com/connect-to/woocommerce/oss-report
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [WooCommerce](https://hypamoon.com/connect-to/woocommerce)
3.  OSS report

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.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=woocommerce/oss-report)

## 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.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~woocommerce/oss-report&say=a%20quarterly%20WooCommerce%20file%20of%20sales%20and%20VAT%20per%20EU%20country%20and%20rate%2C%20refunds%20taken%20off%2C%20for%20our%20OSS%20return.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=woocommerce/oss-report)

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

## More for teams on WooCommerce

-   [**I want orders to show as shipped, with a tracking link for the customer.**](https://hypamoon.com/connect-to/woocommerce/shipped-orders)
-   [**Many of my customer emails ask where their order is, and I look each one up.**](https://hypamoon.com/connect-to/woocommerce/where-is-my-order)
-   [**The low stock email comes too late for a supplier with a four week lead time.**](https://hypamoon.com/connect-to/woocommerce/reorder-points)
-   [**When new stock arrives I edit every product in WooCommerce by hand.**](https://hypamoon.com/connect-to/woocommerce/stock-updates)
-   [**I want one page per customer with every order, the total and their favourite products.**](https://hypamoon.com/connect-to/woocommerce/customer-view)
-   [**I want to know my repeat purchase rate and my sales per country.**](https://hypamoon.com/connect-to/woocommerce/repeat-customers)
-   [**Business customers ask me for a proper PDF invoice of every order.**](https://hypamoon.com/connect-to/woocommerce/pdf-invoices)
-   [**Every month I export the orders and clean up the file for my bookkeeper.**](https://hypamoon.com/connect-to/woocommerce/order-export)
-   [**Our B2B customers email PDF purchase orders and we retype each one.**](https://hypamoon.com/connect-to/woocommerce/purchase-orders)
-   [**I want the sales of yesterday by email, without logging in.**](https://hypamoon.com/connect-to/woocommerce/sales-report-email)
-   [**I want to raise the prices of a whole category without opening every product.**](https://hypamoon.com/connect-to/woocommerce/price-changes)
-   [**I want to ask customers for a review a week after their order arrives.**](https://hypamoon.com/connect-to/woocommerce/review-requests)
-   [**I want to set a date for a product to go offline or back in stock.**](https://hypamoon.com/connect-to/woocommerce/scheduled-products)
-   [**Customers who first ordered as a guest don't see those orders in their account.**](https://hypamoon.com/connect-to/woocommerce/guest-orders)
-   [**A bot placed hundreds of fake orders overnight and I cleared them one by one.**](https://hypamoon.com/connect-to/woocommerce/card-testing)
-   [**We run two WooCommerce shops and I update the stock in both after every sale.**](https://hypamoon.com/connect-to/woocommerce/multi-store-stock)
-   [**Our shopping feed keeps refusing products because the GTIN field is empty.**](https://hypamoon.com/connect-to/woocommerce/product-data-check)
-   [**Our regular customers order the same every week and I type it in again each time.**](https://hypamoon.com/connect-to/woocommerce/standing-orders)
-   [**Every week I clean up the supplier's CSV before I can import it.**](https://hypamoon.com/connect-to/woocommerce/supplier-files)
-   [**I have to set the photo for each colour variation one by one.**](https://hypamoon.com/connect-to/woocommerce/variation-grid)
-   [**Before each class I build the attendee list from the orders and email everyone.**](https://hypamoon.com/connect-to/woocommerce/class-lists)
-   [**I want to tell customers their local pickup order is ready to collect.**](https://hypamoon.com/connect-to/woocommerce/pickup-ready)
-   [**I add up our sales per state in a spreadsheet to see where we are getting close to nexus.**](https://hypamoon.com/connect-to/woocommerce/sales-tax-by-state)
-   [**We have thousands of old coupon codes and no safe way to clear them.**](https://hypamoon.com/connect-to/woocommerce/coupon-cleanup)
-   [**I need 300 unique single-use discount codes for an event.**](https://hypamoon.com/connect-to/woocommerce/coupon-codes)
-   [**I copy each order to the supplier who ships it and wait for the tracking code.**](https://hypamoon.com/connect-to/woocommerce/supplier-orders)
-   [**When I sell one product, the stock of the other product should go down too.**](https://hypamoon.com/connect-to/woocommerce/shared-stock)
-   [**For each sale I have to look up what the lowest price was in the last 30 days.**](https://hypamoon.com/connect-to/woocommerce/lowest-price-check)
-   [**Every morning I compare the bank statement with the WooCommerce orders on hold.**](https://hypamoon.com/connect-to/woocommerce/bank-transfers)
-   [**I keep a spreadsheet of what each business customer owes us.**](https://hypamoon.com/connect-to/woocommerce/customer-statements)
-   [**Each month I work out in a spreadsheet what each consignor sold and what we owe them.**](https://hypamoon.com/connect-to/woocommerce/brand-statements)
-   [**Each month I work out the commission per influencer code by hand.**](https://hypamoon.com/connect-to/woocommerce/coupon-commissions)
-   [**Every day I copy the options and names from each order onto a production sheet.**](https://hypamoon.com/connect-to/woocommerce/production-list)
-   [**I open every order and write down what to pick.**](https://hypamoon.com/connect-to/woocommerce/pick-list)
-   [**When a backorder is delayed I email each waiting customer by hand.**](https://hypamoon.com/connect-to/woocommerce/backorder-updates)
-   [**I message every cash on delivery customer to confirm before I ship.**](https://hypamoon.com/connect-to/woocommerce/cash-on-delivery)
-   [**Our business customers want an e-invoice, so I retype each order in our accounting package.**](https://hypamoon.com/connect-to/woocommerce/e-invoices)
-   [**At the end of the year I make a donation statement for each donor from our WooCommerce orders.**](https://hypamoon.com/connect-to/woocommerce/donation-statements)
-   [**Our webhook was off for weeks before we noticed orders had stopped coming through.**](https://hypamoon.com/connect-to/woocommerce/store-health)
-   [**I track the open core charges in a spreadsheet and refund each one by hand.**](https://hypamoon.com/connect-to/woocommerce/deposit-returns)
-   [**Everything for WooCommerce**](https://hypamoon.com/connect-to/woocommerce)
