Skip to main content
G
gc-jp
December 27, 2020
Solved

IIf TimeSheet Import - Hours are entered incorrectly

  • December 27, 2020
  • 1 reply
  • 0 views

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.

Best answer by BigRedConsulting

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.

1 reply

BigRedConsulting
BigRedConsultingAnswer
December 27, 2020

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.

Terms & ConditionsAccessibility statement