A VAT report for a shop that sells abroad needs the sales of the period split by the customer’s country, with net amounts and tax. WooCommerce’s own reports show totals, but not a file with one row per order that you can hand over or check. With Import Export by RockStarLab you export the paid orders of one month to Excel, and a short SUMIF table turns them into tax per country. The example is October in a coffee roastery’s shop that sells to Germany, France and the Netherlands. For the general monthly export to QuickBooks or Xero, see exporting WooCommerce orders for accounting.
PRO: WooCommerce order export needs Import Export PRO. Free: posts, pages, comments and media export.
Below is how to get the numbers out of WooCommerce. Which orders and amounts belong in your tax return is a question for your accountant or tax adviser.
Short Answer
- In Export, choose WooCommerce Orders.
- Add the filters Order Date Greater or Equal the first day, Order Date Less or Equal the last day, and Status In
completed, processing. - Add Order Number, Order Date, Status, Country, Currency, Subtotal, Shipping, Total Tax and Order Total, and export as XLSX.
Filter one month of paid orders
Add two Order Date filters, one Greater or Equal 1 October and one Less or Equal 31 October. The dates compare whole days, so an order placed at 22:50 on 31 October is included. Then add Status with the condition In and completed, processing, so cancelled, failed and refunded orders stay out:

Four of October’s five orders match; the fifth was cancelled. Use the statuses your accountant counts as sales; some count only completed orders.
Choose the columns
From the Basic, Dates, Amounts and Billing Address groups add Order Number, Order Date, Status, Country, Currency, Subtotal, Shipping, Total Tax and Order Total:

The billing country is the one WooCommerce uses for tax when the store calculates tax on the billing address, as ours does. If your store uses the shipping address, add the shipping Country instead. Tax Lines (Array) holds each rate’s name and percentage, but as JSON in one cell; Total Tax is easier to sum.
Export to Excel and total by country
Choose XLSX on the format step and export. Amounts in the file are numbers with two decimals, so Excel, Google Sheets and LibreOffice can add them. Next to the data, we added a small table with one row per country and these formulas:
Net =SUMIF(D:D, K2, F:F) + SUMIF(D:D, K2, G:G)
Tax =SUMIF(D:D, K2, H:H)
Gross =SUMIF(D:D, K2, I:I)
Column D is the country, F the subtotal, G the shipping, H the tax and I the order total; K2 holds the country code.

For October: Germany 138.00 net and 26.22 tax, France 69.00 and 13.80, the Netherlands 32.00 and 6.72, 46.74 tax in total. In each row, subtotal plus shipping plus tax equals the order total, a quick check that nothing is missing.
Refunds and other periods
A fully refunded order has the status Refunded and stays out of this export. Partial refunds are separate records; export them for the same dates with the WooCommerce Refunds export (see exporting WooCommerce refunds). For a quarter, set the dates to its first and last day.
Before you change anything
This export only reads orders. If you ever import corrected orders back into WooCommerce, back up the site first.
With an AI agent
An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) can check the period before you export:
How many paid orders (completed or processing) did we have in October 2026?
In our run, the agent called rsl-ie-pro/export-count for WooCommerce Orders with the two order_date filters and order_status in completed, processing, and answered 4. Without the status filter it found 5, including the cancelled order.
FAQ
Is this a VAT return?
No. It’s the order data your accountant needs to prepare one. They decide which amounts go where.
Can I export a quarter or a year?
Yes, change the two Order Date filters.
Can I use the paid date instead of the order date?
Yes, the filters also offer Paid Date and Completed Date.
Can I get a CSV instead?
Yes. Excel in some languages can read CSV numbers with a decimal point as text or dates, so XLSX is the safer choice for amounts.
Related Guides
- Export WooCommerce Orders for Accounting (QuickBooks and Xero-Friendly CSV)
- How to Export All WooCommerce Orders into CSV or Excel
- How to Export All WooCommerce Refunds to CSV or Excel
- Export WooCommerce Orders to CSV for a Shipping Tool
- ACF Fields for Custom Post Types and Excel-Ready Totals (What’s New in 2.1.45)
Get the free plugin on WordPress.org.

Comments 0
Have a question or a tip to share? Leave it below.