Rolled-up holiday pay calculator for Irregular hours and part-year workers
This Rolled-Up Holiday Pay Excel Calculator simplifies calculating holiday pay by adding a 12.07% uplift to hourly wages for workers with irregular or part-year hours. Ideal for employers, it automatically adjusts based on input, ensuring accurate pay calculations and proper pay-slip breakdowns as per 2024 regulations.
How this Rolled Up Holiday Calculator Works
This system is set up to calculate rolled-up holiday based on the statutory entitlement which gives the multiplier 12.07%. For, example, look at Bob in Cell A3 who works irregular hours. He has 28 days statutory holiday entitlement (5.6 weeks) and is entitled to a rolled-up holiday multiplier of 12.07%. Bob’s hourly rate is £15 an hour and he earned commission of £69 and his pay for the qualifying period was £579. When you add on his holiday pay of £69.88 (12.07%), his rolled up holiday payment is £648.88
How to Use the Rolled Up Holiday Pay Calculator For Irregular hours and part-year workers
Firstly, populate the large table below with employee data as follows:
- Column A : Employee name
- Column B : Hours each employee has worked in the pay period
- Column C : Hourly rate
- Column D : Bonus/Commission paid, (as this must by law be included in holiday pay calculations)
Then,
- Column E will automatically calculate the pay for the qualifying period and include any bonus.
- Column F displays the rolled up holiday multiplier which is drawn from the small ‘Modifier’ box to the right.
- Column G displays the actual holiday pay component
- Column H displays the final rolled up holiday pay figure for staff.
How to include additional holiday entitlement, (over and above statutory holiday)
It’s important to re-iterate that the 12.07% is based on the statutory entitlement. This means that if you offer your workers more than this statutory minimum, you’ll need to use a higher percentage to calculate their holiday entitlement. You can include any additional holiday entitlement in the amber coloured cell in the modifier table below to the right. If, for example, your company offers an additional 5 days holiday on top of the statutory entitlement, (25 days in total), then add 1 in the amber coloured cell to denote one working week. If your company offered additional days, (28 days in total), you would enter 1.6 weeks into the amber coloured cell.
————————————————————————————————————————————————–
Rolled-up holiday pay calculator for Irregular hours and part-year workers
This Rolled-Up Holiday Pay Excel Calculator simplifies calculating holiday pay by adding a 12.07% uplift to hourly wages for workers with irregular or part-year hours. Ideal for employers, it automatically adjusts based on input, ensuring accurate pay calculations and proper pay-slip breakdowns as per 2024 regulations.
