A Shopify store produces a lot of small financial events: orders, partial refunds, shipping charges, gift cards, sales tax in several states, processing fees and a payout that lands in the bank as one net number. QuickBooks Online is where most small and mid-sized merchants close their books. Getting the two to agree is the whole point of a Shopify QuickBooks integration, and it is harder than switching on an app, because the bank deposit never equals the sum of the orders behind it.
This guide is for store owners, bookkeepers and finance leads who want to connect Shopify to QuickBooks Online and keep the numbers reconciled. It covers what data the integration moves and in which direction, the three ways to connect (Intuit's own connector, third-party apps and a custom build), the setup steps for the most common path, the problems teams run into with payouts, fees, taxes and inventory, what the options cost, and when a custom integration is worth it.
What a Shopify QuickBooks Integration Syncs
The data objects are similar across connectors. What differs is how much detail each one sends and whether it posts every order or a summary.
| Data | Direction | How it usually lands in QuickBooks Online |
| Orders | Shopify to QuickBooks | Invoices or sales receipts, per order or as a daily summary |
| Customers | Shopify to QuickBooks | Customer records, or one generic customer for summarized sales |
| Products | Shopify to QuickBooks | Items matched by name or SKU, or created from new Shopify products |
| Taxes | Shopify to QuickBooks | Each Shopify tax mapped to a QuickBooks tax code |
| Shipping, discounts, gift cards | Shopify to QuickBooks | Separate line items or accounts |
| Refunds | Shopify to QuickBooks | Credit memos for refunded and partially refunded orders |
| Fees | Shopify to QuickBooks | Expenses (Intuit's connector records them as bills) |
| Payouts | Shopify to QuickBooks | Deposits into a bank or clearing account |
| Stock levels | QuickBooks to Shopify | Quantities pushed to a chosen Shopify location |
Intuit describes its Shopify connector as bringing in sales, taxes, fees and shipping details "with the correct categorization", along with payouts and product details. It also brings in Shopify B2B orders as invoices, with customer details, products and payment terms, and it matches products to inventory in QuickBooks so quantities and costs stay aligned.
Two points shape every design decision.
The payout is a net figure. Shopify transfers funds from Shopify Payments to the merchant's payout bank account. Shopify's own API describes each payout with a net amount and a summary that breaks down fees and gross amounts by transaction type, such as charges, refunds and adjustments. A payout only contains the balance transactions that were available when it was issued, so one deposit can cover orders from several days, minus refunds and fees.
Orders and payouts describe the same money twice. If an integration posts every order as income and also posts every payout as income, revenue is counted twice. Intuit's own setup guide warns about exactly this, which is why the choice between an order based and a payout based approach comes first.
Integration Options
There are three practical ways to connect Shopify and QuickBooks Online.
Intuit's Shopify connector. Intuit lists a Shopify connector as included with QuickBooks Online subscriptions. It is set up from inside QuickBooks, syncs on a schedule and offers separate workflows for orders, payments, refunds, fees, payouts, new products and stock levels. Intuit says it can automatically reconcile up to 12 months of sales history.
Third-party connector apps. Several apps on the Shopify App Store and accounting app marketplaces specialize in this pair. Two examples whose own pages describe Shopify plus QuickBooks support:
- QuickBooks Online by Bold (Shopify App Store): syncs products, line items, sales, taxes, shipping, gift cards and refunds, imports customers, syncs products and inventory and exports Shopify Payments payout fees and adjustments. It offers a daily sales summary or order details, and can pull historical data on demand.
- A2X: built around payouts. It reconciles each Shopify payout against the bank deposit, posts summarized settlement entries to the accounting system and can create a cost of goods sold entry from uploaded SKU costs.
General automation platforms can also move Shopify events into QuickBooks, but they leave the accounting logic (how a payout is split, where fees go) to whoever builds the workflow.
Custom integration through the APIs. A custom service reads orders, refunds and Shopify Payments payouts from the Shopify Admin API and writes invoices, sales receipts, credit memos, deposits and journal entries through the QuickBooks Online API. It is the only option where the posting logic is entirely yours.
| Option | Best for | Limits | Cost basis |
| Intuit Shopify connector | Single store, standard chart of accounts, merchants who want everything inside QuickBooks | Fixed workflows; payouts and orders workflows must not both post revenue; COGS prices are not synced | Included with a QuickBooks Online subscription |
| Connector apps (Bold, A2X and others) | Growing stores that want summaries, payout reconciliation or COGS entries | Each app's own posting model; priced by order volume | Monthly plans by order count |
| Custom API integration | Multiple stores or entities, custom revenue rules, other systems in the loop | Build and maintenance effort; you own monitoring and API changes | Project cost plus hosting and support |
How to Set Up Shopify and QuickBooks Online with Intuit's Connector
Intuit's connector is the path most merchants try first, because it is already part of the subscription. Intuit's setup guide breaks it into connect, configure and sync. The steps below follow that guide.
Decide on orders or payouts before connecting
Pick the source of revenue first. If you want each order in QuickBooks as an invoice or sales receipt, use the orders workflow. If you want QuickBooks to show what the bank actually received, use the payouts workflow. Intuit's guide says that when payouts are enabled you should disable the orders workflow, because the two "could double up your reported revenue if not set up correctly."
Connect the two accounts
Install Intuit's Shopify connector from the QuickBooks apps area, then sign in to the store to authorize access. Have admin access to both systems ready.
Set the synchronization options
Set the account timezone, the date the integration starts from and whether you want email sync reports. The start date matters: choose the first day of an open accounting period so the sync does not create entries in a period that is already closed.
Configure the workflows
- Orders: filter which order statuses sync, choose invoice or sales receipt, add an order number prefix, set a class or location, and map shipping, discount and rounding items.
- Taxes: map each Shopify tax to a QuickBooks Online tax code.
- Products: match products by name or SKU. Intuit's guide expects unique SKUs on all Shopify items, so clean up duplicates first.
- Payments: map payment methods to clearing accounts.
- Refunds: select the Refunded and Partially Refunded statuses so credit memos sync, and set a fallback account.
- Fees: fees sync as expenses under bills. In the US and Canada the payment account must be a credit card or checking account.
- Payouts: payouts are recorded as deposits. The receiving account must be a Bank or Other Current Asset account, with income accounts for payment methods and expense accounts for fees, charges and taxes.
- New products and stock: QuickBooks items can be created from new Shopify products, and QuickBooks stock levels can be pushed to a chosen Shopify location.
Run the first sync and check it
With auto-sync on, Intuit says the account syncs about every hour, and a Sync Now option runs it on demand. After the first run, take one payout and trace it: the deposit in QuickBooks should equal the bank line, and the gross sales, refunds and fees behind it should match the Shopify Payments activity report for the same dates. Only then switch on the rest of the history.
If you use a connector app instead
The pattern is the same with Bold, A2X or a similar app: install from the Shopify App Store, authorize QuickBooks Online, map accounts and tax codes, choose summary or per order posting, set a start date and test one payout before importing history.
Common Problems and Limits
Double counted revenue. The most common mistake is running the orders and payouts workflows together. Intuit's guide states the risk plainly. Choose one source of revenue, and if you later switch, set a clean cutover date.
Payouts that do not match orders. A Shopify Payments payout nets charges, refunds, adjustments and fees, and only includes transactions available at the time it was issued. Shopify's Payments activity report gives the breakdown of transactions, fees and payouts for a date range and currency, and that is the document to reconcile against. Orders paid through other gateways, gift cards or manual payment methods never appear in a Shopify Payments payout and need their own clearing accounts.
Fees. If fees are not recorded, the deposit will always be short of the sales posted. Intuit's connector records them as bills; Bold exports payout fees and adjustments; A2X splits them out per payout. Whatever the tool, fees should land in a dedicated expense account so they can be checked against Shopify's figures each month.
Sales tax. Each Shopify tax has to be mapped to a QuickBooks tax code. Stores that collect tax in many jurisdictions end up with many mappings, and a missing one usually shows up as tax posted to the wrong account. Confirm that tax is posted as a liability and not as income before the first filing period closes.
Inventory overwrites. Intuit's guide warns that stock sync should be enabled only if stock levels are already set up in QuickBooks Online, otherwise it may wipe out Shopify stock levels. Decide which system owns quantities before turning it on.
Cost of goods sold. Intuit's connector assigns a COGS account only when it creates products and does not sync COGS prices. Merchants who need margin by product often add a tool that posts COGS from uploaded SKU costs, such as A2X, or post COGS through a custom process.
Duplicates and SKU problems. Products are matched by name or SKU. Missing or repeated SKUs create duplicate items in QuickBooks or attach sales to the wrong item.
Multiple currencies. Shopify can pay out in a currency different from the selling currency. The accounting treatment of that conversion, and whether QuickBooks Online has multicurrency turned on, need to be settled before the first sync.
API limits for custom builds. Shopify's API rate limits use a bucket whose size and restore rate vary by API and by plan, and the GraphQL Admin API limits are based on calculated query cost. A custom sync has to queue and retry rather than assume every call goes through, especially during peak sales.
Costs
Published prices, as listed on the vendors' own pages:
| Item | Published price |
| QuickBooks Online (Shopify connector included) | Simple Start $38/month, Essentials $85/month, Plus $140/month, Advanced $340/month (list price; Intuit often runs introductory discounts) |
| QuickBooks Online by Bold | Starter $19.99/month (200 orders, then $0.15 per order, capped at $99.99), Growth $39.99/month (500 orders, then $0.10 per order, capped at $99.99), Enterprise $59.99/month (unlimited orders); 14-day free trial |
| A2X for Shopify | Monthly plans tiered by order volume, published on A2X's own pricing page |
A2X publishes its Shopify plans on its site, with tiers based on monthly order volume, so check the current figures there before budgeting. Shopify's own subscription is a separate cost and varies by plan and region.
A custom integration has no list price. As a reference point, Itexus publishes on its fintech development page that discovery and prototyping "start from around $30,000" and that enterprise fintech projects "often range from $150,000 to $1,000,000+". A focused Shopify to QuickBooks service is usually far smaller than an enterprise platform, and the real figure depends on how many stores, entities and posting rules are involved.
When a Custom Integration Makes Sense
High volume and per order detail. When order counts climb, per order posting creates thousands of QuickBooks transactions a month, and order based app pricing grows with it. A custom service can post summaries for the ledger while keeping order level detail in its own database for audit and lookup.
Revenue rules the apps do not model. Subscriptions, preorders, deposits, bundles, marketplace commissions and deferred revenue need posting logic that fixed connector workflows cannot express. A custom build lets finance define the journal entries.
Several stores or legal entities. Separate Shopify stores feeding separate QuickBooks companies, intercompany sales or a shared warehouse across brands are hard to manage with one app per store. One service can route every transaction to the right company file.
Other systems in the loop. If a warehouse system, an ERP, a subscription platform or a second payment processor also touches orders and money, the integration becomes a data flow between several systems rather than a two way connector.
Reconciliation that has to hold up. Lenders, investors and auditors want every deposit traced to the orders, refunds and fees behind it. A custom reconciliation layer can match each payout to its balance transactions automatically and flag the exceptions instead of leaving them for month end.
How Itexus Can Help
Itexus has delivered 120+ integrations for neobanks, payment providers, robo-advisors and trading systems, and takes on Shopify QuickBooks integration projects.
- Payout reconciliation: matching each payout to its charges, refunds, fees and adjustments, with exceptions flagged.
- Custom posting logic: revenue by product line, deferred revenue, refund and chargeback categorization and sales tax by state.
- Multi-system data flows: connecting Shopify, QuickBooks Online, payment processors and ERPs through APIs or middleware.
- Monitoring and support: retries, rate limit handling and alerts so the books stay in sync.
The closest published work: for a WealthTech platform serving 450K+ investors, Itexus reconciled Stripe payouts into QuickBooks, with revenue by subscription tier, deferred revenue, refund categorization and per-state sales tax. Contact us to discuss your setup.
For related guides, see Stripe QuickBooks integration, Shopify NetSuite integration and the overview of accounting software integration.
Itexus is a trusted partner
Itexus delivered the app according to the requirements. The team met all development milestones and deliverables. They were efficient, friendly, and cooperative. Itexus team was very timely with updates, a regular meeting cadence, and ad-hoc questions and answers via Slack. The team was very responsive and still is.
Stive Jackson
RMD, Investing Fund
Itexus’ work positions the business well for an imminent launch. They excel at managing their team, presenting frequent product demos to ensure that the project is aligned with development goals. An affordable price structure coupled with remarkable technical skill makes them an attractive partner.
Phill Osolinski
CEO Ryze Rewards
The assigned team was easy to work with and they are especially strong collaborators and communicators. They demonstrated flexibility, professionalism, and trust in everything they did, and completed the work on time and budget.
Sue Wollan Fan
CEO Mango Connects
Itexus excelled at both experimental AI and sprint-oriented UI/UX tasks. Itexus did strong project management work, too, a necessity in such a complicated project.
Jesse Dubin
Senior PM Standard&Poors
They’re a great group of developers who really understand the reality of business.
Andreea Vanacker
CEO SPARKX5
Frequently Asked Questions
Does Shopify integrate with QuickBooks?
Yes. Intuit lists a Shopify connector as included with QuickBooks Online subscriptions, and third-party apps such as QuickBooks Online by Bold and A2X also connect the two. Custom integrations use the Shopify Admin API and the QuickBooks Online API.
What is the best way to set up a Shopify QuickBooks integration?
For a single store with standard accounting, start with Intuit's connector and decide first whether revenue comes from orders or from payouts. Stores that need payout reconciliation, COGS entries or daily summaries often use an app built for that. Multiple stores, entities or custom revenue rules point to a custom integration.
How do I reconcile Shopify payouts in QuickBooks?
Record each payout as a deposit, then split it into gross sales, refunds, adjustments and fees using Shopify's payout summary or Payments activity report for the same period. The deposit should equal the bank line. Fees go to an expense account, and payments from other gateways need their own clearing accounts.
Why is my Shopify revenue doubled in QuickBooks?
Usually because both orders and payouts are being posted as income. Intuit's guide warns that enabling payouts while the orders workflow is on could double reported revenue. Turn one of them off and correct the overlapping period.
Does the integration sync inventory?
It can. Intuit's connector matches products by name or SKU and can push QuickBooks stock levels to a chosen Shopify location, but only if stock is already set up in QuickBooks; otherwise it may wipe out Shopify quantities. Bold's app also lists product and inventory sync.
What other Shopify accounting software integrations exist?
Besides QuickBooks Online, connector apps such as A2X also list Xero and NetSuite integrations for Shopify. Larger merchants often move to an ERP, covered in our Shopify NetSuite integration guide.
