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.
QuickBooks Online: the gear icon, then Chart of accounts. In the newer layout it's also under All apps, then Accounting.
Settings › Chart of accountsQuickBooks Desktop: the Lists menu, then Chart of Accounts.
Lists › Chart of AccountsQuickBooks 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.
Working with the list in QuickBooks Online
- 1
Add an account only when a report needs it
Chart of accounts › NewPick 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
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
Retire an account with Make inactive
Action column › Make inactiveOnline 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
Import a full list from a spreadsheet
Settings › Import data › Chart of accountsUpload 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
Export or print it
Chart of accounts › Run reportRun 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.