Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI 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! Go to Solution.
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.