When your Shopify and QuickBooks numbers don't match, it is usually because Shopify shows what you sold and QuickBooks shows the money that landed. The gap comes from fees, payout timing, refunds and chargebacks, held reserves, payments through another provider, or currency. Intuit's free connector brings Shopify Payments payouts into QuickBooks, but it doesn't tell you why a payout came in short, and it leaves other providers to you. So someone still checks each payout by hand. AI agents check them each week and tell you what's off.
Why Shopify and QuickBooks numbers don't match
Your Shopify sales report counts orders. Your bank, and QuickBooks, count payouts. A payout is what's left after fees, refunds and holds, for the days it covers. So the two numbers are rarely the same, even when nothing is wrong.
Shopify says this itself. Its activity report page says the report isn't a statement of revenue for your books, and that sales in your Finance reports can use different timing and totals. The work is finding which reason explains the gap, each week.
Six reasons they don't match
1Fees come off before the payout
Shopify's page on lower payouts says processing fees come off each sale before the payout is sent.
How to check: Open the payout and look at the fees line, or export its transactions: Shopify's file has Amount, Fee and Net columns. Then make sure the fees are in QuickBooks as an expense.
2A payout covers different days
Shopify counts in business days, and its payout timing page says payments from Friday, Saturday and Sunday are sent together as one payout. Once a payout is sent, your bank can take 1 to 3 more business days to show it. Month end is where this shows.
How to check: Match each payout to the sales dates it covers, not to the day it reached the bank.
3Refunds, chargebacks and adjustments
Shopify takes refunds out of your next payout. When a customer opens a dispute, the payment and the dispute fee come out too. Shopify says refunds and chargebacks can settle faster than sales.
How to check: Look for refund, chargeback and adjustment lines in the payout. Shopify lists adjustments such as chargeback fees and tax adjustments there.
4Money held in a reserve
Shopify's reserves page says a reserve holds part of your sales, and sometimes all of it, for a set time to cover refunds and disputes. Shopify sends the terms by email and pays back what's left at the end.
How to check: On the Payouts page, look for the Reserve section. Shopify only shows it when money is being held.
5Orders paid another way
Shopify's payout pages and its activity report cover Shopify Payments only. Orders paid through PayPal or another provider land in your bank on their own. Shopify's fees page also says stores using another provider pay Shopify a transaction fee on top of that provider's fees.
How to check: Filter your orders by payment method and match each provider's deposits on their own.
6A different currency
Shopify's page on payouts in more than one currency says stores on the Basic, Grow and Shopify plans are paid in their home currency, with a fee to convert sales made in other currencies. Refunds go back in the currency of the order.
How to check: Compare the payout currency to the order currency in the payout details, and look for conversion fees.
How to check one Shopify payout against QuickBooks
If you want to find the gap yourself, start with one payout.
- 1
Open the payout in ShopifyFrom your Shopify admin, go to Finance, then View payouts. Open one payout to see its charges, refunds, adjustments, fees and reserves.
- 2
Export what's inside it
Export the transactions for that payout. Each line shows the amount, the fee and what was left.
- 3
Find the deposit in QuickBooksIf you use Intuit's connector, add the payout from its App transactions tab first, then use Match in the bank feed. Intuit says not to add the deposit by hand.
- 4
Match the parts, not just the total
Check that sales, fees and refunds each landed in the right account. A deposit can match the bank while the sales and fees inside it are wrong.
- 5Check the month as a whole
At month end, open the Shopify Payments activity report under Finance, then Documents. It shows sales, fees, refunds, chargebacks and payouts for the dates you set. Write down each gap and its reason from the list above.
Where the Shopify QuickBooks connector stops
Intuit's QuickBooks Online app is free with your QuickBooks plan. It brings in sales, refunds, fees and payouts. It does not explain a payout. Here is what its own pages and its reviews show is still done by hand.
Each payout needs a person before it goes in. Intuit's guide says each adjustment line in a payout needs an account set before you add it. Products that don't match by SKU or name are not added for you, so someone makes them in QuickBooks by hand. The app also brings in no more than 12 months of past sales.
Other providers are left out. Intuit's guide covers Shopify Payments payouts, and Shopify's own activity report leaves out PayPal and other providers too. Their deposits get matched by hand.
The numbers can move after you look. Shopify says pending payouts are estimates, and the final amount can change because of refunds, chargebacks and reserves.
Updates can change your books. The app has a 4.6 rating from more than 3,300 reviews on the Shopify App Store. But after Intuit moved stores to a new version, many low reviews from September and October 2026 say the same things. The new version made its own income and fee accounts, put each sale under one general customer, added tax codes, and no longer kept payment methods separate. Several say they now do more by hand than before.
In a 20-person store, that checking lands on the owner or the bookkeeper, most often at month end, when the gap is biggest.
The agents that check it for you
Each week they pull your Shopify payouts, match each one to QuickBooks line by line, and tell you what doesn't match and why.
Know what sold and what to fix next.
- Pulls sales, ad spend and ordersevery Monday
- Compares it to last weekevery Monday
- Sends it with what to fix nextMonday morning
Know what sold without building the report.
- Pulls sales from your store, wholesale and QuickBooksevery Monday
- Compares it to last weekevery Monday
- Sends it to your teamMonday morning
Questions
Is my customers' information safe?
Yes. Agents work in your own Shopify and QuickBooks and see only what their job needs. Customer details never go into public AI. Agents connect to AI through business-grade connections audited under SOC 2.
Will the agent fix my books?
It finds each gap and tells your bookkeeper what it is and where. Your bookkeeper decides the fix.
We use a connector app already. Why do they still not match?
A connector moves the payouts in. It doesn't explain why a payout is lower than your sales, and Intuit's covers Shopify Payments only. The six reasons above still apply, and each payout still needs a check.
Why is my Shopify payout less than my sales?
Shopify lists the reasons: fees, refunds, chargebacks, adjustments, reserves, currency conversion and a negative balance from past refunds. Open the payout to see which ones apply.
What does it cost?
You get the price on the call, along with the hours it saves your team.
Sources
- help.shopify.com: lower or missing payouts
- help.shopify.com: payout timing
- help.shopify.com: reserves
- help.shopify.com: pay periods and fees
- help.shopify.com: payouts in multiple currencies
- help.shopify.com: view details
- help.shopify.com: payouts activity report
- quickbooks.intuit.com: L8bw6PiWJ ROW en
- apps.shopify.com: reviews