- Intuit's Shopify connector imports each sale, refund and fee, plus every payout, into QuickBooks Online. B2B orders arrive as invoices.
- Payouts are recorded as deposits from Undeposited Funds, which is what makes the bank reconciliation work.
- It imports up to a year of history. Products it can't match by SKU or name have to be created in QuickBooks by hand.
- Check whether stock quantities, other sales channels and more than one store fit your setup before relying on it.
- For a single store it's often enough. Wholesale volume, many channels and real inventory usually need more.
A scene at the bank reconciliation
The bank shows one deposit from Shopify. QuickBooks shows dozens of sales from the same days. The bookkeeper needs them to agree.
The deposit is net. Fees came out. A refund from last week came out. A chargeback adjustment came out.
Then there are the wholesale orders, paid on terms by bank transfer, and the marketplace sales that went through a different channel entirely. Each needs its own path into the books.
Reconciling one store's payouts is a solved problem. Reconciling the whole business takes more thought.
What the built-in connection handles
Intuit offers its own Shopify connector for QuickBooks Online, set up from QuickBooks. From Intuit's help center, as of November 2026:
- Sales come in per order, as a sales receipt with products, shipping, discounts and taxes, plus an expense for the fees.
- Refunds come in per order, with amounts, taxes and products.
- Payouts come in as deposits that move the net amount from Undeposited Funds to your bank. Adjustments in a payout are mapped to accounts before it's added.
- B2B orders arrive as invoices, with their payments linked.
- Taxes collected by Shopify are recorded, including marketplace taxes on Shop app sales.
- Products and customers can be matched to existing QuickBooks records, or rolled into a default item and customer if you turn tracking off.
You can import up to a year of past transactions. Intuit says the first import can take a few hours for a busy store.
Where it stops
The connector focuses on sales and money. The gaps tend to show up as the business grows:
- New products. If a product doesn't match an existing QuickBooks item by SKU or name, it isn't created for you. Someone adds it by hand.
- Stock quantities. Intuit's help center describes matching products to inventory items. Check whether on-hand counts and cost of goods behave the way your accountant expects.
- Other sales channels. Check whether marketplace and point-of-sale sales arrive through the same connector, or need their own path.
- More than one store. Setup describes connecting a single store. Check how separate stores or regions map to your books.
- Wholesale on terms. B2B orders arrive as invoices, and Intuit says paid status goes back to Shopify when an invoice is marked paid in QuickBooks. Check how your team handles credit terms and partial payments.
- Reviewing volume. Unless you turn on automatic adding, each transaction waits for review. At high volume, that becomes a job.
Per-order detail is useful. It can also crowd QuickBooks for a store with thousands of orders a month. Some businesses prefer summary entries per payout, and that's a decision for your accountant.
Your options
Use Intuit's connector as it is. One store, one payment provider, simple inventory: it's likely enough. Intuit maintains it, and it handles payouts well.
Add a third-party accounting app. The Shopify App Store lists several apps that post sales to QuickBooks, some in daily or per-payout summaries, some with inventory and multi-channel support. Compare them against your gaps, with your accountant.
Build a custom connection. This makes sense when wholesale, several channels, an ERP or a warehouse system are in play, and no app fits without workarounds. Since January 1, 2026, new custom apps are built in Shopify's Dev Dashboard and installed on your store.
Often the best answer keeps the connector for sales and payouts and builds only the piece it doesn't cover.
What a custom connection usually adds
- New products created in QuickBooks with the right accounts as soon as they're listed.
- Wholesale orders, terms and partial payments kept in step between both systems.
- Every channel's sales landing with the same structure, so margin by channel is a report.
- Stock and cost of goods kept consistent with your warehouse or ERP.
- A daily exceptions list: payouts that don't tie out, refunds without a match, orders that didn't post.
Our financial reporting page shows what clean, connected numbers make possible at month-end.
Signs you've outgrown the connector alone
Stores rarely outgrow the connector overnight. The signs build up month by month:
- Payouts don't tie out, and finding the difference takes hours.
- Someone creates new products in QuickBooks by hand every week.
- Wholesale accounts are invoiced or chased outside both systems.
- Marketplace or retail sales are added from spreadsheets at month-end.
- Stock in QuickBooks, Shopify and the warehouse never quite agree.
If none of these sound familiar, Intuit's connector is doing its job. Leave it alone.
Questions to answer before you build
Settle these with your bookkeeper or accountant first:
- Do we want per-order detail in QuickBooks, or summaries per payout or per day?
- Which channels and payment providers do we sell through, and where does each one land today?
- Where does inventory really live: Shopify, QuickBooks, a warehouse system or an ERP?
- How do wholesale terms, partial payments and credits work for our B2B customers?
- Who on our team has the Shopify and QuickBooks admin rights a connection needs?
Those answers are the scope, and the measure of whether a custom connection paid off.
Who owns the access
A store owner or staff member with the right permissions installs the custom app and approves what it can access, and your QuickBooks admin approves the QuickBooks side. The store keeps control and can remove access at any time. Our guide on vendor approval for integrations explains why that matters.
What most guides miss
Reconcile to payouts. The bank sees payouts, not orders. If every payout ties out, the sales detail underneath is usually right.
Fix SKUs first. Matching runs on SKU and name. Clean, unique SKUs in both systems prevent most product problems.
Decide detail with your accountant. Per-order or summary, by channel or combined. Settle it before anything is connected, because changing it later is slow.
How we do it
We start with a free intro call and a look at one month's payouts against your books. Then we work alongside your team and your accountant, keep what Intuit's connector does well and build what's missing. See our Shopify and QuickBooks integration pages for more.
