Back to blog
4 min read Export Guides

Export WooCommerce Orders by Date Range for VAT and Tax Reports

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

  1. In Export, choose WooCommerce Orders.
  2. Add the filters Order Date Greater or Equal the first day, Order Date Less or Equal the last day, and Status In completed, processing.
  3. 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:

WooCommerce Orders export filters: Order Date greater or equal 01/10/2026, Order Date less or equal 31/10/2026, Status in completed, processing; total items available 4
October's paid orders: two Order Date filters and a status filter.

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:

Export columns: Order Number, Order Date, Status, Country, Currency, Subtotal, Shipping, Total Tax and Order Total
Order, date, status, billing country and the amounts.

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.

The exported XLSX in a spreadsheet: four orders with subtotal, shipping, tax and total, and a summary by country: DE net 138.00 tax 26.22, FR 69.00 and 13.80, NL 32.00 and 6.72, total tax 46.74
The export with a SUMIF summary per country added in the spreadsheet.

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.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

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

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE