Quick answer: A QuickBooks integration connects your online store, booking system, CRM or payment processor to QuickBooks so that sales, customers, payments and fees flow into your accounts automatically instead of being typed in by hand. For common platforms like WooCommerce, Shopify, Stripe and PayPal, ready-made connector apps handle most needs. When your process is unusual, your data lives in a custom system or you need tighter control, a custom integration with the QuickBooks Online API is the better route. Agree the accounting rules with your bookkeeper before switching anything on.
Why connect QuickBooks at all
Many small businesses still copy sales into QuickBooks by hand. Someone exports orders from the website, opens a spreadsheet, and enters invoices or sales receipts one by one. It works at low volume, but:
- It takes hours every week
- Typing errors creep in
- Books are always behind, so cash flow reports are out of date
- Payment fees and refunds get missed
- Reconciling bank deposits against orders becomes painful
An integration moves that data automatically and consistently. Your bookkeeper spends time reviewing rather than typing, and you see up-to-date numbers.
QuickBooks Online vs QuickBooks Desktop
The version you use shapes your options.
- QuickBooks Online is cloud-based and has a modern REST API, published through the Intuit Developer platform. Most connector apps and custom integrations target it.
- QuickBooks Desktop runs on a local computer. Integrations usually go through the QuickBooks Web Connector or the desktop SDK, which is more limited and requires the computer to be on.
If you are planning a lot of automation and still use Desktop, it is worth discussing a move to Online with your accountant.
What data to sync
Decide what should flow, and in which direction, before choosing a tool.
Customers
Create or update customer records in QuickBooks from website orders or CRM contacts. Some businesses prefer a single generic “Web Customer” for small retail orders to keep the customer list clean, and full records only for trade or repeat customers.
Sales: invoices or sales receipts
- Sales receipts suit orders paid at the time of purchase, as in most online stores.
- Invoices suit orders paid later, such as trade accounts or services billed after delivery.
Products and services
Each order line needs to map to a product or service item in QuickBooks, so income lands in the right account. Matching SKUs on both sides makes this much easier.
Tax
Sales tax or VAT must be recorded correctly. Decide whether QuickBooks or your store calculates tax and make sure the integration does not double-count. Our guide to WooCommerce tax explains store-side tax settings.
Payments and fees
Payment processors deposit money in batches, minus fees. To reconcile your bank account, the integration should record the gross sale, the fee and the net deposit. This is one of the most common gaps in simple setups. Our article on payment gateway integration explains how processors handle payouts.
Refunds and discounts
Refunds should create refund receipts or credit memos. Discount codes and gift cards need clear accounts too.
Inventory
QuickBooks Online can track quantity on hand in some plans. If stock is managed elsewhere, such as in your store or an inventory system, choose one source of truth and sync in one direction only. Our inventory sync API guide covers that decision.
Integration options
Option 1: Native and ready-made connectors
Many platforms offer apps that connect to QuickBooks Online:
- Store plugins and apps for WooCommerce, Shopify and BigCommerce
- Built-in connections from payment processors and point of sale systems
- Integrations in CRMs, booking tools and field service software
Pros: quick to set up, no development, supported by the vendor. Cons: fixed mapping rules, monthly fees, and limited handling of edge cases such as partial refunds, multi-currency or bundles.
Try them on a test company file first. QuickBooks Online lets you create a sandbox through a developer account, and some connectors offer trial periods.
Option 2: General automation tools
Tools such as Zapier can create QuickBooks customers, invoices or sales receipts when something happens in another app, for example a new paid order or a signed proposal.
Pros: connects apps that have no direct integration, cheap for low volume. Cons: each step is simple, so complex tax, fee and refund logic becomes hard to manage, and errors can go unnoticed.
Option 3: Custom API integration
A developer connects your systems directly to the QuickBooks Online API. Access uses OAuth 2.0, so your system receives authorised tokens without storing your QuickBooks password. Our guide to OAuth explains how that works. Webhooks can notify your system when records change in QuickBooks.
Custom work makes sense when:
- You run a custom ordering system, portal or app
- You need specific mapping rules your bookkeeper insists on
- Volumes are high and you need logging, retries and alerts
- You want two-way sync with careful conflict rules
Pros: fits your process exactly, full control and visibility. Cons: upfront cost and ongoing maintenance as APIs change.
Our article on API integration covers the general approach.
Agree the rules with your bookkeeper first
The biggest risk with any QuickBooks integration is not technical. It is creating hundreds of records that do not match how your accountant wants the books kept. Before going live, agree:
- Invoices or sales receipts, and when each is used
- Which income accounts each product category maps to
- How tax is calculated and recorded
- How processor fees and payouts are recorded
- How refunds, chargebacks and discounts are handled
- Whether each order is synced individually or as a daily summary
- Which date is used: order date, payment date or shipping date
Daily summaries keep QuickBooks lighter for high-volume stores. Individual records give more detail. Your accountant should decide.
Testing and going live
- Use a sandbox or test company first, never your live books.
- Run real scenarios: a normal sale, a sale with a discount, a partial refund, a full refund, a sale with shipping, a tax-exempt customer.
- Reconcile a test payout to confirm gross, fees and net match.
- Pick a clean start date and decide what happens to historic orders. Importing old data is a separate decision.
- Monitor closely for the first few weeks. Check that totals in QuickBooks match your store’s reports.
Keeping the integration healthy
- Review a sync log or error report weekly
- Add new products to QuickBooks or the mapping when you launch them
- Recheck after changing tax settings, payment processors or store plugins
- Make sure the connection’s authorisation is renewed if it expires
- Keep a short document describing the mapping rules
FAQ
Can QuickBooks sync with WooCommerce?
Yes. Several connector plugins link WooCommerce with QuickBooks Online and Desktop. Choose one that handles your tax, fees and refund needs.
Should every order become a QuickBooks invoice?
Not necessarily. Paid-at-checkout orders usually suit sales receipts, and high-volume stores often post daily summaries. Ask your accountant.
Is a custom integration worth it?
When connectors cannot handle your process, or errors keep needing manual fixes, a custom integration often pays for itself in saved time and cleaner books.
Accurate books without the typing
A good QuickBooks integration saves hours, reduces errors and gives you up-to-date numbers to run the business. If you want help connecting your sales, payments and accounting, see how we help businesses automate the busywork.
