QuickBooks HelpQuickBooksHelpIntuit

Merge duplicate accounts

by Intuit839 Updated 2 weeks ago

Merge duplicate accounts to keep your records organized and avoid mistakes. Move all the data into the account you want to keep and make the duplicate account inactive.

Note: Some accounts created by QuickBooks, such as accounts connected to online banking, can’t or shouldn't be merged. If you want to merge, for example, the direct deposit funding account, contact support.

If you're an accountant, there's a different merging process to combine multiple of your firm’s client lists

icon of an agentIf you need help managing your chart of accounts, you can partner with QuickBooks Live Experts and feel more confident. Find out more about QuickBooks Live Bookkeeping.

For a better experience, open this article in QuickBooks Online. Open side-by-side view Open this link in a new window

Prerequisites

If you're merging accounts that have reconciliation reports: 

  • The account being merged won't keep its reconciliation history
  • Save those reports first so you don’t lose them
  • The transactions will remain on the merged account and stay reconciled

If both account registers have an opening balance equity transaction:

  • Delete the transaction with the most recent date prior to merging
  • The older transaction becomes the opening balance of the newly merged account

Merge duplicate accounts

Important: Merging accounts is permanent and can't be undone later. Only merge duplicates you made by mistake.

  1. To view your chart of accounts: Follow this link to complete the steps in product Open this link in a new window
  2. Find the account you want to keep. Then, select the dropdown ▼ in the Action column and then Edit.
  3. Note the Account Name, Account Type, and Detail Type of the account. These must be the same between the accounts you want to merge.
  4. Check if the account is a subaccount or a parent account. The names of subaccounts are indented in the Name column of the Chart of accounts list. If it is, note the parent account it's tied to.
  5. Go back to Chart of accounts (Take me there).
  6. Find the duplicate account (the one you won't keep). Then select the dropdown ▼ in the Action column and then Edit.
  7. Change the Account name and Detail Type to that of the account you want to keep.
  8. If you need to make this a subaccount, keep in mind:
    1. If you're merging two parent accounts, make sure they don’t have any subaccounts.
    2. If you're merging two subaccounts, make sure they both have the same parent account.
    3. If you’re merging a subaccount and a parent account, change the Account Type to exactly match the other parent account so it becomes a parent account.
  9. When you're ready, select Save and then Yes, merge accounts. QuickBooks moves past transactions from the duplicate to the account you want to keep.

Related links

QuickBooks LedgerQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.