QuickBooks Shopify Integration: 7-Step Setup

If your setup is unusual, you can book a discovery call.

Table of contents

• What does a QuickBooks Shopify integration record in your books?
• QuickBooks Online or Desktop: which one do you run?
• Which way should you connect Shopify to QuickBooks?
• How do you set up a QuickBooks Shopify integration in 7 steps?
• Why don’t Shopify payouts match your QuickBooks deposits?
• When is a custom QuickBooks Shopify integration worth it?
• How Web25 helps
• FAQ

What does a QuickBooks Shopify integration record in your books?

With Intuit’s Shopify Connector, each Shopify sale becomes a Sales Receipt plus an Expense for the fee, both wait in a clearing account, and the payout is later recorded as one Deposit. That is how Intuit’s Connect Shopify to QuickBooks Online guide, which shows an update date of August 3, 2026, describes its connector.

Shopify event	What QuickBooks Online creates
Payment received (a sale)	A Sales Receipt for the sale and an Expense for the fees, held in Undeposited Funds or Payments to deposit
Refund	A refund transaction with the amount, taxes and products or services
Payout	A Deposit for the net amount, including the related Sales Receipts, Receive Payments and Expenses, with Shopify’s adjustments at the bottom. It moves the net amount from the clearing account to your Deposit account
B2B order and payment	An Invoice linked to a company. A payment creates an Invoice Payment, plus an Expense if there is a payment fee
Marketplace taxes (such as Shop app sales)	An adjustment to the Sales Tax Payable account

If you need stock and orders in an ERP, our ERP website integration guide covers that instead.

QuickBooks Online or Desktop: which one do you run?

The Intuit setup guide above is for QuickBooks Online. Its compatible-products list names QuickBooks Online editions and QuickBooks Ledger, with no Desktop edition. Shopify’s own Desktop page says: “Information on this page is applicable only to QuickBooks Desktop POS merchants that are migrating to Shopify.”

In its stop-sell notice, Intuit said that after Sept. 30, 2024 it would no longer sell new subscriptions of QuickBooks Desktop Pro Plus, Premier Plus, Mac Plus and Enhanced Payroll to U.S. subscribers. “Existing subscribers are not impacted by this change.” Enterprise isn’t affected either, and “This decision applies to the United States only.”

Which way should you connect Shopify to QuickBooks?

There are four ways to connect Shopify to QuickBooks. Any Shopify QuickBooks integration falls into one of them. Try route 1 first and move down only when something in your process doesn’t fit.

Route	Fits when	Watch out for
1. Intuit’s Shopify Connector	You run QuickBooks Online and your flows are sales, fees, refunds and payouts	Intuit may bill separate charges, so read Shopify’s listing
2. A third-party sync or payout-summary app	You run Desktop or want a different level of detail	Features and supported QuickBooks versions differ by app, so read the listing
3. Custom code	Your rules or data go beyond what an app’s settings offer	Intuit’s call limits, token rules and metering, covered below
4. Manual entry from Shopify reports	You get a handful of orders a week	Typing errors, and time lost at every month end

If you sell on WooCommerce with Xero instead, read our Xero WooCommerce integration guide. If you need stock in an ERP, our Shopify NetSuite integration guide is the closer fit.

How do you set up a QuickBooks Shopify integration in 7 steps?

These seven steps set up Intuit’s Shopify Connector on QuickBooks Online, following Intuit’s setup guide.

