QuickBooks Online · Integration
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’s the most common ecommerce cleanup we see: 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.
Reference maintained by the Certified QuickBooks ProAdvisor team at TechBrot Inc., an independent firm — not Intuit, not Shopify, and not their official software support. Not affiliated with Intuit Inc. or Shopify Inc.
The Shopify–QuickBooks integration, in five questions.
What does a Shopify–QuickBooks Online integration do?
It uses a third-party connector app to sync your Shopify store’s activity into QuickBooks Online — orders become sales, and the connector records processing fees, refunds, and sales tax alongside them — so ecommerce activity posts to the books automatically instead of being keyed in by hand. Shopify is the ecommerce platform; QuickBooks is the accounting system; the connector is the bridge between them.
How do Shopify payouts work, and why does it matter for QuickBooks?
Shopify doesn’t deposit each order — it batches many orders into a payout and sends it to your bank net of fees. So the deposit you see is total sales minus processing fees, with refunds and adjustments folded in, spanning many orders. That’s why the number hitting your bank never equals the revenue you earned, and why how the payout is recorded decides whether the books are accurate.
What is the #1 mistake with the Shopify QuickBooks integration?
Recording a Shopify payout as one lump bank deposit. Because the payout is net of fees and covers many orders, a single deposit entry hides the gross sales, the processing fees, the refunds, and the sales tax inside it. Income ends up misstated and the bank account won’t reconcile — this is the most common ecommerce cleanup we see.
How should a Shopify payout be recorded in QuickBooks Online?
Break it out, don’t lump it. Record gross sales as income, processing fees as an expense, refunds as a reduction of income, and sales tax as a liability you owe — then reconcile the net payout against the deposit in your bank, not against the order total. A connector configured this way produces books that actually tie out.
Do I need a ProAdvisor to set up the Shopify integration?
Not always for a small, simple store — some owners connect a connector and review it themselves. A Certified ProAdvisor earns their fee on the account mapping, getting payouts to reconcile, multi-channel or multi-state sales tax, and untangling a file where payouts have been booked as lump deposits. We configure the connector and reconcile inside your own QuickBooks file; we don’t set Shopify’s or the connector’s pricing, and we can’t touch your Intuit or Shopify account.
What a Shopify–QuickBooks integration does
Shopify is an ecommerce platform: it runs your online store, processes orders, collects payments, and tracks the sales tax due. QuickBooks Online is where your accounting lives. A Shopify–QuickBooks integration is a third-party connector app that sits between the two and syncs your store’s activity into QuickBooks — so orders, processing fees, refunds, and sales tax post to the books automatically instead of being entered by hand.
That sounds simple, and the marketing makes it sound automatic, but the detail that decides whether the integration helps or hurts is how money actually moves. Shopify doesn’t deposit each order into your bank as it’s placed. It groups many orders into a payout and sends that payout to your bank net of fees — the deposit you see is the total sales minus Shopify’s processing fees, with refunds and adjustments folded in. So the number that hits your bank account is never the same as the revenue you earned, and it spans many orders, several fees, and possibly a refund or two.
A good integration accounts for all of that: gross sales recorded as income, processing fees recorded as an expense, refunds reducing income, and sales tax recorded as a liability you owe — with the net payout then reconciling against the deposit in your bank. We describe how the integration actually behaves and what it takes to keep it accurate — we don’t claim a connector does work it doesn’t, and we don’t set or quote Shopify’s or any connector’s pricing.
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. This is the #1 ecommerce cleanup we see — 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.
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.
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.
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.
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.
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.
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.
Want the Shopify connector set up right, or a payout mess cleared?
A Certified ProAdvisor reviews the file free, then configures the connector, maps sales, fees, refunds, and tax to the right accounts, and reconciles to Shopify payouts — a focused setup is typically a $1,200–$3,000 fixed-fee scope; cleanup runs $1,500–$15,000+ if payouts have been booked as lump deposits. Independent firm; we don’t set Shopify’s or the connector’s pricing.
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 Certified 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 Certified 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.
Free
file review first — we look before we scope
$1,200–$3,000
typical fixed-fee scope to configure the connector and mapping
Independent
Certified ProAdvisor firm — not Intuit, not Shopify, not their software support
What people ask about the Shopify–QuickBooks integration.
Is this Intuit’s official QuickBooks support?
How does the Shopify integration with QuickBooks Online work?
Why won’t my Shopify payouts match my sales in QuickBooks?
What is the most common Shopify QuickBooks bookkeeping mistake?
How should sales tax from Shopify be handled in QuickBooks?
Does the Shopify connector reconcile my QuickBooks account automatically?
How much does the Shopify QuickBooks integration cost?
Can you set up the Shopify integration in my QuickBooks Online file?
Want the Shopify connector set up right, or a payout mess untangled?
We configure the Shopify integration inside your own QuickBooks file.
Choosing and configuring the connector, mapping sales, fees, refunds, and tax to the right accounts, and reconciling to Shopify payouts is operational bookkeeping — the work an independent ProAdvisor firm does inside your books. Start with a free file review; a focused setup is typically a $1,200–$3,000 fixed-fee scope, and if payouts have been booked as lump deposits for months, a full cleanup runs $1,500–$15,000+. Written scope before any work begins. We don’t set Shopify’s or the connector’s pricing — those are billed by the vendors.