Your Shopify store did $1.2 million in gross sales last year. Amazon added another $800K. Etsy kicked in $150K. When your CPA pulled the numbers together, you owed $38,000 in taxes on income you thought was $240,000 — but was actually $167,000 after marketplace fees, returned inventory, and storage costs you never tracked. That $73,000 gap between what you thought you earned and what you actually earned is why ecommerce bookkeeping is not something you can wing with bank deposit tracking and a spreadsheet.
E-commerce sellers between $250K and $10M in annual revenue operate in a financial environment that looks nothing like traditional retail. Your revenue flows through marketplace intermediaries that take 25-40% before you see a dollar. Your inventory sits in warehouses across 15 states, creating sales tax obligations in every one of them. Your cost of goods sold includes product cost, ocean freight, customs duties, prep fees, and inbound shipping — but most sellers only track the product cost. The result is financial statements that overstate profit by 15-30%, leading to bad decisions on inventory purchasing, pricing, and hiring.
This guide covers the specific ecommerce bookkeeping practices that separate profitable sellers from ones who are just busy. If you already know what COGS means and you are past the “I just look at my bank balance” stage, this is where you go deeper — into chart of accounts design, inventory accounting methods, marketplace fee tracking, revenue recognition, sales tax compliance, multi-channel reconciliation, and the KPIs that actually predict whether your business will survive its next growth phase.
A general bookkeeper can reconcile your bank account and categorize expenses. What they cannot do — without e-commerce-specific knowledge — is untangle the financial complexity of marketplace selling. Here is what makes it different from every other business model.
When a customer buys a $50 product on Amazon, the customer pays Amazon — not you. Amazon collects the $50, deducts a referral fee ($7.50), an FBA fulfillment fee ($5.40), and any advertising costs, storage fees, or return processing charges. Two weeks later, Amazon deposits a net settlement of $34-37 into your bank account. That single deposit represents dozens or hundreds of individual transactions with different fee structures.
If your bookkeeper records that bank deposit as revenue, your financial statements are wrong from line one. Your actual revenue was $50 per unit. Amazon’s fees are expenses. Recording the net deposit as revenue means your gross margins look artificially high and your expense ratios are meaningless.
Critical distinction: Your revenue is the gross amount the customer paid. Marketplace fees are expenses. This is called gross revenue recognition, and it is the correct method for most third-party sellers. Recording net deposits as revenue violates GAAP and will cause problems with your CPA, your lender, and the IRS — because your 1099-K reports gross amounts, not net.
Unlike service businesses where labor is the primary cost, e-commerce sellers carry physical inventory that must be valued, tracked, and adjusted on the balance sheet. For most sellers we work with, inventory represents 40-60% of total assets. Getting the inventory valuation wrong cascades into incorrect COGS, incorrect gross margins, incorrect taxable income, and incorrect purchasing decisions.
Inventory accounting for e-commerce requires:
If you sell through Amazon FBA, your inventory is stored in fulfillment centers across potentially a dozen or more states. Under the South Dakota v. Wayfair (2018) Supreme Court ruling, physical presence of your inventory creates sales tax nexus — a legal obligation to collect and remit sales tax — in every state where your products are stored. Most sellers have nexus in 10-20 states and do not realize it until they get a notice.
For a complete breakdown of sales tax obligations for e-commerce, see our guide on e-commerce sales tax compliance.
Amazon settles every two weeks. Shopify pays daily through Shopify Payments. Etsy deposits weekly. Each platform calculates fees differently, reports differently, and handles returns and refunds differently. Your bookkeeper needs to reconcile each platform independently before producing consolidated financial statements. This multi-channel reconciliation process is where most e-commerce bookkeeping breaks down.
Your chart of accounts is the skeleton of your financial reporting. A generic QuickBooks chart of accounts gives you “Sales” and “Cost of Goods Sold” — which tells you nothing about whether your Amazon channel is profitable or your Shopify store is subsidizing money-losing Etsy products.
Here is a chart of accounts structure built for multi-channel e-commerce sellers:
| Account # | Account Name | Type |
|---|---|---|
| Revenue Accounts | ||
| 4100 | Product Sales — Amazon | Income |
| 4200 | Product Sales — Shopify / DTC | Income |
| 4300 | Product Sales — Etsy | Income |
| 4400 | Product Sales — Walmart | Income |
| 4500 | Product Sales — Wholesale / B2B | Income |
| 4900 | Shipping Revenue (customer-paid) | Income |
| Cost of Goods Sold | ||
| 5100 | Product Cost (Purchase Price) | COGS |
| 5200 | Inbound Freight & Shipping to Warehouse | COGS |
| 5300 | Customs Duties & Tariffs | COGS |
| 5400 | FBA Prep & Labeling Fees | COGS |
| 5500 | Packaging Materials | COGS |
| 5600 | Inventory Write-Downs & Adjustments | COGS |
| Marketplace Fees | ||
| 6100 | Amazon Referral Fees | Expense |
| 6110 | Amazon FBA Fulfillment Fees | Expense |
| 6120 | Amazon Storage Fees (Monthly) | Expense |
| 6130 | Amazon Storage Fees (Long-Term / Aged) | Expense |
| 6140 | Amazon Advertising (PPC / Sponsored) | Expense |
| 6150 | Amazon Other Fees (Removal, Disposal, etc.) | Expense |
| 6200 | Shopify Transaction Fees | Expense |
| 6210 | Shopify Subscription & Apps | Expense |
| 6300 | Etsy Listing, Transaction & Payment Fees | Expense |
| 6400 | Payment Processing Fees (Stripe, PayPal) | Expense |
| Operating Expenses | ||
| 7100 | Warehouse Rent & Utilities | Expense |
| 7200 | Shipping & Fulfillment (Self-Fulfilled Orders) | Expense |
| 7300 | Payroll & Contract Labor | Expense |
| 7400 | Marketing & Advertising (Non-Marketplace) | Expense |
| 7500 | Software & Subscriptions | Expense |
| 7600 | Insurance (General Liability, Product) | Expense |
| 7700 | Returns & Refunds Processing | Expense |
| 7800 | Sales Tax Filing Fees | Expense |
| 7900 | Professional Services (Legal, Accounting) | Expense |
The critical split: Separating revenue by channel (4100-4500) and marketplace fees by platform (6100-6300) is what allows you to calculate true profitability by sales channel. Without this, you cannot answer the question: “Am I making money on Amazon or just generating revenue for Jeff Bezos?”
Why marketplace fees get their own section: Many sellers bury Amazon fees inside COGS. This distorts your gross margin, making it impossible to compare product profitability across channels. Marketplace fees are a selling expense — they vary by platform, not by product. Keep them separate.
Inventory is where e-commerce bookkeeping gets technical — and where the biggest financial mistakes hide. The method you use to value inventory directly determines your Cost of Goods Sold, your gross profit, and your taxable income.
Three valuation methods are commonly used by e-commerce sellers:
| Method | How It Works | Best For | Weakness |
|---|---|---|---|
| FIFO (First In, First Out) | Oldest inventory costs are assigned to COGS first | Most e-commerce sellers; required by many CPAs | Overstates profit when costs are rising |
| Weighted Average | Average cost of all units in stock = COGS per unit | High-volume sellers with frequent replenishment | Smooths out cost spikes — may hide margin erosion |
| Specific Identification | Actual cost of the exact unit sold is used | High-value or unique items (jewelry, custom goods) | Impractical for high-SKU commodity sellers |
Our recommendation for most e-commerce sellers: FIFO. It aligns with the physical flow of goods (you ship older inventory first), it is the most commonly accepted method, and it gives your CPA the cleanest data for tax returns. Once you pick a method, you must use it consistently — the IRS does not allow you to switch methods without filing Form 3115.
Your product cost is not just what you paid your supplier. Landed cost includes every expense required to get inventory from the manufacturer to your warehouse (or Amazon FBA center), ready to sell:
| Cost Component | Example (Per Unit) |
|---|---|
| Supplier purchase price | $8.00 |
| International freight (ocean/air) | $1.20 |
| Customs duties (e.g., 7.5%) | $0.60 |
| Customs broker fee (allocated) | $0.15 |
| Domestic freight to warehouse | $0.40 |
| FBA prep & labeling | $0.50 |
| Inbound shipping to FBA | $0.35 |
| Total Landed Cost | $11.20 |
If your bookkeeper records COGS at $8.00 per unit (the supplier cost only), your gross margin is overstated by 28.6% on every single unit sold. On 50,000 units per year, that is $160,000 in phantom profit — profit that does not actually exist but that you are paying taxes on and making business decisions based on.
For a detailed walkthrough of COGS calculation and inventory valuation methods, see our guide on COGS and inventory accounting for online sellers.
Pro Tip: Track landed cost by SKU, not as a blended average across all products. A product sourced from China with 25% tariffs has a very different landed cost profile than a product sourced domestically. SKU-level landed cost is what reveals which products are actually profitable after all-in costs.
Marketplace fees are typically the second-largest expense for e-commerce sellers, after COGS. Amazon alone charges sellers an average of 30-35% of gross revenue in combined fees. If you are not tracking these fees at the category level, you cannot identify where your margin is leaking.
Amazon charges over a dozen distinct fee types. Here are the ones that matter most:
| Fee Type | Typical Rate | What It Covers |
|---|---|---|
| Referral Fee | 8-15% of sale price (varies by category) | Amazon’s commission for listing on the marketplace |
| FBA Fulfillment Fee | $3.22-$10.48+ per unit (by size/weight) | Picking, packing, shipping, and customer service |
| Monthly Storage Fee | $0.87/cu ft (Jan-Sep), $2.40/cu ft (Oct-Dec) | Warehouse space at FBA centers |
| Aged Inventory Surcharge | $1.50-$6.90/cu ft (after 181+ days) | Penalty for slow-moving inventory |
| Closing Fee (Media) | $1.80 per unit | Additional fee on books, DVDs, music |
| Removal/Disposal Fee | $0.97-$5.75 per unit | Removing unsold inventory from FBA |
| Advertising (PPC) | Variable — $0.50-$5.00+ per click | Sponsored Products, Brands, Display campaigns |
For an Amazon-specific deep dive covering settlement reports, reimbursements, and A2X integration, see our Amazon FBA bookkeeping guide.
Shopify’s fee model is simpler than Amazon’s, but still requires tracking:
For Shopify-specific reconciliation, payment matching, and refund handling, see our Shopify store bookkeeping guide.
Etsy charges a unique combination of listing, transaction, and payment processing fees:
The Etsy Offsite Ads fee is particularly painful — it applies to any sale that Etsy attributes to their advertising, and you cannot opt out once you cross the $10K annual threshold.
This is the single most consequential accounting decision for marketplace sellers. Getting it wrong affects every financial metric downstream.
Gross method (correct for most sellers): Record the full sale price as revenue. Record marketplace fees as separate expenses. Your P&L shows $100,000 in gross revenue and $30,000 in marketplace fees, yielding $70,000 in net revenue.
Net method (incorrect for most sellers): Record only the amount deposited by the marketplace as revenue. Your P&L shows $70,000 in revenue with no marketplace fees. This matches your bank deposits but misrepresents your actual business economics.
Why gross method matters:
Important: The IRS sees your gross revenue via 1099-K. If your tax return shows net revenue, you must reconcile the difference on your Schedule C or business tax return. Using gross revenue recognition from the start avoids this reconciliation headache entirely.
If you sell on more than one platform — and most sellers above $500K in revenue do — reconciliation is the monthly process that keeps your books from drifting into fiction. Each marketplace pays you on a different schedule, deducts different fees, and reports transactions differently.
The reconciliation process requires matching three data sources for each channel:
Discrepancies between these three sources are normal. Amazon adjustments, Shopify refund timing differences, Etsy payment holds — all create gaps that must be identified and resolved monthly. Let any of them carry forward, and by year-end you are looking at a reconciliation nightmare that costs thousands in accounting fees to untangle.
For a step-by-step multi-channel reconciliation process, see our guide on multi-channel seller reconciliation.
Sales tax is the area of ecommerce bookkeeping that creates the most legal liability. Since the South Dakota v. Wayfair ruling in 2018, states can require sales tax collection from remote sellers who exceed economic nexus thresholds — typically $100,000 in sales or 200 transactions per year in the state.
Here is the good news: in all 46 states (plus DC and Puerto Rico) that have marketplace facilitator laws, Amazon, Shopify (via Shopify Tax for certain states), Walmart, and Etsy are required to collect and remit sales tax on your behalf for orders fulfilled through their platforms. You do not need to collect sales tax on those orders.
Here is the bad news: marketplace facilitator laws only cover sales through the marketplace. If you also sell on your own website (Shopify DTC, WooCommerce, wholesale), you are responsible for collecting and remitting sales tax on those orders in every state where you have nexus. And FBA inventory placement creates nexus in states you may never have visited.
Even with marketplace facilitators collecting sales tax, you are responsible for:
For the full state-by-state breakdown including thresholds, marketplace facilitator details, and automation options, see our e-commerce sales tax compliance guide.
E-commerce return rates average 20-30% — significantly higher than the 8-10% in brick-and-mortar retail. For apparel sellers, returns can exceed 40%. Each return triggers a chain of bookkeeping entries:
The bookkeeping challenge is timing. A customer buys in November, returns in January. The sale was recognized in November; the return must be recorded in January. But if you are running accrual-based accounting, you should also be booking a return allowance reserve — estimating returns based on historical rates and setting aside a reserve against current-period revenue.
Example: If your historical return rate is 22% and you sell $100,000 in October, book a $22,000 return allowance as a contra-revenue entry. When actual returns come in, they offset the reserve rather than hitting current-period revenue. This smooths your financials and gives you accurate monthly margins.
Financial KPIs are the output of good ecommerce bookkeeping. If your books are not structured to produce these numbers automatically, your chart of accounts needs restructuring.
| KPI | Target Range | Why It Matters |
|---|---|---|
| Gross Margin (after COGS) | 50-70% | Below 40% and marketplace fees will eat your profit entirely |
| Net Margin (after all expenses) | 10-20% | Below 8% and you are one ad cost increase from losing money |
| ACOS (Advertising Cost of Sale) | 15-25% (varies) | Ad spend ÷ ad-attributed revenue. Above 30% signals overspending |
| TACOS (Total ACOS) | 8-15% | Total ad spend ÷ total revenue. Better measure of ad efficiency |
| Inventory Turnover | 6-12x per year | Below 4x means cash is trapped in slow-moving stock |
| Customer Acquisition Cost | Varies by AOV | CAC should be under 20% of first-order AOV |
| Return Rate | Under 15% | Above 25% signals product quality or listing accuracy issues |
| Amazon Fee Percentage | 28-35% of gross | Above 38% means fee creep or inefficient FBA sizing |
| Days Sales of Inventory (DSI) | 30-60 days | Above 90 days means working capital is locked up |
| Contribution Margin per SKU | Positive | Revenue minus COGS minus marketplace fees per product. Negative SKUs must be fixed or killed |
TACOS (Total Advertising Cost of Sale) deserves special attention. Unlike ACOS, which only measures return on ad-attributed sales, TACOS divides your total ad spend by your total revenue — including organic sales. A declining TACOS means your organic sales are growing faster than your ad spend, which is the ultimate signal of a healthy e-commerce brand. Target TACOS under 12% for mature products.
Contribution margin per SKU is the metric that kills unprofitable products before they kill your business. If a $25 product costs $11.20 in landed cost, $3.75 in referral fees, $5.40 in FBA fees, and $2.50 in advertising, your contribution margin is $2.15 per unit — 8.6%. That is dangerously thin. A 5% increase in any cost category, or a 3% return rate above your estimate, pushes that SKU negative.
Manual reconciliation of marketplace settlement reports is possible but agonizing at scale. Beyond 200 orders per month, automated tools pay for themselves within the first month.
A2X — The gold standard for Amazon, Shopify, eBay, Etsy, and Walmart integration with QuickBooks or Xero. A2X reads your settlement reports, breaks them down into individual accounting entries (revenue, fees, refunds, taxes), and posts summarized journal entries to your accounting software. Starts at $19/month for basic.
Link My Books — Similar to A2X, focused on Amazon and Shopify. Slightly simpler interface, good for sellers on fewer channels. Starts at $17/month.
Finaloop — AI-driven bookkeeping platform purpose-built for e-commerce. Goes beyond integration — attempts to handle the entire bookkeeping function. Best for sellers who want a turnkey solution.
QuickBooks Online remains the standard for e-commerce sellers. It integrates with A2X, Link My Books, inventory management tools, and virtually every other platform in the ecosystem. Use the Plus or Advanced tier for inventory tracking features.
Xero is the alternative for sellers who want multi-currency support (critical if you source internationally and sell in multiple countries). A2X integrates with Xero natively.
TaxJar and Avalara automate sales tax calculation, filing, and remittance across all states. For sellers with nexus in 10+ states, manual filing is impractical — the time cost alone exceeds the software cost.
SoStocked (now Carbon6), RestockPro, and Inventory Planner help forecast demand, manage reorder points, and track landed cost across suppliers. These tools feed data into your accounting system to keep inventory valuations current.
Year-end is where good ecommerce bookkeeping pays dividends — and where bad bookkeeping creates five-figure CPA bills. Here is the year-end checklist:
There is a revenue threshold — typically around $500K-$1M annually — where DIY bookkeeping stops being thrifty and starts being reckless. Here are the signs you have reached it:
A specialized e-commerce bookkeeper costs $500-$2,000/month depending on volume and complexity. Compare that to the cost of bad data: overpaying taxes on phantom profit, making inventory purchases based on inflated margins, or getting hit with a state sales tax audit that goes back 3-4 years.
Ready to get your e-commerce books right? Get an instant quote based on your sales volume and channel mix, or visit our Amazon seller bookkeeping page to see how we work with marketplace sellers.
Get a free quote and see how Steph's Books can save you 40-60% vs hiring in-house.
