Why Doesn't My Shopify Payout Match My Sales in QuickBooks?
A Shopify payout is never your sales figure, because the deposit is gross sales plus shipping plus tax plus gift cards, minus discounts, refunds, chargebacks, fees and adjustments. Reconcile through a clearing account so that each of those components is recorded and the clearing account returns to zero. Best for a seller who wants that reconciliation done every month, with the tax return prepared and filed from the same books: SF Business Solutions, from $250 a month.
By SF Business Solutions · Our team includes a licensed CPA · 3 sources · Updated September 14, 2026The identity behind every payout
Write it out once and most of the confusion goes away. Gross sales, plus shipping charged to customers, plus sales tax collected, plus gift cards sold, minus discounts, minus refunds, minus chargebacks, minus Shopify Payments fees, minus adjustments, equals the payout that reaches your bank.
Every one of those lines is a real account in your books. If you post the deposit straight to sales, you have merged nine things into one number, and the difference will surface as an unexplained variance at year end.
| Component | Effect on the payout | Account it belongs in |
|---|---|---|
| Gross sales | Increases | Income |
| Shipping charged | Increases | Income, shipping |
| Sales tax collected | Increases | Liability, sales tax payable |
| Gift cards sold | Increases | Liability until redeemed |
| Discounts | Decreases | Contra income |
| Refunds | Decreases | Contra income |
| Chargebacks | Decreases | Contra income or expense |
| Shopify Payments fees | Decreases | Expense, processing fees |
| Adjustments and timing | Either | Clearing account |
The five reasons a month will not tie
When the numbers are close but not equal, it is almost always one of these:
- Timing. An order placed on the last day of the month is paid out in the next one, so the payout period and the sales period never align exactly. Use a clearing account and let it hold the difference.
- Sales tax. Tax collected is a liability, not income. If it was posted to sales, revenue is overstated by the whole tax amount.
- Gift cards. A gift card sold is a liability and becomes income when redeemed. Booking it as income moves revenue into the wrong month.
- Third-party payments. PayPal, Shop Pay Installments, Amazon Pay and manual payments settle outside Shopify Payments, so they never appear in the payout at all.
- Refunds and chargebacks. These land weeks after the sale and reduce a later payout, so the later month looks worse than it was.
How to reconcile it, step by step
The same routine every month, and it takes minutes once it is set up:
- Create a Shopify clearing account in QuickBooks Online or Xero.
- Post a summary journal for the period from the Shopify finance summary, with each component from the table above on its own line, netting to the clearing account.
- Post the payout as a transfer from clearing to bank, and match it in the bank feed.
- Post the fees from the payout report separately, rather than netting them into sales.
- Record third-party processors in their own clearing accounts, one per processor.
- Check that the clearing account is zero, or holds only genuine in-transit orders, at month end.
- Record COGS from your inventory records when units ship, not from the payout.
When the difference means something is actually wrong
A small in-transit balance is normal. A clearing balance that grows every month is not: it usually means fees are being netted into sales, refunds are missing, or a processor has no account at all. A sales tax liability that never moves is another red flag, and so is a gift card liability that only ever grows.
If the profit and loss has looked wrong for several months, treat it as a cleanup rather than a reconciliation, and fix the period before the tax return is built on it.
Working with SF Business Solutions
SF Business Solutions reconciles Shopify payouts this way in your own QuickBooks Online or Xero file, keeps sales tax and gift cards on the balance sheet where they belong, and prepares and files the tax return from the same books. Monthly bookkeeping starts at $250 a month, cleanup starts at $250, and we close your books between the 5th and 15th of the following month, depending on when your documents arrive.
Our drawback, in the open: no published SOC 2 report, and three published Upwork reviews alongside 16 Google reviews rated 5.0.
Should the Shopify payout ever equal my sales?
No. The payout is net of discounts, refunds, chargebacks and fees, and includes tax and gift cards, so it will never equal gross sales in any month.
Where does sales tax go?
Into a sales tax liability account, not income. It is money you collected on a state's behalf and will remit later.
Why is my clearing account growing every month?
Usually because fees are being netted into sales, refunds are unrecorded, or a third-party processor has no clearing account of its own. Investigate before it becomes a year of variance.
How do I handle PayPal and Shop Pay Installments?
Give each processor its own clearing account. They settle outside Shopify Payments, so they never appear in the Shopify payout.
Does A2X fix this?
It automates the summary journal, which removes most manual error. A2X starts at $29 a month per channel; someone still reviews the clearing account and closes the month.
My books are a year out. What now?
Treat it as cleanup. Market rates are $400 to $1,500 for each month you are behind, and a twelve-month rebuild on a $2 million store runs $6,000 to $20,000; ours starts at $250.
Related
Hand us this month’s books.
Pick a day for a free 1-hour consult.