.iif import to Quickbooks.
I tried to import 23 employes' hours into QB. Half of them went in and the other half didn't. The error message is "The....<name> of the list elements is already in use". I checked those names and they match with what are in QBs. I tried to see if there are any blanks in the names but couldn't find anything
Can someone help me to know what the problems are and how we can solve it? Thanks a lot
Hi there, Kim. Let me share with you some information about the error message you're getting when trying to import your employees' hours in QuickBooks Desktop (QBDT).
This error message "The....<name> of the list elements is already in use" happens when the name you're trying to import already exists in QuickBooks. This can be an employee, customer, or vendor.
To isolate the issue, please ensure that the names on your IIF file aren't identical to any of the employees, customers, or vendors added in QuickBooks. If you have one, you may add a special character like the following:
You can open these articles to learn more about IFF import:
Just in case you need help with importing or exporting QuickBooks data with MS Excel files in the future, you can also check out this link as your guide: Import or export MS Excel files.
Let me know if you have any other follow-up questions while fixing the error message you're getting when importing the .iif file to QuickBooks. I'm just a post away to help. Keep safe!
Thanks for your response. I do not understand it however. When we import the employees' time, it is the working hours for the current employees. Their names exist in Quickbooks for sure. We also made sure the names in our .iif file match with the names in QB.
The problem is some names successfully went in and some didn't. And the error message pops up as shown in my previous post.
Hope to hear from you
Thanks for getting back to us, @KimYen2022.
Let me share some information about the "The....<name> of the list elements is already in use" error. As mentioned by my peer above, QuickBooks detected the same name already exists in the program.
To resolve this, you'll want to check your name list (employee, customer, and vendor). Ensure there are no identical entries in their profile.
To check from customer's profile, just go to Customers at the top and then select Customer Center. From there, search for the employee names in question. Do the same on the vendor's profile.
If found, you can append the name by adding a punctuation mark to differentiate the two names.
Please none of the recommendation applies, contact our Customer Care Support so we can investigate further. Here's how to reach out:
I'm attaching this link here in case you need help with other payroll tasks. It has payroll topics with articles: View all help for QuickBooks Desktop Payroll.
Keep me posted if you have follow-up questions or concerns about importing employee time. I'll be here for you.
Allow me to clarify my question. I have a number of current employees on QBD. I need to import their hours under .iif file to QB Desktop. Their names are already in QB. I've got the list with their names and their hours in a .iif file. I did check to make sure the file headers match with those in QB, as well as the names in the file .iif match the names in QB.
That's why I don't understand the error "The name.....in the element list is already in use". I am trying to import the time of the current EMPLOYEES, so their names definitely exist in QB. Please advise. Thanks
You're already on the right track in importing your employees' hours in QuickBooks Desktop (QBDT), @KimYen2022. With this, I'm here to guide you on the next steps you need to help isolate this matter and complete your task.
As mentioned by my colleagues above, the error you've encountered happens when QuickBooks detected the same name already exists in the program. Based on your description above, it seems that the error is referring to your inactive employees. You may have ones that aren't included in the IIF file.
With that being said, you can opt to rename or delete your inactive employees to ensure you can import your employees' hours list. To do this, here's how:
To know more about removing an employee profile from your QuickBooks payroll system, please see this article: Delete or hide an employee name in the Employee List.
Once you're done, go ahead and import your IIF file. For the step-by-step guide, please refer to this article: Export, import, and edit IIF files.
Also, to further guide you in managing your workers and employees profile using QBDT, I'd recommend checking out this article: Desktop Payroll Help Articles.
Keep me posted in the comments if you have other importing concerns and questions about managing employees' time in QBDT. I'm always ready to help. Take care, and I wish you continued success, @KimYen2022.
Thanks for your response.
I just checked the employee and vendor centers. All the names we currently have the error of "name already in use" are only existing as active employees. There are no such names as 'released" employees nor in vendor center.
Hope to hear from you.
Thanks for your response.
I thoroughly checked the employee and vendor centers. All the names we have problem of "name already in use" exist as active employees. There is no same name as "inactive employees" or in vendor center.
Hope you can advise me what to do
I want to ensure this will be taken care of, @KimYen2022.
As per my colleagues discussed in this thread, the error <name> of the list elements is already in use means that you're trying to import what's already exists in QuickBooks Desktop (QBDT). The program will not permit the use of identical names and the import will fail.
Since you've already performed the recommended troubleshooting steps to fix the issue and still encounter the same thing, I highly recommend reaching out to our Technical support team. They have tools to pull up your account and investigate the root cause of the error that's preventing you in importing your employee hours.
For your reference in importing and exporting IIF files, feel free to check out this link: Export, import, and edit IIF files. Also, before importing, it's best to create a backup copy of your company data to ensure you can restore the original file in case you run into problems.
Running payroll reports in QBDT is a breeze. With this, you can easily get a summary of your employee details, company finances, and business information.
Don't hesitate to leave a reply below for any importing issues you may have. I'm always around to help. Keep safe.
Hello there, JeanG.
I'd love to help you with your concern, but I may need additional details to understand your situation.
What specific help do you need? I would appreciate any details you can share to help me better understand your concern and provide an accurate solution.
In the meantime, you'll want to check out our Help Articles to help you with the tasks and tips when using QBO.
I'll keep an eye out for your response. Any additional information will do. Take care and have a good one!