Ecommerce Chart of Accounts: Practical Structure

An ecommerce chart of accounts organizes sales, payment settlements, fees, refunds, taxes, inventory, cost of goods sold, fulfillment, and operating expenses. The essential control is the bridge from gross order activity to net cash deposited by each platform or processor.

Recording only bank deposits as revenue usually loses marketplace fees, refunds, gift cards, reserves, and taxes. A good chart makes those components visible while using channels, products, customers, and locations as dimensions rather than creating an account for every SKU.

Illustrative ecommerce chart of accounts

The account type and treatment of specific costs depend on the business’s facts and accounting policies. Inventory, sales tax, gift cards, foreign currency, and revenue recognition can require professional analysis.

Use clearing accounts for net payouts

A clearing account records what the platform owes the business between sale and settlement. Post gross sales and other order components to the clearing account. Post fees, refunds, reserves, chargebacks, and the bank deposit against the same account. The remaining balance should equal unsettled platform activity.

The $820 tax is not product revenue in this illustration, and the $270 reserve remains in the clearing balance until released or otherwise resolved. The platform settlement report should reproduce the bridge.

Revenue, discounts, returns, and refunds

Separate gross sales from returns and discounts when that presentation supports useful review. A refund can relate to current or prior-period revenue, tax, shipping, gift cards, or a processor dispute. Preserve the original order identifier so the accounting can follow the underlying event.

Use channel or store dimensions to analyze revenue rather than separate income accounts for every marketplace and SKU. The source system should preserve order and product detail, while the ledger captures controlled summaries.

Sales tax and marketplace collection

Sales tax collected from customers is generally a liability until remitted, not sales revenue. Marketplace-facilitator arrangements can change who collects and remits, but the business still needs reconciled reports and jurisdiction-specific review. Do not assume the platform handled every obligation for every channel.

Create liability accounts or dimensions that align with filing and reconciliation needs. Reconcile beginning liability plus tax recorded minus payments and adjustments to the ending balance.

Inventory and cost of goods sold

Inventory accounting should connect purchases, landed costs, receipts, transfers, sales, returns, shrinkage, and ending quantities. The general-ledger inventory balance should agree to a reliable item-level valuation report. Negative quantities and negative inventory values are warning signs.

Cost of goods sold is recognized according to the selected accounting method and policy. Do not post all inventory purchases directly to cost of goods sold if the financial reporting requires inventory capitalization. Separate obsolete, damaged, or missing inventory adjustments with review and approval.

Fulfillment and shipping

Inbound freight, warehousing, pick-and-pack, packaging, outbound shipping, and marketplace fulfillment fees may have different accounting treatment and management meaning. Define what is included in product cost, direct fulfillment cost, and operating expense. Apply the definition consistently when calculating gross margin or contribution margin.

Advertising and channel economics

Track advertising by channel, campaign, or product using the advertising system and controlled dimensions. Reconcile ad-platform invoices or card charges to the ledger. Return on ad spend should use comparable revenue, timing, attribution, refunds, and cost definitions.

Channel profitability often starts with net sales, then subtracts product cost, platform and payment fees, fulfillment, and attributable advertising. Clearly label allocated overhead so an estimate is not mistaken for a directly traced cost.

Integration mapping controls

1. List each order, marketplace, processor, inventory, tax, and fulfillment system.
2. Identify which application owns orders, quantities, taxes, fees, and settlements.
3. Map every transaction type, including refunds, gift cards, reserves, and chargebacks.
4. Test one complete transaction lifecycle from order through bank deposit.
5. Create alerts for failed or duplicate imports.
6. Reconcile clearing and inventory control accounts at least monthly.
7. Review mapping changes before they affect live transactions.

Common mistakes

• Recording net deposits as sales.
• Leaving processor clearing balances unreconciled.
• Treating all customer cash as earned revenue.
• Combining sales tax with product sales.
• Posting inventory purchases directly to expense without reviewing the policy.
• Creating separate accounts for every SKU or vendor.
• Comparing channel margins with inconsistent cost definitions.

Use the chart of accounts guide for the general design, and the QuickBooks chart list for a system-specific structure. Businesses needing reconciled settlement and inventory controls can review bookkeeping services.