What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/What Is a Chart of Accounts in QuickBooks?
QuickBooks explained

What Is a Chart of Accounts in QuickBooks?

It's the list of buckets your money gets sorted into. Every invoice, bill and bank line is assigned to one, and every report you run, from the P&L to the balance sheet, is those buckets added up.

Where to open it

QuickBooks Online: the gear icon, then Chart of accounts. In the newer layout it's also under All apps, then Accounting.

Settings Chart of accounts

QuickBooks Desktop: the Lists menu, then Chart of Accounts.

Lists Chart of Accounts

QuickBooks gave you a starting list based on the industry you picked at setup. It's a sensible default, not one built around your business.

The five types every account belongs to

Under each type, a detail type tells QuickBooks how the account behaves, for example Checking or Savings under Bank, or Travel under Expenses.

Type What's in it Shows up on
Assets Bank accounts, money customers owe you, inventory, equipment Balance sheet
Liabilities Credit cards, bills you owe, loans, sales tax collected Balance sheet
Equity Owner's contributions and draws, retained earnings Balance sheet
Income Sales, service revenue, other income Profit and loss
Expenses Rent, wages, supplies, cost of goods sold Profit and loss

Working with the list in QuickBooks Online

  1. 1

    Add an account only when a report needs it

    Chart of accounts New

    Pick the account type and detail type, then name it the way your team talks. Before adding one, ask whether you'd ever want to see that number on its own line. If not, an existing account will do. A sub-account keeps detail without cluttering the top level.

  2. 2

    Rename or retype freely

    Changing a name or detail type doesn't touch past transactions. To switch on account numbers, go to Account and settings, then Advanced, and turn on account numbers in the chart of accounts section.

  3. 3

    Retire an account with Make inactive

    Action column Make inactive

    Online can't fully delete an account, only make it inactive or merge it into another. Inactive accounts drop out of dropdowns, but their old transactions stay on reports.

    Watch for: a balance. If a balance sheet account isn't at zero, QuickBooks zeroes it with an automatic entry to Opening Balance Equity. Move the balance yourself first.

  4. 4

    Import a full list from a spreadsheet

    Settings Import data Chart of accounts

    Upload an Excel, Google Sheets or CSV file with account name, type, detail type and, if you use them, numbers. It's built for setting up a new company in bulk.

  5. 5

    Export or print it

    Chart of accounts Run report

    Run report at the top of the list turns it into a report you can export to Excel or PDF, or print. Printing the plain list view directly doesn't give you a clean copy.

Questions people ask

How do I export my chart of accounts in QuickBooks?

In Online, open the chart of accounts, choose Run report, then use the export icon for Excel or PDF. In Desktop, run the Account Listing report from the Reports menu under List, and export it from there.

How do I import a chart of accounts into QuickBooks Online?

Go to Settings, then Import data, then Chart of accounts, and upload your spreadsheet with name, type and detail type columns. It's meant for loading a new company's accounts, not for merging two existing charts.

How do I delete an account from the chart of accounts in QuickBooks?

In Online you can't delete one, only make it inactive from the dropdown in the Action column, or merge it into another account. Default accounts and accounts used by products and services can't be made inactive. In Desktop, an account that's never been used can be deleted from the Edit menu, and one with history can be made inactive.

How do I print my chart of accounts?

Use Run report from the chart of accounts list, then the print icon on the report. That gives you a proper page layout instead of the on-screen list.

How do I set up a chart of accounts for a new business?

Start from the list QuickBooks builds when you pick your industry, then trim what you'll never use and add the income and expense lines you'll want to see separately. Add new accounts one at a time, or import a spreadsheet if your accountant has already drafted one.

How a chart of accounts drifts out of shape

Too few accounts. The business adds a product line, a second location or a new way of billing, and it all keeps landing in one generic income account. The P&L can't tell you which part is making money.

Too many. A new account gets created every time someone isn't sure where a purchase goes. Forty expense lines, half of them near-duplicates, take longer to read than twelve that mean something. Merging two accounts is how you fold them back together.

Other apps with their own lists. A POS, an online store, a payroll provider and a CRM each have their own categories, and each sync maps them onto your chart. When a new menu category or product type appears on their side, it often lands in a catch-all account, or in uncategorized, and nobody notices until quarter-end.

Neither QuickBooks nor those apps keep that mapping honest over time. Someone has to look at the chart like a filing system now and then, and ask whether it still answers the questions the business actually has.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.