Skip to main content
A
aquinones
February 2, 2021
Solved

Manually override Gross Salary

  • February 2, 2021
  • 2 replies
  • 0 views

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. 

Best answer by BigRedConsulting

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!

2 replies

M
Mark_R
February 2, 2021

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!

A
aquinonesAuthor
February 2, 2021

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
    BettyJaneB
    February 2, 2021

    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. 

    CreateADeductionPayrollItem.PNG

     

    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
    BigRedConsultingAnswer
    February 3, 2021

    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!

    Terms & ConditionsAccessibility statement