How Do I Merge Two Accounts in QuickBooks (Desktop & Online)

Duplicate accounts in QuickBooks can create confusion, distort financial reports, and increase the risk of posting transactions to the wrong account. They commonly occur when multiple users create similar accounts, import accounting data, or accidentally add an account that already exists. Merging two accounts in QuickBooks is an effective way to eliminate duplicate records without losing historical transaction data. However, while merging accounts is generally simple, users can encounter messages such as:

“You cannot merge an account that has online information associated with it into another account”

“You can’t merge two accounts that are both set up for Online Banking or Web Connect”

“You cannot merge into an Intuit managed account”

“Cannot merge list elements” / “The account number is already in use”

In this guide, we’ll discuss why you should merge duplicate accounts in QuickBooks, how to merge accounts, customers, and vendors in QuickBooks Online and QuickBooks Desktop, and more.

Why Merge Two Accounts in QuickBooks Desktop and Online?

If you have duplicate accounts set up in QuickBooks and want to combine the two into one account, here are the steps for merging two accounts in QuickBooks Desktop and Online.

• Removes duplicate data
  • Combines multiple records for one account, customer, or vendor into a single record.
• Merges business records
  • Merges historical data from like records of customers or vendors after the business has grown, merged, or been reorganized.
• Fixes naming inconsistencies
  • Removes duplicate records created through variation in naming or misspellings.
• Improves financial reporting
  • Keeps your Chart of Accounts in order and results in clearer balance sheet and profit and loss reports.
• Makes financial management easier
  • It combines all the transactions, invoices, bills, payments, and amounts owed into one account, which is easier to keep track of and manage.

Prerequisites Before You Merge Accounts in QuickBooks

To merge accounts in QuickBooks, make sure the two accounts you want to merge are compatible, back up your company file, check important settings before merging to avoid errors, save your financial records, and ensure a smooth merge. Here are some considerations before you merge accounts in QuickBooks.

Parameter	Details
Back Up Your Company File	Create a backup before merging, as the process is permanent.
Administrator Access	Sign in with an Administrator account to merge records.
Single-user Mode (QuickBooks Desktop)	Switch to Single-user Mode to avoid conflicts during the merge.
Verify Account Types	Ensure both accounts have the same account type. QuickBooks cannot merge different account types.
Disconnect Online Banking	Disconnect bank feeds from connected accounts before merging.
Review Transactions	Verify transactions and remove duplicate opening balance entries, if applicable.
Save Reconciliation Reports	Export or print reconciliation reports before merging, as account-specific reports can no longer be available.
Match Account Details	Ensure the account name, detail type, and parent/subaccount structure exactly match the target account.
Irreversible Process	Once confirmed, the merge cannot be undone

Steps to Merge Two Accounts in QuickBooks Desktop

To merge two accounts in QuickBooks Desktop, rename the duplicate account to be the same as the account you wish to keep. QuickBooks will combine those two accounts into one account, but keep the transaction history for both accounts. To merge two accounts in QuickBooks Desktop, follow the steps below.

• Open QuickBooks Desktop and sign in with an Administrator account.
• Switch to Single-user Mode by selecting File > Switch to Single-user Mode.
• Create a backup of your company file by going to File > Back Up Company > Create Local Backup.
• Select Lists > Chart of Accounts.
• Identify the account you want to keep and note its Account Name, Account Type, and Parent Account (if it’s a subaccount).
• Confirm that both accounts have the same Account Type. If you’re merging subaccounts, they must also share the same Parent Account. If Multicurrency is enabled, both accounts must use the same currency.
• Right-click the duplicate account and select Edit Account.
• Rename the duplicate account so its Account Name exactly matches the account you want to keep.
• Click Save & Close.
• When QuickBooks displays a message indicating that an account with the same name already exists and asks whether you want to merge the accounts, click Yes to confirm.
• Open your Chart of Accounts, Balance Sheet, Profit & Loss, and General Ledger to verify that the merge completed successfully and all transactions appear under the remaining account.

Steps to Merge Two Accounts in QuickBooks Online

To combine accounts in QuickBooks Online, you will need to edit the duplicate account to have the same information, such as the name and the primary account. QuickBooks will merge the two accounts but will preserve the transaction history. To merge two accounts in QuickBooks Online, follow these simple steps:

