E-commerce
Why your Shopify payout never matches your sales (and how to fix it)
November 18, 2026 · 10 min read

Quick answer
Your Shopify payout is your sales after processing fees, refunds, chargebacks, reserves and adjustments come out, and it includes sales tax and shipping you collected, so it will almost never equal 'sales'. Timing makes it worse: each payout covers sales from earlier days, and PayPal or other gateways pay you separately. The fix is a Shopify clearing account: record gross sales into it, record fees and refunds against it, and let each bank deposit empty it.
You open the Shopify dashboard: $42,000 of sales in October. You open the bank: $38,345 of Shopify deposits. Nearly $3,700 is unaccounted for, and your bookkeeping software has been quietly recording each deposit as "sales," which means your revenue is wrong too.
Nothing is missing. Shopify pays you a net amount that mixes revenue with things that aren't revenue (sales tax you owe the state), costs (fees), reversals (refunds and chargebacks) and timing (last week's sales).
This post explains what comes out of a Shopify payout and why, shows a worked month from gross sales to the bank, and sets up the clearing-account method that makes every payout reconcile to the penny.
How do Shopify payouts work?
When a customer pays through Shopify Payments, Shopify transfers the money to the payout account you set up: a checking account or a Shopify Balance account. A few details from Shopify's Help Center explain most of the confusion:
- Payouts are grouped. You can choose daily, weekly or monthly payouts (some countries limit the choices). One deposit usually covers many orders, sometimes from several days.
- There's a settlement delay. Shopify counts business days only; weekends and holidays don't count, and charges from a weekend are grouped and paid together. Settlement time varies by country, and Shopify says funds can take another 1 to 3 days to show in your bank after they're paid out. Payouts to Shopify Balance can arrive within 1 business day.
- Other gateways aren't included. PayPal and other third-party payment methods pay you separately and don't appear in the Shopify Payments activity report.
So on any day, some sales are paid out, some are in transit and some aren't paid yet. That alone means monthly sales won't match monthly deposits.
What gets deducted from a Shopify payout?
Shopify's help page on lower or missing payouts lists the usual suspects. Here's what each one is and where it belongs in your books.
| Item | What happens | Where it goes in the books |
|---|---|---|
| Processing fees | Deducted from each transaction before the payout is sent | Expense: merchant or processing fees |
| Refunds | Deducted from your next available payout | Contra revenue (refunds and returns), plus any sales tax refunded |
| Chargebacks | The disputed amount and dispute fee are deducted | Contra revenue or loss, plus a fee expense; reversed if you win |
| Reserves and holds | Part of a payout held back for a period | Still your asset: a receivable from Shopify, not an expense |
| Adjustments | Can raise or lower a payout | Depends on the cause; look at the payout detail |
| Currency conversion | Foreign-currency sales converted, fees may apply | Fee expense, or a foreign exchange gain or loss |
| Negative balance | Past fees or refunds bigger than earnings come out of later payouts | Nets against the next payout through the clearing account |
A few notes on the details:
Fees vary. Shopify says your credit card rate depends on your Shopify plan, with different rates for domestic and international cards. Rather than guessing a percentage, take the actual fee from each payout's detail, which lists the fee on every transaction.
Chargebacks hit fast. Shopify's chargeback page says the cardholder's bank takes the disputed amount right away and charges a chargeback fee, deducted from your next payout. If you win, the money comes back, and Shopify might refund the fee depending on your country or region. An inquiry, by contrast, doesn't take money right away.
Reserves aren't lost money. A reserve is a temporary hold on part (sometimes all) of your transactions to cover possible chargebacks and refunds. Shopify describes fixed-amount reserves and percentage-based ones, for example 10% held for 120 days. That money is still yours, just not yet.
What's usually not in the payout. Your Shopify subscription, apps and shipping labels come through your Shopify bill, which you pay with the payment method on your billing profile (a card, or Shopify Balance). They're real expenses, but they reach your books from the bill, not from the payout.
A worked month: $42,000 of sales, $38,345 in the bank
Say you run a Shopify store selling hand-poured candles. Here's October:
- Gross product sales were $42,000, and you gave $2,000 of discounts.
- Customers paid $2,400 for shipping and $2,600 of sales tax on top.
- So customers paid $45,000 in total at checkout.
- $3,000 of that was paid with PayPal, which deposits separately.
- Shopify Payments fees for the month were $1,290.
- You refunded $1,800.
- One $200 order turned into a chargeback, and with the dispute fee $215 came out.
- $1,100 of late-September sales were paid out in early October.
- $1,450 of sales from October 30 and 31 weren't paid out until November.
From Shopify sales to October's bank deposits
Hypothetical candle store, Shopify Payments plus PayPal
- Adds
- Reduces
- Total
Hypothetical example. 42,000 − 2,000 + 5,000 (shipping 2,400 + sales tax 2,600) = 45,000; 45,000 − 3,000 PayPal − 3,305 (fees 1,290 + refunds 1,800 + chargeback 215) − 350 (September paid in October +1,100, October paid in November −1,450) = 38,345.
Show the numbers
| Gross sales | $42,000 |
| Discounts | −$2,000 |
| Shipping and sales tax charged | +$5,000 |
| Paid by customers | $45,000 |
| Paid via PayPal | −$3,000 |
| Fees, refunds and chargeback | −$3,305 |
| Payout timing (net) | −$350 |
| Shopify deposits in October | $38,345 |
Every dollar of the $3,655 gap between gross sales and deposits is explained. And look at what the deposits contain: $2,600 of sales tax that belongs to the state, $2,400 of shipping income, and $1,100 that was September's revenue. If you'd booked $38,345 as October sales, revenue would be wrong, the sales tax liability would be missing, and fees wouldn't show up as an expense at all.
How does the clearing-account method work?
A Shopify clearing account is a current asset account in your books that stands between Shopify and the bank. Everything Shopify owes you passes through it. The rules are simple:
- When sales happen, record them at gross: debit the clearing account; credit sales, shipping income and sales tax payable separately.
- When refunds, chargebacks and fees happen, record them against the clearing account.
- When the payout lands, debit the bank and credit the clearing account.
If everything is recorded, the clearing account's balance at month-end equals what Shopify still owes you: sales not yet paid out, plus any reserve. In our example, that's the $1,450 from October 30 and 31. If the balance is anything else, something is missing, and you can find it payout by payout.
Here's one payout from the candle store, on October 14:
| Entry | Debit | Credit |
|---|---|---|
| Orders: Shopify clearing | $6,480 | |
| Orders: Product sales | $5,800 | |
| Orders: Shipping income | $330 | |
| Orders: Sales tax payable | $350 | |
| Refund: Refunds and returns | $225 | |
| Refund: Sales tax payable | $15 | |
| Refund: Shopify clearing | $240 | |
| Payout: Bank | $6,052 | |
| Payout: Merchant processing fees | $188 | |
| Payout: Shopify clearing | $6,240 |
The clearing account goes up $6,480, down $240, down $6,240: back to zero. The bank deposit of $6,052 matches the payout exactly, fees are an expense, the refund reduces revenue, and the sales tax liability is right. Run PayPal through its own clearing account the same way.
Apps that sync Shopify with QuickBooks Online or Xero can post these entries payout by payout. Check that yours records gross sales and fees separately, not just the net deposit.
Sales tax collected isn't revenue
This is the most expensive mistake in e-commerce bookkeeping. The $2,600 your candle customers paid in sales tax isn't yours. It's money you're holding for the states, and it belongs in a liability account until you file and pay.
Shopify is clear about who's responsible: it doesn't remit US sales tax for you unless your sales tax is managed by Shopify or you're enrolled in automated filing with Shopify Tax. Your own store is different from selling on Amazon or Etsy, where the platform usually acts as a marketplace facilitator and collects and remits for you. On your own Shopify site, you're the seller.
If you're selling into many states, our post on sales tax nexus explains when you have to register, and the sales tax calculator helps you sanity-check what you're charging.
Don't forget the cost of what you sold
A clean payout reconciliation fixes revenue, fees and sales tax. It doesn't touch cost of goods sold. The wax, wicks, jars and boxes in October's orders are a separate entry, usually from inventory, and they're what tells you whether each candle actually makes money. Our COGS calculator walks through the math, and the marketplace seller profit calculator shows profit per order after fees, shipping and ads.
How to reconcile Shopify payouts each month
Gather
- Export each payout's transactions (Finance > Payouts, open the payout, export)
- Download the Shopify Payments activity report for the month (Finance > Documents)
- Get statements for PayPal and any other gateway
Record
- Sales, discounts, shipping and sales tax at gross into the clearing account
- Refunds, chargebacks and fees against the clearing account
- Each payout as a transfer from clearing to the bank or Shopify Balance account
Prove
- Every bank deposit matches one payout to the penny
- Clearing balance equals sales not yet paid out plus any reserve
- Sales tax payable matches Shopify's tax report for the month
- Shopify Balance, if you use it, reconciled like any other bank account
Shopify itself says the activity report is meant for month-end reconciliation and accountant handoff, but it isn't a statement of revenue for accounting purposes. Use the Finance reports for revenue, and the payout detail for each deposit. If the report and your books disagree, Shopify suggests checking date ranges and time zones, payout timing, currency and third-party payment methods first. Those four explain most mismatches.
Common mistakes
Booking deposits as sales. Revenue ends up net of fees and refunds, sales tax becomes "income," and fees disappear from the P&L.
Forgetting PayPal and other gateways. They have their own deposits, fees and timing. Give each one its own clearing account.
Treating reserves as fees. A reserve is money held, not money lost. Expensing it understates profit and leaves an asset off the balance sheet.
Ignoring the clearing balance. If it creeps up every month, something isn't being recorded (often refunds or chargebacks). If it goes negative, a deposit was probably recorded twice.
When should you get help?
If you have one sales channel, Shopify Payments only, and a sync app that posts gross sales and fees, you can likely run this reconciliation yourself in under an hour a month.
It gets harder with several channels (Shopify, Amazon, wholesale), multiple currencies, frequent chargebacks, reserves, or sales tax in several states. That's when small timing errors compound into a balance sheet nobody trusts. Fintrix Consulting works with e-commerce businesses on exactly this, and our bookkeeping service keeps the books in your own QuickBooks Online or Xero file.
Frequently asked questions
Why is my Shopify payout less than my sales?
Processing fees, refunds, chargebacks, reserves and adjustments come out before the payout is sent. The payout also includes sales tax and shipping you collected, and it covers sales from earlier days, so the two numbers measure different things.
Should I record Shopify sales from the payout or from orders?
From orders, at gross. Record sales, shipping and sales tax separately into a clearing account, then let each payout clear it. Recording only the net payout hides fees and mixes sales tax into revenue.
Is sales tax collected through Shopify my income?
No. It's a liability you owe the states. Shopify doesn't remit US sales tax for you unless it's managed by Shopify or you've enrolled in automated filing with Shopify Tax.
Where do I find what's in each Shopify payout?
In your Shopify admin under Finance > Payouts. Open a payout to see its transactions, fees and net amounts, and export them to a CSV for your bookkeeping.
The bottom line
A Shopify payout isn't your sales. It's your sales plus tax and shipping, minus fees, refunds, chargebacks and reserves, shifted by a few days. Record the pieces at gross through a clearing account, and let each deposit empty it. When the clearing balance equals what Shopify still owes you at month-end, your revenue, fees and sales tax are all right, and the bank deposit stops being a mystery.
Sources
- Shopify Payments payouts (Shopify Help Center)
- Payout timing (Shopify Help Center)
- Lower or missing payouts (Shopify Help Center)
- Viewing payout details (Shopify Help Center)
- Reserves (Shopify Help Center)
- Pay periods and fees (Shopify Help Center)
- Chargebacks and inquiries (Shopify Help Center)
- Payouts in multiple currencies (Shopify Help Center)
- Shopify Payments activity report (Shopify Help Center)
- Collecting sales tax in the United States (Shopify Help Center)
This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.
More articles
- Amazon settlement reports: how to reconcile every deposit
November 18, 2026
- Audit, review or compilation: what your bank actually needs
November 18, 2026
- Why monthly bank and credit card reconciliations matter
November 18, 2026
Have a question about this article?
Ask us. A real person will reply by email within one business day. Your question isn’t published.
Ready for books you can trust?
Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.