How to Set Up a Chart of Accounts in QuickBooks Online (Step-by-Step Tutorial)

For detailed tutorials, visit our QuickBooks Online guides at excelinaccounting.com/category/quickbooks-tutorial.

What Is a Chart of Accounts?

The chart of accounts is an index of all the financial accounts used in your general ledger. Each account captures a specific type of financial activity, such as cash, accounts receivable, sales revenue, cost of goods sold (COGS), payroll expense, or retained earnings. When your accounts are organized logically, categorizing transactions becomes faster and financial reporting becomes far more reliable.

Why Getting the COA Right Matters

Accuracy: A thoughtful COA reduces misclassifications and rework at month-end.

Clarity: Team members can code transactions correctly without guesswork.

Comparability: Consistent accounts let you compare performance across months or business units.

Scalability: A flexible structure accommodates new products, locations, and growth.

Compliance: Proper groupings help with audit trails, tax categories, and disclosures.

Core Account Types (and What Belongs in Each)

Most small businesses can start with five families. Within each family, create subaccounts only when they will drive decisions or improve reporting clarity.

1) Assets

Resources the business owns or controls with future economic benefit.

Current assets: Cash, petty cash, checking, savings, accounts receivable, inventory, prepaid expenses, short-term deposits.

Noncurrent assets: Property and equipment, accumulated depreciation (contra), long-term investments, security deposits, intangible assets.

2) Liabilities

Obligations owed to others.

Current liabilities: Accounts payable, credit cards payable, sales tax payable, payroll liabilities, accrued expenses, customer deposits.

Long-term liabilities: Notes payable, loans payable, lease liabilities, deferred revenue beyond one year.

3) Equity

Owner financing and retained results: common stock or owner’s equity, additional paid-in capital, member contributions/distributions, retained earnings.

4) Income (Revenue)

Sales revenue, service revenue, subscription revenue, project revenue, other operating income. Consider separate streams if you need product line, channel, or region analysis.

5) Expenses

Costs to operate the business. At minimum: COGS (if applicable), payroll & benefits, occupancy, marketing, software, professional fees, merchant fees, utilities, office, travel, and other general & administrative (G&A).

Numbering Your Chart of Accounts

Numbering helps keep accounts in a logical order and makes reporting easier. A common scheme:

• 1000–1999: Assets
• 2000–2999: Liabilities
• 3000–3999: Equity
• 4000–4999: Income
• 5000–5999: Cost of Goods Sold
• 6000–6999: Operating Expenses
• 7000–7999: Other Income
• 8000–8999: Other Expenses

Leave gaps for growth. For example, assign 4100 for “Product Sales,” 4110 for “Service Revenue,” and reserve 4120–4199 for future income categories. Consistency is more important than the specific numbering pattern you choose.

Naming Conventions That Prevent Confusion

Use names that describe the economic event, not internal slang. Good names are short, unique, and unambiguous:

• Good: “Advertising & Promotion” (clear; covers ads, sponsorships, promos)
• Better: “Merchant Processing Fees” (avoids mixing with general bank fees)
• Avoid: “Misc Expense” (encourages lazy coding; creates audit headaches)

Tip: If two people could reasonably place the same transaction in different accounts, your labels need refinement or a short coding policy (one-page guide) with examples.

Dimensional Tracking: When Subaccounts Are Not Enough

Subaccounts add detail, but they can bloat reports. If your software supports classes, locations, or projects, use them for cross-cutting analysis—like departments, regions, or client work—while keeping the COA lean. The COA holds what the transaction is; classes/locations hold where or who it relates to.

How to Set Up Your COA (Step by Step)

Step 1: Define Reporting Needs

List the reports you truly use: monthly profit & loss, balance sheet, cash flow, job profitability, product margins. Only create accounts that feed these outputs.

Step 2: Start with a Minimal Skeleton

Create the five families and a handful of subaccounts. Resist over-engineering at the start. You can always add detail later, but merging or deleting accounts can break historical comparability.

Step 3: Map Tax-Sensitive Items

Set up accounts for sales tax payable, payroll liabilities, owner draws/distributions, depreciation, and interest. Keep these separate so compliance reporting is straightforward.

Step 4: Add COGS (If You Sell Products)

At minimum: Purchases, Direct Labor (if applicable), Freight In, and Inventory Adjustments. Clear naming avoids mixing operating expenses with COGS.

Step 5: Create Guardrails

Draft a one-page coding policy with examples (e.g., “SaaS tools → Software Subscriptions; online ads → Advertising & Promotion; merchant fees → Merchant Processing Fees”). Train anyone who codes transactions.

Step 6: Test With Real Transactions

Run several weeks of actual activity through the draft COA. Review your P&L and balance sheet. If managers still ask, “Where did this go?” adjust names or add a targeted subaccount.

Step 7: Lock and Monitor

Once finalized, restrict account creation to an administrator. New accounts should be rare and justified with a reporting need, not preference.

Mapping Transactions to the COA

Every transaction involves at least two accounts (debits and credits). For day-to-day coding, focus on the primary side that drives reporting:

