How to Setup QuickBooks with Shopify (2026 Guide)

Overview

The Shopify and QuickBooks integration connects your ecommerce store with your accounting software, automatically syncing sales, expenses, taxes, and payouts so you do not have to manually enter financial data. Several integration apps are available, with the most popular being QuickBooks Online by Intuit (official) and third-party connectors like A2X and Shopify QuickBooks Connector by OneSaas.

When connected, your Shopify orders flow into QuickBooks as invoices or sales receipts, products sync as items, and customers sync as QuickBooks customers. Tax amounts, shipping charges, discounts, and refunds are all mapped to the appropriate QuickBooks accounts. This gives you accurate, up-to-date financial records without double-entry and makes tax preparation, reconciliation, and financial reporting significantly easier.

The integration is essential for any Shopify merchant who needs professional bookkeeping. Without it, reconciling Shopify payouts with your bank account and properly categorizing ecommerce revenue in QuickBooks is a time-consuming manual process prone to errors.

Prerequisites

• A Shopify store on any plan
• A QuickBooks Online account (Simple Start, Essentials, or Plus — the integration does not work with QuickBooks Desktop without additional middleware)
• Shopify admin access to install apps
• QuickBooks admin access to authorize the connection
• A basic understanding of your chart of accounts in QuickBooks

Step-by-Step Setup

Step 1: Choose Your Integration App

In Shopify, go to Apps > Shopify App Store and search for "QuickBooks." You will see several options. The official Intuit QuickBooks Connector is free and handles basic order syncing. For more advanced needs (especially accurate accrual accounting and payout reconciliation), consider A2X for Shopify, which is the gold standard for ecommerce accounting. Choose the app that fits your needs and click Add app.

Step 2: Install and Authorize

Click Install app in Shopify to confirm. The app will prompt you to connect your QuickBooks Online account. Click Connect to QuickBooks and sign in with your Intuit credentials. Select the QuickBooks company file you want to sync with and click Authorize. The app will verify the connection and display a success message.

Step 3: Map Your Accounts

The integration will ask you to map Shopify data to QuickBooks accounts. Configure the following mappings: Sales Revenue (map to your income account, typically "Sales" or "Product Sales"), Shipping Revenue (map to a shipping income account), Discounts (map to a discounts or contra-revenue account), Tax Collected (map to your sales tax liability account), and Refunds (map to a refunds or returns account). If these accounts do not exist in QuickBooks, create them first.

Step 4: Configure Product Syncing

Choose how Shopify products should sync to QuickBooks. Options typically include: sync each product as a separate QuickBooks item, sync all sales under a single generic item, or map specific Shopify products to existing QuickBooks items. For most small businesses, syncing each product individually provides the best reporting granularity.

Step 5: Configure Order Syncing

Set the order sync preferences. Choose whether to sync orders as Sales Receipts (for direct-to-consumer sales where payment is collected at checkout) or Invoices (for wholesale or B2B orders where payment may be collected later). Most Shopify stores should use Sales Receipts. Set the sync frequency — real-time or daily batch. Select the start date for syncing (typically the beginning of your current accounting period).

Step 6: Configure Payout Reconciliation

If your integration app supports payout reconciliation (A2X does this well), configure it to match Shopify Payments payouts with your bank deposits in QuickBooks. This creates a clearing account that tracks the difference between when an order is placed and when the payout hits your bank account. Map the clearing account in the app settings.

Step 7: Run an Initial Sync and Verify

Start the initial sync. Depending on your order volume and date range, this may take a few minutes to several hours. Once complete, open QuickBooks and verify a few recent orders synced correctly. Check that the amounts match, taxes are categorized correctly, and products are mapped to the right items. Run a Profit & Loss report in QuickBooks to verify revenue figures match your Shopify analytics.

Configuration Options

Most integration apps let you configure sync direction (one-way from Shopify to QuickBooks or two-way), sync frequency (real-time, hourly, or daily), and which order statuses to sync (e.g., only paid orders, or all orders including pending). You can also configure how multi-currency orders are handled, how gift card sales are recorded, and how to account for Shopify's payment processing fees. Advanced apps like A2X allow you to choose between cash-basis and accrual-basis accounting methods.

What Syncs

Best Practices

• Set up the integration at the beginning of a fiscal quarter or year to keep clean records — avoid starting mid-month if possible
• Review the first week of synced data carefully to catch any mapping errors before they compound over months of transactions
• Create separate income accounts in QuickBooks for product sales, shipping, and fees to get granular financial reporting
• Use a clearing account for Shopify Payments to properly reconcile payouts with bank deposits — the timing difference between order date and deposit date causes confusion without a clearing account
• Reconcile monthly by comparing Shopify's analytics revenue with QuickBooks' income accounts to catch any sync discrepancies early

Common Issues and Fixes

Duplicate Orders in QuickBooks

This typically happens when you switch integration apps or re-sync historical data. Before migrating to a new connector, export a list of synced order numbers and verify no overlapping date ranges. Most apps let you set a start date to avoid re-syncing existing data.

Tax Amounts Not Matching

Shopify calculates taxes based on its own tax engine, and QuickBooks has its own tax calculation system. Configure the integration to use Shopify's tax amounts (pass-through) rather than letting QuickBooks recalculate. In the app settings, select "Use Shopify tax amounts" or similar option.

Payouts Do Not Reconcile with Bank

Shopify batches multiple orders into a single payout and deducts processing fees. If you are syncing individual orders, the bank deposit will not match any single order. Use a payout reconciliation feature (available in A2X) or create a manual clearing account to bridge this gap.

Advanced Configuration

For high-volume stores, consider using A2X which summarizes Shopify payouts into journal entries rather than individual transactions, significantly reducing the transaction volume in QuickBooks and improving performance. Advanced users can also configure inventory tracking between Shopify and QuickBooks, map Shopify order tags to QuickBooks classes or locations for departmental reporting, and set up automatic expense categorization for Shopify subscription fees and app charges.