cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

IIF file import erases workers' compensation class codes

We import time card data via export to import into QuickBooks Pro 2017 using an IIF file.  When the IIF file populates the time card data in the “Enter Payroll Information” window, the workers’ compensation codes assigned to each employee’s profile inside QuickBooks do not appear and we must manually enter the workers’ compensation codes for every payroll item for each employee.  However, when we manually enter the time card data in the “Enter Payroll Information” window, the workers’ compensation codes are populated for each payroll item automatically as per each employee’s profile.  How can we avoid having the workers’ compensation codes from disappearing when importing the IIF file time card data?

Solved
Best answer 07-20-2019

Accepted Solutions
QuickBooks Team

Re: IIF file import erases workers' compensation class codes

Thanks for your response, @APS_User.


@Anonymous  and @Anonymous answers are correct. The IIF file format doesn’t have a field for the Workers Comp codes. You still have to manually enter the information, so they will show in the Enter Payroll Information window.


I will pass along this idea on your behalf for consideration in product enhancements. Once I hear any updates about this feature, I'll let you know by posting the details on this thread. 


To keep up with new product features, please visit the Firm of the Future site. Just navigate to the Product & Industry News menu and select Product Updates to see the information.
wci.png wc1.png


Stay in touch if you have further questions or concerns about QuickBooks. I’ll jump right back in to help you. Wishing you the best. 

View solution in original post

6 Comments
Anonymous
Not applicable

Re: IIF file import erases workers' compensation class codes

I can give you the reason why imported time data does not include employee's Workers Compensation codes, @APS_User,

 

When importing data into QuickBooks, it requires a specific file format and headers. The placement of these headers defines a field in the company file to prevent issues during the import.

 

It serves as a command on what information is imported into QuickBooks. While there isn't a Worker's Compensation column on the import kit or template, you'll have to add them manually. The system only reflects what is on the IIF file.

 

To give you a quick peek of the import templates, check out this link: IIF Overview: import kit, sample files, and headers


Please let me know if you have any other questions or need further assistance with QuickBooks. I'm here to lend you a hand anytime.

Anonymous
Not applicable

Re: IIF file import erases workers' compensation class codes

This is happening because Intuit never added a field to time records for the WC code, and it does not populate much of anything not specified in the IIF file when you import.

 

So, all imported time records won't have a WC code, and then the blank codes will appear the same way on paychecks when that time is used to populate paychecks.

 

Intuit can fix this anytime they want by adding the field.

Level 1

Re: IIF file import erases workers' compensation class codes

Thank you for the responses.  I am still not sure I understand.  BRC, are you saying the only way to remedy this is to have Intuit add the WC code field as part of the IIF file import procedure?  Alternatively, is this something that I can ask the third party software vendor that creates the time card IIF data file to modify on their end by adding a field for the WC code to the IIF when created in their software so it comes pre-populated with the WC codes?  I think this is what Jen_D was describing but I'm not well versed enough to understand the IIF file formatting with headers, etc. just yet.

QuickBooks Team

Re: IIF file import erases workers' compensation class codes

Thanks for your response, @APS_User.


@Anonymous  and @Anonymous answers are correct. The IIF file format doesn’t have a field for the Workers Comp codes. You still have to manually enter the information, so they will show in the Enter Payroll Information window.


I will pass along this idea on your behalf for consideration in product enhancements. Once I hear any updates about this feature, I'll let you know by posting the details on this thread. 


To keep up with new product features, please visit the Firm of the Future site. Just navigate to the Product & Industry News menu and select Product Updates to see the information.
wci.png wc1.png


Stay in touch if you have further questions or concerns about QuickBooks. I’ll jump right back in to help you. Wishing you the best. 

View solution in original post

Level 1

Re: IIF file import erases workers' compensation class codes

@Anonymous you are so correct! I have been looking for this to be added for YEARS now. For those of us who have many time entries per worker, because we track by job for costing, it is a pain to have to manually enter the WC Code for EVERY....SINGLE....ENTRY....!!! 

 

In reference to your wording below, it's the header they need to add, not the field. See print screen below (or attached-not sure how it looks). The field is there and has been for many years. They need to add the header and the coding for their import feature to recognize that the data under that header needs to be placed in the matching field. It is really not rocket science. It is a list just like the other fields on the timer activity entry.

 

QuickBooks Team

Re: IIF file import erases workers' compensation class codes

I appreciate the screenshot you've provided, @NumberCruncher260.

 

I can see how the ability to add a field to enter the time records in the WC code would be helpful for both you and your business. I’d be glad to forward these suggestions to our Product Engineers for consideration in future updates. 

 

You can always get back to us here in the Community if you have other questions. I'm always here to help.

Need to get in touch?

Contact us