1. Sign in to QuickBooks Online using an Administrator account. 
2. Confirm that both accounts have the same Account Type, Detail Type, and Parent Account (if they are subaccounts). If Multicurrency is enabled, verify that both accounts use the same currency. 
3. If either account contains reconciled transactions, export or save the reconciliation reports for future reference. 
4. Select the Settings icon and choose Chart of Accounts. 
5. Locate the account you want to retain and note its Account Name, including the exact spelling, capitalization, and spacing. 
6. Find the duplicate account, open the Action menu, and select Edit. 
7. Update the duplicate account so its Account Name exactly matches the account you want to keep. Also, verify that the Account Type and Detail Type match the primary account. 
8. Click Save. 
9. When QuickBooks prompts you to merge the duplicate account with the existing one, select Yes to continue. 
10. Open your Chart of Accounts, Balance Sheet, Profit and Loss, and General Ledger to confirm that the merged account displays all transactions and balances correctly. 

Note: Account merging is permanent. Once you have confirmed the merge, QuickBooks will delete the duplicate account and move its transaction history to the remaining account.

How to Merge Duplicate Customers in QuickBooks Desktop & Online

In QuickBooks Online and QuickBooks Desktop, merge customers in order to unite two or more customer records into a single customer profile with invoices, payments, estimates, and history records of transactions. Here are the steps for merging duplicate customers in both QuickBooks Desktop and Online.

Steps to Merge Duplicate Customers in QuickBooks Desktop

QuickBooks Desktop lets you merge duplicate customer records by renaming one customer to match another. Follow these steps to merge customers in QuickBooks Desktop:

1. Open QuickBooks Desktop as an Administrator. 
2. Switch to Single-user Mode by selecting File > Switch to Single-user Mode. 
3. Create a backup of your company file by going to File > Back Up Company > Create Local Backup. 
4. Select Customers > Customer Center. 
5. Locate the customer record you want to keep and note its exact Customer Name, including spelling, capitalization, spacing, and punctuation. 
6. Right-click the duplicate customer and select Edit Customer: Job. 
7. Rename the duplicate customer so its Customer Name exactly matches the primary customer record. 
8. Click OK. 
9. When QuickBooks displays the message “A customer with this name already exists. Would you like to merge them?”, click Yes. 
10. Open the remaining customer profile to verify that all invoices, estimates, sales receipts, payments, credit memos, and customer balances have been consolidated. 
11. Review the Customer Center and Customer Balance Detail report to merge customers in QuickBooks Desktop successfully.

Steps to Merge Duplicate Customers in QuickBooks Online

To merge duplicate customers in QuickBooks Online, you should rename the duplicate customers’ Display Name to exactly match the name of the customer record you would like to keep. Follow these steps to merge customers in QuickBooks Online:

1. Sign in to QuickBooks Online as an Administrator. 
2. Go to Sales > Customers. 
3. Locate the customer record you want to keep and note its exact Display Name, including spelling, capitalization, and spacing. 
4. Find the duplicate customer, then click Edit. 
5. Update the duplicate customer’s Display Name so it exactly matches the primary customer record. 
6. Click Save. 
7. When QuickBooks displays the message “This name is already being used. Would you like to merge the two?”, click Yes to confirm. 
8. Open the remaining customer profile and verify that all invoices, estimates, sales receipts, payments, credit memos, and customer balances have been consolidated correctly. 

Important: Merging customers is permanent. Once you confirm to merge duplicate accounts in QuickBooks, it removes the duplicate customer profile and transfers its transaction history to the remaining customer. You cannot reverse this action.

How to Merge Duplicate Vendors in QuickBooks Desktop & Online

To merge duplicate vendors in QuickBooks Online or QuickBooks Desktop, rename the duplicate vendor so it exactly matches the primary vendor record. 

Steps to Merge Duplicate Vendors in QuickBooks Online

QuickBooks Online merges duplicate vendor records using the rename method. Follow these steps to merge vendors in QuickBooks Online. 

1. Sign in to QuickBooks Online as an Administrator. 
2. Go to Expenses > Vendors. 
3. Locate the vendor record you want to keep and note its exact Display Name, including spelling, capitalization, and spacing. 
4. Find the duplicate vendor, select Edit from the Action menu, or open the vendor profile and click Edit. 
5. Rename the duplicate vendor so its Display Name exactly matches the primary vendor record. 
6. Click Save. 
7. When QuickBooks displays the message “This name is already being used. Would you like to merge the two?”, click Yes to confirm. 
8. Open the remaining vendor profile and verify that all bills, bill payments, purchase orders, expenses, vendor credits, and outstanding balances have been consolidated correctly. 

Important: Merging vendors is permanent. After you confirm to merge customers in QuickBooks Online, it removes the duplicate vendor record and transfers its transaction history to the remaining vendor. You cannot reverse this action.

Steps to Merge Duplicate Vendors in QuickBooks Desktop

QuickBooks Desktop Enterprise also has superior list management tools that can help identify duplicate records. But the vendor merge process is the same across versions: Pro, Premier, Enterprise, and Accountant. Follow these steps to merge vendors in QuickBooks Desktop. 

