Shopify + QuickBooks Online integration: how it works & how to connect it well.
A Shopify–QuickBooks Online integration is a connector app that links your Shopify store to QuickBooks Online so ecommerce activity — orders, payouts, processing fees, refunds, and sales tax — flows into the books instead of being keyed in by hand. Done well, it keeps revenue, fees, and tax landing in the right accounts and tying out to your Shopify payouts. Done carelessly, it becomes an ecommerce cleanup: a payout booked as one lump deposit hides the sales, fees, refunds, and tax inside it, and the books stop reconciling. Below: what the integration does, how to connect it so it reconciles, and when a ProAdvisor should set it up for you. Independent firm, not affiliated with Shopify or Intuit Inc.
A Shopify–QuickBooks Online integration uses a connector app to sync your store’s activity into QuickBooks: orders become sales, and the connector records processing fees, refunds, and sales tax alongside them. The single most important thing to get right is how payouts are handled.
Shopify doesn’t deposit each order — it batches many orders into a payout and sends it to your bank net of fees. If that payout is recorded as one lump bank deposit, the sales, fees, refunds, and sales tax inside it disappear into a single number: income is misstated and the bank account won’t reconcile. The fix is to map sales, fees, refunds, and tax to the correct accounts and reconcile to the Shopify payout, not to the order total. We configure the connector and reconcile the result inside your own books. We don’t publish Shopify or connector pricing — those come from the vendors.
What a Shopify–QuickBooks integration does
The moving parts of the integration, in the order they matter — from the connector that links the two systems to the payout behavior that makes or breaks the books.
Part 01 · A connector app links Shopify to QuickBooks Online
Shopify is the ecommerce platform that runs your store; QuickBooks Online is where the accounting lives. A third-party connector app bridges the two, pulling your store’s activity into QuickBooks so you don’t re-key it. Different connectors handle the detail differently — how they break out sales, fees, and tax is exactly what determines whether the result reconciles. We don’t set or quote a connector’s pricing; that comes from the vendor.
Part 02 · Orders sync as sales, with fees, refunds, and tax
The connector turns Shopify orders into sales activity in QuickBooks and records the pieces that come with them — the payment-processing fees Shopify charges, refunds issued to customers, and the sales tax the store collected. Each of those needs its own home in the books: income for sales, an expense for fees, a contra to income for refunds, and a liability for the tax you owe.
Part 03 · Payouts arrive net of fees, across many orders
This is the part that catches everyone. Shopify doesn’t deposit each order — it batches many orders into a payout and sends it to your bank net of fees, with refunds and adjustments folded in. So a single bank deposit can represent dozens of orders, a stack of fees, and a refund or two. The deposit is never the revenue figure, and it never maps one-to-one to an order.
Part 04 · Sales tax is a liability, not income
The tax Shopify collects on a sale isn’t your money — it’s collected on behalf of the state and owed to it. In the books it belongs in a sales-tax liability account, not buried in income. A connector that doesn’t separate tax cleanly leaves you guessing what you actually owe at filing time, which is its own kind of mess on top of misstated revenue.
Part 05 · Reconciliation ties the payout to the bank deposit
The proof the integration is working is reconciliation: each Shopify payout should tie to the matching deposit in your bank, with the sales, fees, refunds, and tax inside it all accounted for. Reconcile to the payout, not to the order total — the order total and the deposit are different numbers by design, and chasing the order total is how reconciliations never close.
The trap · What sinks it: booking the payout as a lump deposit
The most common and most damaging mistake is recording a payout as one lump bank deposit. Because the payout is net of fees and spans many orders, a single deposit entry hides the gross sales, the fees, the refunds, and the sales tax inside it. Income is overstated or understated, fees vanish, tax owed is unclear, and the account won’t reconcile. That is what an ecommerce cleanup has to unwind — and it’s entirely avoidable with the right setup.
How to connect Shopify to QuickBooks well
Six steps, in order. The first set is configuration; the rest are the habits that keep the integration reconciling instead of quietly overstating or understating income.
- 1
Choose a connector that fits your store
Connectors differ in how they break out sales, fees, refunds, and tax and how they handle payouts. Pick one that records the detail rather than collapsing it, and that matches how your store actually operates — volume, sales channels, and the states you collect tax in. Pricing and capabilities come from the connector vendor; confirm it can map a payout to a bank deposit before you commit.
- 2
Map sales, fees, refunds, and tax to the right accounts
Before turning on the sync, set the account mapping deliberately: gross sales to an income account, Shopify processing fees to an expense, refunds as a reduction of income, and sales tax to a liability account — not lumped together. Getting the chart-of-accounts mapping right up front is what makes every later payout reconcile instead of needing to be unwound.
- 3
Configure payouts to reconcile, not lump
Set the connector so each Shopify payout records as its components — the sales, fees, refunds, and tax it contains — and lands as a net amount that matches the bank deposit. The goal is that the payout reconciles against the deposit in your bank. Never let a payout post as a single lump revenue figure; that is the exact mistake the whole setup exists to prevent.
- 4
Reconcile to the Shopify payout, not the order total
When you reconcile, tie each net payout to the matching bank deposit, not to the total of the orders. The order total and the deposit differ by fees and refunds by design, so reconciling to the order total never closes. Working payout-by-payout against the bank is what proves the ecommerce books are complete and correct.
- 5
Watch the first weeks closely, then spot-check
After go-live, review the first batches of synced activity carefully — confirm sales, fees, refunds, and tax are landing in the right accounts and that payouts reconcile cleanly. Once it’s behaving, keep spot-checking each period rather than assuming the sync is perfect; ecommerce volume means a mis-mapped category compounds fast if it goes unnoticed.
- 6
Reconcile every month against the statement
An integration that syncs is not the same as books that are reconciled. Each month, reconcile the bank account against the statement to confirm every payout is present, nothing is duplicated, fees and refunds are captured, and the balance ties. The connector makes the data current; the monthly reconciliation is the control that proves the ecommerce books are true.
When a ProAdvisor should help
Payouts booked as lump deposits
If Shopify payouts have been recorded as single lump bank deposits, income is misstated and the account won’t reconcile — the gross sales, fees, refunds, and tax are all hidden inside one number. Unwinding that history, restating each piece to the right account, and bringing reconciliation back into line is real cleanup work, and exactly where a ProAdvisor saves the most.
Account mapping and multi-state sales tax
Mapping sales, fees, refunds, and tax so the books actually reconcile takes judgment, and sales tax is its own knot — especially across multiple states or sales channels, where what you owe and where you owe it gets complicated fast. Getting the connector’s mapping and the tax treatment right from the start is far cheaper than correcting months of it later.
Volume, multiple channels, or a file that’s behind
High order volume, selling across more than one channel, or a QuickBooks file that’s already behind — unreconciled months, miscategorized history — all multiply the risk. At that point the connector isn’t the first thing to fix; the books are. That’s a free file review and a fixed-fee cleanup, after which the integration is configured properly so it stays reconciled.
A QuickBooks ProAdvisor configures the integration inside your own books.
Installing a connector takes a few clicks; making it produce books that reconcile is the real work. A QuickBooks ProAdvisor chooses a connector that fits how your store actually operates, maps gross sales, processing fees, refunds, and sales tax to the right accounts, and configures the sync so that each Shopify payout reconciles against the matching bank deposit — not the order total. Where a store has been booking payouts as lump deposits, we unwind the history, restate income, fees, refunds, and tax to the correct accounts, and bring reconciliation back into line — against a written scope, inside your own QuickBooks Online file. Independent firm — not Intuit, not Shopify, and not their software support; an Intuit account, a Shopify store setting, or a connector’s own billing stays with the vendor.
What people ask about the Shopify–QuickBooks integration.
How does the Shopify integration with QuickBooks Online work?
A third-party connector app links your Shopify store to QuickBooks Online and syncs orders, processing fees, refunds, and sales tax into the books. Orders record as sales, fees as an expense, refunds as a reduction of income, and tax as a liability — and each Shopify payout should reconcile against the matching bank deposit. The connector brings the data in; configuring the account mapping and payout handling correctly is what makes it accurate.
Why won’t my Shopify payouts match my sales in QuickBooks?
Because they’re not supposed to match the order total — Shopify pays out net of fees and batches many orders into one payout, with refunds and adjustments folded in. The deposit you see is sales minus fees, so it will never equal gross revenue. The fix is to break the payout into its parts — sales, fees, refunds, tax — and reconcile the net payout to the bank deposit, not to the order total.
What is the most common Shopify QuickBooks bookkeeping mistake?
Recording a Shopify payout as one lump bank deposit. Because the payout is net of fees and spans many orders, a single deposit entry hides the gross sales, the fees, the refunds, and the sales tax inside it — so income is misstated and the account won’t reconcile. It’s what an ecommerce cleanup has to unwind, and it’s avoided by mapping each piece to the right account and reconciling to the payout.
How should sales tax from Shopify be handled in QuickBooks?
As a liability, not income. The sales tax Shopify collects is owed to the state, not money you earned, so it belongs in a sales-tax liability account — kept separate from revenue. A connector that doesn’t break tax out cleanly leaves you unsure what you owe at filing time. Multi-state or multi-channel selling makes this more complex, which is a common reason owners bring in a ProAdvisor.
Does the Shopify connector reconcile my QuickBooks account automatically?
No. The connector syncs data; reconciliation is the separate monthly step that compares your QuickBooks register to the bank statement to confirm every payout is present, fees and refunds are captured, nothing is duplicated, and the balance ties. A connector can be syncing and the account can still be unreconciled — you reconcile each month, tying each net payout to the matching deposit.
How much does the Shopify QuickBooks integration cost?
We don’t set or quote Shopify’s or the connector app’s pricing — those are billed by the vendors, and you should check their current pricing directly. What we can quote is our work inside your books: a free file review first, then configuring the connector, mapping the accounts, and getting payouts to reconcile is one fixed fee, scoped in writing, or a bookkeeping cleanup ($1,200–$15,000+) if payouts have been booked as lump deposits and the books are behind.
Can you set up the Shopify integration in my QuickBooks Online file?
Yes — that’s operational work we do inside your own books: choosing and configuring a connector, mapping gross sales, processing fees, refunds, and sales tax to the right accounts, and setting payouts so each one reconciles against the bank deposit rather than posting as a lump sum. We start with a free file review, then a focused setup is one fixed fee, scoped in writing, or a bookkeeping cleanup ($1,200–$15,000+) if payouts have been mishandled. An Intuit or Shopify account issue stays with the vendor.