🛒
Chart of Accounts for E-Commerce — QB Template Chart of Accounts
47 accounts · QBO-ready CSV
QuickBooks-ready chart of accounts for e-commerce businesses. 47 accounts.
⬇️ Download CSV TemplateHow to Import into QuickBooks Online
1
Download the CSV file above
2
In QBO, go to Settings (⚙️) → Import Data → Chart of Accounts
3
Click Browse, select the CSV file, then click Next
4
Map the columns: Account Number, Account Name, Type, Detail Type
5
Click Import — done in under 2 minutes
All 47 Accounts
Bank (5)
| Number | Account Name |
|---|---|
| 1000 | Business Checking |
| 1001 | Business Savings |
| 1004 | Shopify Payments Clearing |
| 1005 | Amazon Payments Clearing |
| 1006 | PayPal / Stripe Clearing |
Accounts Receivable (1)
| Number | Account Name |
|---|---|
| 1002 | Accounts Receivable |
Accounts Payable (1)
| Number | Account Name |
|---|---|
| 1010 | Accounts Payable |
Credit Card (1)
| Number | Account Name |
|---|---|
| 1011 | Credit Card |
Equity (3)
| Number | Account Name |
|---|---|
| 1016 | Owner's Equity |
| 1017 | Owner's Draw |
| 1018 | Retained Earnings |
Income (7)
| Number | Account Name |
|---|---|
| 1019 | Product Sales — Direct (Website) |
| 1020 | Product Sales — Amazon |
| 1021 | Product Sales — Etsy |
| 1022 | Product Sales — Wholesale |
| 1023 | Shipping Income |
| 1024 | Returns & Allowances |
| 1025 | Gift Card Redemptions |
Cost of Goods Sold (6)
| Number | Account Name |
|---|---|
| 1026 | Product Cost / Purchases |
| 1027 | Inbound Freight & Duties |
| 1028 | Amazon FBA Fees |
| 1029 | Marketplace Fees |
| 1030 | Packaging & Supplies |
| 1031 | Inventory Shrinkage |
Other Industry Templates
Related Resources
Need your books cleaned up, not just a template?
Accounting Ketchup catches up your QuickBooks, builds your chart of accounts, and categorizes every transaction. Flat rate.