Shopify Connector by QuickBooks: Linking Your Store to QuickBooks Online
QuickBooks Online users can import Shopify sales, refunds, and payouts automatically through the Shopify Connector app; here is how the setup works.
Merchants who run a Shopify store and keep the books in QuickBooks Online tend to arrive at the same question sooner or later: can the two systems share data without manual entry? Community threads on the topic draw a steady, formally accepted answer. The supported route is a first-party app, the Shopify Connector by QuickBooks, and it installs from inside QuickBooks Online rather than from an outside marketplace.
Why connect Shopify to QuickBooks Online?
Hand-keying each day’s orders, refunds, platform fees and payouts invites errors and eats time that a growing store rarely has. The connector imports those transactions and their details automatically. The practical payoff is reconciliation: Shopify payouts, refunds and fees arrive in the books already tied to the sales that produced them. That makes month-end review faster and bank reconciliation far cleaner.
What do you need before you start?
Four things must be in place. You need an active QuickBooks Online account. You need the store’s original myshopify.com web address, the one Shopify generated when the shop was created, not any custom domain pointed at it. You need your Shopify sign-in details. And you need permission within Shopify to install third-party apps, since the connection counts as one.
The original-address requirement trips people up most. A polished custom domain will not work in the connection screen. Sign in to Shopify and copy the underlying store address if you are unsure which one it is.
The connection steps that work
The whole setup happens from the QuickBooks Online side. Sign in, open the Integrations menu, and choose the option to explore integrations. Find the Shopify Connector by QuickBooks app in the catalog and select the control to get the integration now. Enter the store’s myshopify.com address, select Connect, review the summary, and continue.
At that point Shopify itself takes over briefly. Sign in when prompted and approve the request to share data between the two platforms. Approval returns you to QuickBooks Online, where a settings page waits.
Settings that shape how sales land in your books
The settings page deserves a slow pass, because several choices here are awkward to revisit later. You pick the date the app should start importing orders, and history reaches back as far as one year. If you already entered some of those older transactions by hand, the app lets you exclude or undo them so nothing lands twice.
You also map the accounts. One deposit account receives Shopify payouts. A separate payments account covers negative payouts, the cases where Shopify pulls money back rather than depositing it.
Two switches control behavior rather than accounts. Turn on automatic transaction adding, and high-confidence entries post themselves, landing in the categorised area of the integration transactions view. Leave it off and every imported transaction waits for your review instead, a safer posture while you learn how the mapping behaves.
Do products and customers sync too?
Optional tracking covers both. Product tracking pulls Shopify items into QuickBooks Online inventory. The app tries to match items by SKU and by name against what already exists, which guards against duplicates. Where a match is close but not certain, the item appears in the review tab with a suggested pairing for you to accept or reject. Customer tracking works along similar lines, carrying customer details across with each order.
How long does the first import take?
Patience matters on day one. The initial import runs somewhere between ten minutes and three hours, depending on how many orders sit inside the date range you selected. Imports arrive in batches, so a busy store’s history may fill in gradually rather than all at once. Nothing is wrong if the books look incomplete an hour in.
The short version
The connection is supported, first-party, and handled entirely from QuickBooks Online. The two sticking points are predictable ones: use the original myshopify.com address rather than a custom domain, and make sure your Shopify role allows third-party app installs. We would add a third caution of our own: choose the start date with care, decide between automatic posting and manual review, and let the first batch finish before judging the results.