---
title: "Export WooCommerce Orders for Accounting (QuickBooks and Xero-Friendly CSV)"
url: "https://wpimportexport.com/export-woocommerce-orders-for-accounting/"
description: "Export a month of WooCommerce orders for your accountant: paid statuses only, subtotal, discount, shipping, tax and total per order, plus refunds."
type: post
published: 2026-11-08T15:00:40+00:00
modified: 2026-11-14T10:37:41+00:00
categories: ["Export Guides", "Tutorials", "WooCommerce"]
tags: ["Import Export by RockStarLab", "WooCommerce", "WordPress export"]
docs_topics: ["WooCommerce"]
---

# Export WooCommerce Orders for Accounting (QuickBooks and Xero-Friendly CSV)

At the end of every month your accountant asks for the same thing: the orders of the month with totals, tax, shipping and payment method, plus the refunds. WooCommerce can show orders on screen, but a usable file for QuickBooks, Xero or a spreadsheet takes some decisions: which orders count as sales, which date decides the month, and where refunds go. The setup below exports one row per order, filtered to a month, with a separate refunds file.

We tested it on a store with sales tax for California and Texas and a month of orders: card and PayPal payments, a bank transfer, a coupon, international orders, a partial refund and a full refund. We used [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) 2.1.25 with the **PRO** add-on 2.1.5, WooCommerce 11.2 and WordPress 7.1. Exporting WooCommerce orders and refunds is a PRO feature.

## Short Answer

1. Go to **Import Export → Export** and choose **WooCommerce Orders**.
2. Add three filters: **Order Date** greater or equal the first day of the month, **Order Date** less or equal the last day, and **Status** in `completed, processing, refunded`.
3. Pick the columns: order number, date, status, customer, country and state, payment method, transaction ID, currency, subtotal, discount, shipping, tax and total.
4. Export as CSV or XLSX.
5. Export **WooCommerce Refunds** for the same month into a second file.

## Decide What Counts as a Sale

WooCommerce orders have statuses, and not all of them are income:

- **Completed** and **Processing**: paid. Processing only means the order has not been shipped yet.
- **Refunded**: paid and then fully refunded. Keep it in the month it was sold, and record the refund in the month it was made.
- **On hold** (usually a bank transfer you have not received), **Pending payment**, **Cancelled** and **Failed**: no money arrived. Leave them out.

This is the usual cash view for a small shop. If your accountant works differently, for example with the date the payment arrived, use **Paid Date** instead of **Order Date** in the filters below.

## Step 1: Filter the Orders of the Month

Open **Import Export → Export**, choose **WooCommerce Orders** and click **Next Step**. Add the filters:

