MVPMost Valued Partner
Home/Software we connect/Shopify and QuickBooks Online

Connect Shopify to QuickBooks Online, and keep the books matching

Intuit makes a free Shopify connector for QuickBooks Online that brings in orders, fees, refunds, and payouts. We set up the accounts behind it, handle what it does not cover yet, and check every morning that each payout matches the bank.

From $525 per connection, then $99/mo to keep it checked. Facts checked November 2026.

  1. Shopify QuickBooks OnlineA paid order arrives as Payment received and becomes a sales receipt plus a fee expense
  2. Shopify QuickBooks OnlineSales tax goes onto the sales receipt and gift card sales go to a liability account
  3. Shopify QuickBooks OnlineA refund arrives as its own transaction
  4. Shopify QuickBooks OnlineThe payout becomes one deposit that you match to the bank feed
  5. QuickBooks Online ShopifyNothing flows back yet, so a stock change made in QuickBooks needs a script or a manual update in Shopify
Checked each morning6:00 am, all clear

What the official connection does.

Yes, there is an official connector. Intuit builds and supports it: it is called Shopify Connector by QuickBooks in Intuit's help center and is listed in the Shopify App Store as QuickBooks Online by Intuit Inc. The listing is free to install, and Intuit's help article lists it for QuickBooks Online Simple Start, Essentials, Plus, and Advanced. It replaced Intuit's older QuickBooks Connector, and Intuit publishes a migration guide for stores still on the old one.

What it moves

  • Each paid order comes in as a Payment received transaction. Once confirmed, it becomes a sales receipt for the sale and an expense for the fees.
  • B2B orders come in as invoices linked to the company, with their payments attached
  • Refunds come in as separate transactions with the amount, tax, and products
  • Shopify fees, selling commission, and payment processing fees post to the fees account you pick
  • Each payout becomes a deposit in your deposit account, ready to match in Bank transactions
  • Sales tax is recorded on the sales receipt, and gift card sales go to a gift card liability account
  • With Product Tracking on, products are matched to QuickBooks items by SKU and name

What it leaves to you

  • No two-way inventory sync yet. Intuit's migration guide says you have to update stock in both QuickBooks and your store.
  • Orders cannot be imported as unpaid, and transactions import one by one. There is no single summary entry per payout.
  • The sync runs every few hours, according to Intuit, with a Sync now option for an immediate run.
  • History is limited to 12 months back from when you connect.
  • Products with no match are not created for you. They wait under For Review, and transactions do not reach your reports until they are confirmed, unless you turn on automatic adding.
  • Users report trouble in the Shopify App Store reviews, describing missing payout data and duplicate entries. Read the current reviews before relying on it.

What we add on top.

Official integration where it does the job, a custom script built in your own accounts where it doesn't, and a check every morning either way.

The accounts behind the connector

We choose the deposit, payments, fees, gift card, and sales tax accounts with your bookkeeper before the first import, and pick a start date that does not overlap anything already in your books. Intuit warns about that overlap in its migration guide, and it is an easy way to end up with duplicates.

SKUs that match on both sides

We line up Shopify SKUs with QuickBooks items so sales post to the right products. That keeps them out of the For Review queue and off the default Shopify Sales Item.

A payout tie-out every morning

We check each Shopify payout against the QuickBooks deposit and the bank line: sales, less refunds, less fees, equals the amount that landed. When one does not tie, we tell you which order or fee is the difference.

Scripts for what the connector leaves out

Where you need something the connector does not do yet, such as stock counts kept in step or a payout summary for your accountant, we build a script inside your own Shopify and QuickBooks accounts. We also check the For Review queue on a schedule, so nothing sits unconfirmed at month end.

Where it breaks

The four problems we see most.

The payout gets entered twice

The connector creates the deposit, then someone adds the same bank line as new income when it should have been matched. Intuit's help article says to match the deposit in Bank transactions for exactly this reason.

A reconnect overlaps old data

The app is disconnected and reconnected, or a store moves from the old connector, with a start date that overlaps orders already in the books. Those orders can then be in QuickBooks twice.

The For Review queue piles up

Transactions wait for someone to confirm them and nobody owns that job. Sales are missing from reports, and money sits in Undeposited Funds with no deposit to clear it.

Inventory drifts apart

Shopify sells the stock, but counts adjusted in QuickBooks never reach the store. Because inventory does not sync both ways yet, the two numbers separate a little more every week.

Morning check, TuesdayAn example of the report a client gets each day
  1. Shopify to QuickBooks Online: yesterday's records comparedOK
  2. The payout gets entered twice: 1 foundFlagged
  3. Totals match on both sidesOK
  4. Sync log: no errors overnightOK
One item needs a look. Your office manager already has the details.

Example of how the morning check catches it.

Questions about Shopify and QuickBooks Online.

Is the QuickBooks Online app for Shopify free?

The Shopify App Store listing shows it as free to install and notes that Intuit may bill external charges separately from your Shopify invoice. Intuit's help article lists the connector for Simple Start, Essentials, Plus, and Advanced. You still need a QuickBooks Online subscription.

Does it post every order or a daily summary?

Every order. Intuit's documentation says transactions import individually and that there is no summary sales receipt per payout. If your accountant prefers summaries, we can build that as a script, or you can look at a third-party connector.

Does it sync inventory between Shopify and QuickBooks?

It matches products sold in Shopify to QuickBooks items when Product Tracking is on. Intuit's migration guide says the new connectors do not yet offer two-way inventory sync, so stock changes have to be made in both places or handled by a script.

How far back can it import my Shopify orders?

Up to 12 months before the date you connect. Pick a start date that does not overlap orders already entered in QuickBooks, and plan another way to bring in anything older.

Sources, checked November 2026
  1. Intuit help: Connect Shopify to QuickBooks Online
  2. Intuit help: Migrate to the new QuickBooks Online e-commerce connectors
  3. Intuit: Shopify connector overview
  4. Shopify App Store: QuickBooks Online by Intuit Inc. (listing and reviews)

Start with a free systems check.

Twenty minutes on a call. You get a written list of what we found and a fixed quote, whether or not you hire us.

  • Fixed price, quoted before any work starts
  • Every account stays in your name
  • Month to month after the first three months

We reply within one business day. No sales calls, no mailing list.