How to correct iif file with: [ERROR] The record at (or starting at) this line could not be imported. The name "EE Name" of the list element is already in use. [3100]

Hi there, @lcarnel.

You can review the line stated by the error to ensure that the fields are correct.

Here's how to review the errors in .IIF:

1. If you encounter errors "File not imported", QuickBooks gives you the option to review and resolve the errors found in the .IIF file.
2. Select the Review now button.
3. Look for Error to see the problem with the file.
4. Correct the corresponding errors, the Save.
5. Click Yes if you're asked to keep the file.
6. Close the File not imported window, then import the new corrected file.

I'm adding this article for more details: Improved IIF Import in QuickBooks 2019 and later.

If you're having trouble with correcting the file, I'd suggest contacting our Phone Support Team. This way, they can further check on the file and help you correct it so you can get back to working order.

You might want to check out these articles to learn more about importing IIF file: 

• IIF Overview: import kit, sample files, and headers.
• Export, import, and edit IIF files.

Please know you can continue to reach me here with any additional questions. Thanks for coming to the Community, wishing you continued success.

I am unable to utilize the "review now" option. I am only able to make changes to the file if I open the file through Excel.

When reviewing the data through Excel, the information is accurate and it is the only entry for the employee. All of the employees who are having an error are employees who have terminated.

; [ERROR] The record at (or starting at) this line could not be imported. The name "Employee Name" of the list element is already in use. [3100]

I appreciate you getting back to us, @lcarnel.

You can consider renaming or deleting those employees who are inactive to ensure you can import the list in your QuickBooks Desktop account.

Here's how:

1. Go to the Employees menu, then select Employee Center.
2. From the Employees drop-down, select All Employees to show all employees including the inactive ones.
3. Right-click the name of the inactive employee and select Delete Employee.
4. Click the Hide inactive name button to confirm.

Here's an article for more details: Delete or hide an employee name in the Employee List.

Once done, go back and try to export the employee list, then import via the IIF file. For more guidance, feel free to check out this article: Export, import, and edit IIF files.

If the issue persists, I highly recommend contacting our Phone Support Team. This way, they can investigate the issue further and provide additional troubleshooting steps to get you back to working order.

As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.

Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back. Have a good day.