Ecommerce bookkeeping is different from regular small business bookkeeping for one core reason: the money that lands in your bank account is not your revenue. This guide is for Shopify, Amazon, and multi-channel sellers who want books that show true sales, true margins, and a sales tax setup that will not bite later.
We see the same pattern with online sellers again and again. The store is growing, the deposits look healthy, and the books quietly tell a different story than the business. Almost every time, the cause is one of three things: payouts booked as revenue, inventory handled wrong, or sales tax treated as an afterthought.
Payouts are not revenue: the number one ecommerce bookkeeping error
When Shopify or Amazon sends you money, that deposit is a net number. It bundles your gross sales minus platform fees, payment processing, refunds, chargebacks, and sometimes advertising costs. Booking the deposit as “sales” makes two errors at once: it understates your revenue and it hides your real costs.
A simple illustration: a store sells $10,000 in a payout period. The platform withholds $300 in processing fees and $200 for refunds, and deposits $9,500. Booked correctly, the books show $10,000 of revenue, $300 of fees, and $200 of refunds. Booked as a $9,500 deposit, the books show a smaller business with mysteriously thin costs. Every downstream number, from gross margin to your tax return, inherits the error.
The fix is to record the components of each payout, not the deposit total. A clearing account per channel, reconciled monthly against the platform’s settlement reports, keeps this honest.
Inventory is an asset, not an expense
The second habit that distorts seller books: expensing inventory the day you buy it. Inventory you have not sold yet is an asset sitting on your balance sheet. It becomes an expense, cost of goods sold, only when the item sells.
Why it matters:
- Your margins depend on it. Gross margin is the single most important metric in a product business, and you cannot compute it without real COGS.
- Big buys distort everything. Expense a $20,000 container of stock in March, and the books show a catastrophic March. April through June then look fake-profitable.
- Platform fees are not COGS. Shopify and Amazon fees are selling expenses. Mixing them into product cost hides which products actually make money.
Sales tax: what California sellers actually owe
Good news first. Under California’s Marketplace Facilitator Act, marketplaces like Amazon collect and remit California sales tax on your marketplace sales. Per the CDTFA, you do not even need a seller’s permit when every retail sale runs through a registered marketplace.
The catch: the moment you sell through your own website too, those direct sales are your responsibility. You need a CDTFA seller’s permit for the direct channel. You collect and file for it while the marketplace handles its own. Sellers shipping nationwide should also watch other states’ economic nexus thresholds. Once your volume in a state grows, filing duties can follow.
Sales tax is a transactional tax, and that makes it a bookkeeping-level problem. With channel-by-channel revenue tracking, every filing becomes a report instead of a research project.
One set of books, one revenue account per channel
Multi-channel sellers should keep a single set of books with separate revenue and fee accounts for each channel. Amazon’s fees eat a different share than Shopify’s, and shipping costs differ by channel too. When each channel has its own lines, the P&L answers the strategic question directly: which channel is worth growing?
The monthly close that keeps a store honest
For our ecommerce clients, a month is closed when:
- Every payout reconciles to the platform settlement report, fee by fee.
- Clearing accounts return to zero, so no money is stuck between the platform and the bank.
- Inventory and COGS move together, tying the balance sheet to what actually shipped.
- Sales tax collected matches sales tax payable by state and channel.
Connector tools like A2X or Link My Books can automate the payout breakdown into QuickBooks Online or Xero. They help, but they still need monthly human review. A misconfigured mapping repeats the same error five hundred times with perfect consistency. That is the failure mode we described in our post on AI bookkeeping with human oversight.
How Books LA handles this
Books LA keeps monthly books for ecommerce sellers in QuickBooks Online and Xero. That covers payout reconciliation against settlement reports, inventory and COGS tracking, channel-level P&L, and filing-ready sales tax numbers. If the books are behind, a cleanup gets the foundation right first. Details on our services page.
Frequently asked questions
Should I record my Shopify payout as income?
No. The payout is a net amount after fees and refunds. Record the gross sales, the fees, and the refunds separately, using the payout report as your source. Otherwise your revenue is understated and your costs are invisible, and both your margins and your tax filings inherit the mistake.
Is inventory an expense when I buy it?
Not in accrual bookkeeping. Purchases go to an inventory asset account, and cost moves to COGS when items sell. This is what keeps monthly profit meaningful. Very small sellers sometimes run cash-basis instead; talk to your tax professional about which method fits your size and situation.
Do I need a California seller’s permit if I only sell on Amazon?
Per the CDTFA, no permit is required when every retail sale you make runs through a registered marketplace like Amazon. The marketplace collects and remits the tax. Start selling from your own site and that changes immediately.
What about sales tax in other states?
Most states now have marketplace facilitator laws similar to California’s. For direct sales, most states set economic nexus near $100,000 of annual sales into the state. If your direct-channel volume is growing, a nexus review is worth doing before a state does it for you.
Do I need A2X or a similar connector tool?
At meaningful volume, yes, they save hours and reduce keying errors. But they are mapping tools, not judgment. Set one up carefully, then review monthly that the mappings still match reality, especially after the platform changes its fee structure.
Which reports should an ecommerce owner review monthly?
Review four reports: P&L by channel, gross margin by product line, inventory on hand versus platform counts, and cash flow net of stock purchases. If your books cannot produce these, that is the first problem to fix.
My books just show deposits for the last two years. How bad is it?
Common, and fixable. A cleanup rebuilds sales, fees, refunds, and COGS from platform reports, which exist going back years. It is detailed work, but it turns guesswork into accurate history. The margin picture usually changes once owners see it.
If your store’s books do not match your store’s reality, book a short call with Books LA and we will map out the fix.
This article is general information for online sellers, not tax advice. Books LA provides bookkeeping services and does not provide income tax advice; we work with our clients’ CPAs on income tax matters. Confirm sales tax registration questions with the CDTFA or your tax professional.
