Maya sells handmade ceramic mugs. Her Shopify store had a good October, and her bookkeeping system recorded every Shopify deposit as "Sales." Tidy, right? Except her revenue came out lower than her store reported, her fees seemed to be zero, and the sales tax she owed was hiding inside her income.
Nothing was missing. It was just all squished together, like a smoothie you have to un-blend.
Maya is hypothetical, but the setup is very common. Here's how Shopify payouts reconciliation works, with an example you can follow line by line.
Why the deposit never matches your sales
A Shopify Payments payout is a batch of activity netted together before the money hits your bank:
- Customer charges (product, shipping and sales tax, all in one number per order)
- Minus refunds issued during the period
- Minus processing fees
- Minus or plus adjustments, like chargebacks, chargeback reversals or reserves
A payout can also cover more than one day of orders depending on your payout schedule and weekends. So the deposit on Tuesday rarely equals Tuesday's sales report. That's normal. Your job is to unpack it.
If you're not yet sure why this matters for your whole P&L, start with our explainer on why your Shopify dashboard isn't your P&L.
Where to find the payout detail
In Shopify admin, open the payouts page (in recent versions it sits under Finances) and click into a single payout. You'll see the list of transactions in that payout: charges, refunds, adjustments and the fee total. You can export that detail to a CSV.
Two things to keep in mind:
- Only Shopify Payments transactions appear there. Orders paid through PayPal or another gateway settle separately, with their own fees and their own deposits.
- Gift card redemptions don't produce cash in the payout, because the cash came in when the gift card was sold.
A worked example, line by line
Say one payout from Maya's store lands in her bank for $8,751.60. The payout detail shows:
| Component | Amount |
|---|---|
| Charges (includes product, shipping and tax) | $9,200.00 |
| Refunds | ($180.00) |
| Fees | ($268.40) |
| Net payout | $8,751.60 |
Her order report for the same orders breaks the charges into product sales of $8,120, shipping charged of $600 and sales tax collected of $480.
The journal entry looks like this:
| Account | Debit | Credit |
|---|---|---|
| Checking (bank deposit) | $8,751.60 | |
| Merchant processing fees | $268.40 | |
| Sales returns and refunds | $180.00 | |
| Product sales | $8,120.00 | |
| Shipping income | $600.00 | |
| Sales tax payable | $480.00 | |
| Totals | $9,200.00 | $9,200.00 |
Now revenue is recorded at the full amount, fees show up as an expense, tax lands as a liability, and the bank side equals the actual deposit. (In real life a refund may include some tax and shipping too. If yours do, split them the same way.)
The clearing account method
Most ecommerce bookkeepers don't book every payout by hand like that. They use a clearing account, a temporary holding account that sits between the store and the bank.
It works in two steps:
- Record each day's sales summary into a "Shopify Clearing" account: debit clearing, credit sales, shipping income and sales tax payable. Record refunds and fees against clearing too.
- When the payout lands, record a transfer from clearing to checking for the deposit amount.
If everything is right, the clearing account returns to zero (or to the amount of payouts still in transit at month end). A balance that keeps growing tells you something is off: a missed refund, a chargeback, or a payout that never got recorded.
QuickBooks users may notice this works a lot like Undeposited Funds, which holds payments until they're grouped into a deposit. If that account has ever confused you, our piece on Undeposited Funds in QuickBooks and why your bank balance disagrees with your books is worth a look.
Some stores use a sync app to create these summaries automatically. That's fine. Apps still need someone checking that the clearing account actually clears.
How to reconcile Shopify payouts in QuickBooks each month
Here's the monthly routine:
- Export the payouts list for the month from Shopify.
- Confirm each payout is recorded in QuickBooks as a transfer from clearing to checking, for the exact deposit amount.
- Compare total sales, shipping, tax, refunds and fees in QuickBooks to Shopify's reports for the month.
- Look at the clearing account balance at month end. It should equal payouts in transit (sales Shopify has processed but not yet deposited).
- Investigate any leftover difference. Chargebacks and reserves are the usual suspects.
- Then reconcile the checking account to the bank statement as normal.
Step six is its own skill, and we cover it in the bank reconciliation process, step by step. Payout reconciliation makes it much easier, because each deposit already has a known match.
Common snags
A few things trip people up more than others:
- Chargebacks. The disputed amount and a chargeback fee come out of a later payout. Record the reversal of the sale and the fee separately so you can see what disputes are costing you.
- Currency. If you sell internationally, conversion can create small differences between the order value and the payout.
- Payouts in transit at month end. Sales from the last day or two of the month often land in next month's bank account. That's what the clearing balance is for.
- Recording deposits as revenue. The original sin of Shopify bookkeeping. It understates sales and hides fees.
If this all sounds like a lot to do every week, our ecommerce accounting team handles payout reconciliation as part of a reviewed monthly close.
Questions owners ask
Why is my Shopify payout less than my sales?
Payouts are net of processing fees, refunds and any chargebacks or adjustments. They may also include orders from more than one day. The payout detail page in Shopify lists each piece.
Should I record Shopify deposits as sales?
No. Recording the net deposit as sales understates revenue, hides your fees, and mixes sales tax into income. Record gross sales, tax, shipping, refunds and fees separately, then match the net to the deposit.
What is a Shopify clearing account?
It's a temporary account that holds sales activity until the payout arrives in your bank. When the books are right, it zeroes out or equals payouts still in transit at month end.
Want more notes like this?
The ABFI Accounting Brief sends short, practical notes on books, closes, reconciliations and CPA handoffs, written for owners and the people who keep their books. Join The ABFI Accounting Brief for the next issue. If your clearing account has become a junk drawer, a consultation is the gentler next step.