Shopify to QuickBooks Online: Connector Setup and the Store URL Catch
QuickBooks Online users connecting Shopify hit the store URL snag; the connector's start date and review settings shape how sales and payouts land.
One request keeps surfacing in the QuickBooks Online community: sellers running a Shopify storefront want orders, refunds, fees and payouts to reach their books without anyone rekeying them. The accepted solution names one app, the Shopify Connector by QuickBooks, built by Intuit itself. Installation is quick. The parts that decide whether the link works, and whether the books stay clean afterwards, are the store address, the import start date, and a row of review settings.
Sales in one place, books in the other
Shopify records the sale. QuickBooks Online keeps the accounts. What sellers keep asking for is a bridge between the two, so reconciliation becomes a check rather than a copy-paste chore. The connector is that bridge. It imports transactions and their related detail from the Shopify side automatically, so you can match sales, refunds, fees and payouts against what the bank actually received.
Four prerequisites apply before you begin. You need an active QuickBooks Online account, the store’s original myshopify.com address, your Shopify sign-in, and permission inside Shopify to install third-party apps. The address is the detail that deserves a closer look.
Which store address does the connector want?
Not the one customers type. The connector asks for the original myshopify.com address that Shopify generated when the store was created, not the custom domain layered over it. A storefront the public knows by a clean branded address still lives, underneath, at something like your-store.myshopify.com. That underlying address is the one the app accepts. The branded domain will not satisfy the prompt, so if the two have never been distinguished before, this is the moment to look up the original.
The connection path in QuickBooks Online
From there the flow is short, and the exact labels matter. Sign in to QuickBooks Online, open Integrations, and select Explore integrations. Find the Shopify Connector by QuickBooks app and choose Get integration now. Enter the myshopify.com address, select Connect, review the summary, and select Continue. You are then handed to Shopify to sign in and authorise access.
Authorisation happens on Shopify’s side of the fence. Once approved, QuickBooks Online drops you on the Review your app settings page, and the real decisions start there. A Go to Integration Transactions button appears once the link is live.
Settings that shape the books from day one
The transaction sync date comes first. You can wind it back as far as one year, which matters when the store has been trading while the books ran elsewhere. Anything already entered by hand inside that window can be excluded or undone after the import, so an overlap is recoverable rather than fatal.
Two account fields follow. Deposit account sets where Shopify payouts land. Payments account is the mirror image: it sets where negative payouts are recorded from, the periods when refunds outweigh sales and money flows backwards.
Add transactions automatically decides the daily workload. Switched on, it lets QuickBooks Online post high-confidence transactions by itself, and they surface in the Categorised tab under Integration transactions. Switched off, every imported item waits in For Review for a human decision. Sellers who want a manual eye on everything keep it off and accept the queue.
Product Tracking and Customer Tracking finish the set. The first pulls Shopify products into QuickBooks Online as inventory items, matching on SKU and name so duplicates are not created. Close matches appear in For Review as suggestions, and where nothing matches, a new item is created. The second carries buyer details across. Select Sync now to close the settings page and start the flow.
How long should you wait for the first import?
Between ten minutes and three hours, on Intuit’s published estimate, depending on how much history you requested. Imports run in batches, so the count can look complete while stragglers are still landing. Our suggestion is simple: give the process the full three hours before judging it, and hold off re-entering recent sales by hand meanwhile. If those sales fall inside the backfill window, the connector will find them, and the undo option above is the cleanup path.
The Australian angle
The thread carries the Australian locale marker, and it shows up in small ways. The review tab reads Categorised rather than Categorized, and the authorisation prompt uses the local spelling. The connector and the sequence of steps are the same either way, so an Australian seller can follow this path without hunting for a regional variant.
The short version
Connect the app, mind the myshopify.com address, choose the start date with care, point the two account fields at the right places, and decide whether automation or review suits the business. That is the whole of it. The connector handles the movement; the settings decide the shape of the books the data lands in.