An ecommerce chart of accounts organizes how sales, inventory, refunds, fees, taxes and other transactions appear in QuickBooks Online or another accounting system.
A basic chart may work for a small store, but it often becomes inadequate when the business adds Shopify, Amazon, payment processors, warehouses or new product lines. Without the right structure, financial reports may show total income and expenses without explaining which channels are profitable or whether payouts, inventory and taxes are accurate.
This guide explains how US ecommerce businesses can build a practical chart of accounts for reliable bookkeeping and financial reporting.
What Is an Ecommerce Chart of Accounts?
A chart of accounts is the organized list of accounts used to classify financial transactions. It normally includes assets, liabilities, equity, income, cost of goods sold and operating expenses.
An ecommerce chart of accounts adds categories needed for online selling, such as:
- Shopify and Amazon sales
- Payment-processor clearing accounts
- Discounts, refunds and chargebacks
- Inventory and cost of goods sold
- Processing and marketplace fees
- Fulfillment and advertising costs
- Sales-tax liabilities
The objective is not to create an account for every transaction. It is to provide enough detail for accurate reconciliation and useful reporting without making the accounting system unnecessarily complex.
Income Accounts
Revenue should generally be separated by major sales channel. A multichannel seller may use accounts for Shopify sales, Amazon sales, wholesale revenue, subscription revenue, shipping income and other operating revenue.
This structure allows management to compare channels and reconcile sales against platform reports. However, creating a separate general-ledger account for every product or SKU can make the chart difficult to manage. Product-level reporting is usually better maintained in Shopify, Amazon, an inventory system or a specialized analytics platform.
Sales should also be recorded in the correct reporting period. The date a payout reaches the bank may differ from the date of the underlying customer transactions.
Shopify and Amazon Clearing Accounts
Clearing accounts represent funds processed by a platform but not yet transferred to the business bank account.
Common accounts include:
- Shopify Payments Clearing
- Amazon Clearing
- PayPal Clearing
- Stripe Clearing
- Walmart Marketplace Clearing
Shopify and Amazon deposits are normally net settlements. They may include sales, refunds, fees, chargebacks, reimbursements and other adjustments.
A clearing account connects the platform activity, payout and bank deposit. Sales and deductions are first recorded through the appropriate clearing account. When the payout reaches the bank, the amount is transferred from the clearing account rather than recorded as new revenue.
Any remaining balance should represent legitimate unsettled funds, reserves or timing differences. An unsupported balance may indicate missing payouts, duplicated entries, incorrect mappings or transactions recorded in the wrong period.
Learn more in our guides to reconciling Shopify payouts in QuickBooks Online and Amazon settlement accounting.
Refunds, Discounts and Chargebacks
Refunds, discounts and chargebacks should remain visible rather than being hidden inside net deposits or combined with unrelated expenses.
The chart may include accounts for:
- Sales discounts
- Promotional discounts
- Returns and refunds
- Chargebacks
- Dispute fees
- Sales allowances
Separating these amounts helps management calculate net sales, monitor refund rates and measure the effect of promotions.
Chargebacks should also be distinguished from ordinary refunds. A chargeback may include both the reversal of a customer payment and an additional dispute fee charged by the processor.
Processing and Marketplace Fees
Payment processors and marketplaces often deduct their fees before sending a payout. These charges should be recorded separately instead of being netted against revenue.
Relevant accounts may include Shopify Payments fees, Stripe fees, PayPal fees, Amazon referral fees, FBA fulfillment fees, FBA storage fees, subscription charges and other marketplace costs.
Separating significant fees helps the business measure the cost of accepting payments and selling through each platform. However, similar minor charges can be grouped when additional detail would not improve decision-making.
Each recorded amount should agree with the applicable payout or settlement report.
Inventory, Landed Costs and COGS
Inventory purchased for resale is generally recorded as an asset until the related products are sold. Its cost is then recognized as cost of goods sold.
Inventory accounts may include inventory asset, inventory in transit, raw materials, finished goods, packaging inventory and inventory held at Amazon FBA or a third-party warehouse.
Cost-of-goods-sold accounts may include product cost, inbound freight, import duties, packaging used, inventory adjustments and damaged or obsolete inventory.
Landed cost generally includes the purchase cost and certain expenses required to bring inventory to its intended location and condition. Depending on the circumstances, these may include inbound freight, duties and customs charges.
Recording inventory purchases immediately as an expense can understate inventory and distort gross margin. A business may reconcile every Shopify and Amazon deposit while still reporting inaccurate profit because its inventory and COGS are incorrect.
Sales-Tax Liabilities
Sales tax collected from customers generally represents a liability rather than revenue.
The chart may include sales tax payable, state-specific liabilities or a marketplace-facilitator tax clearing account. The appropriate structure depends on the seller’s jurisdictions and filing requirements.
Amazon and other marketplaces may collect and remit tax on certain transactions under marketplace-facilitator rules. However, the seller may still have registration or filing responsibilities.
The accounting records should distinguish tax collected directly by the company from tax handled by a marketplace. Liability balances should agree with sales-tax reports and returns for the same periods.
Our guide to ecommerce sales-tax nexus explains how business activity may create state registration and filing obligations.
Advertising and Fulfillment Costs
Advertising and fulfillment can consume a substantial portion of ecommerce revenue, so their costs should remain visible.
Advertising accounts may include Meta, Google and Amazon advertising, influencer marketing, affiliate commissions, creative production and agency fees.
Fulfillment accounts may include third-party logistics, outbound shipping, pick-and-pack fees, warehousing, packaging supplies and returns shipping.
Separating major advertising channels helps management compare marketing costs with sales and gross profit. Fulfillment costs should also be classified consistently so expenses already included in inventory or landed cost are not recorded twice.
Example Ecommerce Chart of Accounts
A practical chart might include:
Assets
- Operating bank account
- Shopify Payments Clearing
- Amazon Clearing
- PayPal Clearing
- Accounts Receivable
- Inventory Asset
- Inventory in Transit
- Equipment
Liabilities
- Accounts Payable
- Business Credit Cards
- Sales Tax Payable
- Gift Card Liability
- Payroll Liabilities
- Inventory Financing
Equity
- Owner Contributions
- Owner Distributions
- Retained Earnings
Income
- Shopify Sales
- Amazon Sales
- Wholesale Sales
- Shipping Income
- Sales Discounts
- Returns and Refunds
Cost of Goods Sold
- Product Cost
- Inbound Freight
- Import Duties
- Packaging Used
- Inventory Adjustments
Operating Expenses
- Payment-Processing Fees
- Amazon Marketplace Fees
- Fulfillment and Storage
- Outbound Shipping
- Advertising
- Software
- Payroll and Contractors
- Professional Fees
- Insurance
- Interest Expense
This is an illustrative framework. The final structure should reflect the company’s legal structure, sales channels, accounting method and reporting requirements.
Common Setup Mistakes
Common ecommerce accounting mistakes include recording net payouts as revenue, using one clearing account for every platform, expensing inventory purchases immediately and treating sales tax as income.
Other problems arise when businesses create too many accounts, use overly broad categories or mix personal spending with business expenses.
Clearing accounts should not be forced to zero through unexplained adjustments. Differences should be investigated and supported.
Automation also requires review. An integration may appear to work while sending revenue, taxes, fees or refunds to incorrect accounts.
Monthly Review Checklist
During each monthly close, confirm that:
- Bank and credit-card accounts are reconciled
- Shopify and Amazon clearing balances are supported
- Other payment processors are reconciled separately
- Sales are recorded in the correct period
- Refunds, discounts and chargebacks are complete
- Marketplace and processing fees are categorized
- Sales-tax liabilities agree with supporting reports
- Inventory agrees with the inventory system
- COGS has been updated
- Advertising and fulfillment expenses are complete
- Owner transactions are correctly classified
- Uncategorized accounts have been reviewed
- Duplicate or unused accounts are identified
- Financial statements have been reviewed for unusual balances
The chart should also be reviewed whenever the company adds a major marketplace, processor, warehouse or financing arrangement.
Frequently Asked Questions
Should Shopify payouts be recorded as revenue?
No. A Shopify payout is generally a net transfer after fees, refunds, chargebacks and adjustments. Its underlying components should be recorded separately.
Does Amazon need a separate clearing account?
A separate Amazon clearing account generally makes settlement reconciliation and the investigation of timing differences easier.
Should revenue be separated by sales channel?
Separating major channels can improve reconciliation and profitability analysis. Product-level detail can remain in the ecommerce or inventory system.
How should inventory purchases be recorded?
Inventory purchases are generally recorded as assets and recognized as cost of goods sold when the related products are sold.
How many accounts should an ecommerce business have?
There is no universal number. The chart should provide enough detail for accurate reconciliation and decision-making without becoming unnecessarily complicated.
Build Financial Reports You Can Use
A well-designed ecommerce chart of accounts creates the foundation for accurate payout reconciliation, inventory accounting, sales-tax reporting and profitability analysis.
AYBE Finance provides specialized ecommerce accounting services for Shopify, Amazon and multichannel businesses. We help structure accounting systems, reconcile payouts, clean up QuickBooks Online, track inventory and COGS, and produce reliable monthly financial reports.
