Shopify pays you the net of each payout: sales minus refunds, fees, chargebacks, reserves and adjustments. Intuit's connector is meant to group those lines into one QuickBooks deposit that equals the bank amount, which you then match in the bank feed. When it doesn't match, a line is missing, uncategorised or posted twice. Compare the payout's breakdown in Shopify with the QuickBooks deposit, line by line.
How a payout gets into QuickBooks
Shopify doesn’t send you each sale. It collects payments, takes off fees, refunds and other deductions, and sends one net amount: the payout. Your bank shows that one number.
Intuit’s rebuilt Shopify connector (see our guide to the 2026 connector change) is built around this. According to Intuit’s setup guide:
- Sales, refunds and fees sync from Shopify and wait under Integration transactions (also called App transactions) for you to confirm.
- Each payout becomes a Deposit that moves the net amount from Undeposited Funds into the bank account you chose as the deposit account. Fees, adjustments, reserves, holds and disputes, gift cards and tips each go to their own account.
- In Bank transactions, QuickBooks suggests a match between the Shopify deposit in your bank feed and that Deposit. You match it. You never add it.
So the deposit in QuickBooks should always equal the bank deposit. When it doesn’t, something in steps 1 or 2 is incomplete.
Intuit says this payout-level matching works for Shopify and Amazon only. For WooCommerce, BigCommerce, Etsy, eBay, Wix and Squarespace it’s “planned for a future release”.
What’s in a payout
Open Finance > Payouts in Shopify and click a payout. The breakdown shows:
| Line | What it is | Where the connector posts it |
|---|---|---|
| Charges | Customer payments | The synced sales (sales receipts or invoices) |
| Refunds | Money returned to customers | Synced refunds |
| Fees | Card processing fees, plus tax on fees in some countries | The Fees account |
| Adjustments | Chargeback fees, tax adjustments and other corrections | The Adjustment account |
| Reserves | Money Shopify holds back against future disputes | The Reserve balance account |
| Retried amounts | An earlier payout that failed and is being sent again | Not documented by Intuit |
Chargebacks come out of your next available payout, along with any dispute fee. If you win the dispute, you get the amount back. The Shopify page on this doesn’t say which payout it comes back in.
Why the deposit doesn’t match, and what to do
| Symptom | Where to look | Fix |
|---|---|---|
| No match suggested for the Shopify deposit | Integration transactions: are all sales in that payout confirmed? | Confirm the missing sales. Intuit says every sale in the payout must be categorised before the deposit is created. |
| QuickBooks deposit is higher than the bank | The payout breakdown in Shopify vs the QuickBooks deposit lines | Usually a missing fee, refund, chargeback or reserve line. Check the adjustment lines all have an account selected. |
| QuickBooks deposit is lower than the bank | Same comparison | Usually a refund or adjustment posted twice, or a reserve released back to you that isn’t recorded |
| Income too high, bank balance right | Bank feed history for that date | The payout was added instead of matched. Undo it in the bank feed and match it to the connector’s deposit. See duplicate Shopify sales. |
| Orders from several days in one payout | Payout transaction list in Shopify | Normal. Sales settle after a few business days, and Friday to Sunday payments are grouped into one payout. |
| Two payouts on one day | Payouts page in Shopify | Normal. Shopify says one payout date can hold more than one payout. Match each one separately. |
| Payout is in a different currency from your sales | Payout details, which can be split by currency | Shopify may convert the payout and charge for it. Intuit’s guides don’t say how the connector records conversion. Check the deposit against the bank amount, and ask your accountant how to book the difference. |
| Fees missing entirely | The Fees account for the month | Check the connector’s Fees mapping in its settings, then re-confirm the payout. |
| Payout shows “Deposited” but isn’t in the bank | Payout status in Shopify | “Deposited” means sent, not received. Allow 1 to 3 business days, then ask your bank using the bank reference on the payout. |
| A payout “Withdrawn” from your bank | Payout status in Shopify | In some regions Shopify debits your bank when the balance is negative, for example after large refunds. Intuit’s guide has a Payment account for money you owe Shopify; check it’s set. |
Reconcile one month, step by step
- Export the payouts. In Shopify, go to Finance > Payouts and export all payouts for the month. Each row has the date, charges, refunds, adjustments, fees, reserved funds, total and bank reference.
- Confirm everything waiting in QuickBooks. Clear Integration transactions before touching the bank feed. Intuit’s guide is explicit about the order.
- Check each payout has one deposit. In QuickBooks, list deposits to your Shopify deposit account for the month. You want one deposit per Shopify payout, for exactly the same total.
- Match in the bank feed. For each Shopify line in Bank transactions, accept the suggested match or use Find other match. Don’t add or categorise Shopify deposits.
- Work through the leftovers. For each payout that doesn’t match, export that single payout’s transactions from Shopify and compare them line by line with the QuickBooks deposit. The difference is almost always one line from the table above.
- Check the fee and adjustment accounts. Total fees in Shopify’s export for the month should equal the Fees account in QuickBooks. Do the same for refunds and reserves.
- Reconcile the bank account as usual once every payout is matched.
If a payout is wrong in a period your accountant has already closed, don’t change it yourself. Ask how they want it corrected.
What merchants tell us
In our analysis of 118 merchant complaints about the Shopify–QuickBooks sync, 7 were about payouts, fees or deposits not matching the bank. The typical story: sales look right, but the bank account won’t reconcile, because a fee or refund didn’t come through with the payout.
When a different sync makes sense
If many payouts need fixing by hand every month, the connector may not fit how you sell. Payout-summary tools such as A2X and Link My Books post one summary per payout, built from Shopify’s own payout report. Order-by-order syncs such as MyWorks Sync and Webgility post every order and group them into a deposit through a clearing account. Whichever you choose, fix the open months first so the new sync starts from clean books.
Questions people also ask
Should I match or add the Shopify payout in the bank feed?
Match. Intuit's guide says never to add the Shopify deposit manually in the bank feed, because the connector has already recorded the sales and fees. Adding it records the income twice.
Why doesn't QuickBooks suggest a match for my Shopify deposit?
QuickBooks only suggests a match when an existing record has the same amount and a nearby date. If the connector's deposit is missing a fee, refund or adjustment line, the amounts differ and no match appears. Fix the deposit first, then match.
Why are several days of sales in one payout?
Shopify settles payments after a few business days, and weekend sales are grouped into one payout. One payout can cover several days of orders, and one day can have more than one payout.
Does Intuit's connector reconcile payouts from WooCommerce, BigCommerce or Etsy too?
Not yet. Intuit's migration guide says payout-level reconciliation works for Shopify and Amazon, and is planned for other channels in a future release.
My payout went to Shopify Balance, not my bank. What now?
Intuit's Shopify guides don't cover Shopify Balance. Make sure the connector's deposit account is the account the money actually lands in, and ask your accountant how to record transfers out of Balance.
Sources
- Intuit: Connect Shopify to QuickBooks Online (US, updated 3 August 2026)
- Intuit: Migrate to the new QuickBooks Online e-commerce connectors
- Intuit: Match your bank and credit card transactions in QuickBooks Online
- Shopify Help Center: Viewing and exporting your Shopify Payments payout details
- Shopify Help Center: Lower or missing payouts
- Shopify Help Center: Payout timing
- Shopify Help Center: Chargebacks
- Wield analysis of 118 merchant complaints about the Shopify–QuickBooks sync (115 Shopify App Store reviews and 3 Trustpilot reviews, collected November 2026)