A QuickBooks chart of accounts cleanup comes down to 9 steps: back up, list, group, merge, reclassify, inactivate, rename, review and lock. Intuit says a merge is permanent, so prepare first. A broken chart of accounts is one of the most common problems we see.
Last updated October 26, 2026. Reviewed by Aryan Patel, founder of Senvora Group, a bookkeeping firm that supports CPA firms and business owners in the US, UK, Canada and Australia. Everything we say about QuickBooks behavior comes from Intuit help pages, linked in the Sources section. The step order is our own method, and we say so where it matters.
Key takeaways
- Intuit says merging accounts is permanent and cannot be undone. Back up and save your reports before you merge anything.
- Per Intuit, you cannot delete an account in QuickBooks Online. You can make it inactive or merge it into another one.
- Inactive accounts and their transactions still show on reports. Making an account inactive does not erase history.
- Uncategorized Income, Uncategorized Expense and Opening Balance Equity are accounts QuickBooks creates for you. Treat a growing balance in any of them as a to do list.
- A common problem we see in QuickBooks files: a broken chart of accounts. Average cleanup cost was $600 to $1,200.
Why a messy chart of accounts hurts
The Intuit chart of accounts overview describes the chart as a complete list of your accounts and their balances. Every transaction touches at least two accounts. Categorized transactions then feed your Profit and Loss and Balance Sheet.
So if the list is a mess, the reports are a mess. Two accounts for the same thing split your numbers in half. A vague account hides what you really spent. A dead account clutters every dropdown.
We see this all the time. In our 5 QuickBooks setup errors we see most, a broken chart showed up as duplicates, catch all categories like Miscellaneous, and far too many accounts. One example was a 5 person business with 89 active accounts. Reclassifying it took 12 hours.
Common signs of a messy file:
- Two or more accounts with nearly the same name, like Software and Software Subscriptions.
- Contractors and Freelancers as separate accounts, which hides your real labor cost.
- A Miscellaneous or Other account holding a big slice of your spending. Our audit used 5% of total spend as the warning line.
- More than 15 expense accounts for a business under $1M in revenue. That is our own audit rule of thumb, not an Intuit rule.
- A Profit and Loss report that runs for pages.
- Accounts nobody can explain and nobody has touched in a year.
Know the rules before you touch anything
Intuit publishes some firm limits. Read these first. They shape the whole cleanup.
Merging
The Intuit page on merging duplicate accounts says merging moves past transactions into the account you keep and makes the duplicate inactive. It also says:
- Merging is permanent and cannot be undone. Use it only for accounts that were created by mistake.
- Both accounts must have the exact same name, account type and detail type before a merge can succeed. So you edit the duplicate to match the one you keep.
- Do not merge accounts connected to online banking, or accounts QuickBooks creates for you.
- The account you merge away loses its reconciliation history. Save those reconciliation reports first. The transactions stay and remain reconciled.
- If both accounts have an opening balance equity transaction, delete the most recent one before you merge. The older one becomes the opening balance.
- Two parent accounts must have no subaccounts. Two subaccounts must share the same parent.
Making accounts inactive
The Intuit page on making an account inactive says making an account inactive removes it from your active list and blocks new transactions. It does not remove the transactions. It also says:
- You cannot delete an account. You can only make it inactive or merge it.
- Inactive accounts and their transactions still appear on reports. Hiding them in a custom report may affect accuracy.
- Default accounts cannot be made inactive.
- An account with subaccounts cannot be made inactive. Move the subaccounts first.
- An account used by a product or service cannot be made inactive until you change the linked account.
- A balance sheet account should have a zero balance first. If it does not, QuickBooks makes an automatic adjustment and adds it to Opening Balance Equity.
- If you reactivate an account later, the balance is not moved back.
Intuit also suggests reaching out to your accountant before you make this change. Good advice. We would add that you should do it on a day you are not closing a month.
The accounts QuickBooks creates for you
The Intuit chart of accounts overview lists default accounts, including Opening Balance Equity, Retained Earnings, Undeposited Funds, Uncategorized Expense and Uncategorized Income. The Intuit page on default and special accounts adds some detail:
- Uncategorized Income and Uncategorized Expense are created automatically. They track money your business earned or spent that still needs a category. You can edit them, but not make them inactive or merge them.
- Opening Balance Equity is the default account for adjustments. You can edit its name, but you cannot make it inactive.
- Services, the default income account, can be renamed but not deleted. Intuit suggests renaming it to reflect your main type of income.
- Retained Earnings can be renamed, but Intuit advises against it.
On opening balances, the Intuit page on opening balances says QuickBooks uses Opening Balance Equity to offset those entries and keep your books balanced. It warns that older transactions are summarized in the opening balance. Add them without adjusting it and you double count money. Talk to your accountant before you do that.
We did not find an Intuit page that defines an Ask My Accountant account, so we will not tell you what it is. If you see one in your file, check what is sitting in it and where those items belong.
How to clean up your QuickBooks chart of accounts in 9 steps
This is our method, built from the rules above. It is not an official Intuit procedure. Follow it in order.
- Back up first. Export your chart of accounts. Save a Profit and Loss and a Balance Sheet for the periods you care about. Save reconciliation reports for any account you might merge. You cannot undo a merge, so this is your safety net.
- List every account. Put them in a spreadsheet with account type, detail type, balance and the date of the last transaction. Include inactive ones so you see the full picture.
- Group the duplicates. Sort by name and look for near matches. Software, Software Subscriptions and Software Expenses belong in one group. Decide which single account you keep in each group.
- Merge true duplicates only. Edit the duplicate so its name, account type and detail type match the keeper. Then merge. If two accounts mean different things, do not merge them. Move the transactions instead.
- Reclassify catch all accounts. Open the register or a transaction report for Miscellaneous, Other and any Uncategorized account. Recode each item to a real category. Then add bank rules so it stops happening.
- Make dead accounts inactive. If an account has no recent activity and a zero balance, make it inactive. Check for subaccounts, linked products and recurring transactions first.
- Rename for plain English. A CPA should understand every name at a glance. Drop initials, vendor names and inside jokes. If you use account numbers, the next step helps.
- Review Opening Balance Equity. It should not be a parking lot. If it holds a balance, find out where it came from before you move anything. Involve your accountant.
- Lock the structure. Write a one line rule: nobody adds an account without approval. Then consider locking accounts you have settled. Intuit says locked accounts are grayed out in dropdowns, bank rules posting to them stop running, and bank feeds stop predicting them. It also says third party apps can still post to a locked account.
Take your time with steps 3 and 4. Rushing a merge is the one mistake you cannot reverse.
Should you use account numbers?
Optional, and often smart. The Intuit page on account numbers says the feature is off by default. You can assign numbers one by one or in a batch. Any numbering system works, though Intuit recommends following GAAP and lists these ranges:
- 10000 to 19999: Assets
- 20000 to 29999: Liabilities
- 30000 to 39999: Equity
- 40000 to 49999: Income or Revenue
- 50000 to 59999: Job Costs or Cost of Goods Sold
- 60000 to 69999: Expenses or Overhead Costs
- 70000 to 79999: Other Income
- 80000 to 89999: Other Expenses
The Intuit chart of accounts overview calls account numbers optional and not required. Numbers keep your chart in a steady order and make it harder to create a second copy of the same account.
A sample clean chart of accounts skeleton
Here is a simple starting point. It is a suggestion, not an Intuit template and not a rule. Your industry will add or remove rows. Keep it short and keep it boring.
| Account type | Example names | Why it exists |
|---|---|---|
| Bank and cash | Operating Checking, Savings, Petty Cash | One account per real bank account so every statement can be reconciled. |
| Receivables and payables | Accounts Receivable, Accounts Payable | Tracks what customers owe you and what you owe vendors. |
| Credit cards | Business Visa, Business Amex | One per card. Reconcile each one to its statement. |
| Other current assets | Undeposited Funds, Prepaid Expenses | Holds money in transit and costs paid ahead of time. |
| Fixed assets | Equipment, Vehicles, Accumulated Depreciation | Big purchases that last more than a year, plus their depreciation. |
| Liabilities | Payroll Liabilities, Sales Tax Payable, Business Loan | Money you owe that is not a regular bill. |
| Equity | Owner Contributions, Owner Draws, Retained Earnings | Separates owner money from business income and expenses. |
| Income | Service Revenue, Product Sales, Other Revenue | One account per real revenue stream so you can see what earns. |
| Cost of goods sold | Materials, Subcontractors, Shipping Costs | Direct costs of delivering what you sell. |
| Operating expenses | Rent, Software, Payroll Expense, Professional Fees, Insurance, Marketing, Bank Fees | A short list of clear buckets. Add detail with subaccounts only when you will actually use it. |
| Other income and expense | Interest Income, Interest Expense | Keeps non operating items out of your main results. |
Notice what is missing. No Miscellaneous. No Other. No Stuff. If a cost does not fit, add the right account on purpose, with approval, instead of hiding it.
When to bring in help
Cleanup is fine to do yourself on a small file. It gets harder when the file is years behind, when reconciliations are missing, or when you need to restate reports for a CPA. If that sounds familiar, read our retroactive bookkeeping guide and our wrong company start date fix. Our QuickBooks Online cleanup checklist before year end also covers the other checks worth running while you are in there.
Still unsure? A short review by a bookkeeper can save you from a bad merge. That is part of what our outsourced bookkeeping service does for business owners and CPA firms.
Frequently asked questions
Can I delete an account in QuickBooks Online?
Intuit says you cannot delete an account. You can make it inactive or merge it with another account. Inactive accounts and their transactions still appear on reports.
Can I undo a merge in QuickBooks Online?
No. Intuit says merging is permanent and cannot be undone. It also says the account you merge away loses its reconciliation history, so save those reports first.
Can I merge accounts that have different names or types?
Intuit says both accounts must have the exact same name, account type and detail type before a merge can succeed. You edit the duplicate to match the account you keep, then merge.
Can I make Uncategorized Income or Opening Balance Equity inactive?
Per Intuit, you can edit Uncategorized Income and Uncategorized Expense, but you cannot make them inactive or merge them. Opening Balance Equity can be renamed but not made inactive. Our advice is to keep their balances near zero by recoding the items sitting in them.
How many accounts should my chart of accounts have?
There is no Intuit number. In our audit we flagged more than 15 expense accounts for a business under $1M in revenue, and we saw a 5 person business with 89 active accounts. Treat that as our rule of thumb, not an official limit.
Sources
- Intuit chart of accounts overview (quickbooks.intuit.com)
- Intuit page on merging duplicate accounts (quickbooks.intuit.com)
- Intuit page on making an account inactive (quickbooks.intuit.com)
- Intuit page on default and special accounts (quickbooks.intuit.com)
- Intuit page on account numbers (quickbooks.intuit.com)
- Intuit page on opening balances (quickbooks.intuit.com)
- Senvora 5 QuickBooks setup errors we see most (senvoragroup.com)
Want a second pair of eyes on your chart of accounts?
Senvora Group handles outsourced bookkeeping for business owners and CPA firms, including chart of accounts cleanups that leave a file easy to read. You can check our outsourced bookkeeping pricing breakdown, or DM Aryan. How many accounts are sitting in your chart right now?
