Key takeaways
What this article covers, in order:
- The payout that looks like income but isn't
- Every payout, broken down
- How Shopify, Etsy and Amazon payouts differ
- The clearing account method
- Inventory and cost of goods: the part sellers postpone
- A monthly e-commerce close checklist
Good bookkeeping for e-commerce sellers comes down to one rule: never record a marketplace payout as your sales. A payout is sales minus fees, minus refunds, minus whatever else the platform withheld, so you record each piece separately and then match the net amount to your bank deposit. Do that every payout and your profit numbers stay real.
The payout that looks like income but isn't
Jess sells hand-dyed yarn. She runs a Shopify store, an Etsy shop, and in Aug 2026 started listing her bestsellers on Amazon. On Sep 8, 2026 her bank shows a deposit of $1,486.30 from Etsy. Her first instinct is to log $1,486.30 as sales.
But the Etsy payment account statement for that payout period tells a different story. She sold $1,742.00 of yarn and collected $186.00 in shipping. Etsy took listing fees, transaction fees and payment processing fees. A customer got a $38.00 refund. The deposit is what's left.
If Jess books the deposit as revenue, three things go wrong at once. Her sales look lower than they were. Her fees disappear from her expenses, so she has no idea what selling on Etsy actually costs her. And when she compares channels, she's comparing net numbers on one platform with gross numbers on another.
That's the whole game in e-commerce bookkeeping. Break the payout back into its parts.
Every payout, broken down
Here's the general shape of a marketplace payout. The labels differ between Shopify, Etsy and Amazon, but the bones are the same.
| Line | What it is | Where it goes in your books |
|---|---|---|
| Gross product sales | What customers paid for items | Sales revenue |
| Shipping charged to customers | What customers paid for shipping | Shipping income (or sales, per your chart of accounts) |
| Sales tax collected | Tax the platform collected | A liability account, not income (many marketplaces remit it for you; ask your CPA how to show it) |
| Refunds | Money returned to customers | Sales returns and refunds (a contra-revenue account) |
| Platform/selling fees | Listing, referral, transaction or subscription fees | Expense: marketplace fees |
| Payment processing fees | Card processing charges | Expense: merchant fees |
| Advertising fees | Offsite or sponsored ads deducted from payouts | Expense: advertising |
| Reserves or holds | Money the platform is holding back | A clearing or "funds held" asset account |
| Net payout | What hits the bank | Matches the bank deposit |
The bottom row is the check. If your recorded pieces don't add up to the deposit, you've missed something.
How Shopify, Etsy and Amazon payouts differ
We're keeping this to the patterns that matter for your books, because each platform changes its reports and fee names from time to time. Always work from the payout report the platform gives you for that specific payout.
Shopify
If you use Shopify's own payment processing, payouts usually bundle several days of orders into one deposit, with processing fees taken out. Your monthly Shopify subscription and any app charges are typically billed separately, often to a card, so they won't show up inside the payout. Watch for orders paid through other gateways, which will deposit separately.
Etsy
Etsy payouts net off a mix of fees (listing, transaction, processing, and possibly offsite ads) and refunds. In many states Etsy collects and remits sales tax as the marketplace, and that shows up in the reports too. The payment account statement is your friend here.
Amazon
Amazon settlements are the most detailed and the most confusing. A single settlement can include product sales, shipping credits, promotional rebates, referral fees, fulfillment fees if you use their warehouses, storage fees, refunds and reimbursements. Settlements also don't line up neatly with calendar months, so one settlement can straddle two.
A word of caution on all three. Fee names and payout schedules change, and we don't want to pretend otherwise. Read the actual report. Don't rely on what a blog (including this one) says the fees are.
The clearing account method
This is the technique most bookkeepers use for marketplace sellers, and it'll save your sanity.
Create one clearing account per platform: "Shopify Clearing," "Etsy Clearing," "Amazon Clearing." Think of each as a holding tank for money the platform owes you.
- Record the sales side into the clearing account. For each payout period, post gross sales, shipping, tax collected and refunds into the clearing account using a journal entry or sales receipt.
- Record the fees out of the clearing account. Platform fees, processing fees and ad fees reduce the clearing balance and hit your expense accounts.
- Record the payout as a transfer. When the deposit lands in the bank, record it as a transfer from the clearing account to your checking account.
- Check the clearing balance. After each payout, the clearing account should be at zero, or equal to whatever the platform is still holding (reserves, sales after the payout cutoff).
When Jess does this, her Etsy deposit of $1,486.30 becomes a transfer, not income. Her $1,742.00 of sales and her fees all land in the right places. And if Etsy Clearing shows a leftover $62.14 at month-end, she knows exactly where to look: probably sales after the cutoff that'll pay out next time.
Inventory and cost of goods: the part sellers postpone
Fees are only half the cost picture. If you sell physical products, you also have cost of goods sold: what you paid for the yarn, dye, packaging and inbound shipping on the items you sold.
At a minimum, track what you buy as inventory purchases and estimate cost of goods sold each month. If inventory is a big part of your business, this is a good moment to get a CPA or bookkeeper to set up a method that fits. Inventory accounting has a few real choices (how you value it, when you count it) and getting it set up right once beats fixing it for years.
A monthly e-commerce close checklist
- [ ] Download every payout or settlement report for the month from each platform
- [ ] Post gross sales, shipping, tax collected and refunds to each platform's clearing account
- [ ] Post fees (platform, processing, ads) as expenses
- [ ] Match each bank deposit to a payout and record it as a transfer from clearing
- [ ] Review each clearing account balance and explain any leftover
- [ ] Record subscriptions and app charges billed to cards
- [ ] Record inventory purchases and update cost of goods sold
- [ ] Reconcile the bank account and the card used for platform bills
- [ ] Compare net margin by channel
That last line is the payoff. Once your books split fees out by platform, you can finally answer the question every multichannel seller has: which channel actually makes me money after fees?
Common mistakes we see
- Booking the deposit as sales. Covered above. It's the big one.
- Ignoring refunds that happen next month. A refund on Oct 3, 2026 for an order from Sep 28, 2026 belongs in the Oct 2026 books, recorded as a refund.
- Treating sales tax collected as income. It's money you're holding (or the platform is remitting), not revenue. Your CPA can tell you how to treat marketplace-remitted tax for your situation.
- Mixing personal and business purchases on the card you use for supplies.
- Letting clearing accounts drift. A clearing account with a growing, unexplained balance means something's being missed every payout.
How HelloBooks helps
To be clear up front: HelloBooks doesn't connect directly to Shopify, Etsy or Amazon. You'll work from the payout reports those platforms give you. Where HelloBooks helps is the bank side and the books themselves. You can connect most US banks and credit cards for a live feed, or import statements as CSV if a connection isn't available. Deposits from each platform come in through the bank feed, ready to match to your clearing account entries.
The Free plan gives you one live bank feed and up to 200 transactions a year, which suits a small shop just starting out. Busy sellers will likely hit that ceiling, and Starter ($14.99/month) adds AI auto-categorization and three bank connections, enough for a checking account, a savings account and a supplies card. Pro ($39.99/month) adds unlimited bank connections and multi-currency with auto FX, which matters if you sell internationally. Your P&L, Balance Sheet and Cash Flow reports come built in. See more on our Etsy seller page, the retail page, and plans and pricing.
FAQs
Should I record marketplace sales gross or net?
Gross. Record full sales as revenue and fees as expenses. Net recording hides your real costs and makes channel comparisons meaningless.
What's a clearing account and do I really need one?
It's a temporary holding account for money a platform owes you. It's the cleanest way to break a net payout into sales and fees and then match the deposit. One per platform is the usual setup.
My Amazon settlement covers two months. How do I handle it?
Split it by the transaction dates in the settlement report, posting each part to the month it belongs to. The clearing account absorbs the timing difference until the deposit lands.
Does HelloBooks pull orders from Shopify, Etsy or Amazon?
No. HelloBooks doesn't integrate with those platforms. You'll use their payout reports and record entries yourself, while HelloBooks handles the bank feed, categorization and reports.
How often should an online seller reconcile?
At least monthly. If you get payouts every few days and sell on several channels, weekly is easier than one big monthly sort.
Break the payout apart once, and every month after gets easier.
Start free, no credit card. Try HelloBooks Free
