Skip to content
Tutorials Center
My learning

Topics

Lesson 5 of 36 ยท Setup and Chart of Accounts

The QuickBooks Chart of Accounts: Design, Numbers and Sub-accounts

Design a clean QuickBooks chart of accounts: account types and detail types, numbering, sub-accounts, importing, merging, making accounts inactive and common mistakes.

The chart of accounts (COA) is the list of every account in your books: where each dollar of sales, each expense and each balance lives. Every transaction posts to accounts from this list, and every report groups by it. A well-designed chart gives you useful reports with little effort; a messy one buries information. This lesson shows how to view, build and maintain it.

Open the chart

Go to gear > Chart of accounts (in some layouts, Accounting > Chart of accounts). You see columns for Number (if enabled), Name, Type, Detail type, QuickBooks balance and Bank balance (for connected accounts). The Run Report drop-down at the row's end opens the account's transactions (the account QuickReport), and the row's View register shows balance-sheet accounts like a checkbook.

Account types and detail types

Each account has a type (the big category) and a detail type (the specific kind). The main types:

Group Types
Assets Bank, Accounts receivable (A/R), Other current assets, Fixed assets, Other assets
Liabilities Accounts payable (A/P), Credit card, Other current liabilities, Long-term liabilities
Equity Equity
Income Income, Other income
Expenses Cost of goods sold, Expenses, Other expense

Detail types refine reporting and tax mapping: type Expenses with detail type Rent or Lease of Buildings, for example. Choose the closest match; it is used by some tax reports.

You get exactly one A/R account and one A/P account for each currency by default. QuickBooks creates them automatically the first time you enter an invoice or a bill.

Add an account

  1. Click New at the top right of the chart.
  2. Pick the Account type and Detail type.
  3. Enter a Name (and Number if used). Names must be unique within the chart.
  4. Optionally tick Is sub-account and choose a parent.
  5. Add a description and, for balance-sheet accounts, an optional starting balance. Prefer entering opening balances properly (see opening balances).
  6. Save and close.

Numbering scheme

Enable numbers in Account and settings > Advanced > Chart of accounts. A common scheme groups by first digit:

Range Accounts
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 and expense

Leave gaps (1000, 1010, 1020) so new accounts fit between existing ones.

Sub-accounts

A sub-account rolls up into a parent. For example, parent Utilities with sub-accounts Electricity, Water and Internet. Reports can show the subtotal or the detail. Use sub-accounts for useful detail, not to mirror every vendor; too many accounts make reports unreadable. For per-customer, per-project or per-department analysis use classes, locations and tags instead of more accounts (available on higher plans).

Edit, merge and inactivate

  • Edit: change name, number or detail type. The type can change only within its group.
  • Merge: edit one account and give it the exact name of another of the same type; QuickBooks offers to merge them. The change cannot be undone, so back up by exporting the chart first.
  • Make inactive: from the row's drop-down. Inactive accounts keep their history but disappear from lists. An account with a non-zero balance should be cleared first.
  • Import and export: use gear > Import data > Chart of accounts with the sample spreadsheet to load many accounts at once, and Export from the chart's utility icons.

Design principles

  • Start small. Add an account only when you will actually report on it.
  • One purpose per account. Do not park unknown items in "Miscellaneous".
  • Use detail types honestly so tax reports map correctly.
  • Avoid Uncategorized accounts as a long-term home; QuickBooks creates Uncategorized Income/Expense/Asset when it cannot tell, and these need to be cleared during review.
  • Keep owner money in equity (Owner's draw, Owner's investment), never in expenses.

Stand-in: a chart of accounts validator

This stand-in treats the chart as data and checks the rules above: unique names, numbers in the right range, parents that exist.

Python Stand-in: validating a chart of accounts

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Python Stand-in: rolling sub-accounts up to a parent

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What are the two classification levels of an account?

    The type is the broad category; the detail type is the specific kind used by reports and tax mapping.
  2. 2. What is a good way to track profit by department without hundreds of accounts?

    Classes and locations (on supporting plans) tag transactions for analysis without growing the chart.
  3. 3. How do you merge two accounts?

    Giving an account the exact name of another of the same type triggers a merge, which cannot be undone.
  4. 4. Why leave gaps in account numbers?

    Gaps like 6100, 6110, 6200 leave room for future accounts.

Summary

  • The chart of accounts is the backbone of all reports; design it deliberately.
  • Each account has a type and a detail type; use sub-accounts sparingly and classes for extra dimensions.
  • Number accounts by group with gaps; add accounts only when you need to report on them.
  • Merge or inactivate accounts with care; export a backup first.

Next: Opening balances and the conversion date