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.
Why the numbers differ
A Shopify Payments payout is never just "the sales for that day". Every payout is:
| Line | Effect 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:
- Fees weren't posted, so QuickBooks only has the gross amount. This is the most common one.
- A refund, chargeback or adjustment in the payout isn't in QuickBooks.
- An order is missing or at the wrong amount. Edited orders and orders paid in another currency are frequent culprits: some connectors post the original or pre-conversion amount.
- Other payment methods are mixed in. PayPal, gift card and manual payments don't go through Shopify Payments, so they aren't in the payout.
- Timing. A payout usually contains orders from a few days earlier, so it crosses days and sometimes months.
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
- In Shopify admin, go to Finance → Payouts and click the payout with the same amount and date as the bank line.
- 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).
- 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
- 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.
- 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.
- Compare the total of the ticked sales with the payout's charges. Any difference is missing or wrong-amount orders.
- 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
- Add any missing orders or refunds first (see missing orders and missing refunds).
- 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.
- 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.
- 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.