How to Merge Accounts, Customers & Vendors in QuickBooks (Online & Desktop)

Duplicate accounts, customers, and vendors can quickly create confusion in QuickBooks Online and QuickBooks Desktop. They often occur when multiple users enter the same record, data is imported from another accounting system, or similar names are created by mistake. Fortunately, QuickBooks allows you to merge duplicate accounts, customers, and vendors into a single record. Since merging is a permanent action that can affect reconciliations and opening balances, it’s important to follow the correct process before making any changes.

In this guide, we’ll discuss when you should merge records in QuickBooks, the pre-merge checklist, the requirements for merging, how to merge accounts, bank accounts, customers, and vendors in QuickBooks Online and Desktop, and more.

When Should You Merge in QuickBooks? (And Why Merge Instead of Recode)

Merging records in QuickBooks is the right choice when duplicate accounts, customers, or vendors refer to the same entity. However, only merge records that are true duplicates. If they serve different accounting or reporting purposes, recoding transactions is the better option.

When Should You Merge in QuickBooks?

You should merge records in QuickBooks in the following situations:

• Duplicate customer or vendor profiles
• Redundant accounts
• Duplicate bank or credit card accounts
• Business name changes
• Data migration or multi-user entry

Why Merge Instead of Recode?

Although both options help organize your accounting records, they solve different problems. Here are the reasons to merge accounts in QuickBooks instead of recoding.

• Permanently combines duplicate records into one.
• Consolidates transaction history, balances, and attachments under a single record.
• Removes duplicate accounts, customers, or vendors from active lists, reducing future data-entry errors.
• Produces cleaner financial reports and simplifies record management.

Use Merge when both records represent the same account, customer, or vendor, and you want one complete financial history. On the other hand, use Recode when transactions were posted to the wrong account, but the records represent different entities or reporting categories.

Before You Merge in QuickBooks: Essential Pre-Merge Checklist

Since QuickBooks doesn’t allow you to undo a merge, complete the following checks before proceeding. Here is the pre-merge checklist to follow before you merge accounts, customers, and vendors in QuickBooks.

Parameter	Details
Back up your data (QuickBooks Desktop)	Create a local backup of your company file. If you use QuickBooks Online, export key financial reports because you can’t restore a merged record.
Switch to Single-User Mode (Desktop)	Perform the merge in Single-User Mode to prevent conflicts with other users.
Verify that the records are duplicates	Merge only records that represent the same account, customer, or vendor. Use recoding if they serve different accounting or reporting purposes.
Meet QuickBooks’ merge requirements	Confirm that account names, account types, detail types, and parent accounts (for sub-accounts) match.
Review sub-accounts, jobs, and sub-customers	Remove or reassign linked sub-accounts, jobs, or sub-customers if QuickBooks requires it before the merge.
Save reconciliation reports	Export past reconciliation reports before merging reconciled accounts. QuickBooks retains the reconciled transactions but removes the deleted account’s reconciliation history.
Check opening balances	Review opening balance entries, especially for bank and credit card accounts.
Disconnect bank feeds (if applicable)	Disconnect online banking from connected accounts to reduce synchronization issues and duplicate downloads.
Review feature restrictions	Verify that Multicurrency, vendor payment settings, tax authority links, or inventory tracking won’t prevent the merge.
Export key reports	Save reports such as the Chart of Accounts, General Ledger, and Trial Balance.
Confirm you’re ready to proceed	Merging permanently transfers transactions to the surviving record and deletes the duplicate.

What Happens When You Merge (Permanent, Reconciliation, Opening Balance)  

When you merge accounts, customers, or vendors in QuickBooks, the software combines duplicate records into one. Here are the key changes to expect after merging accounts, customers, or vendors:

1. The Merge Is Permanent

Once you confirm the merge, QuickBooks permanently removes the duplicate record and transfers its data to the surviving one.

• You can’t undo the merge.
• All transactions move to the remaining record.
• Merge only true duplicate accounts, customers, or vendors.

2. Transaction History Is Consolidated