1. 1. Gather what you need. You need a QuickBooks Online account, your shop’s myshopify.com address (not a custom domain), your Shopify login and permission to install apps.
2. 2. Add the Shopify Connector and authorize your shop. In QuickBooks Online, open Integrations, then Find integrations, and pick the Shopify Connector. Select Get integration now, enter your store address, then sign in to Shopify and approve.
3. 3. Pick the import start date. You can import transactions from up to one year back. If you typed some of those months in by hand, Intuit says you can “manually exclude or undo transactions imported from this period if they were previously entered.”
4. 4. Set your accounts. Choose the Deposit account where payouts arrive and the Payments account for negative payouts. The app creates default Fees and Adjustment accounts, which you can change in App Settings. Agree all four with your accountant first.
5. 5. Choose product and customer tracking. With Product Tracking on, the connector tries to match products by SKU and name, and it doesn’t add a product when it finds no match. With tracking off, sales use a default item called Shopify Sales Item and customers use Shopify Customer.
6. 6. Review and confirm sales, then add the payout. Select Sync now, open Integration Transactions, review each sale and select Confirm. Confirmed sales become Sales Receipts and fee Expenses in Undeposited Funds or Payments to deposit. Then add the payout, which creates one Deposit for the net amount.
7. 7. Match the deposit in your bank feed. In Bank transactions, use Match on the deposit. Intuit’s wording is “Do not manually Add the deposit in the bank feed.” Then check how sales tax was recorded.

Why don’t Shopify payouts match your QuickBooks deposits?

Your bank receives the net payout, while QuickBooks may still be holding gross sales. Intuit describes a payout as “Disbursements from Shopify, typically covering sales over a 1 day period (or longer if selected).” Intuit says Shopify “collects funds, deducts fees and adjustments, and sends the net amount to your deposit account.”

Shopify’s ShopifyPaymentsPayout documentation shows the same split. A payout carries a net amount and a summary that breaks down fees and gross amounts by transaction type, such as charges and refunds.

When a payout doesn’t match, check three things:

• Every sale in that payout is confirmed, so its Sales Receipt sits in the clearing account.
• Every fee and adjustment line points to an account you chose in step 4.
• The payout was added before you went to the bank feed, and you used Match, not Add.

If you take payments through a gateway other than Shopify Payments, our payment gateway API integration guide follows a gateway’s money into your accounting.

When is a custom QuickBooks Shopify integration worth it?

A custom QuickBooks Shopify integration is worth it when the app’s settings can’t express your process. Examples are several stores feeding one QuickBooks company, or a person who must approve entries first.

Intuit’s developer pages set the rules. A realm ID is one QuickBooks company, and the table copies the scope Intuit gives each rule.

Rule	What Intuit says	Source
Request rate	“500 requests per minute per realm ID.” Also “10 requests per second, per realm ID and app.” On HTTP status 429, wait 60 seconds before you retry.	API call limits and throttles, production servers
Access token	“Access tokens are valid for 3,600 seconds (or one hour).”	Authorization FAQ
Refresh token	Valid for 100 days, with a rolling expiry that extends each time you refresh an access token. Maximum validity is five years.	Authorization FAQ
Core and CorePlus calls	Core calls (most data-in operations, such as creating invoices) are “unmetered and uncharged.” CorePlus calls (most data-out operations, such as reading accounts) are “metered and charges may apply.”	Partner FAQ, last updated October 2, 2026
Builder tier	An included limit of 500,000 CorePlus API calls per workspace per month. The FAQ says calls above the allotment are blocked.	API call limits and throttles and the partner FAQ
Metering start	“CorePlus API metering began November 3, 2025, for partners in the US, Canada (excluding Quebec), UK, and Australia.”	Partner FAQ

A custom app has to store each new refresh token it receives and slow down on a 429.

Scoping a build is covered in our custom API integration services guide. For the money side, see API integration cost.

How Web25 helps

Web25 is our agency; this guide covers it alongside alternatives.

Start with Intuit’s app, and only pay for custom code when its settings run out. Our backend and API service covers custom links from a store to the software behind it, but we have no public Shopify or QuickBooks project. The closest public work is the Mirael3D WooCommerce and POHODA case study, so nothing here rests on Shopify or QuickBooks delivery experience.

Checked October 22, 2026. Where a page shows no date, quotes are as read that day.

FAQ

What to do next

Check which QuickBooks you run, then try Intuit’s app. If your setup doesn’t fit it, book a discovery call.

---

Written by Adam Khaled, Founder, Web25. Published October 22, 2026. Last updated October 22, 2026.