• Customer receipt: Debit Cash; Credit Revenue (or Accounts Receivable if invoiced earlier).
• Vendor bill: Debit Expense or Inventory; Credit Accounts Payable.
• Credit card purchase: Debit Expense; Credit Credit Card Payable.
• Inventory purchase: Debit Inventory (asset) or Purchases (COGS, periodic method); Credit Cash/AP.
• Payroll run: Debit Wages Expense; Debit Employer Taxes; Credit Cash; Credit Payroll Liabilities.

When in doubt, trace the transaction’s purpose and match it to the economic substance: asset acquisition, revenue earned, expense incurred, liability created, or equity activity.

Industry-Specific COA Examples

Example A: Service Business (Consulting/Creative)

• Income: Service Revenue, Change Orders, Training Income
• Direct Costs: Subcontractors, Project Travel, Software Pass-Through
• Expenses: Salaries & Wages, Payroll Taxes, Advertising & Promotion, Software Subscriptions, Professional Fees

Why: Separate subcontractors and pass-through items to understand true project margin.

Example B: Retail/E-Commerce

• Income: Product Sales, Shipping Income, Promotions/Discounts (contra revenue)
• COGS: Purchases, Freight In, Inventory Adjustments, Packaging
• Expenses: Merchant Processing Fees, Marketplace Fees, Advertising & Promotion, Warehouse Rent, Returns & Allowances (contra expense or separate)

Why: Dedicated accounts for merchant and marketplace fees reveal net margin after platform costs.

Example C: Construction/Trades

• Income: Contract Revenue, Change Orders, Retainage Receivable (asset)
• COGS: Materials, Subcontractors, Equipment Rental, Direct Labor
• Liabilities: Customer Deposits, Retainage Payable

Why: Retainage accounts and customer deposits keep contract accounting clear and compliant.

Example D: Nonprofit

• Income: Contributions, Grants, Program Service Revenue
• Net Assets: Without Donor Restrictions, With Donor Restrictions
• Expenses: Program Services, Management & General, Fundraising

Why: Segregating net assets and functional expenses supports donor and board reporting.

COA for Inventory: Periodic vs. Perpetual

Periodic method: Purchases recorded in COGS during the period; an adjusting entry reclassifies to Inventory at period-end.

Perpetual method: Each sale relieves Inventory and books COGS in real time. Requires tighter item setup but yields real-time margins.

Choose the method that matches your volume, systems, and reporting needs. Either way, use distinct accounts for Purchases, Inventory Adjustments, and Freight In to maintain transparency.

Common Mistakes to Avoid

• Too many accounts: If you can’t remember what to use, you probably have too much granularity. Collapse low-value subaccounts.
• Catch-all buckets: “Miscellaneous” and “Other G&A” hide problems. Reassign entries or split the account with clearer names.
• Mixing COGS and operating expenses: Keep direct costs with COGS for proper gross margin analysis.
• Duplicated accounts: “Dues & Subscriptions” vs. “Subscriptions” causes split coding. Standardize and merge.
• Unmapped sales tax: Record sales tax to a liability account, not revenue or expense, to avoid misstating income.

Governance: Policies, Controls, and Maintenance

Create a brief COA policy that covers naming, numbering, who can add accounts, and when to archive/merge. Review the COA quarterly. If an account has no activity for a year and no clear purpose, consider inactivating it to reduce clutter without destroying historical data.

Pair COA discipline with a monthly reconciliation process. Reconcile bank, credit card, and key balance sheet accounts so miscodings surface early. Lock closed periods to protect prior reconciliations.

Frequently Asked Questions

How many accounts should I start with? Most small service businesses can operate with 60–120 accounts, including subaccounts. Product companies may need more for inventory and COGS detail.

When should I add a new account? Only when a manager needs to track that category separately for decisions or compliance. Otherwise, use classes, locations, or projects.

Can I change my COA later? Yes, but plan carefully. Merging accounts can affect historical reports. Document any changes and keep a mapping table.

How do I handle owner transactions? Use equity accounts for owner contributions and distributions. Avoid coding personal items to business expenses.

Example Starter COA (Service Business)

Here’s a concise starter set you can adapt. Replace or expand to match your operations.

• Assets (1000–1999): 1000 Cash, 1010 Savings, 1100 Accounts Receivable, 1200 Prepaid Expenses, 1300 Fixed Assets, 1310 Accumulated Depreciation
• Liabilities (2000–2999): 2000 Accounts Payable, 2100 Credit Cards Payable, 2200 Sales Tax Payable, 2300 Payroll Liabilities, 2400 Notes Payable
• Equity (3000–3999): 3000 Owner’s Equity, 3100 Owner Contributions, 3200 Owner Distributions, 3300 Retained Earnings
• Income (4000–4999): 4100 Service Revenue, 4110 Training Income, 4200 Other Operating Income
• COGS (5000–5999): 5100 Subcontractors, 5200 Project Materials (if applicable)
• Expenses (6000–6999): 6100 Salaries & Wages, 6110 Employer Taxes & Benefits, 6200 Advertising & Promotion, 6210 Merchant Processing Fees, 6300 Software Subscriptions, 6400 Rent, 6500 Professional Fees, 6600 Utilities, 6700 Office Expenses, 6800 Travel

Putting It All Together

A practical chart of accounts is intentional, lean, and aligned with the way you manage the business. Start with core accounts, label them clearly, and use dimensions (like classes or locations) for additional analysis. Maintain the COA with light governance and monthly reconciliations, and your financial reports will reflect the real story of your operations.