How to Record Shopify Payouts in QuickBooks Online
The single most common bookkeeping error in e-commerce is treating a Shopify payout as sales revenue. It is not. A payout is what is left after Shopify has deducted its fees, netted off refunds, and held back anything in dispute — and it arrives days after the sales it relates to. Categorise it as income in your bank feed and you will understate revenue, hide thousands in fees, and misstate the sales tax you owe. This guide shows the correct way to record Shopify payouts in QuickBooks Online.
Why a Shopify payout is not your revenue
When a customer pays $100 on your Shopify store, several things happen at once. You earn $100 of gross sales. You may have collected sales tax on top. Shopify Payments takes a processing fee. If that customer later returns the item, a refund is deducted. Days later, Shopify sends you a single net figure.
Say you sold $10,000 in a payout period, collected $800 of sales tax, paid $320 in Shopify fees, and refunded $400. The payout landing in your bank is $10,080. If you categorise that deposit as "Sales", you have recorded $10,080 of revenue when your actual gross sales were $10,000, you have recorded no fee expense at all, no refunds, and you have quietly treated $800 of sales tax you owe to a state as if it were your own money.
Every figure in a payout is a different account. Sales revenue, sales tax payable, processing fees and refunds must be separated. A single bank-feed categorisation cannot do that.
The clearing account method
The reliable approach is a clearing account — a holding account that represents money Shopify owes you but has not yet paid. Sales flow in, deductions flow out, and the payout empties it.
Step 1. Create the account. In QuickBooks Online go to Accounting → Chart of Accounts → New. Account type Bank (or Other Current Asset), name it Shopify Clearing. Making it a Bank type lets you reconcile it, which is the whole point.
Step 2. Record gross sales into the clearing account. For each payout period, create a journal entry or sales receipt that puts the gross figures in:
- Debit Shopify Clearing — gross sales plus sales tax collected plus shipping charged
- Credit Sales Revenue — gross product sales
- Credit Shipping Income — shipping charged to customers
- Credit Sales Tax Payable — tax collected, a liability, not income
Step 3. Record the deductions out of the clearing account.
- Debit Merchant Processing Fees — Shopify Payments and gateway fees
- Debit Refunds and Returns — a contra-revenue account, not an expense
- Debit Chargebacks — if any were deducted
- Credit Shopify Clearing — the total deducted
Step 4. Record the payout as a transfer. When the money lands, it is not income — it is a movement between two accounts you already own. Use + New → Transfer, from Shopify Clearing to your bank account, for the exact payout amount. In the bank feed, match the deposit to that transfer rather than categorising it.
The check that proves it worked
After the transfer, your Shopify Clearing balance should equal the amount Shopify is still holding — sales made but not yet paid out. Open your Shopify admin, go to Finances → Payouts, and compare the pending balance to your clearing account balance.
If they agree, every dollar is accounted for. If they do not, something is missing, and you have found it in minutes rather than at year end. This one reconciliation is the reason the clearing method is worth the extra step.
A worked example
Payout period sales of $10,000, shipping income $250, sales tax collected $800, Shopify fees $320, refunds $400. Shopify deposits $10,330.
Debit Shopify Clearing 11,050 Credit Sales Revenue 10,000 Credit Shipping Income 250 Credit Sales Tax Payable 800Debit Merchant Fees 320Debit Refunds and Returns 400 Credit Shopify Clearing 720Transfer: Shopify Clearing → Bank 10,330
Clearing account nets to zero for the period. Revenue reads $10,000, not $10,330. Fees of $320 appear as an expense you can actually see and manage. And $800 sits in Sales Tax Payable where it belongs, waiting for the filing.
Sales tax is the part that bites
Sales tax you collect is never your income. It is money held in trust for a state, and it belongs on the balance sheet as a liability until you remit it. Recording it as revenue overstates profit, inflates your tax bill, and leaves you with no record of what you owe.
It gets harder if you sell across state lines. Economic nexus rules mean crossing a sales or transaction threshold in a state can create a filing obligation there, and the thresholds differ by state. If you are shipping nationwide, that is worth reviewing properly rather than assuming.
Handling Shop Pay Installments, gift cards and third-party gateways
- Shop Pay Installments — you are typically paid up front less a higher fee, while the customer pays over time. Record the fee where it falls; the instalment risk is not yours.
- Gift cards — selling one is a liability, not revenue. Revenue is earned when the card is redeemed. Credit a Gift Card Liability account on sale, and move it to revenue on redemption.
- PayPal, Amazon or other gateways — each settles separately and needs its own clearing account. Do not pool them; you lose the ability to reconcile any of them.
Doing it monthly instead of per payout
If you take dozens of payouts a month, entering each one is unrealistic. Use Shopify's Finances summary report for the month, post one summary journal entry with the same structure, and record the individual payouts as transfers from the clearing account.
The clearing account still has to reconcile at month end, which is what keeps a summary approach honest. If it will not clear, the summary is wrong somewhere and needs unpicking before you close.
The errors we see most often
- Categorising the payout as Sales in the bank feed. Fastest route to books that look fine and are wrong.
- Booking refunds as an expense. Refunds are contra-revenue. As an expense they inflate both revenue and costs, distorting your gross margin.
- Ignoring fees entirely. At roughly 3% of sales, a $500k store is losing $15,000 a year into a number nobody is tracking.
- No clearing account. Without one there is nothing to reconcile, so errors accumulate silently.
- Treating sales tax as income. Overstates profit and leaves no record of the liability.
Once sales are recorded properly you can see your real numbers. Run them through our profit margin calculator to see what you actually keep, and our inventory turnover calculator to check how much cash is sitting in stock.
Stop Guessing at Your E-Commerce Books
Multi-channel sales, inventory and multi-state sales tax are where small-business books quietly break. Our Ex-PwC Chartered Accountants set this up properly, once.
Working from downloaded statements? Our free bank statement converter turns a PDF into a QuickBooks-ready CSV in your browser — nothing is uploaded.
Talk to an E-Commerce BookkeeperFrequently Asked Questions
Do not categorise it as income. Record gross sales, shipping and sales tax into a Shopify Clearing account, record fees and refunds out of it, then record the payout itself as a transfer from the clearing account to your bank. The deposit is a movement of money you already own, not new revenue.
Because payouts are net of fees, refunds and chargebacks, and they arrive days after the sales. Gross sales for a period will almost never equal the cash deposited in that period. The gap is exactly what a clearing account is designed to hold.
No. Sales tax collected is money held in trust for a state and belongs in a Sales Tax Payable liability account until you remit it. Recording it as income overstates your profit and leaves no record of what you owe.
Post them to a Refunds and Returns contra-revenue account, not to an expense account. Contra-revenue reduces gross sales to net sales, which keeps your gross margin accurate. Booking refunds as an expense inflates both revenue and costs.
Yes. Each payment processor settles on its own schedule with its own fees. Pooling them into one clearing account means you cannot reconcile any of them individually, which defeats the purpose.