Back to blog
6 min read Export Guides

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

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