Chart of Accounts for Small Business: Examples and Setup Guide

A chart of accounts is the organized list of accounts used to classify a business’s transactions. It connects everyday bookkeeping with the balance sheet and income statement. A useful chart gives each transaction a consistent home without creating a separate account for every vendor, customer, or minor purchase.

This guide uses a fictional business and illustrative account numbers. Adapt the structure to your activities, accounting basis, reporting needs, and professional advice.

Download the Excel chart-of-accounts planning worksheet (.xlsx)

The five main account categories

“Usual balance” describes the normal direction, not a rule that every individual entry must follow. Contra accounts work in the opposite direction: accumulated depreciation is a credit-balance contra asset; owner draws normally reduce equity with a debit balance. Account titles alone do not determine correct treatment.

In QuickBooks Online, the selected account type affects where an account appears in reports. Account numbers are optional. See Intuit’s chart-of-accounts explanation and account-number guidance. Available features can vary by subscription.

A simple numbering example

One possible structure reserves 1000–1999 for assets, 2000–2999 for liabilities, 3000–3999 for equity, 4000–4999 for revenue, 5000–5999 for cost of goods sold, and 6000–7999 for operating and other expenses. These ranges are an editorial example, not a universal standard or legal requirement.

How to design your chart in seven steps

1. List the reports and decisions you need. Start with financial statements, budgets, tax-preparation support, and meaningful cost comparisons.
2. Review your current accounts. Export the list and recent activity. Identify duplicate names, inconsistent classifications, and accounts no longer used.
3. Choose consistent names and categories. Use clear descriptions such as “Software subscriptions.” Avoid vague accounts such as “Miscellaneous 2.”
4. Use subaccounts sparingly. A parent “Insurance expense” might contain useful insurance categories. Do not create levels that nobody uses in decisions.
5. Keep customer and vendor detail in subledgers. A separate general-ledger account for each supplier usually makes the chart difficult to manage. Use customer, vendor, project, location, or class fields where supported and appropriate.
6. Assign an owner and approval process. Require a purpose, report mapping, and reviewer before adding or changing an account.
7. Test the resulting reports. Review sample transactions, trial balance, balance sheet, income statement, and budget mappings before using the structure broadly.

Use the Excel planning worksheet

The workbook contains 29 fictional sample accounts plus blank planning rows. It records account code, name, category, statement, normal balance, purpose, parent account, approval status, reviewer, and mapping notes. It is a planning worksheet, not a software import file.

1. Save a working copy and identify the business and review date.
2. Keep codes as text so leading zeros remain intact if your numbering system uses them.
3. Replace the examples with accounts you actually need. Choose Proposed, Approved, Inactive, or Needs review in the status column.
4. Record the reason for each account and the old-to-new mapping when reorganizing an existing chart.
5. Have the appropriate reviewer approve classifications before configuring the accounting system.

The file is designed for Excel 2016 or later. It contains no macros, external data connections, or private business records. Store completed versions with appropriate access restrictions and a clear approved-version name.

Worked example: classify the transaction, not just the payment

A fictional business pays $1,200 for an annual insurance policy. If its accounting basis and policy require recognizing a prepaid asset, the initial entry debits prepaid insurance and credits cash. It then recognizes $100 per month as insurance expense over the 12-month coverage period. Coding the full payment to the current month’s expense would produce a different monthly result.

Similarly, a $600 loan payment might include $500 principal and $100 interest. Principal reduces the loan liability; interest is an expense. A payment to an owner might be a draw, distribution, reimbursement, loan repayment, or compensation depending on the facts and entity. Do not assume every bank withdrawal is an expense.

Changing an existing chart safely

Preserve historical reports and exports before reorganizing. Document how old accounts map to new ones. Renaming, merging, making inactive, and changing account types can have different effects across systems. Review the software’s official instructions and obtain appropriate accounting review before making changes that affect prior-period reporting.

Do not enter opening balances again simply because you added an account. During a genuine migration, reconcile opening balances to the approved trial balance, bank statements, receivables, payables, and other schedules, and check that conversion entries do not duplicate imported transactions.

Common mistakes to avoid

• Creating too many accounts to answer questions better handled by customer, vendor, or project reports.
• Changing classifications each month, making comparisons unreliable.
• Combining loan principal and interest in one expense account.
• Using one catch-all account without regular review.
• Changing account names without updating budgets, report mappings, or the data dictionary.

Frequently asked questions

How many accounts does a small business need?

There is no useful universal number. Use enough detail to support accurate statements and decisions, while keeping classifications consistent and manageable.

Are account numbers required?

Not in every system. Numbers can help organize the list, but clear account names and correct types matter more than a particular numbering convention.

Should every vendor have a separate account?

Usually vendor records provide that detail. The general ledger should describe the financial nature of the transaction; the vendor subledger identifies whom you owe or paid.

Is this worksheet ready to import?

No. Review it first, then use the current template and requirements supplied by your accounting software. Intuit provides separate instructions for adding accounts.

Build the rest of your reporting system

Continue with accounts receivable aging, budget-versus-actual variance analysis, and small-business data governance. Return to the Accounting learning hub for related guides.