Shopify + QuickBooks problems after the Shopify Connector by QuickBooks migration

Practical fixes for U.S. store owners when sales, payouts, or bank feeds stop lining up after Intuit’s e-commerce connector rebuild—not tax or accounting advice.

Updated October 7, 2026 · Sources linked under each section.

Intuit replaced legacy OneSaas and Commerce connectors with Shopify Connector by QuickBooks inside QuickBooks Online. The new flow imports individual sales, refunds, fees, and payouts, then expects you to reconcile each payout before you touch the bank feed (Intuit migration overview).

Below are the five problems merchants report most often right after migration—and fix steps you can take with Intuit and Shopify documentation.

1. Duplicate Shopify sales after connector migration

What it looks like: The same order or amount appears twice in Sales Receipts, income looks inflated, or payout totals no longer tie.

Common causes: Import start date overlaps days you already brought in via the old connector, CSV, or manual entry; or two sync tools run at once.

Fix steps

1. Note your connector transaction sync start date and the last day covered by legacy imports.
2. If you can remigrate or adjust settings, set a start date that does not overlap prior imported data (Intuit migration article).
3. Disconnect other Shopify→QuickBooks apps or stop parallel CSV imports for the same period.
4. In Integration transactions (Accounting → Integration transactions or All apps → Accounting → Integration transactions), review For Review and Excluded for duplicate payout lines.
5. Before changing posted amounts, confirm each entry is a true duplicate (same order reference and amount). If the accounting period is closed or already filed, check with your accountant before voiding or deleting anything—Intuit’s cited migration help focuses on preventing overlap, not on how to void entries.
6. After duplicates are resolved in your books, match bank deposits as in section 3.

Sources: Intuit — Migrate to new e-commerce connectors; Intuit-published migration mirror.

2. Shopify payout not matching QuickBooks deposit or bank amount

What it looks like: Shopify’s net payout for a day does not equal the QuickBooks Deposit or the amount that hit your bank.

Common causes: Fees, refunds, or adjustment lines inside the payout were not categorized; payout confirmed before child transactions were Categorized; or timing (payout initiated vs bank received).

Fix steps

1. Export the payout from Shopify: Finance → Payouts → open payout → Export payout transactions (Shopify Help).
2. In Integration transactions, open the payout: ensure included sales/refunds show Categorized.
3. Assign accounts for every line under Funds in this payout.
4. Confirm the payout so QuickBooks creates a Deposit equal to the net payout (Intuit connect workflow).
5. Compare Shopify net, QBO Deposit total, and bank statement; document small timing gaps separately.

Sources: Intuit U.S. — Connect Shopify (three-step reconcile); Shopify — Export payout transactions.

3. Bank feed: used Add instead of Match on a Shopify deposit

What it looks like: Bank balance is right but income is overstated; Shopify deposits appear twice (once from connector Deposit, once from bank Add).

Common cause: Adding the bank line instead of matching to the Deposit Intuit created from the payout.

Fix steps

1. Finish Integration transactions for that payout (sales/fees, then payout confirm) first.
2. Go to Bank transactions (All apps → Accounting → Bank transactions, or Banking for your deposit account).
3. Select Match to the existing Deposit—not Add (Intuit connect article).
4. If you already Added, undo the bank entry per your accountant’s guidance, then Match correctly.

Source: Intuit U.S. — Connect Shopify (“Always use Match”; confirm Integration transactions before bank feed).

4. Undeposited Funds or For Review backlog won’t clear

What it looks like: Undeposited Funds (or Payments to deposit) stays high; payouts sit in Integration transactions while bank deposits already cleared.

Common cause: Individual Payment received rows not confirmed, or bank feed handled before payout workflow completed.

Fix steps

1. Work the For Review tab: Confirm or complete Review for missing customer/product/account mapping.
2. When Intuit creates Sales Receipts and fee Expenses, they remain in Undeposited Funds until the payout is confirmed (connector help).
3. Confirm the payout only when all included lines are Categorized.
4. Then Match the bank deposit as in problem #3.

Sources: Shopify Connector by QuickBooks help; Intuit U.S. connect article.

5. Fees or adjustments missing inside a payout

What it looks like: Deposit is a few dollars off; Shopify CSV shows fee or adjustment lines QBO did not map.

Common cause: Unassigned lines in Funds in this payout, or comparing gross sales to net bank deposit.

Fix steps

1. From Shopify Payments, export payout detail for a single deposit (Finance → Payouts → Export payout transactions, per Shopify Help). To compare a date range, export payouts for the date range from Shopify Payments (balance-transaction export paths vary by admin version—use Shopify’s current Payments export help if your menus differ).
2. In the payout row in Integration transactions, open Funds in this payout and assign fee, reserve, gift card, or tax adjustment accounts (connector settings defaults are editable).
3. Assign all lines in Funds in this payout before confirming the payout; if you already confirmed the payout and totals still do not tie, contact Intuit support at qbo-integrationsupport@intuit.com before changing posted amounts.
4. For period-level review, use Finance → Documents → Shopify Payments activity report (Shopify Help).

Sources: Shopify payout export and activity report URLs above; Intuit connector terminology on fees and adjustments in connector help.

FAQ

Why do I have duplicate Shopify sales in QuickBooks after the connector migration?

Duplicates usually mean your new connector import start date overlaps days already imported from the legacy OneSaas or Commerce app, a CSV, or a second sync tool. Intuit instructs you to choose a start date that does not overlap previously imported data. Turn off other Shopify-to-QuickBooks sync paths, then confirm each entry is a true duplicate before removing or undoing it in the overlap window (if that period is already closed, check with your accountant first) and only then match bank deposits.

Why doesn't my Shopify payout match my QuickBooks deposit or bank feed?

A Shopify payout is net of fees, refunds, and adjustments. In QuickBooks, confirm each sale, refund, and fee inside Integration transactions until they are Categorized, assign accounts on Funds in this payout, then confirm the payout to create a Deposit. The deposit total should equal the Shopify net payout and your bank deposit. Compare amounts using Shopify's export payout transactions CSV and your QBO Deposit detail.

Should I Add or Match Shopify deposits in the QuickBooks bank feed?

Use Match. Intuit's Shopify connect help says to confirm transactions from Integration transactions first, then Match the bank deposit to the Deposit created from the payout—not Add—which duplicates income.

Why is Undeposited Funds growing after I connected Shopify?

Sales and fees often sit in Undeposited Funds or Payments to deposit until you confirm the payout. If you Match bank deposits before individual Integration transactions are categorized, or you Add bank deposits instead of Match, balances drift. Finish Integration transactions for the payout, confirm the payout deposit, then Match in Bank transactions.

Where do I export Shopify payout details to compare with QuickBooks?

In Shopify admin, use Finance, then Payouts, open a payout, and Export payout transactions for one deposit. For a date range, export payouts for that range from Shopify Payments; menus vary, so use Shopify's current Payments export help. Compare those totals with your QBO Deposit and bank statement.

When to get help

Want the checklist and payout workbook as files? Get the $34 Connector Cleanup Kit on Gumroad (DIY file kit, not a service).