Overtime calculation help

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Post Reply
oyeaussie
Posts: 7
Joined: Mon May 11, 2015 4:04 am

Overtime calculation help

Post by oyeaussie » Wed Jul 10, 2019 9:29 pm

Please see attached images for all the information (including versions)

I am trying to configure the OT policy in a way that if an employee works more than 8 hours a day, the calculation excludes anything more than 8 hours. The employee wage in example is 40 per hour, so 40*8 should be 320, but you will see that the calculation is 324 instead. How can we exclude the extra 6 minutes from the calculation.

Thanks.

The system is ubuntu 18, running php 7.3 and timetrex was installed using apt.

Also, I ran recalculate after making any modification to the configuration. Still no go.
Attachments
version.jpg
version.jpg (108.18 KiB) Viewed 30 times
policy_groups.jpg
policy_groups.jpg (90.86 KiB) Viewed 30 times
OTpolicy.jpg
OTpolicy.jpg (54.07 KiB) Viewed 30 times
paycode.jpg
paycode.jpg (45.75 KiB) Viewed 30 times
payformulapolicy.jpg
payformulapolicy.jpg (58.85 KiB) Viewed 30 times
report.jpg
report.jpg (53.92 KiB) Viewed 30 times
report_2.jpg
report_2.jpg (94.09 KiB) Viewed 30 times
wageofemployee.jpg
wageofemployee.jpg (44.55 KiB) Viewed 30 times

mikeb
Posts: 541
Joined: Thu Jul 27, 2006 11:58 am

Re: Overtime calculation help

Post by mikeb » Thu Jul 11, 2019 9:39 am

Can you please include a screenshot of the employees timesheet showing the overtime, after you click the "Show Wages" icon to the right of the date field.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!

oyeaussie
Posts: 7
Joined: Mon May 11, 2015 4:04 am

Re: Overtime calculation help

Post by oyeaussie » Thu Jul 11, 2019 7:40 pm

Please see attached screenshot.
Attachments
timesheetwithwages.jpg
timesheetwithwages.jpg (226.63 KiB) Viewed 20 times

mikeb
Posts: 541
Joined: Thu Jul 27, 2006 11:58 am

Re: Overtime calculation help

Post by mikeb » Fri Jul 12, 2019 9:13 am

I see, due to the complexities of overtime policies, TimeTrex will only trigger overtime policies that increase the employees rate of pay, not decrease it. Since you are trying to use an overtime policy that decreases the employees rate of pay, TimeTrex is ignoring it.

Its very unusual that you wouldn't be paying employees for working more than 8 hours, so if you can provide more information as to your actual use case we may be able to find another solution for you.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!

oyeaussie
Posts: 7
Joined: Mon May 11, 2015 4:04 am

Re: Overtime calculation help

Post by oyeaussie » Sun Jul 14, 2019 8:00 pm

Sorry for the late response, the forum doesn't seem to be sending me emails for updates.

We don't have overtime in our company, so if the employee has worked > 8 hrs per day, they don't get paid for that time.

As chances of clocking out every day will never result to exact 8 hours, it will either be above or below 8 hours. Below is fine, as the calculation will generate proper amount. But over 8 hrs, it should be considered as the day MAX pay an employee can get.

By adding 0 amount to the overtime calculation should solve this. As if someone worked for 8:10 mins. 8 hours should be regular wage calculation + 10 mins * 0, which should result in 0 and adding them together should give us the day MAX wage for that employee.

We don't want to round the 8:10 to 8:00 as we would like to monitor the extra hours spent in the office as well.

Thanks.

mikeb
Posts: 541
Joined: Thu Jul 27, 2006 11:58 am

Re: Overtime calculation help

Post by mikeb » Mon Jul 15, 2019 7:48 am

You would have two options then:

1. Round the punch time to their schedule (strict rounding), however keep in mind that TimeTrex still allows you to see the "Actual" non-rounded time for reporting purposes.

2. Use Premium Policies to calculate all pay, rather than regular time and overtime policies. This will complicate your setup somewhat, but should give you more flexibility to allow what you want. Essentially you would leave your existing regular time/overtime policy and set them both to paid at $0/hr, then setup premium policies that are based off of each, paid at whatever rate you want. Since premium policies don't have any of the restrictions that overtime policies do, the rates can be whatever you want.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!

Post Reply