WooCommerce Orders in Google Sheets, Built for Accountants

Most WooCommerce store owners hand their accountant a CSV export on the first of the month. The CSV is missing the tax breakdown, mixes refunds with sales, and ignores subscription renewals entirely. The accountant then spends hours rebuilding the picture inside QuickBooks Online, Xero, or a spreadsheet of their own.

The friction stacks up fast. Currency columns are inconsistent. Refunds appear as negative line items mid-month but the original order sits in last month's export. Coupons get bundled into the subtotal. Subscription renewals from WooCommerce Subscriptions live in a totally separate report. By the time your bookkeeper has cleaned the data, half a workday is gone.

A live Google Sheet fixes this. Every completed order, refund, and renewal lands in the workbook the moment it happens. Your accountant opens the same file all month long and reconciles in minutes, not hours. The WooCommerce + Google Sheets integration we'll build below skips CSV exports completely.

Four WooCommerce events drive a clean accounting feed. If you only listen to one, you'll miss revenue. Wire up all four, and the workbook reconciles to the penny against your payment processor.

The first is woocommerce_order_status_completed. This fires when an order moves to completed and is the canonical revenue event. The second is woocommerce_order_status_refunded, which fires on full refunds. Partial refunds need woocommerce_order_partially_refunded, which we'll route to the same Refunds tab.

The third event is woocommerce_subscription_renewal_payment_complete, exposed by the WooCommerce Subscriptions plugin. Renewals create new orders behind the scenes, but they also update billing schedules, so the renewal hook is the cleanest signal. The fourth is woocommerce_created_customer, which captures new customer accounts for the Customers tab and helps your CPA cross-reference repeat buyers.

SheetLink Forms wraps these in three named hooks inside the WooCommerce Sync add-on: order_created, order_completed, and order_refunded. You bind each one to a tab in the workbook through the admin UI. Subscriptions and customer creation are toggled on the same screen, no code required.

Sales tax is where most accountant feeds fall apart. WooCommerce stores tax in two places: a flat order_tax total and a child set of tax line items, one per rate. A US store charging state plus county tax will have two tax lines per order. A UK store with reduced-rate VAT will have one or two as well.

For most stores, tax_total on the Orders tab is enough. Pair it with billing_country and billing_state, and your accountant can group by jurisdiction with a pivot table. This works for any store with a single tax rate per order, which is the majority of small WooCommerce shops.

If your store charges multi-line tax, like NYC's combined state and city rates, add a second tab called Tax Lines. Bind it to order_completed and write one row per tax line item with order_id, rate_label, rate_percent, and tax_amount. The Orders tab still shows the aggregate; the Tax Lines tab gives your CPA the breakdown for sales tax filings. Your bookkeeper can then run a SUMIF by jurisdiction at the end of each quarter without touching WooCommerce reports.

Refunds need their own row, not an edit to the original order. This is non-negotiable from an audit perspective. If your accountant ever needs to defend a sales tax filing, they need to show that the original revenue was recorded, then later reduced by a refund event with its own date and reason.

The order_refunded hook fires when a refund is processed. Route it to the Refunds tab with these fields: order_id, refund_date, refund_amount (always positive), refund_reason, refunded_by, and currency. Keep the amount positive in the sheet. Sign conventions cause more bookkeeping bugs than any other field.

For net revenue, use this formula in column 15 of the Orders tab:

=ARRAYFORMULA(IF(A2:A="",,J2:J - IFERROR(VLOOKUP(A2:A, Refunds!A:C, 3, FALSE), 0)))

Column J is order_total, Refunds!A:C is order_id through refund_amount on the Refunds tab. The result is a per-order net revenue figure that updates automatically when a refund lands. Your accountant can then SUM net_revenue for the period and tie it directly to your bank deposits, less processor fees.

The whole point is that your bookkeeper opens the workbook once and gets everything they need. Here's the typical month-end workflow with a live SheetLink-fed sheet.

1. Filter Orders by date. The accountant filters order_date to the month being closed. They scan the totals.
2. Pivot by currency. A pivot table groups order_total_base by currency, giving a single base-currency revenue figure.
3. Reconcile against Stripe or PayPal. Sum the order totals, subtract refunds from the Refunds tab, compare to the processor's monthly statement. Differences are usually chargebacks or processor fees.
4. Pull tax by jurisdiction. A pivot of tax_total by billing_state feeds the sales tax filing.
5. Export to QuickBooks or Xero. The Orders tab exports as CSV directly into QuickBooks Online's bank deposit screen, or into Xero's invoice import. Refunds become credit notes.

YTD totals live in a summary tab with =SUMIFS() formulas referencing the Orders and Refunds tabs. The accountant never has to ask you for an export again. For stores running multiple WooCommerce instances, the Integrations Bundle consolidates several stores into one workbook.

By December 31, the workbook is your tax-prep starting point. A few standing pivot tables turn the raw event log into the totals your accountant or filing software needs.

Build a Summary tab with these blocks:

• Revenue by month: pivot Orders on MONTH(order_date), sum order_total_base.
• Refunds by month: same pivot on Refunds tab. Net revenue = Revenue - Refunds.
• Sales tax collected by jurisdiction: pivot Orders on billing_state, sum tax_total. This is your sales tax liability by state.
• MRR by month: pivot Renewals on month, sum order_total. Add new-subscription revenue from Orders for true MRR.
• Top SKUs by revenue: pivot on product_skus, sum subtotal. Useful for inventory planning.

For the IRS Schedule C or the UK self-assessment, your accountant pulls a single number off the Summary tab. For sales tax filings (whether that's TaxJar, Avalara, or manual state portals), the jurisdiction pivot maps directly to the filing forms. No reformatting, no last-minute exports. The WooCommerce Sync add-on keeps the feed live all year, so the December workbook is just the January workbook with twelve months of data instead of one.