QuickBooks combines the complete financial history under the surviving record.

• Transfers invoices, bills, payments, checks, and journal entries.
• Retains attachments and notes.
• Preserves historical transaction records.

3. Financial Reports Update Automatically

QuickBooks updates your reports to reflect the merged record.

• Removes duplicate entries from reports.
• Updates the Balance Sheet, Profit & Loss, and General Ledger.
• Displays a single customer, vendor, or account history.

4. Reconciliation Records Require Attention

QuickBooks retains reconciled transactions but doesn’t preserve separate reconciliation histories.

• Reconciled transactions remain reconciled.
• Save reconciliation reports before merging.
• Disconnect active bank feeds before merging bank or credit card accounts.

5. Review Opening Balances

Duplicate opening balances can create inaccurate account totals after the merge.

• Compare both account registers.
• Remove the newer duplicate opening balance entry.
• Verify the beginning balance after merging.

What are the Requirements: Name, Account Type, and Detail Type Must Match?  

Before you merge accounts, customers, or vendors in QuickBooks, verify that the records meet the required criteria. Here are the requirements to successfully merge accounts, customers, or vendors in QuickBooks.

Requirement	Description
Account or Record Name	Rename the duplicate account, customer, or vendor so its name exactly matches the record you want to keep.
Account Type	Both accounts must belong to the same account type, such as Bank, Expense, Income, Asset, Liability, or Equity.
Detail Type (QuickBooks Online)	The accounts must have the same Detail Type. If they differ, edit the duplicate account and select the matching detail type before merging.
Parent Account (Sub-Accounts)	To merge sub-accounts, assign them to the same parent account. If necessary, update the parent account or temporarily remove the sub-account designation before merging.
Record Type	Merge only records of the same category. For example, Account with Account, Customer with Customer, and Vendor with Vendor.
Multicurrency	If Multicurrency is enabled, certain accounts or list records cannot be eligible for merging.
Online Banking Connections	Disconnect active bank feeds before merging connected bank or credit card accounts.

How to Merge Chart of Accounts in QuickBooks Online?

If your Chart of Accounts contains duplicate accounts, QuickBooks Online lets you merge them into a single account instead of manually moving transactions. Follow these steps to merge accounts in QuickBooks Online:

1. Sign in to QuickBooks Online.
2. Verify that both accounts have the same Account Type, Detail Type, currency, and parent account (if they are sub-accounts).
3. If either account has reconciliation history, save or export the reconciliation reports before proceeding.
4. Click the Settings icon and select Chart of Accounts.
5. Locate the account you want to keep and note its exact name, including spelling, capitalization, and spacing.
6. Find the duplicate account, click Action, and select Edit.
7. Rename the duplicate account so its Account Name exactly matches the account you want to keep.
8. Update the Account Type and Detail Type, if necessary, so they match the primary account.
9. Click Save.
10. When the confirmation message appears, click Yes to merge the accounts.
11. Review your Chart of Accounts and financial reports to verify that all transactions now appear under the surviving account.

What are the Steps to Merge Sub-Accounts (Parent/Child Rules) in QuickBooks Online?

To merge sub-accounts in QuickBooks Online, both records must belong to the same parent account and meet QuickBooks’ merge requirements.

1. Go to Settings > Chart of Accounts.
2. Locate the sub-account you want to keep and note its Account Name, Account Type, Detail Type, and Parent Account.
3. Find the duplicate sub-account and click Action > Edit.
4. Update the duplicate sub-account so it has the same:
   • Parent Account
   • Account TypeDetail Type
   • Currency (if Multicurrency is enabled)
5. If the duplicate belongs to a different parent account, assign it to the correct parent. If QuickBooks doesn’t allow the change, temporarily clear the Is sub-account checkbox, save the account, then edit it again and assign the correct parent.
6. Rename the duplicate sub-account so its Account Name exactly matches the sub-account you want to keep.
7. Click Save, then select Yes when QuickBooks asks you to confirm the merge.
8. Review your Chart of Accounts and key financial reports to verify the merge.

