Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have an ongoing issue where when I review the employee hours (after importing from QBTime) the hours show as whole (for example 8 hours for a day). Then, after I have run payroll and I run a report the hours are showing up as rounded down (for example 7.99667). This changes the gross amount paid to the employees. We frequently pay our employees prevailing wage rates and submit certified payroll, so the hours and amounts they are paid absolutely have to match between QuickBooks, the daily sign in sheets and our certified payroll reports.
How can I correct the hours prior to submitting payroll so that our employees are paid the correct amount?
Hi there, @JLB-9. I'll share with you information to help you fix the issue that you have with your employee hours.
QuickBooks allows you to customize how hours are rounded, affecting final calculations and payment amounts.
We can check the rounding preference in your timesheet settings to ensure your employees get the proper pay.
Here's how :
Refer to the following article for more comprehensive information on this topic: Set up timesheet rounding in QuickBooks Time
In addition, I'm sharing an article that offers the advantages of maintaining accuracy, compliance, financial analysis, and comprehensive record-keeping for businesses and employees: Run payroll reports.
If you require any support managing your payroll transactions, don't hesitate to get in touch with me anytime.
Thank you for your reply and info. This issue is solely within QuickBooks and does not have anything to do with QBTime that I am aware of. We already have our rounding preference set within QBTime and do not want to change them. The issue is that QBT, and the weekly timesheets within QB, will show that an employee has 8 hours of work for a day. I'll pay them, then run a payroll summary report afterwards and the report will show that they were actually paid for 7.99667 hours. I need to see that rounded down amount before I run payroll and be able to fix it so that the payroll summary is actually showing 8 hours worked and their gross pay is for 8 hours.
Here are the places within QB that I can see the hours prior to submitting payroll:
Employees: Enter Time: Use Weekly Timesheet
Employees: Pay Employees: Enter Payroll Information (on the summary page, not on the individual employee paycheck page)
In neither of those places does QB show the hours worked with 5 decimal places, so there is no way for me to know that QB is actually going to pay that employee less then 8 hours.
Let me guide you on how to fix this and show the rounded amount when running payroll, JLB-9.
Normally, what shows on the paycheck should match the hours when running the Payroll Summary report. I've tried this on my end and used the same information based on your screenshot:
However, since it still shows 7.99667 hours when you run the report, you'll have to make sure to update QuickBooks to the latest release so it provides new and improved functionality making it free from errors and at the same time getting the latest tax table update to provide up-to-date, accurate rates and calculations for payroll tax forms.
After you've performed them, try running the report if it is still showing the incorrect information. Otherwise, use the QuickBooks Tool Hub to fix the common issues. For the best experience, we recommend using Tool Hub on Windows 10, 64-bit. Here's
Furthermore, you may experience having issues if the hours are listed in the Weekly Timesheet and you've run payroll but the hours don't display in the payroll fields, check out this article for more details: Fix QuickBooks Time Payroll Hours Display In QuickBooks Desktop.
Let me know if you have any questions when running payroll. The Community is always here to help you anytime. Have a nice day!
Thanks for the info. Our company preferences are already set to decimal. And I don't have any issues with seeing the employees hours when running payroll, I have issues that the amount shown when running payroll is rounded up, but the actual amount paid is actual slightly less.
See attached screenshots showing the weekly timesheet showing 8 hours, the paycheck review showing 8 hours and then the payroll summary showing actual hours paid as 7.99667.
Good day, @JLB-9. I appreciate your patience in troubleshooting the difference between the paycheck review showing 8 hours and the payroll summary with 7.99667 hours paid. Worry no more, I'm here to direct you to the department that handles this matter.
When considering whether or not to round hours, we strongly advise seeking guidance from a labor/employment attorney in your country. Furthermore, if your company is based in the USA, we suggest checking the US Department of Labor's website and your state's labor laws for additional information.
Since your Timesheet settings on QB Time and Company Preferences on QBDT have been reviewed and configured, I recommend contacting our Support Team. They have all the necessary tools to pull up your account in a secure environment and investigate this issue further. Rest assured that our experts will provide resolutions according to your situation.
Here's how:
Please check out this article for our support hours: Contact QuickBooks Desktop Support. It is to ensure we cater to your needs on time.
If you have concerns about QuickBooks Time, check out this link to raise them during their operating hours: Contact QuickBooks Time support.
These resources will help you learn more about how employers round employee timesheets, what the Department of Labor has to say about it, and how it’s done right:
Through this process, we should be able to narrow down the issue regarding the incorrect amount shown when running payroll. You're always welcome to go back to this thread for more assistance in managing employees or generating paychecks. It'll be my pleasure to aid you.
I am having the exact same issue. Quickbooks support is of no use. Can you give me a suggestion on how to fix this problem?
We don't want you to feel that way when contacting our support team, Shannah. Allow me to provide some details regarding the time formats to ensure the calculation is accurate when creating paychecks for your employees.
You'll want to look at how your time entries are set up since QuickBooks Desktop has two-time formats: decimal and minutes. These are the time formats followed in QuickBooks Desktop, and you can change the time entered on paychecks or set up sick and vacation time balances. These are the following:
When you enter 4:30 while your preferences are set to decimal, QuickBooks converts your entry to 4.5 (4 and a half hours).
When you enter 4.5 while your preferences are set to minutes, QuickBooks converts your entry to 4:30 (4 hours and 30 minutes).
To change and set the format for your time entries, follow the steps below:
For more details, open this link: Change the time format from decimal to minutes or vice versa in QuickBooks Desktop Payroll.
Here are some resources to help you add sick or vacation pay hours when making paychecks and fix problems with their payroll hours:
Please know that I am available to provide further assistance with time entries or any related issues. I'll be more than happy to help.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here