QuickBooks HelpQuickBooksHelpIntuit

Merge list entries in QuickBooks Desktop

SOLVEDby QuickBooks1Updated over 1 year ago

Learn how to merge accounts, customers, suppliers, and more in QuickBooks Desktop for Windows.

If you enter the same item twice with different names, you can merge them and keep your lists accurate. We'll show you how.

Before you merge make sure:

  • Backup your QuickBooks Desktop for Windows company file.
  • Switch your company file to "Single User" mode.
  • Clear any pending accountant changes.
  • To turn multicurrency off in QuickBooks Desktop for Windows.
  • The suppliers you want to merge aren’t:
    • Tax authorities
    • Tax exempt
    • Paid through online banking
    • Direct deposit suppliers

Merge entries in Chart of Accounts, Item List, Customer List, Supplier List and Employee List

  1. Go to Lists, then select the list that has the entries you want to merge.
  2. Copy the name of the entry you want to keep.
  3. Right-click the entry you don’t want to use, then select Edit.
  4. Paste the name you copied, then select Save & Close.
  5. Select Yes to merge the entries.

Note: If you get the message, “You cannot merge an account that has online information associated with it into another account”, you have an active bank feed on one of the accounts. Here’s how to turn off bank feeds.

Use Merge Suppliers tool in Accountant and Enterprise editions

  1. Accountant Edition: Go to Accountant, select Client Data Review, then select Merge Suppliers.
    Enterprise edition: Go to Company, select Accounting tools, then select Merge Suppliers.
  2. Select the suppliers you want to merge, then select Next.
  3. Select a Primary Supplier, then Merge.
  4. Select Yes to merge the suppliers, then select OK.

User-added image

Merge entries in chart of accounts, Item, Customer:Job, Supplier, Employee, and Other Name

Re-name to merge:

  1. Go to Lists, then select the list that has the entries you want to merge.
  2. Copy the name of the entry you want to keep.
  3. Select the entry you don’t want to use, then select the pencil icon to edit it.
  4. Paste the name you copied, then select OK.
  5. Select Yes to merge the entries.

Use the Merge menu item:

  1. Go to Lists, then select the list that has the entries you want to merge
  2. Select the name of the entry you want to remove
  3. Go to Edit, then select Merge.
    Note: You can also right-click the entry and select Merge.
  4. Select the name of the entry you want to keep.
  5. Select Merge to merge the entries.
  6. Select Yes to confirm the merge operation.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Desktop PremierQuickBooks Desktop Pro

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this