How to Merge Chart of Accounts in QuickBooks Desktop?

QuickBooks Desktop allows you to merge duplicate accounts to keep your Chart of Accounts organized and improve reporting accuracy. Follow these steps to merge accounts in QuickBooks Desktop:

1. Open QuickBooks Desktop and switch to Single-User Mode.
2. Create a backup of your company file (File > Back Up Company > Create Local Backup).
3. Go to Lists > Chart of Accounts.
4. Locate the account you want to keep and note its exact Account Name.
5. Verify that both accounts have the same Account Type. If you’re merging sub-accounts, ensure they share the same Parent Account. If Multicurrency is enabled, both accounts must also use the same currency.
6. Right-click the duplicate account and select Edit Account.
7. Change the duplicate account’s Account Name so it exactly matches the account you want to keep.
8. Click Save & Close.
9. When QuickBooks displays a message stating that an account with the same name already exists, click Yes to confirm the merge.
10. Review your Chart of Accounts, Balance Sheet, Profit & Loss, and General Ledger to verify that the merge completed successfully.

How to Merge Bank or Credit Card Accounts in QuickBooks?

QuickBooks allows you to merge duplicate bank and credit card accounts to keep your Chart of Accounts organized and improve reporting accuracy. Here are the steps to merge bank or credit card accounts in QuickBooks.

1. Complete, categorize, or delete all transactions in the For Review tab. QuickBooks won’t merge an account with pending bank feed transactions.
2. Save any existing reconciliation reports for future reference.
3. Review both account registers for duplicate opening balance entries and remove any unnecessary duplicates before proceeding.
4. Go to Transactions > Bank Transactions.
5. Select the duplicate bank or credit card account.
6. Click the Edit (Pencil) icon and choose Edit account details.
7. Select Disconnect this account on save, then click Save to remove the online banking connection.
8. Go to Accounting > Chart of Accounts.
9. Locate the account you want to keep and note its exact Account Name, Account Type, and Detail Type. If Multicurrency is enabled, verify that both accounts use the same currency.
10. Find the disconnected duplicate account, click Action > Edit, and rename it so the Account Name exactly matches the primary account. Before saving, ensure both accounts have the same Account Type, Detail Type, and Currency (if applicable).
11. Click Save. When QuickBooks displays the confirmation message, select Yes to complete the merge.
12. Review your Chart of Accounts, Balance Sheet, General Ledger, and latest reconciliation reports to confirm that the merge completed successfully.

How to Merge Duplicate Customers in QuickBooks?

QuickBooks lets you merge duplicate customers by combining their records into a single profile. Listed below are the steps to merge duplicate customers in both QuickBooks Online & Desktop.

Here are the steps to merge duplicate customer records in QuickBooks Online.

1. Go to Sales > Customers.
2. Locate the customer record you want to keep and note its exact Display Name, including spelling, spacing, and capitalization.
3. Open the duplicate customer record and click Edit.
4. Update the duplicate customer’s Display Name so it exactly matches the customer record you want to keep.
5. Review the customer details and make any necessary updates before saving.
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 the merge.
8. Open the surviving customer profile and verify that invoices, estimates, sales receipts, payments, and other transaction history have been consolidated correctly.

Merge Customers in QuickBooks Desktop  

QuickBooks Desktop lets you merge duplicate customer records to combine transaction history and keep your customer list organized. Here are the steps to merge duplicate customers in QuickBooks Desktop:

1. Open QuickBooks Desktop, switch to Single-User Mode, and create a backup of your company file.
2. Go to Customers > Customer Center.
3. Locate the customer record you want to keep and note its exact Customer Name, including spelling, spacing, and punctuation.
4. Right-click the duplicate customer record and select Edit Customer: Job.
5. Replace the duplicate customer’s Customer Name with the exact name of the customer you want to keep.
6. Click OK.
7. When QuickBooks displays the message “A customer with this name already exists. Would you like to merge them?”, click Yes.
8. Open the surviving customer profile to verify that invoices, estimates, payments, sales receipts, and other transactions have been consolidated.
9. Review the Customer Center and the Customer Balance Detail report to confirm the merge was completed successfully.

