Too Many Accounts in QuickBooks? A Practical Guide to Cleaning Your Chart of Accounts

My Chart of Accounts Has 200 Lines: How to Shrink It Without Wrecking Your Reports

Hi, I’m Elena. I love a good Chart of Accounts the way some people love a well-organized toolbox.

If you don’t, you’re in good company. Here’s a message I got from a client last month:

“We have a separate expense account for every tiny thing we’ve ever bought. It’s like a graveyard. I scroll forever to find anything. I’m terrified to delete anything because I don’t want to break the reports my CPA uses.”

This is one of the most common QuickBooks Online problems I see: account sprawl.

The Intuit help docs quietly confirm it: your Chart of Accounts is the backbone of how QuickBooks reports work, and the only “reset” option they officially recommend is to carefully inactivate accounts, not mass-delete them. On Reddit and in bookkeeper groups, the advice is even more direct: “Hide or deactivate what you don’t need, merge the obvious duplicates, and stop making new accounts for every little thing.”

In this guide, I’ll walk you through:

How to know your Chart of Accounts is bloated (it’s not just about the number)
How to identify what your “core” account set should be
How to safely inactivate and merge accounts without blowing up history
When to use sub-accounts, and when to avoid them
What to do with accounts you can’t delete, no matter how much you want to

How to Tell If Your Chart of Accounts Is Actually the Problem

Plenty of users have long account lists that are annoying but not dangerous. Others have lists that are actively making their financials misleading.

Here are the red flags I look for:

You have multiple accounts with nearly the same name, like “Software,” “Subscriptions,” “Online Subscriptions,” “Apps,” and “SaaS.”
You have expense accounts with tiny year-to-date totals — a few dollars here, a few dollars there — scattered across the P&L.
You see income accounts like “Sales,” “Sales Income,” “Product Sales,” and “Store Sales” that all seem to overlap.
When you run a Profit & Loss, your brain shuts down halfway because there are too many lines to scan.
Your tax preparer quietly consolidates lines on their own schedule because your categories are too granular to be useful.

If that feels familiar, your CoA isn’t just messy; it’s probably hiding patterns that would be obvious with a cleaner structure.

QuickBooks itself describes the Chart of Accounts as the list that drives every report, and recommends using clear account types and a manageable number of accounts. Many pros recommend starting cleanup here before any other fix.

Step 1 – Take an “X-Ray” of Your Current Accounts

We’re not deleting anything yet. We’re just scanning.

H3: Run a Year-to-Date P&L and Balance Sheet

Go to Reports → Profit and Loss.
Set the date range to This year-to-date (or last full year if you’re reviewing history).
Click Run report.

Then:

Go to Reports → Balance Sheet.
Set the same date range.
Click Run report.

On the P&L, you’re looking for:

Long lists of expense accounts with tiny amounts (under, say, 100–200 in your currency).
Multiple income accounts whose names are variations on the same theme.
“Catch-all” accounts like “Miscellaneous” or “General” with big balances.

On the Balance Sheet:

Look for multiple similar asset or liability accounts that could be combined.

H3: Export to Excel or Sheets (Optional But Helpful)

QuickBooks lets you export your Chart of Accounts and your P&L detail:

In Chart of Accounts, click the Run report button at the top and then use the Export button.
In Profit and Loss, export to Excel as well.

This gives you a playground to highlight:

Accounts with small balances.
Accounts with overlapping names.
Obvious “why does this exist?” categories.

Step 2 – Decide What Your “Core 40” (or 20) Should Be

I’m not a fan of arbitrary universal lists — a Shopify store and a consulting firm do not need the same Chart of Accounts. But every business benefits from a core set of accounts that do 90% of the work.

Think in groups:

Income: A handful of revenue accounts that actually matter (e.g., Product Sales, Service Income, Other Income).
Cost of Goods Sold (if you have inventory): Direct costs only.
Operating Expenses: Clusters like Rent, Payroll, Marketing, Software & Subscriptions, Professional Fees, Utilities.
Other Income/Expenses: Interest income, interest expense, unusual one-offs.
Assets & Liabilities: Bank accounts, credit cards, loans, a small set of fixed assets, a clear equity section.

The goal isn’t to force everything into 20 accounts forever. It’s to stop creating a fresh account every time you buy something new.

A lot of bookkeeping pros recommend using sub-accounts — for example, a main “Marketing & Advertising” account with sub-accounts for specific channels — instead of spawning new top-level accounts. We’ll come back to that.

For now, sketch:

5–10 income accounts
10–20 expense accounts
A minimal list of assets, liabilities, and equity accounts that reflect your real structure

This is your “target” CoA.

Step 3 – Inactivate the Truly Unused Accounts

QuickBooks’ own guidance is clear: inactivating accounts is the safest way to simplify your Chart of Accounts without damaging historical data. Deleting is limited and often not available when there’s any history.

How to Inactivate Accounts Safely

Go to Accounting → Chart of Accounts.
Filter by All or Active to see your full list.
For each account you’re sure you’ll never use again:

Click the dropdown arrow in the Action column.
Choose Make inactive.

What this does:

Hides the account from your everyday lists (so it’s not cluttering your dropdowns).
Keeps historical transactions intact; reports that include historical periods will still show the old balances.

Reddit advice matches this: “Just hide or deactivate the ones that don't apply to you — go to Accounting > Chart of Accounts and click the dropdown next to any account to make it inactive.”

Which Accounts to Inactivate First

Start with accounts that:

