Shopify accounting: payouts, clearing accounts, and revenue by channel
Short answer: Good Shopify accounting books gross sales, discounts, refunds, fees, and sales tax separately, runs every payout through a clearing account that should zero out, and recognizes revenue when an order is fulfilled rather than when it is placed. If your Shopify financial summary and your P&L disagree, the books need work before anyone builds a forecast on them.
Why a Shopify deposit is not your revenue
A Shopify payout is a net number. By the time it hits the bank, Shopify has already taken out processing fees, refunds, chargebacks, and sometimes reserves, and it may batch several days of orders together. Booking the deposit as “sales” understates revenue, hides your fees, and makes margin look better or worse than it is.
The fix is a clearing account. Gross sales, tax collected, shipping income, discounts, refunds, and fees post to it from the order data. The bank deposit posts against it. When everything is captured, the clearing balance goes to zero for each payout. A balance that keeps growing tells you something is missing.
Revenue when the order ships, not when it is placed
Shopify’s standard reports are built around when an order is placed. Under accrual accounting, revenue generally belongs in the period the order is fulfilled. That gap matters most for preorders, crowdfunding campaigns, and backorders, where cash arrives weeks or months before product ships and should sit in deferred revenue until it does.
“should be recognizing the revenue when the order is fulfilled, not when the order is placed. But the reports that Shopify gives you is always on order placed.”
— Saman Izadiyar
Saman described clients who came in already on accrual but still looking at revenue by order placed, with older campaign money still sitting in deferred revenue after the product had shipped. Middleware that pulls sales data from Shopify and other channels can post revenue on fulfillment automatically.
A chart of accounts by channel
If you sell on Shopify, Amazon, TikTok Shop, wholesale, or retail, one “Sales” line hides which channel actually makes money. Splitting revenue, fees, and cost of goods by channel lets you see contribution margin where you make decisions. Amazon and other marketplaces need their own settlement reconciliation, because fees, reimbursements, and reserves are netted the same way Shopify payouts are.
Retail and big-box remittances add another layer: chargebacks, slotting fees, and deductions mean the cash received can be lower than the invoice, and the gap has to be read line by line from the remittance.
A five-minute sniff test for your Shopify books
- When was the last bank and credit card reconciliation? If it is months behind, that is a red flag.
- Does the reconciliation report show discrepancies?
- Are the clearing accounts and loan balances actually reconciled on the balance sheet?
- Does the Shopify financial summary match revenue on your P&L for the same period?
- Does inventory on the balance sheet look reasonable compared with what is in the warehouse?
“Then I would look at my Shopify dashboard. I’m just going to call out Shopify directly and be like, do the numbers here on the financial summary match with what’s on my P and L?”
— Saman Izadiyar
Saman said that if two or more of these checks look off, he would question everything else in the file.
Clean books before a controller
Founders often ask for forecasts or a controller when the real problem is upstream: the data feeding the reports was wrong. Rebuilding the chart of accounts and cleaning up the balance sheet can answer the question on its own.
“I didn’t need a controller, I just needed a clean set of books.”
— Saman Izadiyar
Related reading: how multi-channel e-commerce accounting works, TikTok Shop accounting, and accountants who do sales channel reconciliation.
Take the quiz, or request quotes. Get a quote does not show matched firm names to visitors.
Frequently asked questions
What is a Shopify clearing account?
It is a holding account in your ledger. Order-level sales, tax, discounts, refunds, and fees post to it, and the net Shopify payout posts against it. When everything is recorded, it zeroes out for each payout.
Should I record Shopify payouts as revenue?
No. Payouts are net of fees, refunds, and sometimes reserves. Record gross sales and the deductions separately, then match the payout through a clearing account.
When should a Shopify store recognize revenue?
Under accrual accounting, revenue is generally recognized when the order is fulfilled. Cash from preorders or crowdfunding sits in deferred revenue until the product ships. Confirm your treatment with your accountant.
Do I need separate accounts for Amazon and Shopify?
Splitting revenue, fees, and cost of goods by channel makes it possible to see margin by channel. Amazon settlements also need their own reconciliation.
Does Ottit handle sales tax?
Ottit's Sam's List profile lists sales tax among its services. Ask Ottit directly about scope for your states and channels.
The full suite bookkeeping firm supporting fast-growth E-Commerce, SaaS and SMB companies with fast, accurate, and clean financials.
See Ottit’s profileRelated reading: signs your Shopify books won't survive due diligence, e-commerce bookkeeping cost, Amazon seller accounting, e-commerce accountants.
Some professionals on Sam’s List pay for visibility or leads. Inclusion and order do not rank professionals. This page is educational and is not tax, legal, or investment advice. Firm names are never shown on Get a quote matches.
Quotes and client examples are what Saman Izadiyar described; they are not a guarantee of results.