QuickBooks Online: Setting Up a Clean Chart of Accounts
Short Answer: Start with a minimal, bare-bones chart of accounts and expand only as the client’s needs grow. Use a relevant industry template as a baseline — don’t start completely from scratch.
Step-by-Step Strategy
1. Begin with an Industry-Specific Template
When creating a new QBO company file:
- QuickBooks asks for the business type (Service, Retail, Contractor, Nonprofit, etc.).
- Choosing the right type gives a preloaded Chart of Accounts with common accounts for that industry.
Example:
- Contractor template: Job Materials, Subcontractors, Equipment Rental
- Professional service template: Billable Expenses Income, Client Reimbursements
Keep these base accounts; only delete if they clearly don’t apply.
2. Simplify First Avoid Overbuilding
You don’t need 200 accounts to start. A core COA for most small businesses includes:
| Type | Example Accounts |
|---|---|
| Assets | Checking, Savings, Accounts Receivable, Equipment, Prepaid Expenses |
| Liabilities | Credit Cards, Loans Payable, Payroll Liabilities, Taxes Payable |
| Equity | Owner’s Equity / Retained Earnings, Owner Contributions, Owner Draws |
| Income | Sales Income, Service Income, Other Income |
| COGS | Materials, Subcontractors, Freight, Merchant Fees |
| Expenses | Rent, Utilities, Office Supplies, Software, Insurance, Advertising |
Add new accounts only when needed consistently, not for one-off transactions.
3. Align with Reporting Goals
Ask: “What reports will my client actually use?”
Group accounts logically:
- Tax reporting view (IRS categories)
- Management view (operational breakdowns)
Example: Group “Software Subscriptions,” “IT Services,” and “Domain Fees” under Technology Expenses for cleaner management reports.
4. Set Account Numbers (Optional but Recommended)
For growing businesses or multi-entity clients:
- Enable account numbers in Settings → Chart of Accounts → Advanced → Account Numbers.
- Use structured numbering (1000–1999 Assets, 2000–2999 Liabilities, etc.) to maintain order as accounts expand.
5. Document and Lock Down
- Export the Chart of Accounts to Excel for documentation.
- Restrict who can add/delete accounts using user permissions.
Common Mistakes to Avoid
- Starting with an over-detailed template creates confusion and duplication.
- Creating separate accounts for every vendor or expense variation (use Classes or Tags instead).
- Deleting default QBO accounts like Undeposited Funds, Opening Balance Equity, or Retained Earnings.
- Mixing balance sheet and P&L accounts (e.g., treating loan principal payments as expenses).
Best Practice Summary
| Stage | Approach | Goal |
|---|---|---|
| Setup | Start with QBO’s built-in industry template | Quick launch with standard structure |
| First 2–3 months | Add only essential missing accounts | Keep data consistent and clean |
| After operations stabilize | Refine and group accounts for better reporting | Streamlined management and tax reporting |
| Year-end or scaling up | Apply numbering, clean up inactive accounts | Efficient reporting and reconciliation |