Connect Shopify and QuickBooks so the books actually match

The short answer

You can connect QuickBooks Online to Shopify with Intuit’s free Shopify connector, which syncs orders, payouts, fees and products, or with a third-party app that summarizes each Shopify payout into one clean entry. The right choice depends on order volume, how many sales channels you run, whether you track inventory in QuickBooks, and whether your CRM also needs customer and order data. Whatever you pick, set it up so every Shopify payout matches the deposit in your bank account.

Why the connection is harder than it looks

Shopify and QuickBooks count the same money differently. Shopify sees individual orders. Your bank sees payouts: one deposit that bundles many orders, minus processing fees, refunds and chargebacks. If you post every order as income and then also record the deposit, you double count. If you only record deposits, you lose the detail of sales tax, discounts and fees.

Good integrations solve this with a clearing account. Sales and fees post to the clearing account, and each payout moves the net amount into your bank. When the clearing account returns to zero for that payout, the books match.

A payout, worked through

Here is how one Shopify payout should land in QuickBooks when a clearing account is used. The numbers are illustrative.

1. Orders come in. Over two days the store sells $2,000 of products and collects $120 of shipping and $140 of sales tax. The integration records $2,000 to product sales, $120 to shipping income and $140 to sales tax payable, all against the clearing account.
2. Adjustments happen. One $100 order is refunded, and payment processing fees total $68. These post as a $100 refund and a $68 fee expense, both reducing the clearing account.
3. The payout arrives. Shopify deposits $2,092 to your bank. The integration records a transfer of $2,092 from the clearing account to your checking account.
4. The check. The clearing account for that payout is now zero, and the deposit matches the bank feed exactly. Your accountant matches the bank line to the transfer instead of creating new income.

If the clearing account doesn’t return to zero, something is missing: usually a refund, chargeback, reserve hold, gift card or currency conversion. Fix the mapping once, rather than adjusting by hand every week.

Your main options

Check pricing and features directly with each vendor, since plans change.

Summary or order-level: a decision rule

• Choose payout summaries if you sell mostly direct-to-consumer, have high order volume, manage inventory in Shopify, and your accountant mainly needs clean revenue, fees and tax by period.
• Choose order-level sync if you invoice wholesale customers, need customer records in QuickBooks for accounts receivable, or track inventory cost in QuickBooks.
• Consider a custom integration if you have several channels (Shopify plus Amazon, a B2B portal or a POS), a separate CRM, or rules the apps can’t express.

Whichever route you take, test it on a copy of real data first. Run two or three weeks of orders through the connection and reconcile them by hand before switching it on for good.

Ask your accountant before you choose. They will close the books with whatever you set up.

Setup checklist

1. Decide the source of truth for products, prices, inventory and customers. Only one system should own each.
2. Map your chart of accounts: product sales, shipping income, discounts, refunds, sales tax payable, merchant fees, gift cards and the clearing account.
3. Handle sales tax deliberately. Decide whether Shopify’s collected tax posts to a liability account, and confirm with your accountant how you file.
4. Pick a start date and don’t import years of history unless you need it. Intuit’s connector lets you go back up to a year.
5. Turn on review mode first so transactions wait for approval while you check a few payouts by hand.
6. Reconcile one full month against the bank and Shopify’s payout reports before you trust it.
7. Document the setup: which app, which accounts, who gets error alerts, and who fixes them.

Want a second opinion on your setup? Book a free 30-minute call. We’ll look at how Shopify, QuickBooks and your other systems connect today and tell you what we’d change first. No obligation. Book your call.

Bringing your CRM into the picture

Many growing stores also run a CRM or email platform such as HubSpot or Klaviyo. That’s where questions like “which customers bought twice and haven’t ordered in 90 days?” get answered. The accounting connection and the CRM connection are often set up separately, and that’s how data starts to disagree.

A few principles keep three systems in line:

• One customer ID carried across Shopify, the CRM and, if needed, QuickBooks.
• One direction per field. Order totals flow from Shopify; payment status flows from accounting; marketing preferences live in the CRM.
• Wholesale and retail kept apart where terms, pricing or tax treatment differ.
• Error alerts that reach a person. A silent sync failure is worse than no sync.

Problems to watch for

• Duplicate income from syncing orders and also recording deposits from the bank feed.
• Payouts that don’t match deposits because refunds, chargebacks or reserve holds weren’t mapped.
• Missing fees that make margins look better than they are.
• Sales tax posted as income instead of a liability.
• Inventory counts that drift because both systems try to own stock levels.
• Silent failures after an app update or expired connection. Check sync status weekly.
• Too many apps writing to QuickBooks at once, such as a Shopify connector, a payments app and a CRM, each creating its own customers and products. Decide which one is allowed to write, and turn off the rest.

When to move beyond an off-the-shelf app

Connector apps cover most single-store setups well. Signs you’ve outgrown one:

• Your bookkeeper makes the same manual correction every week.
• You sell on more than one channel and each has its own connector that doesn’t know about the others.
• Wholesale orders need net terms, customer-specific pricing or purchase order numbers that the app drops.
• Your CRM shows different lifetime value numbers than your accounting.
• You run more than one entity or currency.

A typical integration project starts with a short discovery: which systems, which data, who owns what, and where the errors happen today. Then a written field map, a build or configuration phase, a test month run alongside your current process, and documentation your team keeps. The goal is fewer moving parts, not more.

How JLB USA helps

JLB USA builds and supports e-commerce stores on Shopify, Shopify Plus, BigCommerce, WooCommerce and others, and we handle systems integration between storefronts, CRMs, accounting and ERP systems. That can mean configuring an off-the-shelf connector properly, connecting your CRM and email platform, or building a custom integration when apps can’t do the job. Where repetitive work remains, our automation team can take it off your staff’s plate.

We work with your accountant, not around them. If the store itself needs work, see our web design services. Not sure where to start? Book a free 30-minute call and we’ll tell you what we’d change first.

Related services

• Systems integration
• Automation and practical AI
• Web design and e-commerce