Skip to main content

'Days allowed' flexible holiday calculation

Lindsey Braniff
Is the number always rounded UP (and never down), and is it always to the nearest whole number, or half. The Days Allowed is showing as 27, but is this just cosmetic? i.e. is it only showing to a whole number, but the number behind it that actually gets used in the calculation is to 3 decimal places? If the employee were to leave now would it pay the employee based on 26.936 days, or 27? (In this instance, there is no holiday owed, but if there were…….) Also, how often is this updated? Everytime a rota is submitted? Or everyday? If the employees start date was (say)exactly 3 weeks into the holiday year, how would it pro-rate the entitlement. Would it be the calculation below, but 343/365 of this? And again is this updated daily, or weekly?      
0 votes

Linked Ideas

Comments

Sophie Waters

Hi {@005D0000001aFUEIA2}​ 

Holiday will always round UP to the nearest half day as you cannot pay an employee less than their legal entitlement.

As an employee cannot take .936 of a day, if the employee left it would pay the whole day as if they were taking it as a days holiday so as not to penalise the employee.

 

The holiday entitlement is updated on submitted rota weeks and will look back at the last 12 or 26 weeks (depending on configuration) to calculate the average days worked. This will include holiday days and if configured, absences too.

 

Calculation when an employee starts part way through the holiday year.

The system will calculate the number of days between the employees start date and the end of the holiday year and divide this by 365.

No. of days between Employment Start Date:(20/07/2018) and Holiday Year End Date: (31/12/2018) = 164

 

= {164.00000/365}

= 0.44932

 

If average days worked is 5 the system will calculate a whole year at 28 and will multiply this by Fraction Worked(Calculated):"0.449315"

 

= 12.5808

 

This will always be rounded to 13

 

Hope this helps

Kindest

{@005D0000003or4iIAA}​ 

#Holidaycalculation​ #[Holiday Balance]​ 

 

 

 

 

Lindsey Braniff

Thank you so much @Debbie Thomas​ Hope this helps @Karen Griggs​ ​

Please sign in to leave a comment.