If you're running an e-commerce business on Shopify, Amazon, or WooCommerce, you've probably discovered something your bookkeeper hasn't: e-commerce accounting is nothing like traditional service-business bookkeeping. The complexity of inventory valuation, multi-state sales tax, marketplace fee reconciliation, and multi-channel revenue makes it one of the hardest industries to get right.
We've onboarded dozens of e-commerce clients over the years, and the same problems show up every time. Here's what makes e-commerce bookkeeping uniquely challenging — and what to do about it.
1. Inventory Accounting: FIFO vs. Weighted Average
For service businesses, there's no inventory to track. For e-commerce, inventory is often your largest asset — and how you value it directly impacts your profit margin, tax liability, and balance sheet.
The two most common methods are:
- FIFO (First In, First Out) — assumes the oldest inventory is sold first. Better for businesses with perishable goods or rapidly changing costs.
- Weighted Average — averages the cost of all inventory on hand. Simpler to manage, especially with high SKU counts.
The problem? Most bookkeepers pick one and never revisit it. But as your product mix changes, your supplier costs shift, and your volume grows, the wrong method can overstate or understate your COGS by 10-15% — which means your P&L is lying to you.
2. Sales Tax Nexus: The Multi-State Nightmare
If you sell products online, you almost certainly have sales tax nexus in multiple states. Since the 2018 South Dakota v. Wayfair ruling, economic nexus means you can owe sales tax in states where you have zero physical presence — just by crossing revenue or transaction thresholds.
Here's what that means in practice:
- Most states have thresholds of $100K in sales OR 200 transactions
- Each state has different filing frequencies (monthly, quarterly, annual)
- Each state has different product taxability rules
- Amazon FBA inventory stored in warehouses creates physical nexus in those states too
Missing a nexus filing isn't just a fine — it's back taxes plus penalties plus interest. We've seen businesses hit with $30K+ in surprise liabilities because their bookkeeper didn't understand nexus.
3. Marketplace Fee Reconciliation
Shopify takes a payment processing fee. Amazon takes a referral fee, FBA fee, storage fee, and sometimes an advertising fee. Each marketplace reports revenue differently and pays out on different schedules.
If your bookkeeper is recording the deposit amount as revenue, your books are wrong. The gross sale is the revenue; the fees are expenses. Getting this wrong overstates your profit margin and understates your true cost of doing business on each channel.
Proper reconciliation means:
- Recording gross revenue at the point of sale
- Separately tracking platform fees, payment processing, and FBA costs
- Reconciling marketplace payouts to your bank deposits (they never match cleanly)
- Tracking channel-level profitability so you know where to invest
4. COGS Tracking Across Channels
Cost of Goods Sold is straightforward in theory: what did you pay for the inventory you sold? In practice, it's a mess:
- Landed costs (product cost + shipping + duties + customs) vary by shipment
- Bundle and kit components need disaggregated costing
- Promotional pricing and discounts affect realized margin
- Damaged, lost, and returned inventory needs write-off tracking
Without accurate COGS, you can't calculate gross margin — and without gross margin, you're making pricing and advertising decisions blind.
5. Returns and Refunds
E-commerce return rates typically run 15-30% for apparel and 5-10% for hard goods. Each return creates a chain of accounting entries: reverse the revenue, add back inventory (if sellable), write off the cost (if not), process the refund, and account for return shipping costs.
Most bookkeepers treat returns as a simple revenue reduction. But that ignores the inventory impact, the shipping costs, and the restocking labor. When returns are 10%+ of revenue, getting this wrong materially misstates your financials.
6. Multi-Channel Revenue Recognition
If you're selling on Shopify, Amazon, wholesale, and maybe a brick-and-mortar pop-up, you need to track revenue by channel — not just in total. Why?
- Each channel has different margins (DTC is typically 3x more profitable than Amazon)
- Ad spend ROI varies dramatically by channel
- Inventory allocation decisions depend on channel performance
- Your growth strategy should be informed by which channels are actually profitable
A generic bookkeeper lumps it all together. A specialized e-commerce accountant gives you channel-level P&Ls so you can make real decisions.
What to Do About It
If any of this sounds familiar, you need a bookkeeper who specializes in e-commerce — not someone who's trying to fit your Shopify business into the same template they use for law firms and consultants.
At CleanBooks, we've built our e-commerce practice around solving exactly these problems. We integrate directly with Shopify, Amazon Seller Central, and your inventory management tools. We handle multi-state sales tax nexus analysis and filing. We give you channel-level profitability reporting and accurate COGS tracking.
Want to see what that looks like? Explore our interactive e-commerce financial dashboard — it's built with real metrics that DTC brands actually need.
Ready to fix your books? Book a free Controller Fit Call and let's talk about your specific situation.