Have zero activity for the last several years.
Were created by mistake and never really used.
Are duplicates in concept but contain no actual transactions (for example, you created “App Subscriptions” but ended up posting everything to “Software & Subscriptions”).

If an account has just a handful of transactions but clearly overlaps another category, put it on your merge list, not your inactive list, for now.

Step 4 – Merge Obvious Duplicates (The Safe Way)

QuickBooks Online has a powerful but slightly scary feature: if you rename one account to have the exact same name and setup as another, QuickBooks will merge them and move all historical transactions into the remaining account.

This is ideal for combining duplicates like:

“Software” and “Subscriptions” into a single “Software & Subscriptions”
“Office Supplies” and “Office Expense”
“Sales Income” and “Product Sales”

How to Merge Two Accounts in QuickBooks Online

Go to Accounting → Chart of Accounts.
Identify the primary account you want to keep (for example, “Software & Subscriptions”).
Identify the secondary duplicate (for example, “Subscriptions”).
Click Edit on the secondary account.
Change the Name to match the primary account’s name exactly (case, spacing, punctuation).
Make sure the Account Type and Detail Type match as well.
Click Save.
QuickBooks will warn you that an account with that name already exists and ask if you want to merge them. Confirm.

After this:

All transactions from the secondary account now live under the primary account.
The secondary account disappears from your list.

This is permanent, so I strongly recommend:

Exporting your CoA and a P&L before merging anything.
Starting with one simple, low-risk merge (like two rarely-used miscellaneous accounts) to build your confidence.

What Not to Merge Without Professional Help

Avoid merging:

Accounts that map to different tax forms or compliance reporting (for example, wages vs subcontractors, or income types that map differently to 1099s).
Accounts with very different account types (Assets vs Expenses).
Accounts your CPA specifically set up for year-end adjustments.

If you’re unsure, make a quick “Ask CPA before merging” list with screenshots.

Step 5 – Use Sub-Accounts When You Actually Need Detail

One common reason people end up with 200+ accounts is that they crave detail — but they implement it in the most painful way possible: everything is a separate top-level account.

A better pattern is:

Pick a simple main account
Add sub-accounts only where detail genuinely matters

For example:

Main account: Marketing & Advertising

Sub-accounts: Google Ads, Meta Ads, Sponsorships, Events

Main account: Software & Subscriptions

Sub-accounts: Accounting, CRM, Email, Project Management

This way:

At high level, your P&L shows a clean line “Marketing & Advertising.”
If you want detail, you can expand that line to see the sub-accounts.

QuickBooks Online supports sub-accounts directly in the Chart of Accounts. Many cleanup guides suggest converting redundant top-level accounts into sub-accounts instead of deleting them outright.

Guidelines from both Intuit docs and pro videos:

Don’t go more than one or two levels deep (parent → child, maybe grandchild, but no deep nesting).
Only use sub-accounts where you will actually read and use the extra detail.
Don’t create “cemetery” sub-accounts for every one-off purchase.

Step 6 – What to Do with Accounts You Can’t Delete

Certain QuickBooks accounts are built-in and can’t be deleted, because they’re tied to system features or cash vs accrual reporting.

Examples include:

Undeposited Funds
Opening Balance Equity
Some special cash-basis adjustment accounts

Intuit support is pretty blunt about this: inactivating accounts is often the only option; some system accounts can’t even be inactivated. In pro videos, a common workaround is to leave those accounts active but give them no account number or tuck them out of the way, so they sit at the bottom of your list.

My approach:

Don’t fight the system accounts.
Make sure you understand what they do (for example, Undeposited Funds is how QBO batches multiple payments into one bank deposit).
Hide them from your mental view by:

Not giving them account numbers.
Keeping them collapsed in reports unless you’re troubleshooting.

Perfection is not the goal. Usability is.

Step 7 – A Simple Ongoing CoA Hygiene Routine

Once you’ve done the big cleanup, keeping your Chart of Accounts tidy is mostly about saying “no” to unnecessary new accounts.

Here’s the routine I recommend:

Monthly glance

When you run your monthly P&L, scan for any brand-new account names with tiny balances.
Ask, “Does this really deserve its own account, or can it live under an existing category?”

Quarterly cleanup

Inactivate any obvious “one-and-done” accounts that were mistakes.
Merge any duplicates that snuck through.

Year-end review with your CPA

Before tax season, send your CPA a copy of your Chart of Accounts.
Ask which accounts they actually use in their tax software, and which could be consolidated safely.

QuickBooks and multiple clean-up checklists agree on one thing: start any books cleanup by getting the Chart of Accounts under control. Otherwise, every other fix just feeds more data into a confusing structure.

How This Connects to the Rest of Your Cleanup

If your Chart of Accounts is a mess, chances are your bank feed history and your “junk drawer” accounts (Uncategorized, Ask My Accountant) are also overloaded.

In this series:

Article 1 covers what to do when you’ve been clicking Add on bank feeds and accidentally doubled your income.
Article 2 covers what to do when reconnecting your bank dumped 8–15 months of duplicate transactions into QuickBooks overnight.
Article 3 (this one) addresses the underlying structure: your Chart of Accounts.

Next, we’ll tackle:

“Year-End Junk Drawer: How to Triage Mystery Transactions, ‘Ask My Accountant’, and Uncategorized Everything.”

That article focuses on:

Clearing out Uncategorized Income/Expense
Handling Ask My Accountant and Suspense accounts
Deciding which mystery transactions are worth chasing and what can be reasonably parked

If your P&L currently has thirty lines of “Uncategorized Something,” that’s your next stop.

Search This Blog

qb-insider