How to Fix Duplicate Names in Quickbooks

​

Introduction:

 

QuickBooks can encounter a duplicate name error when importing lists or transactions. This issue can occur in various Quickbooks lists like customer, account, employee, item, and others. Here's a step-by-step guide on how to fix duplicate names in QuickBooks.

​

I. Finding the Duplicate Names 

​

1. Check the QBWIN.LOG file to view a list of duplicate names

2. Press F2 or Ctrl+1 from the Home Page in QuickBooks to open the Product Information window.

3. Press F3 or Ctrl+2 to open the Tech Help window and select the Open File tab.

4. Scroll down and highlight QBWIN.LOG and click Open File.

5. Press Ctrl+End to move down to the bottom of the log file and Ctrl+F to bring up the Find window.

6. Type "duplicate" in the Find and Replace box and press enter. B. Use the Master Name List to find duplicate names

7. Go to the Banking menu and select Write Checks.

8. In the Write Checks window, click the PAY TO THE ORDER OF field and press Ctrl+L to open the Master Name List.

9. Check the Include Inactive box at the bottom to show active and inactive names.

10. Click the NAME heading to sort the names in alphabetical order and look for duplicate names.

​

II. Editing the Duplicate Names to fix Duplicate Names

​

1. A. Open the list where the duplicate name is and find the name.

2. B. Double-click the duplicate name to edit it.

3. C. Add, remove, or change at least one character of the duplicate name and click OK.

4. D. Repeat the above steps for all the duplicate names showing in QBWIN.LOG.

​

III. Conclusion :

​

After editing all the duplicate names, run the Rebuild and Verify utilities to ensure that there are no more duplicate names in QuickBooks. If the issue persists, Call Us at 1-866-768-8927 for further assistance.