Clean up your chart of accounts in QuickBooks Online
by Intuit• Updated 4 days ago
Learn how to use the Chart of accounts cleanup tool to find and fix duplicate, misnamed, and unused accounts.
QuickBooks works best when your transactions are sorted into clear categories, which make up your chart of accounts. Duplicate, overlapping, misnamed, and unused accounts make it harder to organise and read financial reports. They also make categorisation suggestions from Intuit Intelligence less accurate.
The Chart of accounts cleanup tool uses Intuit Intelligence to find these issues and suggest fixes. Nothing changes in your books until you review and approve each suggestion.
Before you start
- Chart of accounts cleanup is available in QuickBooks Online Simple Start, Essentials, Plus, and Advanced.
- It’s available to anyone with access to the chart of accounts.
- Some recommendations are only available to accountants.
- You only see a recommendation when QuickBooks finds something to fix, so you may see some or all of them.
- Note: You can’t undo changes after you approve them. Review each suggestion carefully.
Start a cleanup
- Go to All apps
, select Accounting, then select Chart of accounts (Take me there). - Select Clean up ▼ dropdown, then select Start cleanup session.
- Select Continue to review.
- Review the recommendations, one tab at a time.
Review the recommendations
Consolidate
Consolidate suggests combining related accounts to remove redundancies. For example, if you have a separate account for each supplier, QuickBooks suggests consolidating them into a single account and assigning a supplier to each transaction instead. QuickBooks assigns the supplier and other details to those transactions for you, so you don’t have to update them one by one. This simplifies reporting and makes it easier to see data on reports for specific suppliers, customers, and locations.
Consolidate can also group related accounts under a single parent account.
Read the Cleanup plan section to see the steps QuickBooks will take. If you approve, select Consolidate accounts. QuickBooks carries out the steps in the order shown.
Combine duplicates
Combine duplicates suggests combining accounts that track the same thing. For example, if you track phone costs in both a ‘Phone’ and a ‘Telephone’ account, you’d have to run reports for these accounts separately, or add up their totals manually, to see your complete phone expenses.
Review each group of accounts. To leave an account out of a group, select the X next to it. To combine the rest, select Combine accounts, and follow the next steps.
Make inactive
Make inactive shows accounts you haven’t used in a long time. Use the filters to select how far back to look. You can select an account to review how it’s been used. If you don’t need it anymore, make it inactive.
Removing unused accounts simplifies reports and makes it easier to select the right account on transactions. If your plan has an account limit, this also helps you stay under it.
Rename
Rename suggests new names for accounts to improve clarity and consistency. It looks for inconsistent capitalisation, extra symbols, and spelling mistakes.
Choose the suggestions you want to apply, edit any of them, then select Rename.
Change type
Change type shows accounts that may have the wrong type, and may even show up on the wrong financial statement. If QuickBooks thinks an account should have a different type, it suggests a new account type and detail type. Select the updates you approve, then select Update account types.
If you’ve closed your books
If you’ve closed your books as of a certain date, it’s best practice not to change records in the closed period.
By default, Chart of accounts cleanup respects your closed books date and won’t make changes to any transactions before it. For example, if you make an account inactive, it only moves transactions dated after the closed books date. Earlier transactions stay in the inactive account, so financial reports you’ve already filed don’t change.
You’ll have the option to choose a different date if needed before QuickBooks makes any changes.
Make your own changes in edit mode
You can also use edit mode to make changes to multiple accounts yourself.
- Go to All apps
, select Accounting, then select Chart of accounts (Take me there). - Select Clean up ▼ dropdown, then select Open chart of accounts in edit mode.
You’ll see all your accounts, grouped the same way they appear on a financial statement. You can edit account names, account numbers, account types, and detail types, and even lock accounts. QuickBooks automatically saves your changes as you make them.
You can also organise accounts into parent and subaccounts:
- To make an account into a subaccount, drag it under a parent account.
- To make a subaccount a parent account, or move it up a level, drag it to the left.
You can’t drag accounts into a different order, because the chart of accounts is always sorted by column. You also can’t drag an account into a different group, because edit mode groups accounts by type. If you want to move an account to another group, change the account type.
If you use account numbers, QuickBooks suggests a number when you drag an account without one under a parent. It never changes an existing account number without your permission. To turn off these suggestions, select the ⚙ Settings in edit mode.
Related links
More like this