What to do if: Overtime is calculated incorrectly
This article is intended for:
Relevant module:
Several settings are involved in calculating overtime.
If you notice an error in the calculation, don't panic—we have compiled a list of points to check to resolve the issue.
Warning!
If your timesheet has been approved, configuration changes will have no impact. You must change the timesheet back to the “new” status for the data to synchronise and for your new rules to be taken into account.
📖 In this article:
- Reading the timesheet
- I check the “theoretical hours” setting
- I check the configuration of the “overtime” rules
- I check the impact of public holidays
- I check the impact of absences
Before getting started, here is a quick reminder on how to read the summary tables in the timesheet.
Reading the timesheet
Summary table of hours worked
Go to: Menu > Time & Activities > My timesheets
- Theoretical time = working hours − holiday/absence hours “deducted from theoretical time” / non-valued public holiday.
- Counted as worked = working hours + holiday/absence hours “counted as worked” / valued public holiday.
- Difference = theoretical time − hours counted as worked.
Summary table of overtime
Go to: Menu > Time & Activities > My timesheets
- Counted for the overtime calculation = hours counted as worked that are not excluded from the overtime calculation (certain types of time or certain types of absence, for example).
- Calculated overtime = overtime calculated according to the rules established.
- Approved overtime = overtime actually transferred to a time-off-in-lieu or other balance, or to payroll, after the timesheet or transfer has been approved.
Need to explore the subject further before continuing? Read the full article: Understanding timesheet summary tables.
I check the “theoretical hours” setting
The number of theoretical hours is determined in the working hours schedule, under the “General” tab.
To find out the employee's working hours schedule, I go to the employee record, under the “Employment” tab.
Go to: Admin Area > Employees and users > Employee record > “Employment” tab > Working hours schedule
Warning!
Make sure you select the working hours schedule corresponding to the period covered by the problematic timesheet.
I check the daily working hours and the number of weekly hours.
I check the configuration of the “overtime” rules
The rules that will be triggered when timesheets are approved are configured in overtime profiles:
Go to: New Admin Area > Time & Activities > Overtime profiles
I check:
- the triggering conditions.
For example: if I want the employee to receive overtime at 125% from 36 to 39 hours, based on the theoretical hours, I select “Between”: “Theoretical hours” at 35:00 and “Fixed number of hours” at 39:00.
- the transfer type: manual or automatic;
- the destination: time off in lieu (or another balance) or payroll;
- the uplift.
In this profile, you can also manage the rules for night hours, weekends, public holidays, special time, etc.
To find out more about overtime rules and other uplifts: Configuring overtime, uplifts and other special time.
Once the rules have been modified/checked and saved, you will need to change the timesheet back to the “new” status, synchronise it again and then save it again. You must then follow the initial submission and/or approval steps to trigger the rules.
I check the impact of public holidays
If there are public holidays during the timesheet period, it is also advisable to check whether they have been configured correctly.
You can choose whether or not to include public holidays in the theoretical working time.
To find out which setting corresponds to your requirements, please see our dedicated article: Including or excluding public holidays from actual working time.
If work on public holidays is subject to an uplift, the rules must be entered in the overtime profile linked to the working hours schedule.
For example, if working on public holidays entitles the employee to time off in lieu:
I check the impact of absences
Absence settings can affect the calculation of overtime in timesheets.
Go to: Admin Area > Holidays & Absences > Holiday and absence types
In the holiday types, you will find the “Other settings” and “Time and activities” sections:
Other settings
“Count as worked”: treats the absence as actual working time in activity sheets (overtime calculation). When exporting the holiday schedule, this indicates whether the absence is counted as worked for people who are not on a days-based package.
“Deduct from theoretical working time”: when calculating overtime on timesheets, hours or days taken as holiday will delay the triggering of overtime and will not be counted as working time.
“Include in the overtime calculation”: hours/days taken as absence or holiday contribute to triggering overtime. Example:
- if the box is not ticked, when the employee takes the absence in question, they will not be able to record any overtime during the week in which the absence was taken;
- if the box is ticked, when the employee takes the absence, they may record overtime.
Time and activities
“Show in timesheets”: tick this box to display this type of absence in the Time & Activities module; it allows you to select this type of absence when entering timesheets.
“Allow deletion in timesheets”: if this box is ticked, you can delete the absence if it appears in your timesheets.
“Overtime management”: allows you to define this type of absence as a potential destination balance for transferring overtime (or night hours, etc.) from the Time & Activities module. For example: “Compensatory rest”, “Time off in lieu”, “Hours to be paid”...
If, despite all these checks, you still notice anomalies in the overtime calculation, our cheerful support team will be happy to help!
Keywords: hour · hours · overtime · OT · OT. · weekly · profile · profiles · weekly · uplifted · with · without · uplift · transfer · payroll · manual · rule · rules · calculation · pay · working hours schedule · work · overtime management · number of OT hours · holiday balances · calculation of actual time worked · theoretical hours at 100% or 125% or 150% or 200% · time · additional worked time · deducted absences
Comments
Article is closed for comments.