The Ecommerce Chart of Accounts That Actually Answers Questions

Your chart of accounts decides which questions your books can answer. With QuickBooks' default COA, "how were sales?" gets an answer. "Which channel makes money?" and "why did margins drop in March?" do not. Here's the structure we set up for marketplace sellers, and you're welcome to copy it.

The design principle: one level of useful detail

Bad COAs fail in both directions. Five accounts tell you nothing; three hundred accounts never get categorized consistently and tell you less. The rule: break out an account only if you'll make a different decision based on its balance. Channel-level revenue? Different decisions. Separate accounts for blue pens and black pens? No.

Revenue: by channel, gross and honest

• 4010 Sales – Amazon
• 4020 Sales – Shopify
• 4030 Sales – eBay
• 4040 Sales – Walmart
• 4050 Sales – Etsy
• 4910 Refunds & Returns (contra-revenue, also by channel if volume justifies)
• 4920 Discounts & Promotions (contra-revenue)

Gross sales by channel, refunds shown separately. Netting refunds into sales hides your return rate, and your return rate is a product-quality dashboard.

COGS: the section everyone gets wrong

• 5010 Cost of Goods Sold (recognized on sale, not purchase)
• 5020 Inbound Freight & Duties (landed cost)
• 5030 Inventory Shrinkage & Write-offs
• 5040 Fulfillment Supplies (boxes, tape, labels if you self-fulfill)

And on the balance sheet: 1310 Inventory. Purchases go to the balance sheet first, then move to COGS as units sell. That single discipline separates books a lender trusts from books they don't. If the mechanics behind it are fuzzy, our COGS formula guide works through the math with real landed-cost numbers.

Marketplace fees: itemized, because they creep

• 6010 Referral / Commission Fees – by channel
• 6020 FBA / Fulfillment Fees
• 6030 Storage Fees (watch long-term storage separately if FBA)
• 6040 Payment Processing (Shopify Payments, PayPal, Stripe)
• 6050 Marketplace Subscriptions (Pro accounts, store fees)
• 6060 Shipping Labels Purchased

Fees are most sellers' second-largest cost after inventory, and platforms raise them a percentage point at a time. Itemized accounts make the creep visible while it's still an email to your account manager instead of a margin crisis.

Advertising: split by platform

• 6110 Advertising – Amazon PPC
• 6120 Advertising – Meta
• 6130 Advertising – Google
• 6140 Advertising – Other (TikTok, influencers, Etsy/Offsite ads)

Blended ad spend can't tell you where the next dollar should go. Split it.

Operating expenses: standard, with two ecommerce additions

The usual (software, payroll, rent, insurance, professional fees), plus: 6210 3PL Fees if you use one, and 2250 Sales Tax Payable as a liability so collected tax never touches revenue. If a bookkeeper ever books sales tax as income, that's your cue to keep interviewing.

Per-channel P&L without duplicate accounts

In QuickBooks Online Plus, use Classes for channels; in Xero, Tracking Categories. Revenue accounts stay clean, and every expense that's channel-specific gets tagged, giving you a true margin picture per channel. This is the report that tells you Walmart is worth doubling down on, or isn't. If your channels include Shopify's multi-gateway payouts or Walmart's WFS fee taxonomy, those guides cover the extra accounts each one needs.

Setting this up

Building this into a fresh file takes an afternoon. Restructuring a live file with history takes more care: account merges, remapped A2X postings, and reclassifying enough history that trends stay comparable. We do both as part of onboarding, and the QuickBooks setup is included in every plan. Or take this template and build it yourself; either way, stop running a marketplace business on "Sales" and "Fees."