Quick answer: Your Shopify payout never matches your sales because Shopify deducts processing fees, refunds, chargebacks and dispute fees before paying you, includes sales tax and shipping you collected, and groups orders on its own schedule. To reconcile, record gross sales from Shopify’s reports, post each deduction to its own account, and match the net to each bank deposit.
Key takeaways
- A payout is a net, batched number, never your revenue.
- Fees, refunds and chargebacks each need their own account.
- Sales tax collected is a liability, not sales.
- Payouts that cross month-end must be split so each month keeps its own sales.
- PayPal and other gateways pay separately and need their own reconciliation.
Your Shopify dashboard says you sold $10,000 last week. Your bank says Shopify sent $9,205. The difference isn’t missing money. It’s fees, refunds, chargebacks, sales tax and timing, all netted out before the payout lands.
If your books record that $9,205 as sales, they’re wrong twice: revenue is understated and your costs are invisible. This guide explains what sits in the gap and how to reconcile Shopify payouts so your P&L shows what really happened.
What is a Shopify payout?
A Shopify payout is the net amount Shopify Payments transfers to your bank for a group of orders. It is your customers’ payments minus processing fees, refunds, chargebacks and any adjustments for that period. You can choose daily, weekly or monthly payouts, and your bank usually needs 1 to 3 business days to process each deposit.
Because a payout is a net, batched number, it will almost never equal the sales total for any single day or week.
Why doesn’t my Shopify payout match my sales?
Five things usually explain the gap.
1. Processing fees come out first. With Shopify Payments, you pay a credit card rate that depends on your Shopify plan, deducted before the payout. Those fees are a cost of doing business and belong in an expense account.
2. Refunds reduce the payout, sometimes weeks later. A refund on an order from last month comes out of this week’s payout. That’s why one week’s payout can look low for no obvious reason.
3. Chargebacks and their fees. When a customer disputes a charge, the amount is held or withdrawn, often with a dispute fee on top. If you win, the money comes back in a later payout.
4. Sales tax and shipping are inside the total. The customer paid tax and shipping, so they’re in the payout, but sales tax is money you owe the state, not revenue. Shipping charged to customers is income, and what you pay carriers is a separate expense.
5. Timing and other gateways. Orders are grouped into payouts on their own schedule, so a payout can span two months. And if customers also pay through PayPal, Shop Pay Installments or another gateway, those funds arrive separately and never appear in your Shopify Payments payout at all.
What does a reconciled payout look like?
Here’s one week, with illustrative figures.
| Item | Amount |
|---|---|
| Product sales | $9,000 |
| Shipping charged to customers | $400 |
| Sales tax collected | $600 |
| Total collected from customers | $10,000 |
| Refunds | −$350 |
| Processing fees | −$310 |
| Chargeback and dispute fee | −$135 |
| Payout to bank | $9,205 |
In the books, that one deposit becomes several entries:
- $9,000 product sales and $400 shipping income
- $600 to the sales tax liability account
- $350 to refunds (a reduction of sales, tracked on its own line)
- $310 to merchant processing fees
- $135 to chargebacks and dispute fees
The deposit ties out to the bank, and every dollar is explained.
How do you reconcile Shopify payouts each month?
This routine works whether you do it yourself or hand it to a bookkeeper.
- Export the payout report. In Shopify admin, open Payouts and export the transactions for the month. Each payout lists the orders, refunds, fees and adjustments inside it.
- Match each payout to a bank deposit. Every payout should equal one deposit. Flag any that don’t.
- Break each payout into its parts. Record gross sales, shipping, tax, refunds, fees and chargebacks to their own accounts, as in the example above. Tools like A2X can summarize payouts into these entries for QuickBooks or Xero.
- Handle month-end timing. Orders placed on the last days of the month may pay out in the next. Record them as a receivable from Shopify so the month’s sales are complete.
- Add other gateways. Reconcile PayPal, Shop Pay Installments and any other processors the same way, each against its own deposits.
- Check the totals. Sales in your books should match the Shopify sales report for the month. If they don’t, the difference is usually a missed refund, a gateway you forgot, or an order that changed after it was placed.
Why does this matter more in Q4?
Holiday volume multiplies every line in the table above. More orders mean more fees, more refunds in January and more chargebacks. If you’re already behind, December is the month the gap gets too large to untangle later.
It also matters for tax time. Payment processors report your gross payments to the IRS on Form 1099-K. For third-party payment networks, the federal threshold is $20,000 and more than 200 transactions, and payment card transactions have no threshold. A 1099-K shows the gross figure, before fees and refunds. If your books only recorded net payouts, you’ll need a reconciliation to explain why your reported revenue looks different from the form.
How do you reconcile payouts that cross month-end?
This is where most Shopify books go wrong, so it’s worth walking through. Say a weekly payout covers orders from December 28 to January 3, and lands in your bank on January 6.
| Part of the payout | December | January |
|---|---|---|
| Orders placed | $5,200 | $3,800 |
| Refunds processed | −$140 | −$90 |
| Processing fees | −$160 | −$118 |
| Net | $4,900 | $3,592 |
| Total payout on January 6 | $8,492 |
If you record the whole $8,492 in January, December loses $5,200 of sales and January gains them. Instead:
- In December, record $5,200 of sales, $140 of refunds and $160 of fees, with the $4,900 net as a receivable from Shopify.
- In January, record the January activity, then when the $8,492 deposit arrives, clear the $4,900 receivable and the January portion together.
Now each month holds its own sales. This matters most at year-end, because December’s figures feed your tax return and your 2027 planning.
How do you reconcile other payment methods?
Shopify Payments is often only part of the picture. Each payment method pays out on its own schedule and needs its own matching.
| Payment method | Where the money arrives | How to reconcile it |
|---|---|---|
| Shopify Payments | Shopify payout to your bank | Payout report, as above |
| PayPal | Your PayPal balance, then a transfer to your bank | Treat PayPal as its own bank account and reconcile it monthly |
| Shop Pay Installments | Usually inside your Shopify Payments payouts | Check how it appears in your payout report and match accordingly |
| Gift cards redeemed | No new cash, the customer already paid | Reduce the gift card liability and record revenue |
| Manual payments (bank transfer, cash on delivery) | Directly to your bank | Match each payment to its order |
| Marketplace sales synced to Shopify | Paid by the marketplace, not Shopify | Reconcile against that marketplace’s settlement reports |
The PayPal line catches many sellers out. Money that sits in a PayPal balance is still your cash, and fees and refunds come out of it too. If you only record the transfers to your bank, you’ll miss everything that happened inside PayPal.
How should shipping, discounts and gift cards be recorded?
Three items inside a Shopify order often end up in the wrong place.
Shipping. What customers pay for shipping is income. What you pay carriers and your 3PL is a cost. Keep them on separate lines so you can see whether shipping makes or loses money. Many brands find free-shipping thresholds cost more than they thought.
Discounts. Record sales at the full price with discounts on their own line, or record them net, but be consistent. Tracking discounts separately lets you see what promotions really cost, which is useful after a heavy Black Friday.
Gift cards. A gift card sold is a liability, not revenue. It becomes revenue when it’s redeemed. If gift card sales are counted as sales, December looks stronger than it was and the redemptions in January look like free goods.
Cash basis or accrual: which shows the truth?
On a cash basis, you record income when money arrives and expenses when they’re paid. On an accrual basis, you record sales when they happen and costs when they’re incurred, whatever the cash timing.
For a Shopify store, accrual books are usually the clearer picture. Payouts lag orders, refunds lag sales and inventory is bought months before it’s sold. Cash-basis books blend all of that into a monthly number that moves with your payout schedule, not your business.
Your tax filing may use a different basis than your management reports, which is normal. Your CPA can advise on the right basis for your return. For running the business, accrual-based monthly reports show what you actually earned.
Your monthly Shopify reconciliation checklist
- Export Shopify Payments payouts and transactions for the month
- Match each payout to a bank deposit
- Split each payout into sales, shipping, tax, discounts, refunds, fees and chargebacks
- Record month-end orders not yet paid out as a receivable
- Reconcile PayPal and any other gateway as separate accounts
- Move gift card sales to the liability account and record redemptions
- Reconcile sales tax payable to Shopify’s tax report
- Compare total sales in your books to Shopify’s sales report
- Investigate and fix any difference before closing the month
What to do when the numbers still don’t match
Even with a routine, some months won’t tie on the first pass. Most gaps come from a handful of causes, and each has a quick check.
| If you see | Likely cause | What to check |
|---|---|---|
| A payout with no matching deposit | Deposit still in transit, or sent to a different account | Shopify’s payout status and the bank account on file |
| A deposit with no matching payout | A PayPal transfer, a manual payment or a marketplace payout | The deposit description and other gateways |
| Sales in your books lower than Shopify’s report | Missed orders from another gateway, or payouts recorded as sales | That gross sales came from Shopify’s report, not deposits |
| Sales in your books higher than Shopify’s report | Gift cards recorded as sales, or an order counted twice | Gift card sales and duplicate imports |
| Fees far higher than usual | More international cards, disputes or a change in plan | The fee lines inside the month’s payouts |
| A payout lower than expected for no clear reason | A refund on an older order, a chargeback or a reserve | The adjustments section of that payout |
Work through the list in order. In most months, two or three of these explain the whole difference. If a gap remains after that, look for an order that was edited after it was placed, since changes to an order’s total can create small differences that are easy to miss.
The key is not to plug the difference with an adjustment you can’t explain. A small unexplained number this month tends to become a large one by year-end.
How does this look in practice?
Consider an illustrative skincare brand doing about $80,000 a month on Shopify, with PayPal as a second checkout. For most of the year, its bookkeeper recorded each Shopify payout as a single sales deposit. The P&L showed healthy revenue and almost no processing fees.
When the brand switched to recording gross sales and splitting each payout, three things changed. Revenue went up, because refunds and fees had been hiding inside the deposits. Processing fees appeared as their own line, at a little over 3% of card sales. And the PayPal balance, which had never been reconciled, turned out to hold several thousand dollars of sales and refunds that had never reached the P&L at all.
None of this changed the cash in the bank. It changed what the owner could see. With fees, refunds and PayPal on their own lines, the brand could finally compare the cost of each checkout option, spot that refunds spiked after a particular promotion and plan the January cash dip with real numbers.
That’s the practical case for reconciling payouts properly: not tidier books for their own sake, but numbers you can make decisions from.
Key terms
- Payout: the net amount Shopify Payments transfers to your bank for a group of orders.
- Payout period: the range of orders included in one payout, set by your payout schedule.
- Gross sales: the full value of orders before fees, refunds and other deductions.
- Net payout: what lands in your bank after every deduction.
- Chargeback: a payment reversed after a customer disputes it with their card issuer.
- Receivable from Shopify: money you’ve earned that Shopify hasn’t paid out yet.
- Accrual basis: recording sales when they happen and costs when they’re incurred, whatever the cash timing.
- Form 1099-K: the IRS form payment processors use to report your gross payments.
What are the most common Shopify bookkeeping mistakes?
- Recording payouts as revenue. The single most common error. It hides fees and refunds.
- Leaving sales tax in revenue. It inflates sales and leaves you short when the filing is due.
- Ignoring other gateways. PayPal sales disappear from the P&L.
- No month-end cutoff. Sales slide between months, and trends become meaningless.
- Guessing at chargebacks. Disputes won and lost need to be tracked so the net cost is clear.
For a broader look at keeping a Shopify store’s books clean, including returns and gift cards, see Bookkeeping for Shopify Businesses.
FAQs
Why is my Shopify payout less than my sales?
Because processing fees, refunds, chargebacks and dispute fees are deducted before the payout, and sales tax collected is included in it even though it isn’t revenue.
Should I record Shopify payouts as revenue?
No. Record gross sales from Shopify’s reports, then record fees, refunds, chargebacks and sales tax to their own accounts. The payout is the net result.
How long does a Shopify payout take?
It depends on your payout schedule. Once sent, Shopify says banks usually take 1 to 3 business days to process the deposit.
Do PayPal sales show up in my Shopify payout?
No. PayPal and other gateways pay out separately, so they need their own reconciliation.
How do I handle a payout that covers two months?
Record each month’s orders, refunds and fees in that month. Treat the part not yet paid at month-end as a receivable from Shopify, then clear it when the payout arrives.
Should I use cash or accrual accounting for my Shopify store?
Accrual usually gives a truer monthly picture for e-commerce, because payouts and refunds lag sales. Ask your CPA which basis to use for tax filing.
Is shipping income or a cost reduction?
Shipping customers pay is income. What you pay carriers is a separate expense. Keeping both lets you see whether shipping makes or loses money.
Can an app reconcile Shopify for me?
Apps like A2X can summarize payouts into journal entries, which saves a lot of time. Someone still needs to review exceptions and close the month.
Stop reconciling payouts by hand. CoCountant’s controller-led team syncs Shopify to QuickBooks, reconciles every payout to orders, fees and deposits, and signs off your close each month. Until December 31, the Year-End Offer includes 2 months of controller-led bookkeeping on us (12 for the price of 10) and 50% off our e-commerce add-on.
