Connecting Shopify to QuickBooks Online: What to Know
QuickBooks Online users can sync Shopify sales, refunds, fees, and payouts with the Shopify Connector by QuickBooks. Here's how.
QuickBooks Online users who sell through Shopify have a first-party way to bring store transactions into the books. The Shopify Connector by QuickBooks app imports sales, refunds, fees, and payouts from a Shopify store into QuickBooks Online, so reconciliation can happen without manual data entry. The most common community questions center on setup, the settings that control what gets imported, and how long the initial load takes.
What the connector imports
The app collects Shopify transactions and related details, then brings them into QuickBooks Online. That covers the money moving in and out of your Shopify account: customer sales, refunds, payment processing fees, and payouts. The goal is to make end-of-month reconciliation more accurate because the figures come from the same source as your Shopify reports.
The connector also handles inventory and customer information, but only if you turn those parts on. Product tracking syncs products sold on Shopify to inventory items in QuickBooks Online. Customer tracking syncs customer details from Shopify into QuickBooks Online.
Before you connect
You need an active QuickBooks Online account and a Shopify store. You also need the original Shopify store URL, the one Shopify generated when you created the store. It looks like your-store-name.myshopify.com. A custom domain, one you bought separately and pointed at your store, will not work for this connection.
You also need your Shopify login credentials and permission to install third-party apps in Shopify. If you do not have that permission, the store owner or a Shopify administrator has to grant it before the connection can finish.
The connection steps
Start inside QuickBooks Online. Go to the integrations area and find the Shopify Connector by QuickBooks app. Choose to get the integration, then enter the original Shopify store URL and select Connect.
The app takes you through a short review screen before redirecting you to Shopify. Sign in to Shopify there, then authorize access so the two accounts can share data. After that, you return to a settings screen in QuickBooks Online where you choose how the import will behave.
Settings that matter
The transaction sync date is the most important setting. You can tell the app to start importing orders from any date up to one year back. If you already recorded some Shopify activity in QuickBooks Online manually, pick a start date that avoids pulling in those same transactions twice. Imported transactions can be undone manually if you need to remove them.
The deposit account setting determines which QuickBooks account receives Shopify payouts. The payments account setting determines which account records negative payouts, such as refunds or fees that come out of your balance. Pick these carefully so your cash position and fee expenses land in the right places.
The add transactions automatically setting controls whether the app posts transactions on its own. When it is on, high-confidence transactions are added directly to your books. When it is off, transactions appear for review first. That extra review step takes more time, but it gives you control over what gets posted.
Product and customer tracking are optional. With product tracking on, the app tries to match imported products to existing inventory items by SKU and name. Close matches appear in a review list with suggested matches. If there is no match, the product can be created as a new item. Customer tracking works similarly for customer details.
How long the initial import takes
The first import can take anywhere from 10 minutes to 3 hours depending on how many transactions you have. Shopify transactions are pulled in batches, so you will not necessarily see everything at once. Large stores should expect the longer end of that range. While the import runs, you can leave the page and check back later.
Once the connection finishes, new Shopify activity flows in based on the schedule the connector uses. The initial sync date applies only to the first pull; ongoing transactions appear after they happen in Shopify.
Common trouble spots
A failed connection usually comes down to four things. The store URL must be the original myshopify.com address, not a custom domain. The Shopify user must have permission to install third-party apps. The person setting up the link has to complete the authorization step in Shopify itself. And the QuickBooks account must be active and able to install integrations.
Missing transactions after setup are usually a date problem. If the sync date is set too close to today, older orders never enter the queue. Check that date before rerunning anything or contacting support.
Slow imports are a volume issue, not a sign that the connection is broken. Batches can take hours for busy stores. If auto-add is off, transactions will sit in the review area until someone approves them, which can make the feed look incomplete even though it is working as configured.
The Shopify Connector by QuickBooks is not the only integration route, but it is the one Intuit builds and maintains for this pairing. For most stores, it is the simplest way to keep Shopify sales and QuickBooks Online records moving together.