Books Watchdog

QuickBooks Online

Shopify payout doesn't match the bank deposit in QuickBooks

The bank feed shows a deposit from Shopify, but there's nothing in QuickBooks it will match, or the only candidate is off by a few dollars. Here's how to take a payout apart and make it match.

Updated 11 November 2026

Why the numbers differ

A Shopify Payments payout is never just "the sales for that day". Every payout is:

LineEffect on the deposit
Card charges from several days of orders+ gross order amounts
Refunds made in the same period− refunded amounts
Shopify Payments processing fees− fees for each charge
Chargebacks, reserves, currency conversion and other adjustments− or +

Your bank receives the net amount. In QuickBooks, a connector that posts orders one by one usually puts each sale into Undeposited Funds (called Payments to deposit in some screens) at the gross amount. To match the bank line, those sales, minus refunds and fees, need to be grouped into one deposit for the net payout. The match fails when any piece is missing or wrong:

Using Intuit's own Shopify Connector? It posts one sales receipt per order, the fees as a separate expense, and one deposit per payout that moves the net amount to your bank account. Its entries are listed under All apps → Accounting → Integration transactions. If a payout won't match, look there first for a deposit that's missing or at a different amount.

Check by hand

1. Break the payout down in Shopify

  1. In Shopify admin, go to Finance → Payouts and click the payout with the same amount and date as the bank line.
  2. The payout page lists every charge, refund, fee and adjustment in it. To get them as a spreadsheet, use the export icon → Export payout transactions (Shopify emails you the CSV).
  3. Note four numbers: total charges, total refunds, total fees and total adjustments. Together they add up to the deposit.

2. Find the same pieces in QuickBooks

  1. Click + Create → Bank deposit. Pick the bank account Shopify pays into. The list of payments in the deposit window shows everything sitting in Undeposited Funds.
  2. Tick the sales from the payout's charge list. If an order from the payout isn't in that list, it either never synced or was already deposited somewhere else.
  3. Compare the total of the ticked sales with the payout's charges. Any difference is missing or wrong-amount orders.
  4. Close without saving if you're only checking.

3. Check the bank feed

Go to All apps → Accounting → Bank transactions (older layouts: Banking or Transactions → Bank transactions). Find the deposit on the For review tab. If the suggested match is wrong or missing, click Find other match to see what's close. A candidate that's off by exactly the fee total tells you the fees are missing.

Fix it

  1. Add any missing orders or refunds first (see missing orders and missing refunds).
  2. Record the deposit. In + Create → Bank deposit, tick the payout's sales. Under Add funds to this deposit, add a line for the fees as a negative amount to your merchant fees expense account, plus lines for refunds or adjustments if they aren't already in the ticked list. The deposit total must equal the payout. Save it.
  3. Match it in the bank feed: back in Bank transactions, the deposit you created now appears as a match for the bank line. Choose Match it, then Post.
  4. Stop it happening again. Turn on fee and payout posting in your connector's settings, if it has them, so the next payout matches by itself.

Don't use "Add" on the bank line to record the whole payout as income if the orders are already in QuickBooks: that counts the same sales twice.