cancel
Showing results for 
Search instead for 
Did you mean: 
gc-jp
Level 1

IIf TimeSheet Import - Hours are entered incorrectly

I have just started using IIF files to import my employee timesheet data.

One thing I have noticed is that sometimes the value imported into Quickbooks is off by 0.01 hours.

 

For example, if the Hours in the iif file are 66.93, when I run payroll, that particular entry is 66.92.  I believe this is happening because QB is converting to hours/minutes format and then back.

I have verified that my time format preference is set to Decimal.

 

Basically, I am trying to understand the internal processing QB is doing so I can adjust the script that creates my iif file according.

Solved
Best answer December 27, 2020

Best Answers
BigRedConsulting
Community Champion

IIf TimeSheet Import - Hours are entered incorrectly

RE: " I believe this is happening because QB is converting to hours/minutes format and then back."

 

Yes. QB saves time in minutes, regardless of how you enter (or import) it. If you set the option to display time in decimal then you'll see that, because decimals display 100's of an hour and there are only 60 minutes in an hour, that some decimal equivalents can't be saved because they are rounded to the nearest minute, saved, and then displayed as the closest decimal equivalent to that saved value, which may be .01 different.

View solution in original post

1 Comment
BigRedConsulting
Community Champion

IIf TimeSheet Import - Hours are entered incorrectly

RE: " I believe this is happening because QB is converting to hours/minutes format and then back."

 

Yes. QB saves time in minutes, regardless of how you enter (or import) it. If you set the option to display time in decimal then you'll see that, because decimals display 100's of an hour and there are only 60 minutes in an hour, that some decimal equivalents can't be saved because they are rounded to the nearest minute, saved, and then displayed as the closest decimal equivalent to that saved value, which may be .01 different.

View solution in original post

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up