Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Intuit

Merge duplicate accounts, customers, and vendors in QuickBooks Online

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 remove the duplicate. Keeping your lists clean speeds up your bookkeeping and makes bookkeeping easier.

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, 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.

  1. If you’re merging accounts that have reconciliation reports, save those reports first. The transactions remain on the merged account and stay reconciled.
  2. Go to Settings ⚙ and then select the Chart of Accounts.
  3. Find the account you want to keep. Then select the dropdown ▼ in the Action column and then Edit.
  4. Note the name and detail type of the account.
  5. Check if the Is sub-account option is marked. 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:

  1. Go back to the Chart of Accounts.
  2. Find the duplicate account (the one you won't keep). Then select the dropdown ▼ in the Action column and then Edit.
  3. Change the Name and Detail Type so the duplicate account's info matches the account you want to keep exactly. If you need to mark Is sub-account, keep in mind:
    • If you’re merging two parent accounts, make sure they don’t have any sub-accounts.
    • If you’re merging two sub-accounts, make sure they both have the same parent account.
    • If only one is a sub-account, uncheck the Is sub-account option so it becomes a parent account.
  4. When you're ready, select Save and then Yes to confirm.

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, merging vendor profiles is permanent. You can't undo this later on.

  1. Go to the Expenses menu.
  2. Select the Vendors tab.
  3. Find and open the vendor profile you want to keep. Then select edit.
  4. Note the Company and Display name.
  5. Go back to the Vendors tab.
  6. Find and open the vendor you don't want to keep. Then select Edit.
  7. Change the Company and Display name so they match the vendor profile you're keeping exactly. 
  8. 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.

Was this helpful?

You must sign in to vote, reply, or post
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us