1. Open QuickBooks Desktop as an Administrator. 
2. If your company file is in Multi-user Mode, switch to Single-user Mode by selecting File > Switch to Single-user Mode. 
3. Create a backup of your company file by going to File > Back Up Company > Create Local Backup. 
4. Select Vendors > Vendor Center. 
5. Locate the vendor record you want to keep and note its exact Vendor Name, including spelling, capitalization, spacing, and punctuation. 
6. Right-click the duplicate vendor and select Edit Vendor. 
7. Rename the duplicate vendor so its Vendor Name exactly matches the primary vendor record. 
8. Click OK. 
9. When QuickBooks displays a message indicating that a vendor with the same name already exists and asks whether you want to merge the records, click Yes. 
10. Open the remaining vendor profile and verify that all bills, bill payments, purchase orders, expenses, vendor credits, and outstanding balances have been consolidated. 
11. Review the Vendor Center, Vendor Balance Detail, and Accounts Payable Aging Detail reports to confirm the merge completed successfully. 

Important: Merging vendors in QuickBooks Desktop is irreversible. Always create a backup before proceeding.

What Can and Cannot Be Merged in QuickBooks?

QuickBooks will only allow you to merge duplicates when certain conditions are met. Accounts, customers, vendors, and some list items can be merged, but records that are protected by the system and records of an incompatible type cannot be merged. Here are the items you can and cannot merge in QuickBooks.

Parameter	Can Be Merged	Cannot Be Merged
Accounts	Accounts with the same Account Type, Detail Type, and hierarchy (for example, Expense to Expense)	Accounts with different types, such as Asset to Expense or Bank to Income.
Customers	Duplicate customer profiles to consolidate invoices, payments, estimates, and transaction history.	Customer records cannot be merged with vendors or employees. In some cases, linked jobs or subcustomers may need to be reviewed before merging.
Vendors	Duplicate vendor profiles to combine bills, payments, purchase orders, and transaction history.	Vendors cannot be merged with customers or employees. Some payroll-related vendor records may also have merge restrictions.
Items & Lists	Duplicate non-inventory items, service items, and other supported list records with matching names or purpose.	Restricted system lists, payroll items, and protected records cannot be merged.
Currency & Banking	Records using the same currency after disconnecting online banking feeds, if applicable.	Records with different currencies or active online banking connections cannot be merged.
Merge Status	Records that meet all QuickBooks merge requirements.	Completed merges cannot be undone after confirmation

Common Reasons You Can’t Merge Accounts in QuickBooks

If QuickBooks will not merge two accounts, the accounts do not meet one or more of the application’s merging requirements. Some of the more common reasons for this include: account types, detail types, currencies, or account hierarchy are mismatched, or there are active online banking connections preventing QuickBooks from merging the two accounts.

• The account names do not match exactly, including spelling, capitalization, spacing, or punctuation.
• The accounts have different Account Types or Detail Types.
• The accounts have different parent/subaccount structures.
• The accounts use different currencies when Multicurrency is enabled.
• One or both accounts are connected to online banking or bank feeds.
• The accounts are linked to protected QuickBooks features or active online banking services.
• You are not signed in as an Administrator.
• The company file is in Multi-user Mode (QuickBooks Desktop).
• The company file contains data corruption or list damage.

Best Practices to Avoid Duplicate Accounts in QuickBooks

To ensure accuracy in the financial statements and to avoid duplicate account issues, one must ensure bank feeds are being handled appropriately, reconciliations are done regularly, data is entered in a controlled manner, and records are maintained properly.

• Search existing accounts, customers, and vendors before creating new records to prevent duplicate entries.
• Use consistent naming conventions across accounts, customers, and vendors to maintain organized records.
• Select Match instead of Add when QuickBooks identifies an existing bank feed transaction.
• Avoid duplicate bank connections and manual transaction entries when automatic bank feeds are active.
• Review bank rules, recurring transactions, and imports to prevent QuickBooks from creating duplicate entries.
• Reconcile accounts regularly with bank statements to detect duplicate transactions early.
• Verify imported or migrated data before adding it to your company file.
• Limit user permissions to control account creation and reduce accidental duplicates.
• Create a backup before merging records or making major changes in QuickBooks Desktop

Conclusion

To fix duplicate accounts in QuickBooks, you should ensure that the account information is correct, the account types and names are the same, bank feeds are disconnected, the account hierarchy is correct, and you merge accounts in QuickBooks after creating a backup. These practices guide you toward accurate accounting and keep you from misreporting. Verify eligibility requirements, save any needed reports, and ensure that the data complies with QuickBooks merge requirements, as merging is a permanent process.

Frequently Asked Questions