A chart of accounts fails an ecommerce business in five recognizable ways: one revenue line for every channel, fees collapsed into a single bucket, collected sales tax treated as income, purchases used as a proxy for cost of goods sold, and a structure so detailed that nobody can read the resulting statements. Each one hides a decision the seller needs to make.
The chart of accounts is the only part of a bookkeeping setup that is expensive to change later, because changing it breaks comparability with every prior period. Getting it close to right early is worth an afternoon of thought.
1. One revenue account for all channels
A seller on Amazon, Shopify, Walmart, and eBay who posts everything to “Sales” has a top line and nothing else. The channels have different fee structures, different payout timing, different return rates, and different tax treatment. Consolidating them produces a profit and loss statement that cannot answer which channel is funding which.
The fix is a revenue account per channel, and resisting the urge to go further than that. Revenue by channel by product category by month is a report, produced from transaction detail. It is not a set of accounts. A chart of accounts that tries to carry product level detail becomes unmaintainable within two quarters.
The useful test: can someone read the profit and loss statement and see gross margin by channel without exporting anything. If not, the revenue structure is too flat.
2. Every marketplace charge in one “fees” account
Marketplace deductions are several different kinds of cost wearing the same label. Referral and fulfillment fees attach to specific orders and behave as channel cost of sales. Storage, advertising, the monthly selling plan fee, long term storage surcharges, and coupon redemption fees attach to the account and behave as operating expenses.
Amazon’s published seller pricing makes the distinction visible: referral fees run as a percentage of total price or a minimum amount, whichever is greater, varying by category up to 45 percent on device accessories, while the Professional selling plan is a flat $39.99 monthly charge. A single fees account treats a rate change and an advertising increase as the same event, and a seller watching that line cannot tell which happened.
Separate accounts for referral, fulfillment, storage, advertising, refunds, and reimbursements. Six accounts, mapped from the settlement’s own transaction types, and fee analysis stops being a data project.
3. Collected sales tax posted to revenue
Sales tax collected from a buyer was never the seller’s money. It is a liability from the moment it is collected until it is remitted, and it does not belong anywhere near the revenue section.
Posting it to revenue inflates the top line, distorts every margin percentage, and in a bad case leads a seller to pay income tax on money they owe to a state. The structural requirement is a sales tax payable liability account, and for a multichannel seller, visibility into which channels are covered by marketplace facilitator collection and which are not.
That second part is the harder design question. Marketplace facilitator rules shifted collection responsibility to the marketplace for most marketplace sales, while a seller’s own storefront is generally still theirs to handle, and nexus thresholds vary by state and change over time. A chart of accounts that cannot separate facilitator collected tax from seller collected tax makes the remittance question unanswerable from the books. Which registrations a business needs is a question for a state department of revenue or a tax professional, not for an accounting workflow.
4. Purchases used as cost of goods sold
A “Purchases” or “Inventory Purchases” account sitting in the cost of goods sold section, hit whenever a supplier is paid, is the single most damaging structural error on this list.
It expenses inventory on the payment date rather than when units sell, which produces a loss in the month a container was paid for and inflated profit in the months it sells through. Gross margin becomes a function of purchasing cadence instead of product economics.
The correct structure is an inventory asset account, a cost of goods sold account fed by units sold, and separate accounts for inventory adjustments, shrink, and write-downs so that losses are visible rather than buried in COGS. The IRS treats the choice of inventory method as a method of accounting matter: Publication 538 notes that a small business taxpayer may account for inventory by treating it as non-incidental materials and supplies or by conforming to its treatment in an applicable financial statement, and that the method used must clearly reflect income.
Landed cost belongs in the inventory value, not in operating expenses. Freight, duty, brokerage, and prep charges routed to expense accounts understate unit cost and overstate gross margin, often by a wide margin on bulky low cost items.
5. Too many accounts
The opposite failure is a chart with 340 accounts, one per SKU family, per supplier, per warehouse. Someone conscientious built it, and it produces financial statements nobody reads.
Accounts answer questions about the shape of the business. Dimensions, classes, locations, tags, and product level reporting answer questions about specific things inside it. Building product detail into accounts makes every statement unreadable and every reclassification a manual project.
A reasonable ecommerce chart runs 60 to 90 accounts. If it is well past that, the surplus is almost always detail that belongs in a subledger or a reporting dimension.
A workable skeleton
For a multichannel seller, roughly:
- Revenue, one account per channel, plus contra accounts for refunds and for promotional discounts
- Cost of goods sold, one account, fed by units sold at landed cost, plus inventory adjustment and shrink accounts
- Channel cost of sales: referral fees, fulfillment fees, payment processing, each by account rather than by channel
- Operating expenses: advertising, storage, software, professional fees, the usual set
- Assets: inventory, inventory in transit, one marketplace clearing account per channel, sales tax receivable where relevant
- Liabilities: sales tax payable, with facilitator collected and seller collected separated
- Below the line: foreign exchange gain and loss, other income including reimbursements
The clearing accounts are what make batched payouts reconcilable. Gross activity posts to the clearing account, the deposit clears it, and the balance is money earned and not yet received. Without them, every payout becomes a manual puzzle.
Implementing it without breaking history
Changing a chart of accounts midyear costs comparability, so the usual advice is to restructure at the start of a fiscal year, or to map old accounts into new ones and accept that one year of comparatives needs a footnote.
At volume, the mapping work is where accounting tools earn their place, taking settlement transaction types and posting them to the same accounts every period. ConnectBooks does this for Amazon, Shopify, Walmart, TikTok Shop, and eBay into QuickBooks Online, QuickBooks Desktop Enterprise, or Xero, and several other products in the category do a version of the same job with different tradeoffs between detail and simplicity. The tool follows the structure, though. It does not decide it.
For the underlying recordkeeping baseline, the Small Business Administration’s guide to managing business finances sets out what records a business is expected to keep. A chart of accounts is the instrument that makes those records answer questions instead of merely existing.
