Shopify QuickBooks Integration: Connect Shopify to QuickBooks Online, Sync Orders, Payouts and Fees

What a Shopify QuickBooks integration actually has to fix

Without an integration, Shopify reaches your books as a number that is not your revenue. Shopify deposits $3,914.22 on a Thursday, the bank feed shows $3,914.22, and it gets categorized as sales income. That figure is a batch of orders captured two or three days earlier, minus the 2.9% plus $0.30 taken on every card sale, minus refunds, minus any chargeback pulled back mid-cycle, plus or minus adjustments, and with sales tax you collected on behalf of a state sitting inside it as though it were yours.

Two things break. Reported sales come in understated by exactly the fee total, which is a deductible cost you paid and never claimed. And the ledger loses the ability to answer what a given month sold, because deposits are grouped by payout date and orders happen on their own dates. A 1099-K reports gross, so at year end the platform total and your books disagree by every dollar of fees.

An integration fixes this by posting the pieces separately: sales at gross, fees as an expense, sales tax to a liability account, refunds against revenue, and the deposit as a transfer that clears the balance. Everything below is about which route does that for you, and what each one costs.

Start with the first-party connector, and check which listing you install

Intuit publishes a Shopify connector that is included with a paid QuickBooks Online subscription. There is no separate app fee. It imports orders, refunds and Shopify Payments payouts, maps sales, taxes and fees to accounting categories, tracks inventory quantities and cost of goods sold as sales happen, and records B2B orders as invoices with matching customer and product records. At setup you can pull history from up to a year back, and automatic reconciliation covers up to 12 months.

Here is the part worth slowing down for. Search the Shopify App Store for QuickBooks and two listings come back, both named QuickBooks Online and both published under Intuit. In August 2026 the one subtitled "Sync your retail and B2B sales activity to QuickBooks" carries 4.7 stars across 3,216 reviews. The one subtitled "Sync products, orders and payouts to record sales and inventory" carries 2.1 stars across 63 reviews, where merchants describe payouts arriving incomplete, duplicate transactions, and sales data that quietly stops flowing. Same brand, same category, very different experience. Look at the review count before you click Install.

During setup you also choose whether transactions post automatically. Leave the automatic option off for the first few weeks. Everything then lands in a review queue where you confirm or exclude each item, which is how you catch a wrong account mapping before it is spread across three months of entries.

What the included connector will not do for you

Being honest about the limits is what makes the free-first advice usable rather than naive. Four of them matter.

It summarizes around Shopify Payments. Third-party guides consistently report that the summarized sales data the connector produces is built on Shopify Payments and Shop Pay activity. If a meaningful share of your orders is paid through PayPal, Klarna, Amazon Pay or another external gateway, those deposits arrive in the bank feed on their own schedule and you are reconciling them by hand. For a store where Shopify Payments handles nearly everything, this is a non-issue. For a store split across gateways, it is the whole problem.

It works at order level, not settlement level. Each order posts as its own transaction. A payout is a settlement covering many orders. Reconciling one bank line to dozens of entries is fine at 80 orders a month and painful at 800. That gap, not a missing feature, is the actual reason to buy A2X or Synder.

It does not manage inventory the way an inventory app does. Quantities and costs move as sales occur, which is enough for cost of goods sold. It is not a two-way stock sync between systems, and sellers expecting product records to be maintained in both directions are usually disappointed.

It is QuickBooks Online only. Desktop and Enterprise are covered in their own section below, and the price difference is large.

Shopify QuickBooks Desktop and Enterprise: the expensive answer

If you searched for a Shopify QuickBooks Desktop integration, the short version is that the first-party connector does not support Desktop and Intuit does not publish a direct route. What Intuit does publish is a Desktop e-commerce integration powered by Webgility, and that is the supported path. It requires at least QuickBooks Desktop Plus 2022 or Enterprise 22, and it posts every Shopify order, fee, payout and return individually with line-item detail.

The cost is the part nobody puts in the headline. Webgility Desktop starts at $139 a month, or $109 on annual billing, for 500 orders a month. QuickBooks Online sellers get a connector included at no extra cost. A Desktop store doing 400 orders a month pays at least $1,308 a year for the same job, before extra channels at $20 each per month or extra order blocks at $10 per 500.

