Shopify QuickBooks Integration: Complete Setup Guide (2026)
Your accountant sends a message asking why the books do not match the Shopify numbers. You know exactly why. Every order from last week was entered manually into QuickBooks because the sync broke again. Forty-three transactions, each one touching taxes, shipping, and customer records.
Connecting Shopify to QuickBooks properly solves that. This guide covers everything: how the integration actually works, the official Shopify Connector by QuickBooks, how to set it up step by step, which third-party apps are worth considering, what to know about QuickBooks Desktop in 2026, and what changes if you are running B2B sales.
Yes. QuickBooks has an official, native integration with Shopify called the Shopify Connector by QuickBooks, built and maintained by Intuit. It is available to QuickBooks Online subscribers at no additional cost and connects your Shopify store directly to your QuickBooks Online account through the QuickBooks Apps marketplace.
The Shopify Connector by QuickBooks automatically syncs sales transactions, refunds, payouts, fees, taxes, and inventory between the two platforms. It rated 4.8 stars from over 3,000 reviews in the Shopify App Store as of 2026 and is the integration method recommended by both Intuit and Shopify.
For most merchants on QuickBooks Online, the official connector is the correct starting point. Third-party apps serve specific use cases where the official connector falls short, which are covered later in this guide.
The integration creates a data bridge between two systems that do not share a native database. When a Shopify event occurs, the connector reads it through Shopify's API and pushes the relevant data into QuickBooks in the format your chart of accounts expects.
Sales transactions: Orders placed in Shopify sync to QuickBooks as either sales receipts (for immediate payment) or invoices (for B2B orders on net terms). Line items, discounts, and product details transfer with each transaction.
Shopify Payments payouts: This is the data flow that most setup guides explain poorly. Shopify does not pay out each order individually. It batches orders into payouts that are deposited to your bank account, minus processing fees. The Shopify Connector separates gross revenue, Shopify processing fees, and refunds within each payout, matching the payout total to your bank deposit. This is what makes bank reconciliation work correctly.
Taxes: Tax amounts collected at checkout sync to your QuickBooks sales tax payable account. For multi-state US merchants using Shopify's automatic tax calculation, the connector maps taxes by jurisdiction.
Refunds: Refunds processed in Shopify create credit memos in QuickBooks, reducing the corresponding income and adjusting tax liability.
Inventory: Product quantities and costs of goods sold (COGS) sync between platforms. Inventory quantity on hand updates in QuickBooks when orders are fulfilled in Shopify.
Customers: Customer name, email, and billing or shipping address sync from Shopify to your QuickBooks customer list. The connector matches returning customers by email to avoid duplicates.
Fees: Shopify subscription fees, app charges, and payment processing fees sync as expenses to the appropriate expense accounts in your chart of accounts.
There are two approaches to how Shopify transactions enter QuickBooks.
Order-level sync creates a separate entry in QuickBooks for every individual Shopify order. This gives you full granularity: each customer, each product, each transaction amount in its own record. It is the approach used by the official Shopify Connector and most third-party apps.
Summary sync consolidates all transactions from a period (daily, weekly) into a single journal entry. Tools like Bookkeep use this approach. It is simpler to manage at high volume and easier to reconcile against Shopify payouts, but it sacrifices transaction-level detail.
For most businesses under 500 orders per month, order-level sync is the right approach. At higher volumes, the journal entry method can reduce QuickBooks bloat without losing meaningful financial accuracy.
This is the first question to answer before choosing any connector, because the answer determines your options completely.
QuickBooks Online is cloud-based with a robust API accessible 24/7. All major Shopify connector apps are built primarily for QuickBooks Online. Real-time sync is possible because both systems are accessible via API at any time without user intervention.
QuickBooks Desktop (Pro, Premier, Enterprise) is installed locally. Its API is more restricted, and syncing requires either the QuickBooks Web Connector or a dedicated desktop-to-cloud bridge. Real-time sync is not possible with Desktop. Connectors that support Desktop require the QuickBooks machine to be running and connected for the sync to execute.
Important update for anyone on QuickBooks Desktop: Intuit ended service and support for QuickBooks Desktop 2023 in May 2026. If you are currently running Desktop 2023 or earlier, you are on an unsupported version. Intuit is actively transitioning its user base to QuickBooks Online.
If you are on QuickBooks Desktop and planning a Shopify integration, this is the moment to evaluate migrating to QuickBooks Online. The integration options with Shopify are meaningfully better on QBO: real-time sync, the official Intuit connector, and broader third-party app support. Desktop integrations require more manual maintenance and offer fewer connector choices.
QuickBooks Online: 24/7 cloud API
QuickBooks Desktop: Requires running local instance
QuickBooks Online: Yes
QuickBooks Desktop: No (batch only)
QuickBooks Online: Yes, included free
QuickBooks Desktop: No
QuickBooks Online: All major connectors
QuickBooks Desktop: Select apps only
QuickBooks Online: Yes
QuickBooks Desktop: Limited
QuickBooks Online: Current
QuickBooks Desktop: 2023 version unsupported since May 2026
QuickBooks Online: 4.8+ stars
QuickBooks Desktop: Limited options
The official connector takes 15 to 30 minutes to configure for a standard Shopify store. Most of that time is in the account mapping step.
Step 1: Install from QuickBooks, not from Shopify. Sign in to your QuickBooks Online account. Navigate to Apps and search for "Shopify Connector by QuickBooks." Select Get app now. You will be redirected to authorize the connection with your Shopify account.
Step 2: Connect your Shopify store. Enter your store URL (yourstore.myshopify.com) and log in to Shopify to authorize data sharing between the two platforms. You will return to QuickBooks to complete the setup.
Step 3: Map your chart of accounts. This is the step that most errors come from. Configure where each type of Shopify data lands in your QuickBooks accounts:
Take time with these mappings. Incorrect account mapping is the most common source of reconciliation problems after setup.
Step 4: Map your products. Decide how Shopify products match to QuickBooks items: by SKU, by product name, or by a custom product ID. If you have existing items in QuickBooks, match to those records rather than creating duplicates.
Step 5: Set your historical sync start date. Choose how far back to import historical Shopify data. The connector supports up to one year of historical data. Confirm your start date matches your go-live date to avoid overlapping entries if you have been manually entering data previously.
Step 6: Choose your transaction handling. The connector can automatically confirm and record transactions, or hold them for manual review before they post to QuickBooks. Start with manual review for the first two weeks until you are confident the mapping is correct.
Step 7: Run a test transaction. Process one real or test order in Shopify and confirm it appears in QuickBooks exactly as expected. Check the income account, the tax line item, the customer record, and the fee breakdown. Correct any mapping issues before enabling full auto-sync.
Step 8: Monitor for 48 to 72 hours after go-live. Most edge cases surface in the first few days: refunds, partial payments, orders with mixed tax rates, gift card redemptions. Check the connector's transaction log daily until the sync is clean.
The official Shopify Connector by QuickBooks handles the standard use case well. These third-party apps are worth evaluating when you need capabilities the official connector does not cover.
Best for: Most merchants on QuickBooks Online
QBO: Yes
QBD: No
Pricing: Free with QBO subscription
Shopify App Store rating: 4.8 stars (3,000+ reviews)
What it does well: Payout matching, sales tax mapping, free cost
Limitations: Limited customization for complex B2B workflows, no draft order support
Best for: Bidirectional sync, QuickBooks Desktop users
QBO: Yes
QBD: Yes
Pricing: From $19/month
Shopify App Store rating: 4.9 stars
What it does well: Bidirectional inventory sync, supports QuickBooks Desktop, custom field mapping
Limitations: More setup complexity than the official connector
Best for: High-volume DTC stores, payout-focused reconciliation
QBO: Yes
QBD: No
Pricing: From $19/month
Shopify App Store rating: 5 stars (2,500+ reviews)
What it does well: Payout-level reconciliation, automated journal entries, multi-currency
Limitations: Summary-based approach loses transaction-level detail; no B2B order workflow support
Best for: Multichannel sellers (Shopify plus Amazon, eBay, others)
QBO: Yes
QBD: Yes
Pricing: From $79/month
Shopify App Store rating: 4.7 stars
What it does well: Multichannel data consolidation, QuickBooks Desktop support
Limitations: Higher cost; complex setup for simple single-channel stores
Best for: Stripe-heavy businesses, simple DTC
QBO: Yes
QBD: No
Pricing: From $61/month
Shopify App Store rating: 4.8 stars
What it does well: Multi-payment processor support, Stripe integration
Limitations: Not built for draft order or net terms workflows
QuickBooks Online (QBO): Yes
QuickBooks Desktop (QBD): No
Pricing: Free
Best Use Case: Most standard stores
QuickBooks Online (QBO): Yes
QuickBooks Desktop (QBD): Yes
Pricing: From $19/month
Best Use Case: QBD users, bidirectional sync
QuickBooks Online (QBO): Yes
QuickBooks Desktop (QBD): No
Pricing: From $19/month
Best Use Case: High-volume stores, payout reconciliation
QuickBooks Online (QBO): Yes
QuickBooks Desktop (QBD): Yes
Pricing: From $79/month
Best Use Case: Multichannel sellers
QuickBooks Online (QBO): Yes
QuickBooks Desktop (QBD): No
Pricing: From $61/month
Best Use Case: Stripe-heavy businesses
If you are not using an automated connector, or if you need to handle transactions manually for any reason, here is the correct approach.
For individual orders (order-level entry): In QuickBooks Online, create a Sales Receipt for each order that was paid immediately at checkout. Include the customer name, date, product line items with quantities and prices, shipping amount, and tax. Code the payment to your Shopify clearing account or bank account depending on your workflow.
For Shopify Payments payout reconciliation: Do not enter each order separately if you are reconciling at the payout level. Instead, create a single deposit entry for each Shopify payout that matches your bank statement. Break the deposit into: gross sales, minus Shopify processing fees, minus refunds, to arrive at the net payout amount. This is the approach that makes bank reconciliation accurate without managing hundreds of individual entries.
For returns: Create a Credit Memo in QuickBooks referencing the original invoice or sales receipt. Apply the credit memo to the customer's account or issue a refund.
The automated connectors handle all of this logic without manual intervention. The manual approach described above is what the connectors automate.
Duplicate transactions. Caused by running a manual import on top of an active auto-sync, or by resetting the sync start date incorrectly. Fix: identify the duplicate date range, delete the duplicate entries in QuickBooks, and confirm the connector's start date is correctly set.
Payout amounts that do not match bank deposits. Usually caused by incorrect fee account mapping or by including refund amounts incorrectly. Fix: review the connector's payout breakdown, confirm fees are mapping to an expense account (not reducing income directly), and that refund credits are applied correctly.
Rounding differences. Shopify and QuickBooks calculate tax and discount rounding slightly differently. Most connector apps have a rounding tolerance setting. Set the tolerance to one cent. Anything larger creates visible discrepancies at month-end reconciliation.
Missing customer records. Happens when a Shopify order uses guest checkout with no email, or when the connector cannot match a Shopify customer email to an existing QuickBooks record. Fix: configure the connector to create a generic "Shopify Guest Customer" record for unmatched guest orders rather than failing the transaction.
Inventory going negative. Happens when orders sync to QuickBooks before the fulfillment event arrives from Shopify. Fix: delay inventory sync to trigger on fulfillment confirmation, not order placement.
Sales tax not mapping correctly. Multi-state merchants using Shopify's automatic tax calculation may have mismatches if QuickBooks is set up for manual tax rates. Fix: confirm that the connector's tax mapping aligns with how QuickBooks handles your specific tax jurisdictions, or use QuickBooks' automated sales tax feature (available in QBO Plus and above).
Sync lag during high-volume periods. Connectors process transactions in queues. During peak sales periods, the queue can back up. Fix: schedule large historical imports during off-hours and confirm the connector's queue capacity before high-volume events like promotional sales.
Every guide covering Shopify QuickBooks integration is written for a DTC store. If that is your operation, everything above covers your needs. If you are a manufacturer, distributor, or wholesaler running B2B sales through Shopify, there are four workflow differences that standard connector guides do not address.
In B2B commerce, a significant share of orders are created as draft orders in Shopify rather than through the public checkout. A sales rep builds the order manually, the customer confirms, and the rep converts it to a completed order. The official Shopify Connector and most third-party apps sync completed checkout orders reliably. Their handling of draft orders, particularly draft orders modified multiple times before completion, varies. Test draft order behavior specifically before choosing your connector for a B2B operation.
B2B orders on net payment terms do not have an immediate payment event. An order ships on Net 30, and payment arrives weeks later. Standard connector logic matches a Shopify payment event to the QuickBooks entry. When there is no immediate payment because the account is on net terms, that match does not occur. The correct configuration creates a QuickBooks invoice at order creation and applies the payment to the invoice when it is received later. The official connector does support B2B orders as invoices. Confirm this is configured correctly for your net terms accounts before going live.
B2B buyers often have negotiated pricing that differs from standard price lists. If account A pays $18 per unit and account B pays $21 per unit for the same SKU, your QuickBooks items list needs to handle that correctly when orders sync. Some connectors pass the actual transaction price from Shopify for each order. Others map all orders to a single item price and create discrepancies in margin reporting. Test the pricing sync behavior with a real customer-specific pricing scenario before enabling full sync.
Many B2B operations receive orders by phone, email, and text rather than through the Shopify checkout. If your team enters those orders manually into Shopify before they sync to QuickBooks, the QuickBooks connector is not the bottleneck. The bottleneck is the manual entry step that precedes it. The best QuickBooks sync in the world does not fix a workflow where a sales rep spends 20 minutes re-entering an emailed order before the sync even starts.
This is the gap Uncap addresses for B2B manufacturers and distributors. As a Shopify Platinum Partner with over 380 B2B commerce projects delivered since 2013, we have built operations where orders arriving by email, phone, and EDI convert automatically into Shopify draft orders before syncing to your accounting system. The ERP and integration work Uncap builds eliminates the manual step, not just the last sync mile.
QuickBooks handles accounting. It is not built to manage the full quote-to-cash workflow that B2B sales teams run: custom quotes, negotiated pricing, multi-contact account hierarchies, approval chains, order status visibility for the buyer, and coordination between sales and operations.
When your team manages all of that in email threads, spreadsheets, and individual rep inboxes before it ever becomes a QuickBooks entry, the accounting integration is only solving the last step of a process that is still manual everywhere it matters.
That gap is where B2B operations on Shopify feel the most friction. If you are at the point where QuickBooks is clean but the process upstream of it is not, Uncap's B2B app suite is built for exactly that layer: Shopify-native tools that handle how B2B orders actually move through your team before they become accounting entries.
Book a Strategy Session to see how a connected Shopify and QuickBooks setup works inside a real B2B wholesale operation.
Does QuickBooks have a Shopify integration?
Yes. Intuit offers the Shopify Connector by QuickBooks, an official native integration available at no additional cost to QuickBooks Online subscribers. It automatically syncs sales transactions, payouts, fees, taxes, refunds, inventory, and customer data between Shopify and QuickBooks Online. The app is available in both the Shopify App Store and the QuickBooks Apps marketplace.
What is the best app to integrate Shopify and QuickBooks?
For most merchants on QuickBooks Online, the Shopify Connector by QuickBooks (Intuit's official connector) is the best starting point. It is free, rated 4.8 stars from over 3,000 reviews, and handles payout reconciliation, sales tax, and inventory sync natively. For high-volume stores prioritizing payout-level reconciliation, A2X is a strong alternative. For merchants on QuickBooks Desktop or those needing bidirectional inventory sync, MyWorks Sync is the top-rated option at 4.9 stars.
Is QuickBooks Desktop going away in 2026?
QuickBooks Desktop is not being discontinued, but Intuit ended service and support for QuickBooks Desktop 2023 in May 2026. The 2023 version will continue to function but no longer receives security patches or support from Intuit. Intuit is actively transitioning its user base to QuickBooks Online. If you are on QuickBooks Desktop 2023 or earlier, you are on an unsupported version.
Can Shopify sync with QuickBooks?
Yes. Shopify syncs with QuickBooks Online through the official Shopify Connector by QuickBooks and through multiple third-party apps including A2X, MyWorks Sync, Webgility, and Synder. Shopify syncs with QuickBooks Desktop through select third-party apps including MyWorks Sync and Webgility, though options are more limited and real-time sync is not possible with the Desktop version.
How do I enter Shopify sales into QuickBooks?
The automated approach is to connect Shopify to QuickBooks via the Shopify Connector by QuickBooks or a third-party app, which handles transaction entry automatically. If entering manually, create a Sales Receipt in QuickBooks Online for each order paid at checkout, or create an Invoice for orders on net payment terms. For payout reconciliation, enter a single deposit per Shopify payout that separates gross sales, processing fees, and refunds to match your bank statement amount.
What does the Shopify Connector by QuickBooks sync?
The official connector syncs sales transactions (as sales receipts or invoices), Shopify Payments payouts (separating gross revenue, fees, and refunds), sales tax by jurisdiction, product refunds as credit memos, inventory quantity and COGS, customer records, and Shopify fees and processing charges to your expense accounts.
Does the Shopify QuickBooks integration work for B2B?
The official connector supports B2B orders as invoices, which is required for net payment terms workflows. However, B2B-specific requirements including draft order handling, customer-specific pricing sync, and multi-contact account structures have limitations in standard connector apps. B2B operations with complex pricing, approval workflows, or high volumes of manually created orders typically require additional configuration or a more custom integration architecture.
How much does the Shopify QuickBooks integration cost?
The Shopify Connector by QuickBooks (Intuit's official app) is free for QuickBooks Online subscribers. Third-party apps range from $19 per month (A2X, MyWorks) to $79 per month and above (Webgility) depending on features and order volume. All options require an active QuickBooks Online subscription at $35 per month (Simple Start), $65 per month (Essentials), or $99 per month (Plus) as of 2026.
