cancel
Showing results for 
Search instead for 
Did you mean: 
aquinones
Level 2

Manually override Gross Salary

I 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
Best answer February 02, 2021

Best Answers
BigRedConsulting
Community Champion

Manually override Gross Salary

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:

 

Capture.JPG

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!

View solution in original post

4 Comments
Mark_R
QuickBooks Team

Manually override Gross Salary

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:

 

  1. In your QuickBooks Desktop, go to the Employees menu and select Get Payroll Updates.
  2. Select the Download Entire Update checkbox.
  3. Click Download Latest Update.
  4. A window appears when the download is complete.

 

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!

aquinones
Level 2

Manually override Gross Salary

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. 

BettyJaneB
QuickBooks Team

Manually override Gross Salary

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. 

  1. Go to Lists from the top menu. 
  2. Select Payroll Item List
  3. In the Payroll Item drop-down, choose New
  4. Select Custom Setup, then click Next
  5. Choose the payroll item type and enter its name, then click Next
  6. Select the same expense account that was used for the original compensation item with which the employee was overpaid in the Liability account field. Hit Next
  7. Select Compensation as the tax tracking type, then click Next
  8. If the employee was paid hourly, choose Calculate this item based on Quantity. If the employee was paid with a salary item, select Neither.
  9. Click Finish

The screenshot below shows you the sixth to eight steps. 

undefined

 

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.

BigRedConsulting
Community Champion

Manually override Gross Salary

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:

 

Capture.JPG

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!

View solution in original post

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

Need to get in touch?

Contact us