BLOG

Bookkeeping for E-commerce Businesses

By Adil Nadeem · October 13, 2026

Why e-commerce bookkeeping is trickier than it looks

Selling online looks simple: money in, products out. In practice, deposits arrive days late, always smaller than the sale, with fees baked in invisibly. Add inventory on shelves, returns coming back, and sales tax in states you've never visited — e-commerce is one of the most bookkeeping-intensive small businesses there is.

This guide covers the traps that catch most sellers — and the habits that keep books accurate. If yours are already a tangle of unreconciled payouts, start with a cleanup first.

1. Record gross sales, not payouts

The single most common e-commerce mistake: you sell $12,000 in a week; days later $11,240 lands in your account. You record $11,240 as revenue and move on.

But you earned $12,000, not $11,240. The $760 gap is marketplace and processing fees — real expenses that belong on your books separately. Recording only the payout understates revenue and expenses; profit looks roughly right while the statements are wrong twice over.

Why does that matter? Three reasons:

• Tax reporting: your 1099-K (and the platform's records) will show gross sales. If your books show only payouts, your revenue won't tie to the forms the IRS receives.
• Fee visibility: if fees never appear as their own line item, you can't see what selling actually costs you — and you can't spot when fees creep up.
• Decision-making: margin analysis by product or channel requires true revenue numbers. Payout-based books make everything downstream unreliable.

The rule: book the sale when it happens, for the full amount the customer paid. Book the payout as a transfer, and book the fees as an expense.

A realistic example

Say you sell $12,000 in a week on a marketplace. The platform deducts $420 in referral fees, $280 in payment-processing fees, and $60 in a monthly subscription fee, then deposits $11,240. Your books should show:

• Revenue (gross sales): $12,000
• Merchant fees expense: $700 ($420 referral + $280 processing)
• Subscription expense: $60
• Bank deposit (net payout): $11,240

Most accounting software lets you record this as a single sales receipt with the fees as negative line items, so the deposit matches your bank statement while revenue and expenses stay accurate.

2. Account for marketplace and processor fees as their own expense

Once you're recording gross sales, the natural follow-through is giving fees a proper home. Create a dedicated expense account — something like "Merchant fees" or "Marketplace and processing fees" — and route every fee there: referral fees, payment-processing fees, per-transaction charges, listing fees, and subscription fees.

Common mistake: lumping fees into "general expenses" or netting them against revenue. Buried fees hide channel comparisons (is Amazon's effective rate really higher than Shopify's?) and cost you at tax time when your preparer untangles them.

Monthly habit: pull each platform's fee breakdown and compare it to your books. Fee structures change; a glance at the merchant-fees total keeps surprises out of your margins.

3. Sales tax basics for sellers

Sales tax is where sellers get into the most trouble — usually by ignoring it until it's urgent. The general picture (the details aren't simple):

Most states require collection once you have sufficient connection ("nexus"): physical presence (including Amazon FBA warehouse inventory), employees, or economic thresholds. Each state sets its own rules, rates, and thresholds — and they change. No national standard exists.

What you can do from a bookkeeping standpoint:

• Track where you sell. Keep records of sales by state. Most platforms provide state-by-state sales reports — download them regularly.
• Use a sales tax payable account. Tax you collect from customers is not your revenue — it's money you owe the state. Record it as a liability (sales tax payable), not income, and clear it when you remit.
• Reconcile what you collected against what you remitted. Your books should show the liability going up with each taxable sale and coming back down with each filing.

Sales tax rules are state-specific and change often. If you're selling across state lines, talk to a tax professional about where you may have filing obligations — this article can't answer that for your situation.

4. Inventory and COGS for product sellers

Inventory is likely your biggest balance-sheet item — and the most mishandled. The core concept: inventory is an asset, not an expense. Buying $5,000 of products converts $5,000 of cash into $5,000 of inventory. The expense hits later, when the product sells — that's cost of goods sold (COGS).

Common mistake: expensing inventory purchases directly. Stocking up makes good months look terrible; selling from stock makes lean months look great. Profit swings wildly and means nothing.

Periodic vs. perpetual — in plain language

There are two ways to track the movement from inventory asset to COGS:

• Periodic: you count inventory at set intervals (usually month-end or year-end) and back into COGS with a simple formula: beginning inventory + purchases − ending inventory = COGS. Simple, but you only know your true margins after each count.
• Perpetual: every sale reduces inventory and records COGS in real time, usually through inventory features in your accounting software or an inventory app connected to your store. More setup, but your margins are accurate every day.

For meaningful volume, perpetual tracking is worth the setup — your margins stay accurate daily. But it only works if purchases, sales, and counts stay in sync: spot-check a few SKUs monthly against the shelf to catch drift early.

A quick example

You start the month with $8,000 of inventory, buy $4,000 more, and end the month with $6,500 on hand. Your COGS for the month is $8,000 + $4,000 − $6,500 = $5,500 — regardless of how much cash went out for purchases. That $5,500 is the number that belongs on your profit and loss statement.

5. Returns, refunds, and chargebacks

E-commerce means returns — handle them as reductions of revenue, not expenses.

• Refunds: a $120 refund reduces revenue (sales returns account or negative sales line) — it's not an expense. If the item returns to sellable stock, it goes back on the balance sheet as inventory.
• Chargebacks: a $200 dispute plus $15 fee — the $200 reduces revenue, the $15 is a merchant-fee expense. Record both; unrecorded chargebacks are a classic "my bank balance doesn't match" cause.
• Return shipping and restocking costs: these are genuine expenses (shipping, merchant fees), recorded in their normal accounts.

Common mistake: booking refunds to a "returns expense" account. It inflates revenue and expenses and makes gross margin meaningless. Keep revenue net of returns; track return rate as a business metric, not a ledger account.

6. Separate your money and follow a monthly routine

None of this works with mixed money. A dedicated business checking account (plus a business card if you use one) is the foundation.

With separate accounts, this monthly routine keeps everything current:

1. Reconcile payouts. Match each platform payout to the sales and fees behind it. Every deposit should tie to gross sales minus fees.
2. Review the fee totals. Glance at merchant fees by channel. Anything unexpected gets investigated now, not at tax time.
3. Update inventory and COGS. Record purchases to the inventory asset account, count or spot-check stock, and make sure COGS reflects what actually sold.
4. Record returns and chargebacks. Clear any that posted during the month so revenue stays net of returns.
5. Check sales tax payable. Confirm collected tax is sitting in the liability account and that filings are current.
6. Reconcile bank and credit card accounts. Every account, every month — the full routine is covered in this monthly checklist.
7. Review the profit and loss. With everything above done, the P&L is actually trustworthy. Read it: revenue, COGS, gross margin, fees, net income.

Key takeaways

• Record gross sales, not payouts. The payout is a transfer; the fees are expenses.
• Give marketplace and processor fees their own expense account so you can see what selling costs.
• Collect sales tax into a liability account, track sales by state, and get professional guidance on where you owe filings — the rules are state-specific.
• Inventory is an asset; the expense is COGS, recognized when products sell — not when you buy them.
• Refunds and chargebacks reduce revenue; they aren't expenses.
• Separate your accounts, then run the same monthly routine every month. Consistency beats intensity.

E-commerce bookkeeping has more moving parts — payouts, fees, inventory, multi-state tax — but the right structure makes it manageable. If you'd rather have a bookkeeper set it up and keep it clean, book a free consultation.