Overtime Rate to include Add On Amount *1.5

(0) Share

Report

Posted on by Community Member

I have advanced payroll and the client needs to have a shift diff for shift 2 and 3. I have created those add-on codes and tied them to the pay code for Shift 1 and Shift 2. That all works when calculating the pay, however when they have OT it takes base rate (Shift 2 or 3) times 1.5 and adds the Add-On at face value not 1.5 * Add-on. Example: The EE rate is 10.00 the add on is .50 the OT rate is coming out at 15.50 and should be 15.75. I have tried to set up blended rates with no luck. One other note we have the EE base pay in Shift 1 then we used an OT type pay code for Shift's 2 and 3 (Factor of 1) so they only have to update EE rates in the Shift 1 when changes take place and it should roll to other Shift Pay Codes, could this be an issue since blended rates might look at pay type? Does anyone know how to get the Add-On rate to be increased to 1.5 as well? This is GP 2016.

Thank you,

Dawn

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Thomas Franz 1,105 on at

Like (0)

Report
Copy link

Link copied!

GP blends the rates of the pay code transactions, which is not necessarily the rate on the Employee Pay Code Maintenance record. If you assigned the Add-on *after* the payroll transactions were created, the rate on the payroll transaction will not reflect the shift code inflated pay rate. You can select to "Calculate" on the Payroll Transaction Entry window to update the rate of existing transactions updated with the addon amount.

Also, ensure you do not have any "Shift Exceptions" setup for the Calculation Method, else, if you do, ensure the exceptions are included in both the Hours and Dollars averaging calculation. For clarity, you have to change the DDL from "Pay Codes to Include" to "Shift Exceptions" on the Calculation Method Setup window in order to see the exceptions.

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply I found that I was able to make this work by adding the Addon in the Shift Code and then by going to the Pay Code Options and linking a pay code to the Overtime Pay code and using the pay percent as 150%. This is for a client who does not need to use the weighted average method since people stay within the same shift but do pay time and a half on the Shift Differential as well which I was not having any luck in getting it to work, but I seem to have it now. I am not having any luck using the weighted average methods things not change the rate on any of the employees that I tested on. I am obviously missing something here and I did check the exceptions none there but I only had a couple of pay codes that I was trying to run the average on. When does the average calculate, after I hit the calculate on the Transaction Entry screen?

Dawn

Was this reply helpful? Yes No
Thomas Franz 1,105 on at

Like (0)

Report
Copy link

Link copied!

The rate of the overtime pay code will get updated during the "Build Checks" process as it has to be able to consider all of the transactions on the check for the employee in order to accurately calculate the weighted average and apply it to the overtime pay rate.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Again thanks I will try it again and see if I have any success :)

Was this reply helpful? Yes No
efsshiggins 5 on at

Like (0)

Report
Copy link

Link copied!

Hi - I know this is a really old post, but I was wondering if you were successful in getting it to work as I can not - thanks!

Was this reply helpful? Yes No
autourdemoirb 5 on at

Like (0)

Report
Copy link

Link copied!

This is for a client who does not need to use the weighted average method since people stay within the same shift but do pay time and a half on the Shift Differential as well which I was not having any luck in getting it to work, but I seem to have it now. I am not having any luck using the weighted average methods things not change the rate on any of the employees that I tested on.

Was this reply helpful? Yes No