Why are paid leave days deducted from your modulation period ?
Within the 1607h to be worked in a year, the paid holidays and public holidays have already been deducted. In the 52 weeks included in your modulation period, employees will inevitably take leave, even though you currently do not know when. During these weeks, the employees do not work, and the absences are therefore not taken into account.
Why does my employee have a positive balance for the week even though he hasn't worked his full contracted hours ?
The calendar year is made up of 52 weeks. Over these 52 weeks, the employee only works 228 days, and it is over these 228 days that he must complete his 1607 hours. The weekly target is therefore simply an estimate of what your employee has to achieve during the week, because the final target remains the one for the period: 1607 hours !
For 1607h to be worked in 2024 (leap year) : 1607h/366 days x 7 days = 30,73h or 30h44.
If I have 35h weekly contracted hours and I worked 40h, the balance will be (40h-30h44=) +9h16 and not +5h !
Find out more right here 👈!
Why do I find 20 hours taken into account in my employee's week when they have no absences of shifts scheduled ?
When setting up your modulation period, you enter a ceiling and a floor. These values define the limit within which the hours worked are taken into account in your employees' modulation.
If the employee's schedule does not exceed his floor, we will take the floor into account for the balance calculation.
If my modulation floor is set at 20h and my employee has worked 7h, the balance will be calculated from the from to the weekly cumulative target.
20h will be taken into account within his modulation (the floor) and 13h will appear in the missing hours of the payroll report (calculated by deducting the worked hours to the floor).
My employee has worked more hours than the ceiling, but I can't see those hours on the modulation counter !
Hours worked above the ceiling do not affect your employee's modulation balance. These are additional overtime hours which appear at the end of the month in your payroll report.
You can find them in the weekly summary by clicking on the concerned week.
My employee’s contract started or ended in the middle of the week and I don’t understand the calculations
In the case of midweek arrivals or departures, only the modulated days are taken into account. To find the right values, we calculate the ceiling, the floor and the contract time proportionally to the number of days modulated.
Let's take a look at Matthew, whose 35-hour per week contract ends on a Thursday.
In the modulation period settings, the floor for full-time work is set at 0 hours and the ceiling at 42 hours. Over the week, 4 days are modulated, and we apply the following calculations :
Contract time: (35 h / 7 days) * 4 days = 20h
Floor: (0 h / 7 days ) * 4 days = 0h
Ceiling: (42 h / 7) days * 4 days = 24 hours
Over the week, Matthew worked 24h55.
24 hours are taken into account in the modulation and as we exceed the prorata of his ceiling (24 hours) by 55 minutes, these 55 minutes are counted as overtime and will appear in the payroll report.