That number is worth sitting with, because it changes the question. For many Desktop stores the cheapest fix is not a connector at all. It is either moving the books to QuickBooks Online, where the connector is included, or entering one summary journal per payout by hand. Our guide to Shopify QuickBooks Desktop integration prices all three routes side by side. A payout journal takes a few minutes: gross sales credited to revenue, fees debited to expense, sales tax credited to a liability account, refunds debited against revenue, and the net figure debited to the bank account so it matches the deposit exactly. At 100 orders a month that is roughly four journals and it costs nothing.

The clearing account method that makes any route reconcile to the penny

Whichever tool you pick, the entries that reconcile cleanly follow the same shape, and it is worth knowing because it also tells you when your integration has gone wrong.

Create a Shopify Clearing account in QuickBooks as a bank or current asset account. Orders post gross into clearing. Shopify fees post as an expense against clearing. Refunds and chargebacks reduce clearing. Then the payout that lands in your real bank account is recorded as a transfer from clearing, not as income. Done right, the clearing account returns to zero after each payout cycle, and any balance left behind is a real discrepancy you can go find.

Reconcile by payout date, never by order date. This is the single most common Shopify bookkeeping error. In the US, Shopify Payments settles a minimum of three business days from the business day after capture, so Thursday deposit money is Monday and Tuesday order money. Filter the balance transactions export by payout date and the batch ties out. Filter by transaction date and the totals never match, no matter how long you stare at them.

Shopify gives you the raw material for this. The payout reconciliation report lives under Finance, then Documents, and exports to PDF. The balance transactions export lives under Settings, Payments, View payouts, View Transactions, and carries transaction date, type, order number, payout status, payout date, amount, fee and net. Note that the CSV is emailed to you rather than downloaded in the browser, which surprises people the first time.

When paying for A2X, Synder or Webgility starts to make sense

The trigger is order volume, not a feature you are missing. Somewhere around a few hundred orders a month per channel, confirming order-level entries stops being a small weekly task and starts eating a real part of someone billable time. That is the point where a paid tool pays for itself, and it is different for every store.

A2X starts at US$29 a month and is priced per sales channel, so Shopify plus Etsy is two subscriptions. It produces summary entries matched to each payout, which is exactly the settlement-level view the included connector does not build. It works with both QuickBooks Online and Xero, and it was Xero 2025 US Small Business App of the Year.

Synder runs $65 a month for Basic, $115 for Essential and $275 for Pro on monthly billing, with roughly 20% off annually. Basic covers 500 synced transactions a month and two integration slots. QuickBooks Desktop support starts at the Essential tier, which is what that step up actually buys. Synder makes most sense when several gateways and marketplaces all need to land in one ledger.

Webgility is the one to look at if you are on Desktop or Enterprise, or if you need real inventory sync. QuickBooks Online plans start at $79 a month for 300 orders. All plans include three months of historical data, with a wider backfill charged at $200 one time.

None of these is a bad product. The mistake is buying one in month one, when the included connector would have carried the store for a year.

Where Earnly fits, and where it does not

Earnly is not an accounting ledger and will not replace QuickBooks. It sits earlier in the process, on the question of what actually arrived. Connect Shopify alongside Stripe, Etsy, Amazon, eBay, PayPal, YouTube, Patreon and the rest, and every payout shows on one board as gross, then fees, then take-home, with a calendar of expected deposit dates and a forecast that is always labeled an estimate. It is read only and never moves money.

That is useful next to QuickBooks in two ways. It gives you a per-platform gross and fee figure to check the connector against, which is how you notice a mapping that has drifted. And for sellers running several platforms it answers the multi-channel question that a single Shopify connector cannot: which channel is actually paying you, after fees, this month. Pricing is $12 a month for Solo, $32 for Creator and $79 for Studio.

If you want the wider picture first, our guide to ecommerce accounting software for multi-channel sellers covers how these pieces fit together, and Shopify accounting software compares the ledgers themselves rather than the connectors.