QUICKBOOKS ONLINE TEMPLATE · E-commerce & Online Retail

QuickBooks Online Chart of Accounts for E-commerce Sellers

66 accounts built for e-commerce sellers, each with the QuickBooks Online account type and detail type already set. Import the CSV, follow the setup checklist, and fill in the financial statements workbook. Built by an accounting firm.

Import-ready CSVExcel workbookFinancial statements includedInstant download
QuickBooks Online chart of accounts template for e-commerce sellers
Chart of Accounts PackCSV + Excel, setup and close checklists, financial statements workbook
Financial Statements onlyIncome Statement, Balance Sheet, Cash Flow, ratios
All 13 industries bundleEvery pack, every statement template, plus the accountants' toolkit
Secure checkout by Stripe. Download link emailed instantly.

Preview: 22 accounts made for e-commerce sellers

On top of the standard core accounts every business needs (bank, payroll, taxes, equity).

#AccountQBO typeDetail type
1030Shopify Payments ClearingBankChecking
1040Amazon Seller ClearingBankChecking
1045PayPalBankChecking
1400Inventory AssetOther Current AssetsInventory
1410Inventory in TransitOther Current AssetsInventory
2260Gift Cards OutstandingOther Current LiabilitiesOther Current Liabilities
4000Product Sales - ShopifyIncomeSales of Product Income
4010Product Sales - AmazonIncomeSales of Product Income
4020Product Sales - Other MarketplacesIncomeSales of Product Income
4050Shipping IncomeIncomeSales of Product Income
4090Refunds & DiscountsIncomeDiscounts/Refunds Given
5000Cost of Goods SoldCost of Goods SoldSupplies & Materials - COGS
5010Print-on-Demand / Dropship CostsCost of Goods SoldSupplies & Materials - COGS
5100Shipping & PostageCost of Goods SoldShipping, Freight & Delivery - COS
5110Inbound Freight & DutiesCost of Goods SoldShipping, Freight & Delivery - COS
5200Packaging SuppliesCost of Goods SoldSupplies & Materials - COGS
5300Marketplace & Platform FeesCost of Goods SoldOther Costs of Services - COS
5310Payment Processing FeesCost of Goods SoldOther Costs of Services - COS
+ 4 more industry accounts and 44 core accounts in the full file

Setup tips included

Recommended tracking: Use Classes for each sales channel (Shopify / Amazon / Etsy) to see profit by channel

How it works

1

Buy securely. Checkout is handled by Stripe.

2

Download. Your link arrives by email right after payment.

3

Import. In QuickBooks Online go to Settings > Import data > Accounts and upload the CSV.

4

Report. Enter balances in the workbook and your statements are done.

Questions

Can I import this chart of accounts into QuickBooks Online?

Yes. Upload the included CSV in QuickBooks Online under Settings, Import data, Accounts. Every account already has a valid QuickBooks Online account type and detail type.

Does it include financial statements?

Yes. The pack includes a fill-in workbook: type your balances once and the Income Statement, Balance Sheet, Cash Flow Statement and key ratios build themselves, with balance checks.

Will it overwrite my existing accounts?

No. Importing adds accounts. Review the list in Excel first and delete any rows you do not need before you upload.

How do I get the files?

Checkout is handled by Stripe. Your download link arrives by email right after payment.

Other industries

RestaurantsConstruction ContractorsReal EstateProfessional Services FirmsSaaS StartupsAI CompaniesNonprofitsMedical & Dental PracticesSalons & Beauty BusinessesTrucking CompaniesMarketing & Creative AgenciesAccounting Firms

Need it set up for you? Book a QuickBooks Advisory session.
Independent templates by Stephennohga. Not affiliated with, endorsed or sponsored by Intuit Inc. QuickBooks and QuickBooks Online are trademarks of Intuit Inc. General bookkeeping guidance, not tax, legal or audit advice.

Template

Secured by Stripe