Shopify payouts do not match sales because a payout is not a day's sales. It is a batch of transactions, net of Shopify's fees, after refunds, adjustments and any reserve, paid on a date that can be days after the sales it contains. Sales paid for by other methods, such as other gateways, gift cards or manual payments, are not in it at all. Recording each payout as "sales" in QuickBooks therefore understates revenue, hides fees and makes the books hard to reconcile with Shopify's reports. A clearing account solves this. Record gross sales into it, record fees and refunds out of it, and treat each payout as a transfer from the clearing account to the bank. When the clearing balance equals the amount Shopify still owes you, the clearing account is reconciled.
What a payout actually contains
In the Shopify admin, payouts are listed under Finance > Payouts. Shopify's help explains that each payout's detail shows a breakdown of charges, refunds, adjustments, fees, reserves and retried payouts, and lists the transactions included in that payout. The transactions can be exported, per payout or for a date range, with Amount, Fee and Net columns. Net is the difference between the amount and the fee.
So the bank deposit for a payout is roughly:
charges − fees − refunds ± adjustments − reserves held (+ reserves released) = payout
Add timing to that. Shopify notes that pending amounts and payout dates are estimates, and that the final payout can change before the funds reach your bank. A sale made on the last day of a month may be paid out in the next month.
Why "deposit = sales" goes wrong
Recording each payout deposit as sales income causes four problems:
- Revenue is understated by the fees, because only the net amount is recorded.
- Fees never appear as an expense, so margins are misstated and fee changes can go unnoticed.
- Refunds and chargebacks disappear into a lower deposit, instead of showing as returns.
- Period-end sales are wrong. Sales made late in the month but paid out early next month fall into the wrong period.
Sales tax or VAT collected adds a fifth problem. If it sits inside "sales", it is not separated as a liability.
The clearing-account method
Set up one account in QuickBooks, for example Shopify Clearing, as an asset account. It represents money Shopify has collected for you but not yet paid out. Then record four kinds of entry.
1. Sales, gross, into the clearing account. For each day or each payout period, record the Shopify sales summary as gross figures: product sales, shipping income, discounts, and sales tax or VAT collected as a liability. Debit Shopify Clearing for the total collected through Shopify Payments. Sales paid by other methods go to their own clearing accounts, such as a PayPal clearing account, not this one.
2. Fees, out of the clearing account. Debit a merchant fees expense account and credit Shopify Clearing, using the Fee column from the payout export.
3. Refunds and chargebacks, out of the clearing account. Debit returns, refunds or chargeback accounts, and reverse the related tax where it applies. Credit Shopify Clearing.
4. Payouts, as transfers. When the payout arrives in the bank, record it as a transfer from Shopify Clearing to the bank account, as a single transaction affecting both accounts. If the deposit also comes through the bank feed, match it to that transfer rather than adding it again. Do not add it as income.
Reserves held back by Shopify stay in the clearing account until released, because they are still money owed to you. If you prefer to track them separately, use a second asset account for reserves.
Reconcile the clearing account monthly
At each month-end:
- Export Shopify's pending transactions, the sales not yet included in a payout. Note any reserve held, and any payout Shopify has sent that has not yet reached the bank.
- Compare the total with the Shopify Clearing balance in QuickBooks.
- The two should agree. If they do not, check for:
- a payout recorded as income rather than as a transfer;
- a fee or refund batch not recorded;
- sales paid through another method included in the Shopify Payments figure;
- a payout matched to the wrong transfer, or recorded twice from the bank feed.
A clearing account that keeps growing, or goes negative, is a sign that one of these entries is missing.
Summary entries or one per order?
One summary entry per day or per payout keeps the ledger readable, and the order detail stays in Shopify. Use one entry per order only if you need order-level detail in QuickBooks, for example for wholesale customers who are invoiced.
Integration apps can post these entries automatically. If you use one, check what it posts. Does it record gross sales and fees separately? Does it post payouts as transfers? Does the bank feed add the same deposit again? If both post the same deposit, it appears twice. Our post on duplicate transactions after reconnecting a bank feed covers how to find them.
Points to settle with your accountant
- Gift cards. Agree how gift card sales are recorded until the card is redeemed, and how unredeemed balances are treated.
- Sales tax or VAT. Check that the tax collected recorded in QuickBooks agrees with Shopify's tax reports for the period before filing returns.
- Multi-currency stores. Where customers pay in one currency and payouts arrive in another, record the exchange difference explicitly rather than leaving it in the clearing account.
Where this fits
The clearing account is the same idea as Undeposited Funds in QuickBooks: money received but not yet banked, held in one place until it is. The same discipline applies. The balance should always be explainable.
Wissen Solutions sets up and reconciles e-commerce clearing accounts as part of our QuickBooks Online and offshore accounting services.
Sources (checked 26 October 2026; Shopify updates its admin periodically)
- Shopify Help Center: Viewing and exporting your Shopify Payments payout details: Finance > Payouts, payout breakdown, export of payout and pending transactions, Amount, Fee and Net columns
- Intuit: Add and match bank feed transactions in QuickBooks Online
- Intuit: Transfer funds between accounts: a transfer is one transaction affecting both accounts