---
title: "Export WooCommerce Orders by Date Range for VAT and Tax Reports"
url: "https://wpimportexport.com/export-woocommerce-orders-date-range-vat-tax-report/"
description: "Export one month of paid WooCommerce orders with net, tax, total and country to Excel, and total the VAT per country with SUMIF for your accountant."
type: post
published: 2026-11-17T17:00:00+00:00
modified: 2026-11-14T10:45:35+00:00
categories: ["Export Guides", "Tutorials", "WooCommerce"]
tags: ["CSV Export", "Import Export by RockStarLab", "WooCommerce"]
docs_topics: ["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](https://wordpress.org/plugins/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](https://wpimportexport.com/export-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](https://wpimportexport.com/wp-content/uploads/2026/11/01-filters-8.webp)

_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](https://wpimportexport.com/wp-content/uploads/2026/11/02-columns-7.webp)

_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](https://wpimportexport.com/wp-content/uploads/2026/11/03-by-country.webp)

_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](https://wpimportexport.com/how-to-export-all-woocommerce-refunds-to-csv-or-excel/)). 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](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) first.

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) 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)](https://wpimportexport.com/export-woocommerce-orders-for-accounting/)
- [How to Export All WooCommerce Orders into CSV or Excel](https://wpimportexport.com/how-to-export-all-woocommerce-orders-into-csv-or-excel/)
- [How to Export All WooCommerce Refunds to CSV or Excel](https://wpimportexport.com/how-to-export-all-woocommerce-refunds-to-csv-or-excel/)
- [Export WooCommerce Orders to CSV for a Shipping Tool](https://wpimportexport.com/export-woocommerce-orders-shipping-csv/)
- [ACF Fields for Custom Post Types and Excel-Ready Totals (What’s New in 2.1.45)](https://wpimportexport.com/acf-custom-post-types-xlsx-totals-import-export-by-rockstarlab-2-1-45/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
