Skip to main content
Skip to content
Back to Ecommerce Accounting Hub

WooCommerce Accounting Guide

Master your WooCommerce bookkeeping: understand payment gateway fees, export order data, reconcile multiple gateways, and import everything into QuickBooks — free.

2.9% + $0.30 (WooPayments)Self-Hosted & Open SourceMulti-Gateway SupportFree QuickBooks Import

WooCommerce Fee Structure

WooCommerce itself is free, but you'll pay for payment processing, hosting, and plugins. Understanding the full cost stack is essential for accurate profit tracking.

Cost ItemRateDescription
WooPayments (US Cards)2.9% + $0.30Built-in payment processor powered by Stripe. No monthly fee. Competitive rates for US domestic transactions.
WooPayments (International)3.9% + $0.30Higher rate for international cards. Additional 1% currency conversion fee applies for non-USD transactions.
Stripe (Direct)2.9% + $0.30Popular third-party gateway. Same rate as WooPayments for standard processing. Offers advanced features like Radar fraud detection.
PayPal Standard2.99% + $0.49Widely trusted by shoppers. Higher per-transaction fee. Separate payout schedule from card-based gateways.
Hosting Costs$10–$300/moSelf-hosted infrastructure: shared hosting ($10–$30/mo), managed WooCommerce hosting ($30–$100/mo), or VPS/dedicated ($100–$300/mo).
Premium Plugins$0–$300/yr eachWooCommerce Subscriptions ($199/yr), advanced shipping, tax automation, and other premium extensions. Track as annual operating expenses.

Key takeaway: WooCommerce has no platform fee, but your total cost of ownership includes hosting, gateway fees, and premium plugins. For a typical store, expect to spend $50–$200/month on infrastructure before any transaction fees — factor this into your profitability calculations.

How to Export from WooCommerce

WooCommerce offers multiple export paths, from built-in CSV exports to powerful plugin-based solutions. Choose based on your store's complexity.

Built-in Orders Export

Native WooCommerce export from Orders → Export. Includes standard order fields, dates, totals, and payment methods. Quick and simple for basic accounting needs.

Best for: Simple stores with standard products and single payment gateway

WooCommerce Analytics

Advanced reporting with filters for revenue, orders, products, coupons, taxes, and downloads. Exportable to CSV. Provides aggregated views and trend data.

Best for: Stores that need summarized reporting and trend analysis alongside raw data

WP All Export Plugin

Powerful third-party plugin that exports any WordPress/WooCommerce data including custom fields, ACF data, and product attributes. Supports scheduled exports.

Best for: Complex stores with custom fields, subscriptions, or automated monthly exports

Orders Export (Built-in)

Standard order data with payment details

WP AdminWooCommerceOrders → Export
  1. 1.Log into your WordPress Admin panel
  2. 2.Navigate to WooCommerce → Orders
  3. 3.Filter by date range or order status if needed
  4. 4.Click Export and choose CSV format
  5. 5.Download the file — it includes all standard order fields

Analytics Export

Aggregated reports with filtering

WP AdminAnalyticsRevenue / Orders
  1. 1.Go to Analytics in the WP Admin sidebar
  2. 2.Choose Revenue, Orders, or Products
  3. 3.Set your date range and apply any filters
  4. 4.Click the Download icon to export as CSV
  5. 5.Use for summarized reporting and trend analysis

Pro tip: For QuickBooks import, the Orders Export with individual transaction lines works best. The Analytics Export provides summary data useful for dashboard reviews but lacks the per-order detail needed for bank reconciliation.

Common Accounting Challenges

WooCommerce's self-hosted, plugin-based architecture creates unique bookkeeping challenges. Here are the six that trip up most store owners.

1

Self-Hosted Data Ownership

Unlike marketplace platforms, all your data lives on your own server. This means you are responsible for backups, data integrity, and ensuring your export plugins produce accurate CSV files. Server migrations can break export functionality if not handled carefully.

2

Multiple Payment Gateway Reconciliation

Many WooCommerce stores accept payments via 2–3 gateways (WooPayments, PayPal, Stripe). Each gateway has its own fee structure, payout schedule, and bank deposits. Reconciling all of them against your QuickBooks records requires tracking each gateway independently.

3

Plugin Ecosystem Complexity

WooCommerce's power comes from its plugin ecosystem, but each plugin (subscriptions, bookings, memberships, bundles) creates different transaction types. Your bookkeeping must account for recurring revenue, deferred income, and complex order structures that plugins generate.

4

Hosting & Infrastructure Costs

Self-hosting means ongoing costs for servers, SSL, CDN, security plugins, backups, and developer maintenance. These costs don't exist on managed platforms like Shopify. Properly categorizing them as operating expenses in QuickBooks is essential for accurate profit tracking.

5

Tax Calculation Complexity

WooCommerce does not handle sales tax collection or remittance automatically. You need a tax plugin (TaxJar, Avalara) or manual tax rules. Incorrect configuration can lead to under-collecting or over-collecting sales tax, creating compliance issues.

