Use Order Export & More for WooCommerce to filter WooCommerce orders by Completed status and a fixed weekly date range, then export the file as CSV for your finance report. This keeps unpaid, failed, cancelled, and processing orders out of your numbers. The plugin is listed in the official WordPress plugin directory, which makes it easy to install and review before use [source: WordPress.org].
TLDR: Install the plugin, open its export screen, set the order status to Completed, choose your start and end dates, and export a CSV. For example, a store with 240 weekly orders may find that only 198 are completed, so reporting all orders would overstate revenue by about 21%. Exporting only completed orders gives accounting a cleaner file for sales, tax, shipping, and payment checks. Do this every Monday for the prior Monday to Sunday period.
Why completed orders matter for weekly reports
Weekly financial reporting should not include every order in WooCommerce. Some orders are still waiting for payment. Some failed at checkout. Others were cancelled by the customer or the store team.
That is why the Completed status matters. In WooCommerce, completed normally means the order has been paid and fulfilled, depending on how the store is set up [source: WooCommerce]. For finance work, that status is usually much safer than exporting all orders.
Honestly, it feels like a small filter should be impossible to miss. Yet it is the exact thing that causes messy spreadsheets, inflated sales totals, and awkward Monday morning corrections.
Before you export
Set a repeatable rule first. This avoids arguments later.
- Date range: Use the same weekly period each time, such as Monday 00:00 through Sunday 23:59.
- Order status: Use only Completed.
- File type: CSV is best for Excel, Google Sheets, and accounting tools.
- Columns: Include order ID, date, customer name, subtotal, tax, shipping, discounts, total, payment method, and currency.
- Timezone: Use your store timezone, not the timezone of the person exporting the file.
If your store sells across borders, add currency and tax fields every time. Do not assume all orders use the same rates. That mistake is painful to fix after the file has been sent to finance.
How to export completed WooCommerce orders for a date range
-
Install the plugin.
In WordPress, go to Plugins > Add New. Search for Order Export & More for WooCommerce. Install it, then activate it. -
Open the export tool.
Go to the plugin’s export area in your WordPress admin. The exact menu name can vary by version, but it will be tied to order export settings. -
Select WooCommerce orders.
Choose orders as the export type. Do not export products, customers, or coupons for this report. Finance needs order rows. -
Filter by status.
Set the order status filter to Completed. This is the main control that removes pending, processing, failed, cancelled, and refunded-only records. -
Set the weekly date range.
Enter the start and end dates for the reporting week. Example: 2026-01-05 to 2026-01-11. Keep the format consistent each week. -
Choose the fields.
Include financial fields first. Order ID, order date, billing country, subtotal, tax, shipping, coupon discount, order total, and payment method should be near the front. -
Export as CSV.
Download the file. Name it clearly, such as completed-orders-2026-01-05-to-2026-01-11.csv.
What to check before sending the file
Do not send the file straight away. Spend two minutes checking it. It can save half an hour later.
- Row count: Compare the number of exported orders with the completed orders shown in WooCommerce for the same week.
- Totals: Sum the order total column and compare it with your sales report.
- Refunds: Check whether partially refunded completed orders need a separate adjustment.
- Coupons: Make sure discounts are shown as their own field if finance tracks gross and net sales.
- Tax: Confirm tax is not mixed into the subtotal column.
The annoying part is that one missing column can make the whole export less useful. If finance needs tax by country, add billing country now. If they reconcile payment deposits, add payment method now. Do not wait for the second email asking for “one more version.”
A simple weekly workflow
Use the same process every week. Consistency matters more than fancy formatting.
- Every Monday morning, export the prior Monday to Sunday range.
- Use Completed as the only order status.
- Save the CSV with the date range in the file name.
- Store the file in a shared finance folder.
- Send the same clean version to bookkeeping, tax, or management.
For a small store, this may take five minutes. For a busy store with hundreds of weekly orders, it prevents bad revenue numbers from reaching payroll, tax planning, or cash flow reports.
A clean weekly export is not complicated. It only needs the right plugin, the right status filter, and a date range that never changes from one report to the next.
