Merge duplicate accounts, customers, and vendors in QuickBooks Online
by Intuit•376• Updated 2 months ago
Learn how to keep your accounts, customers, and vendors organized.
If you have duplicate accounts, customers, or vendors, you can merge them. This moves all the data into the one you want to keep and makes the duplicate inactive. Keeping your lists clean speeds up your bookkeeping and makes bookkeeping easier.
For a better experience, open this article in QuickBooks Online. Launch side-by-side view
Important: Be careful merging. Only merge duplicates that were created in error. This is good bookkeeping practice. If you're an accountant, follow these steps to consolidate multiple client lists at your firm.
Merge duplicate accounts
Keep in mind that merging accounts is permanent. You can't undo this later on. QuickBooks uses some accounts as the default for certain features. These, like accounts connected to online banking, can't be merged or deleted.
Before you continue, make sure you’re in Accountant view.
- If you're merging accounts that have reconciliation reports, save those reports first. The account being merged may not keep the reconciliation history. The transactions remain on the merged account and stay reconciled.
Note: If both account registers have an opening balance equity transaction, you'll need to delete the transaction with the most recent date prior to merging. The older transaction becomes the opening balance of the newly merged account. - Go to Settings and then select Chart of accounts (Take me there).
- Find the account you want to keep. Then, select the dropdown ▼ in the Action column and then Edit.
- Note the Account Name, Account Type, and Detail Type of the account. These must be the same between the accounts you want to merge.
- Check if the account is a subaccount or 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.
You have all the info you need for the account you want to keep. Now let's handle the duplicate:
- Go back to Chart of accounts (Take me there).
- Find the duplicate account (the one you won't keep). Then, select the dropdown ▼ in the Action column and then Edit.
- Change the Account name and Detail Type so the duplicate account's info exactly matches the account you want to keep. If you need to make this a subaccount, keep in mind:
- If you're merging two parent accounts, make sure they don’t have any sub-accounts.
- If you're merging two subaccounts, make sure they both have the same parent account.
- If only one is a subaccount, change the Account Type to exactly match the other parent account so it becomes a parent account.
- When you're ready, select Save and then Yes, merge accounts.
This merges the two accounts so you end up with one. QuickBooks moves past transactions from the duplicate to the account you want to keep.
Merge duplicate customers
Merging customer profiles requires you to delete one manually. This ensures you can move data to the customer profile you want to keep. Learn more about how to merge your duplicate customers.
Merge duplicate vendors
Keep in mind that merging vendor profiles is permanent. You can't undo this later on.
- Go to Expenses and then select Vendors (Take me there).
- Find and open the vendor profile you want to keep. Then select Edit.
- Note the Company name and Vendor display name.
- Go back to the Vendors (Take me there) tab.
- Find and open the vendor you don't want to keep. Then select Edit.
- Change the display name to make it identical to the vendor you're merging it with.
- Select Save, then Yes to confirm.
This merges the two vendor profiles so you end up with one. QuickBooks moves past transactions from the duplicate to the vendor you want to keep.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Merge duplicate clients in QuickBooks Online Accountantby QuickBooks•90•Updated June 11, 2024
- Merge list entries in QuickBooks Desktopby QuickBooks•15•Updated July 26, 2024
- Add and manage customers in QuickBooks Onlineby QuickBooks•3632•Updated October 17, 2024
- Add a customer, employee, or vendor in QuickBooks Desktop for Macby QuickBooks•39•Updated 2 weeks ago