Merge Duplicate Bank Accounts in QuickBooks Desktop by Renaming

Two bank accounts with different names will not combine on their own; renaming one to exactly match the other merges them into a single account.

Duplicate bank accounts are one of the most common side effects of a re-imported bank feed, a converted file, or a second chart of accounts entry created in error. QuickBooks Desktop has no merge button for accounts, but it does have a built-in merge behavior: when two accounts of the same type end up with exactly the same name, QuickBooks combines them into one, rolling their transactions and balances together. This page walks through how to do that safely and how to confirm it worked.

How the merge actually works

QuickBooks requires every account name in the chart of accounts to be unique. The moment you save an account whose name is identical to another account of the same type, QuickBooks does not reject the duplicate; it merges the two. All transactions from the renamed account move to the surviving account, and the surviving account's balance becomes the sum of both. The renamed account disappears from the chart of accounts entirely. This behavior is what makes the rename trick work, and it is also why you must be careful: the merge is immediate and cannot be undone with an Edit menu command.

Preconditions

1. Make a full backup first. From the File menu, choose Back Up Company, then Create Local Backup, and save a complete backup (.qbb) before touching anything. Account merges are permanent; the backup is your only undo.
2. Work in single-user mode. Switch to single-user mode under File so no one else edits the chart of accounts while the merge is in progress.
3. Confirm both accounts are the same type. A Bank account can only merge with another Bank account, and a Credit Card account with another Credit Card. If the duplicates are different types, the merge will not happen and you will instead get a name-collision error.
4. Check for subaccounts. If either account is a subaccount, the names must match including the parent relationship. The simplest path is to make both top-level accounts first, then rename.
5. Review online banking connections. If either account is connected for bank feeds, disconnect the one you plan to rename before merging, then reconnect the surviving account afterward. Leaving a live connection attached to an account that is about to vanish can produce download errors.

The merge steps

1. Open the chart of accounts: Company menu, then Chart of Accounts (or press Ctrl+A).
2. Decide which account will survive. Note its exact name, character for character, including punctuation and spacing. If the name is not exactly what you want long term, rename the survivor first to its final name, click Save, and confirm the rename.
3. Right-click the duplicate account (the one you want to disappear) and choose Edit Account.
4. In the Account Name field, delete the current name and type the survivor's name exactly. A trailing space or a different hyphen character will cause QuickBooks to treat it as a new name rather than a duplicate, so retype it rather than pasting when in doubt.
5. Click Save and Close. QuickBooks will ask whether you want to merge the accounts. Read the prompt carefully; it names the account that will remain.
6. Click Yes. The duplicate account vanishes from the list immediately.

Signs it worked

• The duplicate account no longer appears anywhere in the chart of accounts, including inactive entries (you can confirm by toggling "Include inactive" in the account list view).
• The surviving account's balance now equals the sum of the two previous balances.
• A QuickReport on the surviving account (right-click, QuickReport) shows transactions from both original accounts in one list.
• Reconciliations: previously cleared transactions keep their cleared status, but the reconciliation history of the renamed account does not carry over as separate statements. If you were mid-reconciliation on the account you renamed, expect to finish that period on the surviving account.

Where this workaround stops

The rename merge is only correct when the two accounts genuinely represent the same real-world account. If the duplicates each contain their own copy of the same transactions, for example after a double import, merging will not deduplicate anything; you will end up with every transaction twice in one register, and each duplicate must be removed manually. That situation is common after bank feed re-downloads, and it is a data-cleanup problem rather than a chart-of-accounts problem.

The rename trick also does not help when the duplicates live in two separate company files. QuickBooks Desktop has no command for combining two company files, and name matching across files behaves differently than within one file; our engineers cover how cross-file merging of QuickBooks files works separately. And if the chart of accounts itself shows signs of damage, such as accounts that will not save, balances that do not add up, or Verify errors after the merge, stop editing and restore the backup you made in step 1 before the problem compounds.