![Export Filter Data for WooCommerce Orders: Order Date greater or equal 01/10/2026, Order Date less or equal 31/10/2026, Status in completed, processing, refunded; total items available 7](https://wpimportexport.com/wp-content/uploads/2026/11/01-filter-october-statuses.webp)

_October orders with a paid status: 7 of 18._

- **Order Date**, **Greater or Equal**, 1 October 2026.
- **Order Date**, **Less or Equal**, 31 October 2026. Dates compare by day, so orders placed late on the 31st are included.
- **Status**, **In**, `completed, processing, refunded`, separated by commas.

The counter shows 7 orders. October also had a cancelled order and an unpaid check order, and there were orders on 28 September and 2 November; the filters left all four out.

## Step 2: Choose the Columns

On **Select Fields**, drag the columns into **Export File Structure** in the order your accountant wants them:

![Export Select Fields for WooCommerce Orders: Order Number, Order Date, Paid Date, Status, First Name, Last Name, Company, State, Country, Payment Method Title, Transaction ID, Currency, Subtotal, Discount, Shipping, Total Tax, Order Total](https://wpimportexport.com/wp-content/uploads/2026/11/02-select-accounting-columns.webp)

_The columns an accountant usually needs, one row per order._

- **Order Number**, **Order Date** and **Paid Date**.
- **Status**, so refunded orders are easy to spot.
- **First Name**, **Last Name**, **Company**, **State** and **Country** from the billing address. State and country decide the sales tax; companies often need an invoice name.
- **Payment Method Title** and **Transaction ID**, to match each order with the Stripe or PayPal payout.
- **Currency**, **Subtotal**, **Discount**, **Shipping**, **Total Tax** and **Order Total**.

Leave out customer IP addresses, user agents and order notes; your accountant does not need them.

## Step 3: Export and Check the Totals

Choose **CSV** (or **XLSX** for Excel), click **Start Export** and download the file. One row per order:

![October orders export as a table with order number, date, status, last name, state, country, payment method, transaction ID, subtotal, discount, shipping, total tax and total; sum row 379.00, 4.50, 60.00, 18.70, 453.20](https://wpimportexport.com/wp-content/uploads/2026/11/03-october-orders-csv-scaled.webp)

_The October export. Order total = subtotal − discount + shipping + tax._

How the amounts fit together:

- **order_subtotal** is the price of the items before the coupon. **order_discount** is the coupon: order 2051 had 10% off 45.00.
- **order_total** = subtotal − discount + shipping + total_tax. For the month: 379.00 − 4.50 + 60.00 + 18.70 = 453.20.
- **total_tax** includes tax on shipping. The German and British orders have no US sales tax, so their tax is 0.00.
- Amounts are plain numbers with the store’s decimals (41.00, 4.50), without currency symbols, so a spreadsheet can add them up.
- **transaction_id** is empty for the bank transfer: there is no gateway payment to link to.

Order 2056 was refunded in full on 3 November. It stays in the October file with status `refunded` and its original total, and the refund goes into November.

## Step 4: Export the Refunds

Refunds are separate records in WooCommerce, with their own date. Start a new export, choose **WooCommerce Refunds** and filter **Date Created** to the same month:

![Export Filter Data for WooCommerce Refunds: Date Created greater or equal 01/10/2026 and less or equal 31/10/2026; total items available 1](https://wpimportexport.com/wp-content/uploads/2026/11/04-filter-refunds-october.webp)

_Refunds made in October._

Choose **Parent Order Number**, **Date Created**, **Amount**, **Reason** and **Currency**:

![Refunds export: order 2052, 2026-10-27, amount 25.00, reason Wrong size, returned, USD](https://wpimportexport.com/wp-content/uploads/2026/11/05-october-refunds-csv.webp)

_One partial refund in October; the full refund of order 2056 belongs to November._

In October there was one partial refund: 25.00 of order 2052, a returned shirt. Its order stays “completed” because only part of it was refunded, which is why refunds need their own file: the orders export alone would not show this money going back.

## Sales Tax and VAT

- For a sales tax return, group the orders file by **billing_state** (or the shipping state, if your taxes are based on the shipping address) and add up **total_tax**.
- For VAT, add **billing_country** and the company name, and keep the VAT number if a plugin stores it with the order: add it with **Add Custom** as an order meta field.
- Tax rates and tax on shipping are set in **WooCommerce → Settings → Tax**. The export shows the amounts WooCommerce calculated; it does not recalculate them.

## Importing into QuickBooks or Xero

Both accept CSV files of sales, but their column names and required fields change between versions and plans. The usual way is to export with the columns above, then map them on the accounting side or rename the header row once in a spreadsheet and keep that file as a template. Many shops import only the monthly totals by payment method instead of each order; a pivot table on the export gives you those numbers in a minute.

If you use a dedicated integration that syncs orders automatically, the export is still useful as a monthly cross-check.

## Common Mistakes

- **Exporting all statuses.** Cancelled and pending orders were never paid. Filter by status.
- **Taking refunded orders out of the month they were sold.** Keep the sale in its month and record the refund when it happened.
- **Using the orders file alone.** Partial refunds do not change an order’s status. Export refunds too.
- **Mixing currencies.** If your shop sells in more than one currency, add **Currency** and total each currency separately.
- **Opening the CSV with the wrong regional settings.** In countries that write decimals with a comma, Excel may read 4.50 as text. Use XLSX or import the CSV with “.” as the decimal separator.

## FAQ

### Can I export one row per product instead of per order?

The order export has one row per order. The products of each order are in the **Order Items** column as a list, which is enough to check an order but not to total products. For sales by product, use WooCommerce Analytics.

### Which time zone are the dates in?

The site’s time zone from **Settings → General**, the same times you see on the Orders screen.

### Can I export only orders paid with PayPal?

Yes. Add a filter **Payment Method** equals the gateway ID, for example `ppcp-gateway`, or filter **Payment Method Title** contains `PayPal`.

### Do I need PRO?

Yes, WooCommerce orders and refunds are PRO exports.

## Related Guides

- [How to Import WooCommerce Orders from CSV](https://wpimportexport.com/import-woocommerce-orders-csv/)
- [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/)
- [How to Export WooCommerce Customers to CSV](https://wpimportexport.com/export-woocommerce-customers-csv/)
- [WordPress Export Data Filters: Examples and How to Use Them](https://wpimportexport.com/wordpress-export-data-filters-examples-how-to-use-them-effectively/)

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