If your Shopify dashboard shows strong sales but your bank account tells a different story, and you’re not sure which number to trust, you’re not alone. Or maybe you know that feeling in the beginning of the new year when your CPA asks for your financials and you’re suddenly piecing together a year’s worth of Shopify payouts from scratch. Both are related to the same underlying problem: your books aren’t connected to your store.
A proper Shopify–QuickBooks integration is one of those small decisions that keeps paying dividends every month. When it’s set up correctly, your numbers stay current, tax season stops being a scramble, and you have visibility into your store’s profitability. Here’s exactly how to get that connection set up and what to watch out for along the way.
But First, What Makes Connecting Shopify to QuickBooks Online So Important?
Shopify is built to run your store, not your books. It tracks orders, payouts, and fees, but turning that data into something useful can mean hours of manual work every month.
QuickBooks Online is where that organized financial picture lives, but it has no idea what’s happening in your Shopify store unless you connect the two. That’s the gap this integration fills, the bridge, so to speak.
What You’ll Need Before You Start
Getting this set up is straightforward, but make sure you have everything in place before you begin:
- An active Shopify store with at least one completed payout
- A QuickBooks Online subscription (Simple Start or higher)
- Admin access to both your Shopify account and your QBO account
- A connector app
One important note on that last point: there is no built-in, automatic connection between Shopify and QuickBooks Online. You need a third-party app to bridge the two. The good news is that the options are solid and relatively affordable.
Choosing the Right Connector App
There are two main options worth considering, and the right choice depends on the state of your business and how detailed your books need to be.
Shopify Connector by Quickbooks
If you’re looking for the simplest way to connect Shopify and QuickBooks Online, Intuit’s free Shopify connector is worth considering.
It’s quick to set up, doesn’t add another monthly subscription, and can work well for newer stores that just need basic financial visibility.
The downside is that the connector sends individual Shopify orders into QuickBooks rather than summarizing activity by payout. As your order volume grows, QuickBooks can quickly become cluttered with hundreds or thousands of transactions each month.
This can make it more difficult to match Shopify payouts to your bank deposits, track Shopify fees accurately, and identify the source of discrepancies when something doesn’t reconcile. Over time, bookkeeping often becomes more time-consuming and may require additional cleanup to ensure your financial reports remain accurate.
A2X is one of the most popular tools for connecting Shopify and QuickBooks Online. Instead of sending thousands of individual orders into QuickBooks, it groups your Shopify activity into clean, easy-to-understand entries that match your payouts.
It also handles the details that often cause problems in ecommerce bookkeeping, including refunds, discounts, gift cards, sales tax, and Shopify fees.
A2X is usually the best fit for growing Shopify brands that want accurate financial reports and a bookkeeping system that can scale as the business grows. While it costs more than the native Shopify connector, starting at $29/month as of June 2026, many store owners find the improved accuracy and cleaner books well worth the investment.
The short version: If you’re just getting started and want something free and simple, the Intuit connector is a decent starting point. For larger or faster-growing brands, a more advanced solution like A2X may save time and provide cleaner financials in the long run.
Step-by-Step: How to Connect Shopify to QuickBooks Online
The steps below use A2X, since it’s what we recommend for most Shopify brands. The Intuit connector follows a similar flow, just with fewer configuration options. If you’d like to view the process to connect your QBO account to the Shopify Connector by Quickbooks, this is the link to the official Intuit setup guide.
Step 1: Start Your A2X Trial
Go to A2X and sign up for a free trial. Choose Shopify as your sales channel when prompted.
Create your account using either:
- Google login, or
- Email and password
Once you complete signup, you’ll be taken to your A2X dashboard.
Step 2: Connect QuickBooks Online
Inside the A2X dashboard, look for the option to connect an accounting system (QuickBooks Online will be the primary option).
Click QuickBooks Online → Connect.
You will then:
- Be redirected to Intuit’s login page
- Sign in to your QuickBooks Online account
- Review and approve access permissions for A2X
- Select the QuickBooks company file (if you manage more than one)
- Choose which bank accounts A2X is allowed to post entries to
- Confirm authorization
After approval, you’ll be sent back to A2X where the connection is now active.
Step 3: Connect Shopify
From the dashboard, find the option to add a sales channel and select Shopify.
You’ll then:
- Enter your Shopify store URL (yourstorename.myshopify.com)
- Click Connect
- Log into Shopify when redirected
- Approve A2X access to your store data
Once approved, A2X will begin importing your payout history automatically.
You’ll usually see initial payouts appear in the “Payouts” section within minutes to a few hours depending on store size.
If you’re an accountant or bookkeeper, you may instead request access from the store owner before completing this step.
Step 4: Configure Accounts & Taxes (Mapping Setup)
Now you define how Shopify data should appear in QuickBooks.
Inside A2X, go to Accounts & Taxes → Setup.
You’ll be guided through either:
Assisted setup (recommended):
- A2X suggests a standard ecommerce chart of accounts setup
- It automatically maps sales, refunds, fees, taxes, etc.
- QuickBooks accounts are created or aligned as needed
Custom setup:
- You manually choose where each transaction type should go in QuickBooks
- You map items like sales, refunds, fees, shipping, and tax to specific accounts
Typical mappings include:
- Sales revenue
- Refunds/returns
- Discounts
- Shipping income
- Shopify fees
- Sales tax payable
- COGS (if tracking inventory)
Once complete, save your mapping configuration. This becomes the rule set for all future payouts.
Step 5: Review Shopify Payouts
Go to the Payouts section in A2X.
Here you’ll see each Shopify payout grouped automatically.
For each payout:
- Click into the payout
- Review the breakdown of sales, refunds, fees, and taxes
- Confirm everything is categorized correctly based on your mapping
This step is essentially your “pre-check” before anything touches QuickBooks.
Step 6: Send to QuickBooks Online & Reconcile
Once a payout looks correct, click Send to QuickBooks.
A2X will create a summarized accounting entry in QuickBooks Online representing that Shopify payout.
Then in QuickBooks:
- Go to the bank feed
- Find the matching Shopify deposit
- Match it to the A2X entry
From this point forward, the process repeats for each payout. Many users eventually automate the posting step once their setup is stable.
Common Mistakes to Avoid
Even with a good connector app, there are a few ways this setup can go sideways.
Mapping everything to a single account. It’s tempting to send all Shopify activity into one “Sales” account, but this removes visibility into fees, refunds, and discounts—making it impossible to understand true margins.
Incorrect mapping setup in general. Even with A2X’s automated chart of accounts, the real risk is overriding defaults or assigning categories without understanding how Shopify data flows through payouts. If sales, refunds, fees, and taxes are mapped incorrectly from the start, your reports can look wrong even when everything is syncing properly. Fixing this later usually means reworking multiple payouts and cleaning up historical data.
Syncing individual transactions instead of payout summaries. When using a transaction-level sync like the Intuit connector at higher volumes, QuickBooks can fill up quickly with thousands of line items, making reconciliation harder and financial reports harder to interpret.
When the Setup Gets Complicated
For a lot of Shopify founders, following these steps will get you to a functional setup. But there are a few situations where things get more complex quickly:
- You’re behind on your books and need to import months (or years) of history
- You sell on multiple channels (Amazon, Etsy, your own site) and need everything to reconcile cleanly
- You carry physical inventory and need COGS tracked accurately
- You’ve already been using QBO but with messy categorization that needs to be cleaned up first.
If any of that sounds familiar, you don’t have to untangle it alone.
Need Help Getting This Set Up?
Getting the Shopify + QuickBooks connection right from the start saves a lot of cleanup work later. At Walnut Hill Bookkeeping, we specialize in bookkeeping for ecommerce brands, so this is exactly the kind of thing we do every day.
If you’d like a second set of eyes on your setup, or if you’re starting from scratch and want it done right, book a free 30-minute consultation and we’ll take a look at where you are and what you need.