Shopify QuickBooks integration
Shopify QuickBooks integration that posts each sale to the right account
Who this is for, and who it is not for
This fits a Shopify or Shopify Plus merchant with at least one of these conditions: a bookkeeper re-keys Shopify sales into QuickBooks by hand, the payout that reaches the bank never matches the orders behind it, sales tax in QuickBooks disagrees with what Shopify charged, or sales also run through a second channel such as Amazon or a point-of-sale.
It does not fit a single-store merchant with standard sales, one currency and a bookkeeper who is content with a month-end summary entry. Intuit's connector or a settlement tool is the right answer there and nobody needs an agency. It also does not fit a team that wants a connector installed with no named owner for its errors, because an accounting feed nobody reviews is a ledger that drifts quietly.
What breaks between Shopify and QuickBooks
Six things decide whether the books match the bank. Each needs one owning system and an account to land in, named before any field is mapped.
Payouts versus orders
Shopify Payments pays out many orders at once, net of fees and refunds, so a bank deposit matches no single order. Intuit's connector holds each sale in Undeposited Funds and then records one deposit for the net payout, per its help article. Whatever tool you use, the payout is the unit you reconcile.
Fees
Payment processing fees come off the payout before it lands, so sales recorded at gross leave the deposit short by the fees. Intuit's connector records fees as expenses linked to the sale. Shopify subscription and app charges are a separate line: they usually arrive on the Shopify bill rather than inside a payout, and belong in their own expense account.
Refunds and chargebacks
A refund reduces the payout it falls in, which can be weeks after the sale, and needs a refund receipt or credit memo dated to that period. Chargebacks and their fees appear as payout adjustments. Partial refunds, exchanges and restocked items change both the ledger and the stock count, so the expected entry for each case is agreed in writing.
Sales tax
Shopify calculates tax at checkout. QuickBooks should record what Shopify charged rather than recalculate it, or rounding gaps appear. Intuit says its connector records the taxes Shopify collected automatically. Canadian merchants map GST, HST, PST and QST to separate tax codes, and US merchants map each state where they collect.
Multi-currency
When customers pay in their own currency, the sale is converted before it is paid out in the store's currency, so order totals and the deposit differ by the conversion. Intuit's help article does not describe multi-currency handling; Synder lists multi-currency on its Shopify App Store listing. Test a foreign-currency order before trusting any connector.
Cost of goods sold and inventory
Shopify knows what sold; QuickBooks needs what it cost, or the profit and loss shows sales with no cost against them. Intuit's connector can match Shopify products to QuickBooks items by SKU and name. A2X creates summarized cost of goods entries from uploaded SKU costs. Only one system should own the quantity on hand.
QuickBooks Online or QuickBooks Desktop: what connects to Shopify
Intuit's own Shopify connector works with QuickBooks Online and Intuit Enterprise Suite only. Its help article lists the QuickBooks Online plans it supports and says it is not compatible with QuickBooks Desktop. Desktop takes a different route.
Shopify's QuickBooks Desktop Connector app was built for merchants moving from QuickBooks Desktop Point of Sale to Shopify POS; Intuit discontinued Desktop POS on October 3, 2023, according to the Shopify Help Center. Shopify's setup guide says the connector has synced with QuickBooks Desktop accounting software once a day since November 7, 2023 (it was every five minutes before), in a summary mode or a detailed mode, that it is set up on the same computer as the Desktop install, and that the setup can be completed only once.
So for Desktop: a former Desktop POS merchant starts with Shopify's connector. An online store on Desktop picks a third-party connector that names QuickBooks Desktop on its listing, has one built on Intuit's QuickBooks Web Connector, or plans the move to QuickBooks Online, which every tool in the table below supports. Whichever route you take, run a full month of payouts through it before you stop the manual entries.
Shopify QuickBooks connectors compared: Intuit, A2X, Synder or custom
Table: four ways to connect Shopify to QuickBooks. Each vendor statement links to the vendor page it comes from (Vendor pages read October 2026). Plan prices change, so each row links the vendor's pricing instead of quoting it. The fit line is our delivery judgement.
Shopify Connector by QuickBooks (Intuit)
What it posts: each sale as a sales receipt with linked fee expenses, held in Undeposited Funds until one deposit records the net payout, per Intuit's help article. The Shopify App Store listing adds B2B orders as invoices, taxes, inventory and customers.
Works with: QuickBooks Online and Intuit Enterprise Suite, not QuickBooks Desktop. Imports up to one year of history.
Fits: one store, one currency, a bookkeeper who reviews the feed.
Cost: the listing says it is included with the QuickBooks subscription.
A2X
What it posts: summarized entries per Shopify payout, so each entry matches a bank deposit, and summarized cost of goods entries from uploaded SKU costs, per A2X's Shopify page.
Works with: QuickBooks Online, Xero and NetSuite.
Fits: high order volume, where the bookkeeper wants one entry per payout rather than thousands of receipts.
Cost: plan prices on A2X's pricing page.
Synder
What it posts: a daily summary or a detailed sync by transaction, with payouts auto-matched for reconciliation, per its Shopify App Store listing, which also lists multi-currency and cost of goods tracking.
Works with: QuickBooks, Xero, NetSuite and Sage Intacct.
Fits: several sales channels or gateways that should reconcile in one tool.
Cost: plan prices on the listing; cost of goods tracking sits on the higher plans.
Custom middleware
What it posts: what your chart of accounts needs: payout-level entries, tax by jurisdiction, landed cost, B2B terms, or several stores into one company file, with a reconciliation job and an exception view an operator can read.
Works with: QuickBooks Online through Intuit's API, or QuickBooks Desktop through the QuickBooks Web Connector.
Fits: rules no connector maps, or volume and audit needs a connector cannot show.
Cost: a build plus a named owner after launch, scoped on a call.
How to reconcile Shopify in QuickBooks, step by step
Reconcile by payout, not by order. Shopify Payments pays many orders out as one bank deposit, net of fees and refunds, so the payout is the only unit that matches the bank. These are the steps, in the order a bookkeeper runs them at month end.
- List the month's Shopify Payments payouts, with the orders, refunds, fees and adjustments inside each one.
- Check that every order and refund in each payout is in QuickBooks once, and only once. With Intuit's connector they sit in Undeposited Funds, which may read Payments to Deposit, until the payout arrives, per Intuit's help article.
- Check that each payout's fees are recorded as expenses in your merchant fees account, so sales stay at their gross amount.
- Group the sales, refunds and fees into one deposit whose total equals the net payout. Intuit's connector and A2X create this entry for you; by hand, you build it as a bank deposit in QuickBooks Online.
- Match that deposit to the bank feed line with the same amount and date.
- Explain every difference that is left. The usual causes are chargebacks, reserves, currency conversion, and payments through other gateways such as PayPal, which settle on their own schedule and need their own clearing account.
- Reconcile the bank account for the statement period, then read the Undeposited Funds balance: it should hold only sales paid out after the period closed, and nothing older.
- Compare sales tax payable in QuickBooks with Shopify's tax report for the same period before you file.
A month that reconciles this way is the test of any connector. If the Undeposited Funds balance keeps growing, or a payout never matches its deposit, the mapping is wrong somewhere, and the fix belongs in the mapping, not in a monthly adjusting entry.
Shopify Xero integration: the same rules, different tools
Shopify connects to Xero the same ways it connects to QuickBooks, and the reconciliation unit is still the payout. Xero offers its own Shopify integration by Xero, which Xero says is free on all Xero plans and posts daily summaries or individual Shopify sales for each payment gateway. Xero has partnered with Amaka, an integrations provider, for setup help. Xero also says the integration does not account for US sales tax, so US merchants take sales tax data from Shopify for reporting and filing.
A2X and Synder post to Xero as well as to QuickBooks, so a merchant who might change ledgers can keep one settlement tool. Choose Xero or QuickBooks for your accountant and your reporting, not for the Shopify connector: both ledgers have a native Shopify option and both are supported by the summarized-posting tools. The payout, fee, refund, tax and cost of goods rules on this page apply to Xero unchanged.
What we check first in a Shopify QuickBooks integration
Five checks come before any mapping, because they decide which row of the table applies.
The chart of accounts and tax codes
We read the live chart of accounts and the tax codes, then list every Shopify line type that has no account to land in: discounts, gift cards, shipping, tips, duties and fees.
The posting level
Per order or per payout. We confirm it against how the bookkeeper closes the month and how the bank deposit is built.
Recent payouts traced to orders
We trace a set of recent payouts, for example the last ten, back to their orders, fees and refunds, and compare each total with the bank deposit. The gaps show which line types the mapping must cover.
The owner of each record
Quantity, cost, customer, tax and refund each get one owning system, written down and agreed with the bookkeeper. Guest checkouts and duplicate customers are decided here too.
Who reads the errors
A named person sees a failed post, the reason and the affected order. Without that name the integration is not ready to launch.
What we run after a Shopify QuickBooks integration goes live
Go-live starts the work, because an integration is a running system. We run these checks and name who acts on each.
- A daily check that every Shopify order posted to QuickBooks exactly once.
- A payout reconciliation against the bank deposit, with differences listed by order.
- An exception view for failed posts, with the reason and the owner.
- A review whenever tax rates, the chart of accounts or a sales channel changes.
- A short written note each month: what failed, what it touched and what we changed.
What we can show, and what we cannot
We have no published client result for a QuickBooks integration yet, so this page names no client and claims no outcome. It carries the method instead: the reconciliation steps above, the five checks we run before any account is mapped, and the checks we keep running after go-live, each with a named owner. If you want to see that method on your own data, the first piece of work is tracing recent payouts back to their orders, fees and refunds.
Other systems and the wider integration scope
The integrations hub sets out how we choose between a native app, an iPaaS and a custom build for any system. Guides to the others we connect most often:
Common questions
Does Shopify integrate with QuickBooks?
Yes. Intuit publishes its own Shopify connector for QuickBooks Online, which its Shopify App Store listing says is included with the QuickBooks subscription, and it imports sales, refunds, fees and payouts. A2X, Synder, iPaaS platforms and custom builds are the alternatives. Use the native connector for one store in one currency, and move up when payouts stop matching deposits.
Does Shopify sync with QuickBooks?
Yes, once a connector app is installed. Intuit's connector imports new Shopify transactions into QuickBooks Online and can bring in history from up to one year back, per Intuit's help article. Shopify's QuickBooks Desktop Connector syncs once a day. Check what syncs, not only whether it syncs: fees, refunds, tax and payouts all need to arrive, or the books will not match the bank.
How do I connect Shopify and QuickBooks?
In QuickBooks Online, open Integrations, find the Shopify Connector by QuickBooks, select Get integration now and follow the prompts to connect your store, as Intuit's help article sets out. Before the first sync, choose the bank account for deposits, the expense account for fees and the tax settings, and decide how far back to import. On QuickBooks Desktop, use Shopify's QuickBooks Desktop Connector instead.
How do I sync Shopify and QuickBooks?
Choose the posting level first. Per-order sync creates a sales receipt for every order, which suits low volume and one currency. Summary sync posts one entry per day or per payout, which keeps the ledger readable at high volume and makes each entry match a bank deposit. Intuit's connector posts per order and groups each payout into a deposit; A2X posts per payout; Synder offers both.
How do I reconcile Shopify in QuickBooks?
Reconcile by payout, not by order. For each Shopify payout, confirm its orders, refunds and fees are in QuickBooks once, group them into one deposit equal to the net payout, and match that deposit to the bank feed. Then explain what is left, usually chargebacks, reserves or currency conversion, and check that Undeposited Funds holds only sales not yet paid out.
How do I record Shopify sales in QuickBooks Online?
Record each sale, or a daily or payout summary, as income with the sales tax Shopify charged, into a clearing account such as Undeposited Funds. Then record the payout as a deposit net of fees and refunds. Intuit's connector does this automatically with sales receipts and linked fee expenses. Recording only the payout as income understates revenue, hides fees and leaves your sales tax reports wrong.
How do I categorize Shopify fees in QuickBooks?
Put payment processing fees in an expense account such as merchant fees, recorded against the payout they came out of, so sales stay at gross. Intuit's connector records fees as expenses linked to each sale. Shopify subscription and app charges are a different expense, usually billed on the Shopify invoice rather than taken from a payout, so give them their own software subscriptions account.
How do I record Shopify sales in QuickBooks Desktop?
Use a connector that supports Desktop, or post one journal entry per payout by hand. Shopify's QuickBooks Desktop Connector syncs once a day in a summary or a detailed mode, per the Shopify Help Center, and is set up on the computer that runs QuickBooks Desktop. By hand, each entry carries gross sales, tax collected, refunds and fees, and lands in the bank at the net payout.
Does Shopify integrate with QuickBooks Desktop?
Yes, but not through Intuit's Shopify connector, which supports QuickBooks Online only. Shopify's QuickBooks Desktop Connector app links Shopify to QuickBooks Desktop accounting software and was built for merchants moving from QuickBooks Desktop Point of Sale to Shopify POS, according to the Shopify Help Center. Online stores on Desktop usually use a third-party connector or move to QuickBooks Online.
Is QuickBooks compatible with Shopify?
Yes. QuickBooks Online is compatible with Shopify through Intuit's own connector and through settlement tools such as A2X and Synder. QuickBooks Desktop is compatible through Shopify's QuickBooks Desktop Connector or a third-party app. Compatibility is the easy part. The work is mapping fees, refunds, tax and payouts so the books reconcile to the bank every month.
Shopify vs QuickBooks: which one do I need?
Both, because they do different jobs. Shopify runs the store: products, checkout, orders and payments. QuickBooks keeps the books: income, expenses, tax owed and the bank reconciliation your accountant works from. Shopify's reports show what sold, but they are not a general ledger. Most merchants run Shopify for selling and QuickBooks or Xero for accounting, joined by a connector.
Does Shopify integrate with Xero?
Yes. Xero offers its own Shopify integration by Xero, which Xero says is free on all Xero plans and posts daily summaries or individual sales for each payment gateway. Xero also says it does not account for US sales tax, so US merchants take tax data from Shopify for filing. A2X and Synder post to Xero too, and reconciliation works the same way: by payout.
Migration & Replatforming
Sales re-keyed by hand and payouts that never match cost more than the fix
Latest guides
Shopify & Ecommerce
Shopify SEO checklist: 13 checks and who owns each
A Shopify-specific SEO checklist: 13 checks from collection canonicals and variant URLs to app scripts, structured data and AI Overview readiness, each with how to check it, what good looks like and who owns it.
Shopify & Ecommerce
Shopify vs Wix: which one fits the store you run?
Wix caps a product at 1,000 variants and six options; Shopify allows 2,048 variants and three options. Wix suits service businesses and small catalogues. Shopify suits stores where inventory, wholesale or an ERP runs the business.
Shopify & Ecommerce
Shopify Plus pricing: what $2,300 a month really costs
Shopify Plus lists at $2,300 a month on a three year term, but the licence is the only line Shopify prices for you. Here is the total cost by stage, Advanced and Plus side by side, and the cases where Advanced is the better answer.
Shopify & Ecommerce
Shopify Plus examples: 10 stores and what to copy
Ten Shopify Plus stores, each confirmed as Plus on Shopify's own customer pages, read as teardown notes. For each one: what to study, why it matters, and whether you need Plus to copy it.
AI & Search
Generative engine optimization for Shopify: 5 page changes
GEO and AEO in plain words for a Shopify brand: what an AI answer needs from your product and collection pages, what we change, how you measure it, and what nobody can promise.
AI & Search
Vector database vs graph database for AI: how to choose
Compare vector and graph databases for RAG and AI applications. Choose based on retrieval questions, relationship checks, data ownership and evaluation.