Issues in the way employees are identified when importing time data

floorsweeper · ‎September 07, 2020

There is a business which regularly downloads employees' work hour data in IIF files from the time tracking system, and imports into QuickBooks. The version of QuickBooks is Desktop version Enterprise 18.

What has been troublesome is that it seems QuickBooks can only identify employees by their names, and, thus, when there are employees with same names, the names had to be modified in some way to make them distinguishable such as by adding some special characters or numbers to the names.

Having to use such naming convention led to frequent troubles for the person who handled the data. If the employees could be identified simply by their employee numbers, such troubles could be avoided.

So, here my question is whether there is a way to import employee time data into QuickBooks in which employees are identified by their employee numbers rather than their names.

RCV · ‎September 07, 2020

We always strive to provide the best experience using QuickBooks Desktop Enterprise, floorsweeper.

I appreciate you for coming up with the workaround to import employee time data into QuickBooks. I know how beneficial it is to your business to import Intuit Interchange Format (IIF) files to QuickBooks by their employee numbers. However, the IIF file only imports the employee's names and payroll data from Intuit payroll services.

Once there's a duplicate imported name, list, or elements, the software will ask you to add special characters or numbers to the names. If the import is unsuccessful, the software automatically creates a new .IIF file for failed records with error descriptions. To troubleshoot the issue, see Improved IIF Import in QuickBooks 2019 and later for more details.

To learn more about IIF files, refer to these articles:

You can visit these blogs for any upcoming QuickBooks updates and enhancements:

I've got a link here where you can find articles about managing your employees' transactions: Workers and employees.

I'm just one click away if you need a hand with running employee's reports or any QuickBooks related. I'm always here to ensure your success. Take care always.