If you sell on Shopify and your books record the payout that lands in the bank as your sales, your books are wrong, and in a way that quietly costs you. The payout is a net number: Shopify has already taken its fees and netted off refunds, and the amount still includes sales tax you collected and owe to the state. Recording that one figure as revenue collapses four different things into one line. Below: what is inside a payout, how to book it in QuickBooks with a clearing account, the same method in Xero, and how to spot it when it has gone wrong.
What’s actually inside a Shopify payout
A payout bundles several items that belong in different places in your books. Here is one, taken apart.
| Line | Amount |
|---|---|
| Product sales | $4,860.00 |
| Discounts | ($310.00) |
| Shipping charged to customers | $285.00 |
| Sales tax collected | $298.20 |
| Refunds | ($240.00) |
| Charged to customers, after refunds | $4,893.20 |
| Processing fees | ($146.04) |
| Payout to the bank | $4,747.16 |
Example only: a made-up business. The figures add up but belong to no real client.
Book only the $4,747.16 deposit as sales and every line above it disappears. Sales are understated by $112.84, fees vanish, refunds vanish, and $298.20 of tax you owe is sitting in revenue. Each line has its own home:
| In the payout | Where it belongs |
|---|---|
| Product sales | Sales, the real revenue before anything is deducted. |
| Discounts | A discounts account under income, so you can see what promotions cost. |
| Shipping charged | Shipping income, set against what postage really costs you. |
| Sales tax collected | Sales tax payable, a liability you owe the state. Never income. |
| Refunds and chargebacks | A refunds account under income, so the refund rate stays visible. |
| Processing fees | Merchant fees, an expense you can see and manage. |
| The payout itself | A transfer from a Shopify clearing account to your bank. |
How Shopify payouts work
Shopify Payments collects your customers’ card payments, holds them briefly and sends them to your bank in batches. You choose a daily, weekly or monthly payout schedule, and Shopify notes that US stores can receive some payouts sooner than scheduled, and more than one payout a day. After a payout is sent, banks typically take one to three business days to post it.
Three things follow for the books:
- Payouts cross month ends. Sales from March 30 and 31 can arrive in April. At month-end those are payouts in transit: real sales, not yet cash.
- A deposit is rarely one day’s sales. It is whatever batch Shopify sent, net of that batch’s fees and refunds, so you can only check it against the payout report, not against a day’s orders.
- Not everything comes through Shopify Payments. PayPal and other gateways pay out on their own, and chargebacks, chargeback fees and Shopify Capital repayments come out of payouts. Your subscription and app charges usually arrive as a separate Shopify bill, which you book as software from the bill itself.
How to record Shopify sales in QuickBooks
The reliable method is a clearing account: a holding account between Shopify and your bank. Everything from the payout report goes in, the bank deposit comes out, and when both sides are booked the account is back to zero.
- Create the clearing account once. In your chart of accounts, add a bank-type or other current asset account called “Shopify clearing”. One per channel if you also sell on Amazon or through PayPal.
- Book each payout from the payout report. Sales, shipping income and sales tax as credits; discounts, refunds and processing fees as debits; the net amount to Shopify clearing. A daily summary works too, as long as every payout is covered once.
- Match the bank deposit as a transfer. When the payout lands in the bank feed, match it as a transfer from Shopify clearing to your checking account, never as new income.
- Reconcile the clearing account at month-end. What is left in it should equal the payouts still in transit. Anything else is a missing payout, a double entry or a fee booked twice.
| Account | Debit | Credit |
|---|---|---|
| Shopify clearing | $4,747.16 | |
| Merchant fees | $146.04 | |
| Discounts given | $310.00 | |
| Refunds | $240.00 | |
| Sales | $4,860.00 | |
| Shipping income | $285.00 | |
| Sales tax payable | $298.20 | |
| Totals | $5,443.20 | $5,443.20 |
Example only: a made-up business. The figures add up but belong to no real client.
If QuickBooks tracks your sales tax through its sales tax center, record the sales through a sales receipt (or a summary app) with the right tax rates instead of a journal entry, so the tax lands where your sales tax return will look for it. The clearing account works the same way.
There are three ways to get the numbers in. A low-volume store can enter one summary per payout by hand. Busier stores often use a summary app, such as A2X, that posts one entry per payout. Be wary of setups that push every single order into QuickBooks: they clutter the file and, with the bank feed adding the deposit as well, often count sales twice. If you would rather not run any of this yourself, that is what our QuickBooks Online bookkeeping services do every month.
Recording Shopify payouts in Xero
The method is identical; only the screens change. Add a “Shopify clearing” account (many bookkeepers set it up as a bank account in Xero so it can be reconciled like one). Post each payout from the payout report as a manual journal, or as a summary invoice if you want Xero’s sales tax tracking to see it. When the deposit appears in your bank feed, reconcile it as a transfer from Shopify clearing. At month-end, the clearing balance should again equal the payouts in transit.
Keeping your books in Xero? Our Xero bookkeeping services handle the payouts and the rest of the monthly close in your own file.
Signs your payouts are booked wrong
- Revenue in your books is lower than your Shopify dashboard shows.
- You can’t see processing fees as their own expense line.
- Gross margin swings wildly month to month for no real reason.
- There’s no sales tax liability on your balance sheet despite collecting it.
- A Shopify clearing account that never comes back to zero, or no clearing account at all.
- Your 1099-K shows far more than your books. It reports gross payments before fees and refunds, which is why your 1099-K is higher than your sales on a payout-only P&L.
Why your Shopify payouts don’t match QuickBooks
Usually it is one of five things: a payout sent in one month and deposited in the next; two payouts on the same day matched to one entry; fees, refunds or chargebacks netted out of the deposit but not booked; sales tax included in the deposit but missing from your sales figure; or a payment that came through PayPal or another gateway instead of Shopify Payments. Working payout by payout through the clearing account finds each of them.
Common questions
Is a Shopify payout the same as revenue?
No. A payout is a net figure. Processing fees, refunds, chargebacks and any Shopify Capital repayment have already come out, and the amount still includes sales tax you collected. Revenue is the gross sales figure before those deductions and without the tax.
Where do Shopify payouts go in QuickBooks?
Into a Shopify clearing account, not straight into income. The sales, fees, refunds and sales tax go into that account from the payout report, and the bank deposit is matched as a transfer out of it. When both sides are in, the clearing account is back to zero.
How do I record Shopify payouts in QuickBooks?
Book one entry per payout from the payout report: sales, shipping and sales tax as credits; fees, discounts and refunds as debits; the net to Shopify clearing. Then match the bank deposit as a transfer from that account. The steps and an example entry are above.
Do Shopify fees count as an expense?
Yes. Transaction and processing fees are a business expense and should appear on the profit and loss as merchant fees, not be hidden by booking only the net deposit.
Does Shopify do bookkeeping for me?
No. Shopify keeps the order, payout and tax reports, which are the raw material, but it does not reconcile your bank, record your other expenses or produce a balance sheet. You still need accounting software, and someone to keep it right.
Can I give my bookkeeper access to Shopify?
Yes. As the store owner you can add a staff account and choose its permissions, for example Reports and View payouts, so your bookkeeper can download payout and order reports without touching products, orders or settings.
Do I need an app to connect Shopify to QuickBooks?
Not always. A low-volume store can book one summary entry per payout by hand. Busier stores often use a summary app that posts one entry per payout. Avoid setups that post every order and also let the bank feed add the deposit: that counts sales twice.
Not sure your payouts are booked right? A free books review tells you. Add us as your accountant, and within about 48 hours you get a written list of what is misclassified or unreconciled. It is free, yours to keep, and nothing in your books changes.