What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/QuickBooks WooCommerce Integration
QuickBooks + WooCommerce

QuickBooks WooCommerce Integration: Pick a Connector, Then Check What It Books

The card payout in your bank says $2,821.13. WooCommerce says those three days of orders came to $3,001.40. The gap is fees, a refund from last week and sales tax, and how much of it your books explain depends on which connector you picked and how it's set up. Here are the two main routes, MyWorks' QuickBooks Sync and Intuit's free WooCommerce Connector, and the settings that decide whether the numbers tie.

How to connect WooCommerce to QuickBooks

MyWorks QuickBooks Sync installs as a plugin in your WordPress admin and links to a MyWorks account. It works with QuickBooks Online, Desktop and POS, and has a free Launch plan with paid plans above it.

Intuit's WooCommerce Connector is free with QuickBooks Online. Open Integration transactions, scroll to WooCommerce Connector and select Connect free integration, then approve the link to your store.

All apps Accounting Integration transactions Connect free integration

By hand: export orders from WooCommerce and enter a daily or monthly summary. It holds up at a few dozen orders a month and not much past that.

MyWorks QuickBooks Sync or Intuit's WooCommerce Connector

MyWorks

A plugin that lives in WordPress

  • Managed from your WordPress dashboard, next to WooCommerce itself.
  • QuickBooks Online, Desktop and POS.
  • Two-way sync of customers, orders, payments, products, inventory and pricing.
  • Lists bank deposit and transaction fee support.
  • Free Launch plan; higher order volumes need a paid MyWorks plan.
Intuit

A free connector run from QuickBooks

  • QuickBooks Online only. Formerly sold as OneSaas.
  • Orders post as invoices or sales receipts, depending on the order statuses you pick.
  • Refunds become credit memos only if you switch that on.
  • Products match on SKU, and stock can flow from QuickBooks back to WooCommerce.
  • Auto-sync runs hourly. Intuit's help says nothing about fees or payouts.

On QuickBooks Desktop, or if you need fees and deposits handled by the connector, MyWorks is built for that. On QuickBooks Online with tidy SKUs and one payment gateway, Intuit's free connector is a fair place to start. Neither one knows anything about your supplier bills.

Why the deposit never equals the orders

Each payment gateway pays out on its own schedule, net of its own fees, often with refunds from earlier orders netted in. A connector that records each order as paid in full leaves that gap for someone to explain.

Example card payout · three days of WooCommerce orders
Products sold (What an order sync records as sales) $2,640.00
Shipping charged + $185.00
Sales tax collected (Owed to the state, not income) + $176.40
Refund on an order from last week (Lands in this payout, not that order's) − $96.00
Card processing fees (Not on the order at all) − $84.27
Deposit in the bank $2,821.13

PayPal orders arrive in a separate payout with their own fees, so a store with two gateways has two of these to unpick. Booking each one through a clearing account, as in our Shopify payout guide, shows exactly what's unexplained.

Connected, and the books still don't tie

Stock levels wiped in WooCommerce

How you'll know: Products show out of stock on the site right after inventory sync is switched on.

Fix: Intuit warns that turning on its inventory option before stock is set up in QuickBooks can wipe WooCommerce stock levels. Enter quantities in QuickBooks first, check a few products, then switch it on. Our WooCommerce inventory page covers the stock side.

Orders landing on the wrong product, or duplicates appearing

How you'll know: New items called the same thing appear in QuickBooks, or sales pile onto one generic product.

Fix: Matching runs on SKU, so every product and every variation needs its own unique SKU in WooCommerce, the same one used in QuickBooks.

Refunds never reach QuickBooks

How you'll know: Revenue in QuickBooks runs higher than WooCommerce's own sales report.

Fix: In Intuit's connector, turn on credit memos and select both the Refunded and Partially Refunded statuses. In MyWorks, check how refunds are set to sync before trusting a month's numbers.

Sales tax that doesn't match the WooCommerce report

How you'll know: The QuickBooks sales tax liability is off from what WooCommerce says you collected.

Fix: Every WooCommerce tax rate has to be mapped to a QuickBooks tax code, including rates added after setup. An unmapped rate is the usual cause.

Margins that look too good

How you'll know: Gross profit on the P&L is far above what the store really makes.

Fix: Intuit's connector doesn't send product cost, so cost of goods sold depends on the cost set on each inventory item in QuickBooks. Fill those in, or margins are fiction.

Deposits short of sales every time

How you'll know: Each bank deposit is lower than the orders around it, by an amount nobody books.

Fix: Gateway fees and netted refunds, as in the example above. Book each payout through a clearing account and reconcile from there, or have the matching done for you.

Sales were syncing fine. Supplier bills weren't.

WooCommerce store · sales already flowing into QuickBooks through a plugin

Before

Orders reached QuickBooks without anyone touching them. The slow part was money going out: supplier invoices arrived in a shared inbox, and someone opened each one and typed it into QuickBooks as a bill, days later, when they remembered.

After

A watcher on that inbox now reads each vendor invoice, picks out the vendor, amount and due date, and creates the QuickBooks bill with the original attached.

The sales sync carried on exactly as before. Supplier bills stopped being anyone's job.

Questions people ask

Does WooCommerce integrate with QuickBooks?

Yes, two main ways. MyWorks' QuickBooks Sync is a plugin you install in WordPress, and it works with QuickBooks Online, Desktop and POS. Intuit's WooCommerce Connector is free and set up from inside QuickBooks Online. Both sync orders, customers and products; check how each handles fees, refunds and tax before relying on it.

What is MyWorks Sync?

MyWorks Software's QuickBooks Sync for WooCommerce, sold on WooCommerce.com. It's a WordPress plugin plus a MyWorks account, and it syncs customers, orders, payments, products, inventory and pricing between WooCommerce and QuickBooks Online, Desktop or POS. There's a free Launch plan, with paid plans for bigger stores. Like any order sync, it covers the sales side, not what you owe suppliers.

Is there a WooCommerce connector by Intuit?

Yes. Intuit's WooCommerce Connector, which used to be sold as OneSaas, is free with a QuickBooks Online subscription. You find it under Integration transactions in QuickBooks. It doesn't connect to QuickBooks Desktop.

Can WooCommerce send vendor bills to QuickBooks automatically?

Not through a standard WooCommerce sync plugin. WooCommerce has no record of what you pay suppliers, so there's nothing for a plugin to send. Vendor bills need their own automation, built around wherever the invoices arrive, usually an inbox or a supplier portal. That's the piece n-frames built in the story above, and it runs alongside the sales sync rather than replacing it.

Does it matter that WooCommerce runs on WordPress?

Somewhat. Your store lives on your own WordPress hosting, so the sync depends on that site being up and reachable. Intuit's help lists minimum versions of WooCommerce 3.5 and WordPress 4.4. With MyWorks, the plugin is updated like any other, so test it on a staging copy before big WordPress or WooCommerce updates.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.