6

Refund Processing Variance

Refund handling varies by payment gateway. Some gateways refund the transaction fee, others don't. WooPayments retains the original processing fee on refunds. PayPal may refund a portion. This inconsistency makes fee tracking difficult when processing refunds across multiple gateways.

Step-by-Step Workflow

Follow these six steps every month to keep your WooCommerce books clean and current.

1

Export Orders from WooCommerce

In WordPress admin, go to WooCommerce → Orders → Export for a basic CSV, or use WooCommerce Analytics → Orders for filtered exports. For custom fields, install WP All Export and configure your template.

2

Review the Raw Data

Open the CSV in a spreadsheet. Verify order totals, payment methods, and status fields. Check for refunds, partial payments, and gateway-specific fields. Cross-reference with your WooCommerce dashboard totals.

3

Convert to QuickBooks Format

Upload the CSV to the PrimeConnect WooCommerce-to-QB converter. The tool auto-detects WooCommerce column formats, separates gateway fees, and outputs a QuickBooks-ready file (CSV, IIF, or QBO).

4

Import into QuickBooks

For QuickBooks Online: Banking → Upload transactions. For Desktop: File → Utilities → Import → Web Connect (QBO) or IIF Import. Select the bank account that matches the payment gateway.

5

Categorize by Payment Gateway

Map transactions to income accounts. Create separate expense accounts for each gateway's processing fees (WooPayments Fees, PayPal Fees, Stripe Fees). Record refunds as contra-revenue with fee adjustments.

6

Reconcile Each Gateway with Bank

Match each payment gateway's payouts against the corresponding bank deposits. WooPayments and Stripe payout on rolling schedules; PayPal may hold funds. Reconcile each gateway independently for accuracy.

Importing to QuickBooks

Once you've converted your WooCommerce export, here's how to get it into QuickBooks.

QuickBooks Online

Best format: CSV or QBO

  1. 1.Go to Banking (or Transactions) in the left sidebar
  2. 2.Click Upload transactions (or Link account → Upload from file)
  3. 3.Select the converted CSV or QBO file from your computer
  4. 4.Map columns if prompted (date, description, amount)
  5. 5.Choose the target bank account and click Import

QuickBooks Desktop

Best format: IIF or QBO (Web Connect)

  1. 1.Go to File → Utilities → Import
  2. 2.Choose IIF Files or Web Connect Files (.QBO)
  3. 3.Select the converted file from your computer
  4. 4.Map to the appropriate bank account when prompted
  5. 5.Review the imported transactions and categorize as needed

Recommendation: For QuickBooks Online, QBO format provides the fastest import via the bank feed. For Desktop, IIF gives you the most control over account mappings and memos. CSV works universally across both platforms.

Tax Obligations

Like Shopify, WooCommerce is a platform, not a marketplace. Sales tax collection and remittance is entirely your responsibility as the store owner.

WT

WooCommerce Tax Settings

WooCommerce has built-in tax rate tables (WooCommerce → Settings → Tax), but they require manual configuration for each jurisdiction. For accurate, automated US sales tax, use a plugin like TaxJar or Avalara that calculates rates in real-time based on customer location.

NX

Economic Nexus

Unlike marketplace sellers, you must track your own economic nexus across states. Most states require registration once you exceed $100K in sales or 200 transactions. WooCommerce doesn't track this for you — use a tax plugin or manual tracking to monitor state-by-state thresholds.

FR

Filing & Remittance

You are fully responsible for filing and remitting sales tax to every state where you have nexus. Marketplace facilitator laws do NOT apply to your WooCommerce store. Consider TaxJar AutoFile or Avalara Returns to automate your state filings and avoid missed deadlines and penalties.

Disclaimer: This guide provides general information only and does not constitute tax advice. Tax laws vary by jurisdiction and change frequently. Consult a qualified tax professional for advice specific to your situation.

Best Practices

Eight tips from experienced WooCommerce store owners to keep your books accurate and audit-ready.

1

Create Per-Gateway Fee Accounts

Set up separate expense accounts in QuickBooks for each payment gateway's fees (WooPayments, Stripe, PayPal). This gives you clear visibility into which gateway costs you the most as a percentage of revenue.

2

Track Hosting as a Fixed Cost

Record your hosting, SSL, CDN, and maintenance costs as a monthly fixed operating expense. This ensures your WooCommerce profitability calculations include infrastructure — a cost that Shopify/Amazon sellers have built into their platform fees.

3

Standardize Your Export Template

Create a saved export template (using WP All Export or WooCommerce Analytics filters) that you run monthly. Consistent column formats prevent mapping errors when importing to QuickBooks.

4

Handle Subscriptions as Recurring Revenue

If using WooCommerce Subscriptions, set up a recurring income account in QuickBooks. For accrual-basis accounting, recognize revenue over the subscription period rather than when the payment is received.

5

Backup Before Every Export

Since WooCommerce is self-hosted, always run a database backup before major export or plugin update operations. A corrupted database can lose order data permanently — unlike managed platforms that handle backups for you.

