Tutorial

WooCommerce Orders in Google Sheets, Built for Accountants

Send each completed order and each refund from WooCommerce to a Google Sheet your accountant can open all month. Skip the month-end CSV scramble.

By Arden Talbot, founder of SheetLinkWPPublished 2026-04-22Updated 2026-11-126 min read
Diagram showing WooCommerce orders flowing into Google Sheets, with completed orders and refunds kept in separate sheets.

The Month-End CSV Problem

Most WooCommerce store owners hand their accountant a CSV export on the first of the month. It is a copy from one moment, refunds from this month sit next to orders from last month, and someone has to clean it before it can be used.

A live Google Sheet removes the export. Each completed order and each refund is written to the sheet when it happens, and your accountant opens the same file all month. The WooCommerce to Google Sheets integration below is how the rows get there.

The Columns Your Accountant Gets

Agree on the layout with whoever does your books before you switch anything on. WooCommerce Sync sends a fixed set of fields for an order, and these are the ones that matter for bookkeeping:

  1. order_id - the WooCommerce order number, used as the audit key.
  2. date_paid - when the order was paid, on the Order completed event. date_created is on Order created.
  3. status - the order's status when the row was written.
  4. total - the gross order total. It does not change after a refund.
  5. total_refunded - everything refunded on the order so far.
  6. net_total - the total less refunds, at the moment the row was written.
  7. currency - the three-letter code.
  8. email, first_name, last_name - the billing contact.
  9. billing_country - on Order created.
  10. items - all line items in one cell, as product names with quantities.

What is not there: subtotal, tax, shipping, discounts and coupons, payment method, and the state or region. For sales tax and payment-processor reconciliation your accountant still needs WooCommerce's own reports or the processor's statement. The sheet gives them orders, refunds and net figures without an export.

Which Events to Switch On

Three of the six events matter for the books.

Order completed is the revenue row: it is written when an order reaches the Completed status. Order refunded is written for every refund, partial or full, and carries the amount and the reason. Order created is written when an order is placed, paid or not; switch it on only if your accountant wants to see orders before they complete.

The other three, Customer created, Product created and Product updated, are for operations rather than accounts. Each event has its own card on the SheetLink → WooCommerce Sync screen, with its own switch.

One Sheet per Event

Do not mix events in one sheet. Each event has its own Receiver URL, so give Order completed and Order refunded a sheet each, with the SheetLink script deployed in both. A shared order_id column lets formulas join them.

Completed sheet

One row per completed order. This is the revenue sheet.

Refunds sheet

One row per refund, with order_id, refund_amount, refund_id, refund_reason, is_partial_refund, total_refunded, net_total, currency and date_modified. Refunds stay separate so the audit trail survives; the completed row is never changed.

The WooCommerce Sync docs cover the screen step by step.

Handling More Than One Currency

Every row carries currency and its totals are in that currency, exactly as the customer paid. Do not convert in place; keep the original figures for refunds and disputes.

Add calculated columns beside the data for a base-currency figure. =GOOGLEFINANCE("CURRENCY:"&currency&"USD", "close", date) returns the rate on a given date, where currency and date are the cells holding the row's currency code and payment date. Wrap it in IFERROR for weekends, when no rate is published, and fall back to the nearest business day.

How Refunds Flow Through the Sheets

A refund gets its own row. That is what an audit needs: the original revenue recorded once, then reduced by a dated refund with a reason.

Each refund row has refund_amount as a positive number, refund_reason, and is_partial_refund, which is 1 when the order has been refunded in part. It also has total_refunded and net_total for the whole order at that moment, so the latest refund row for an order already tells you what the order netted.

For a net figure beside each completed order, sum that order's refunds: =total - SUMIF(Refunds!order_id_column, order_id, Refunds!refund_amount_column), using the column letters in your own sheets. Summing refund_amount, rather than reading net_total, keeps the completed sheet right when an order is refunded more than once.

How the Accountant Uses the Sheets

A typical month-end with the two sheets:

  1. Filter completed orders by date. Filter date_paid to the month being closed.
  2. Total by currency. A pivot table on currency with the sum of total gives revenue per currency.
  3. Subtract refunds. Filter the refunds sheet to the same month and sum refund_amount. Refunds belong to the month they happened in, not the month of the original order.
  4. Compare with the payment processor. The difference between the sheet and the processor's statement is usually fees and disputes, which are not in the sheet.
  5. Take it into the accounting software. Download the sheet as CSV when the software needs a file.

Sales tax is the part this does not cover. The rows have no tax amount, so the tax filing still starts from WooCommerce's tax reports.

Customer Data in a Google Sheet

The sheets hold customer emails and names, so treat them like any other store of personal data: share them with the people who need them and nobody else, and say in your privacy policy that order data is kept in Google Sheets.

When a customer asks for deletion, the sheet rows have to be handled too. Removing the email and name while keeping the order number and amounts preserves the financial record your tax rules require. That is done in the sheet by hand; nothing in WooCommerce Sync reaches back to change a row it has written.

Year-End: Totals From the Event Rows

By the end of the year the two sheets are the starting point for the accounts. Build a summary tab with:

  • Revenue by month: a pivot of the completed sheet on the month of date_paid, summing total.
  • Refunds by month: the same on the refunds sheet, summing refund_amount. Net revenue is one minus the other.
  • Revenue by currency: the completed sheet pivoted on currency.

These are order-level totals. They include whatever tax and shipping the customer paid, because total is the gross figure and the parts are not sent separately. The WooCommerce Sync add-on page lists every field.

Frequently Asked Questions

Does this replace QuickBooks, Xero, or my accounting software?

No. The sheet is the feed your accountant works from. It replaces the manual CSV export, not the ledger.

Which order fields reach the sheet?

The order number, status, gross total, net total, amount refunded, currency, the billing email and name, the line items in one cell, and the payment or creation date. Refund rows add the refund amount, refund ID, reason and whether it was partial.

Is tax, shipping or the payment method in the sheet?

No. The rows have the gross total but not its parts: tax, shipping, discounts and payment method are not sent. Use WooCommerce's reports or the payment processor's statement for those.

How do partial refunds appear in the sheet?

As their own row, like a full refund. The row carries the amount of that refund, the running total refunded and a flag saying the order is only partly refunded. The completed order's row is not changed.

How are refunds tied to the original order?

Every refund row carries the order's order_id. A SUMIF on that column gives the refunds for one order, and the refund counts in the month it happened.

Are subscription renewals handled separately?

No. WooCommerce Sync has no subscription events. It writes rows for orders that are created, completed and refunded, and sends no subscription fields.

Can I push this data directly into QuickBooks Online?

Not from SheetLink. The sheet is the intermediary: your accountant reviews it and imports a CSV, or posts entries by hand.

What happens to the data if I close the store?

The Google Sheet is yours and stays in your Google Drive. SheetLink only writes to it.

Stream WooCommerce Orders Live to Sheets

WooCommerce Sync, part of the Pro tier ($79/yr or $199 lifetime), sends completed orders and refunds to a Google Sheet your accountant can reconcile.