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 need to be able to manually override. This due to the rounding factor if I enter straight 80 hours for example (80 hours x 16.10 hrs. gives me 1288.00)
If I break the same 80 hours into holiday pay, vacation time it gives me 1288.01.
I need to be able to find a way for the Gross pay be 1288.00 not 1288.01.
I already tried a payroll item as a miscellaneous deduction but that will not reduce my compensation.
Solved! Go to Solution.
RE: This due to the rounding factor if I enter straight 80 hours for example (80 hours x 16.10 hrs. gives me 1288.00) If I break the same 80 hours into holiday pay, vacation time it gives me 1288.01.
You don't need to fix this. Thee is really nothing wrong. It's a penny. No one cares.
Still, any given hourly payroll item, when used alone will work the same exact way.
80 hours x 16.10 per hour will always give the same answer.
However, if you split the hours into multiple rows on the paycheck, each row calculates by itself and rounds to the nearest cent. Which is correct. There is no code or goal to make multiple line items with the same total time add up the the same amount as one line item for the total time.
QB does do this for an annual Salary item, but not hourly items, which arguably would be incorrect.This is very typical of payroll systems, and QB, and is true all over QB and other accounting systems, where each accounting line item is stored in dollars and cents, and never parts of cents.
You can duplicate this in Excel. For example:
Seen here in the last example, where the holiday time is a portion of an hour, each line initially calculates a 1/2 cent, like .625 and .375, but that has to be rounded. In this case both lines round up by 1/2 cent, since each decimal ends with with 1/2 cent or more. And when they do that, then you get one extra cent as a total. Both lines are correct and both totals are correct because your data is different.
In your case you're thinking of making the total the same, perhaps because of the vacation concept, but this same concept applies when you split earnings by job or class or other way that requires multiple line items for the period's pay.
You can duplicate the same thing on a QB invoice or a check or any other table where there is a construct like qty * rate = amount, because every line must be rounded to a cent in order to save it in an accounting system.
Hope this helps!
Thank you for posting here in the Community, @aquinones.
It's possible that there's a different rate that may cause the .01 in your gross salary. Since we're unable to override this, let's try updating the payroll tax table to get the latest payroll update. Here's how:
After updating the payroll tax table, process the payroll again and re-enter the payroll items manually. Then, verify the gross salary if still had a rounding difference.
If you still get the same result, I suggest contacting our QuickBooks Support Team. This way, they can further investigate this matter and help you resolved the rounding difference on the gross pay.
Just in case you want to set up and assign pay schedules to pay your employees, you can read this article for more details: Set up and manage payroll schedules.
Should you need any assistance managing your payroll transactions, I'm available here to help any time!
Thank you but that did not work. I wonder if there is a payroll item I can create that will let me enter a minus .01 to adjust it.
I have reached out to support with no luck.
I'm grateful for the update that you gave, @aquinones.
I'd like to share a solution that you can try to help you adjust the gross pay of your employee.
You can create a deduction type payroll item so you can adjust the .01 from your employees' gross pay. This way, it will be applied and must be added to a paycheck with equal or more earnings than the amount that will be deducted, as QuickBooks cannot create a paycheck with a negative net pay.
Let me guide you how.
The screenshot below shows you the sixth to eight steps.
After that, you can now add the deduction payroll item and the amount to your employee's paycheck.
For detailed instructions, see the QuickBooks Desktop Payroll including Basic payroll, Enhanced payroll and Assisted payroll section through this article: Reduce Paycheck Wages For An Employee Who Has Been Overpaid.
Lastly, I'm sharing this reference, which contains details about grossing up a paycheck in QBDT. This includes the the trial and error method to calculate the gross. Feel free to check this out: Gross up a paycheck in QuickBooks Desktop Payroll.
Let me know if you have any questions or clarifications about this. I'll be more than glad to share some more insights to help you with your payroll processing. Just click the Reply button below to notify me.
RE: This due to the rounding factor if I enter straight 80 hours for example (80 hours x 16.10 hrs. gives me 1288.00) If I break the same 80 hours into holiday pay, vacation time it gives me 1288.01.
You don't need to fix this. Thee is really nothing wrong. It's a penny. No one cares.
Still, any given hourly payroll item, when used alone will work the same exact way.
80 hours x 16.10 per hour will always give the same answer.
However, if you split the hours into multiple rows on the paycheck, each row calculates by itself and rounds to the nearest cent. Which is correct. There is no code or goal to make multiple line items with the same total time add up the the same amount as one line item for the total time.
QB does do this for an annual Salary item, but not hourly items, which arguably would be incorrect.This is very typical of payroll systems, and QB, and is true all over QB and other accounting systems, where each accounting line item is stored in dollars and cents, and never parts of cents.
You can duplicate this in Excel. For example:
Seen here in the last example, where the holiday time is a portion of an hour, each line initially calculates a 1/2 cent, like .625 and .375, but that has to be rounded. In this case both lines round up by 1/2 cent, since each decimal ends with with 1/2 cent or more. And when they do that, then you get one extra cent as a total. Both lines are correct and both totals are correct because your data is different.
In your case you're thinking of making the total the same, perhaps because of the vacation concept, but this same concept applies when you split earnings by job or class or other way that requires multiple line items for the period's pay.
You can duplicate the same thing on a QB invoice or a check or any other table where there is a construct like qty * rate = amount, because every line must be rounded to a cent in order to save it in an accounting system.
Hope this helps!
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.