6

Track Plugin Costs as Software Expenses

Premium WooCommerce plugins (Subscriptions, Bookings, Memberships) are annual operating expenses. Record each renewal in QuickBooks under a "Software Subscriptions" expense account for accurate overhead tracking.

7

Use Bank Rules for Gateway Payouts

Set up QuickBooks bank rules to auto-categorize payouts from each payment gateway. WooPayments, Stripe, and PayPal each have distinct payout naming patterns that can be matched automatically.

8

Reconcile Monthly, Not Quarterly

With multiple payment gateways and self-hosted data, reconciliation complexity compounds over time. Monthly reconciliation catches discrepancies early and prevents end-of-quarter accounting nightmares.

Related Tools

Put this guide into practice with these free tools.

WooCommerce to QuickBooks Converter

Convert WooCommerce order CSVs to QuickBooks-ready format instantly. Free, browser-based.

Use tool →

Multi-Channel Merge Tool

Combine exports from WooCommerce, Amazon, Shopify, and more into a single QuickBooks import file.

Use tool →

Ecommerce Analytics Dashboard

Compare fees, revenue, and trends across all your ecommerce platforms in one view.

Use tool →

Related Platform Guides

Running WooCommerce alongside other platforms? These guides cover accounting for channels commonly paired with self-hosted stores.

Shopify Accounting Guide

Shopify Payments fees, payout reconciliation, multi-currency handling, and QuickBooks import workflows for DTC stores.

Read guide

Stripe Accounting Guide

Fee structure, balance exports, gross vs net revenue recognition, and QuickBooks import workflows for Stripe.

Read guide

PayPal Accounting Guide

Fee structure, activity exports, holding reserves, Venmo for Business, and QuickBooks import workflows for PayPal.

Read guide

Frequently Asked Questions

Common questions about WooCommerce accounting and QuickBooks import.

How do I export orders from WooCommerce?
In your WordPress admin, go to WooCommerce → Orders and click the Export button to download a CSV of all orders. For more advanced exports with custom fields, use the free WP All Export plugin or WooCommerce Analytics → Orders → Export. The built-in export includes order date, status, totals, customer info, and payment method.
What payment gateway fees does WooCommerce charge?
WooCommerce itself charges no transaction fees — it is free, open-source software. However, your payment gateway charges processing fees: WooPayments (2.9% + $0.30 for US cards), Stripe (2.9% + $0.30), PayPal (2.99% + $0.49), or whatever gateway you choose. You may also have hosting costs ($10–$100+/mo) and premium plugin costs to factor in.
How do I reconcile multiple payment gateways?
If you accept payments via multiple gateways (e.g., WooPayments + PayPal), each gateway processes payouts independently on its own schedule. In QuickBooks, create a separate bank feed or clearing account for each gateway. Match each gateway's payout against the corresponding bank deposit. The order-level export from WooCommerce includes the payment method, so you can split transactions by gateway.
Does WooCommerce handle sales tax automatically?
WooCommerce has built-in tax calculation, but it is limited to basic rate tables. For accurate US sales tax with nexus tracking, most sellers use a tax automation plugin like TaxJar for WooCommerce, Avalara, or WooCommerce Tax (powered by Jetpack). Unlike marketplace facilitators, WooCommerce does NOT collect or remit tax for you — you must file and pay in each state.
How do I handle WooCommerce subscription revenue?
If you use WooCommerce Subscriptions, recurring payments are processed automatically on the renewal date. In QuickBooks, record each renewal payment as a separate income transaction. For accrual accounting, recognize the subscription revenue over the service period. Export renewal orders separately from one-time purchases for cleaner categorization.
What hosting costs should I track for WooCommerce?
WooCommerce is self-hosted, so you have infrastructure costs that marketplace sellers don't: web hosting ($10–$100+/mo), SSL certificate (often included), domain registration ($10–$20/yr), premium themes ($50–$200 one-time), premium plugins ($50–$300/yr each), and potentially managed WooCommerce hosting ($30–$300/mo). Track all of these as operating expenses in QuickBooks.
How do I export WooCommerce data with custom fields?
The built-in WooCommerce export handles standard order fields. For custom fields (custom product attributes, ACF fields, custom meta), use the WP All Export plugin. It lets you select any field, apply filters, and export to CSV or Excel. You can save export templates to re-run monthly for consistent QuickBooks imports.
Can I import WooCommerce data into QuickBooks for free?
Yes! PrimeConnect's WooCommerce-to-QuickBooks converter is 100% free and runs entirely in your browser. Export your orders CSV from WooCommerce, upload it to the converter, and download a QuickBooks-ready CSV, IIF, or QBO file. No data uploaded to any server.

Ready to Import Your WooCommerce Data?

Convert your WooCommerce orders CSV to a QuickBooks-ready file in under 60 seconds. Free, private, and entirely browser-based.

Convert WooCommerce to QuickBooks →View All Ecommerce Tools