How to Merge Duplicate Vendors in QuickBooks?

QuickBooks allows you to merge duplicate vendors into a single profile so that bills, payments, purchase orders, and vendor history remain organized. Before merging, confirm that both records belong to the same vendor, as the process is permanent.

Merge Vendors in QuickBooks Online  

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

1. Go to Expenses > Vendors.
2. Locate the vendor record you want to keep and note its exact Display Name, including spelling, spacing, and capitalization.
3. Open the duplicate vendor record you want to remove and select Edit.
4. Change the duplicate vendor’s Display Name so it exactly matches the vendor record you want to keep.
5. Click Save.
6. When QuickBooks detects that another vendor already uses the same name, confirm the merge.
7. Open the remaining vendor profile and verify that bills, payments, purchase orders, and other vendor transactions have been consolidated correctly.

Merge Vendors in QuickBooks Desktop

Some QuickBooks Desktop Enterprise editions include additional list management features to handle duplicate records, but the available options vary by version. Follow these steps to merge duplicate vendors in QuickBooks Desktop:

1. Open QuickBooks Desktop. If your company file is in Multi-User Mode, switch to Single-User Mode before merging vendor records.
2. Create a backup of your company file (File > Back Up Company > Create Local Backup).
3. Go to Vendors > Vendor Center.
4. Locate the vendor record you want to keep and note its exact Vendor Name, including spelling, spacing, and punctuation.
5. Right-click the duplicate vendor record and select Edit Vendor.
6. Replace the duplicate vendor’s Vendor Name with the exact name of the vendor you want to keep.
7. Click OK.
8. When QuickBooks detects that a vendor with the same name already exists, confirm the merge.
9. Review the remaining vendor profile to verify that bills, payments, purchase orders, and vendor transaction history have been combined correctly.

List of Accounts You Can’t (or Shouldn’t) Merge in QuickBooks

QuickBooks helps you clean up duplicate records by merging similar accounts, customers, and vendors. However, some records are restricted due to accounting rules, reporting requirements, or system connections.

Record Type / Situation	Why You Can’t or Shouldn’t Merge
Active Bank Feed Accounts	QuickBooks does not allow merging accounts connected to active online banking. Disconnect the bank feed before merging.
Accounts With Reconciliation History	Transactions remain reconciled, but separate reconciliation history cannot be preserved.
Different Account Types	QuickBooks only merges accounts with the same Account Type.
Different Detail Types (QuickBooks Online)	Accounts with different Detail Types or settings cannot be merged.
Different Currencies	Accounts using different currencies cannot be merged when Multicurrency is enabled.
Sub-Accounts With Different Parent Structures	QuickBooks does not merge accounts with mismatched parent-child relationships.
1099 Accounts (QuickBooks Desktop)	Accounts with different 1099 tracking settings cannot be merged directly.
Special System Accounts	Avoid merging Accounts Receivable, Accounts Payable, Retained Earnings, Opening Balance Equity, and Undeposited Funds because they support QuickBooks processes.
Customers and Vendors	QuickBooks treats customers and vendors separately.
Customer Jobs (QuickBooks Desktop)	Customer jobs can prevent a direct customer merge and require separate handling.
Customer Notes and Custom Fields	Some non-transaction details cannot be transferred during a merge.
Vendors and Employees	Vendor records cannot be merged with employee profiles.
1099 Vendors (QuickBooks Desktop)	Changing 1099 settings during a merge can affect tax reporting accuracy.
Accounts With Different Purposes	Avoid merging accounts that serve different reporting needs, even if QuickBooks allows it.

When to Get Professional Help?

Seek professional help when merging involves complex records, multiple entities, reconciliation history, payroll, inventory, or tax-related accounts. A QuickBooks expert can review your data, prevent reporting issues, and ensure accurate financial records. Professional guidance is especially useful before year-end closing, audits, or major bookkeeping cleanup.

---

Frequently Asked Questions