Calculate average holiday pay - 52 weeks

Calculate average holiday pay - 52 weeks


Legislation is changing in April 2020 so that holiday pay is calculated over a 52-week period, rather than a 12-week period. Previously, six functions were available to return holiday pay values based on a 12-week reference period. These functions are only able to calculate 12-week periods, thus are unable to calculate holiday pay as of April 2020.

In order to calculate the correct holiday pay following the 52-week change, a similar set of functions has been introduced in TMS 8 version 8.30.0.0 that are more customisable than the previous holiday pay functions, to be used in custom calculations and reports. These new functions can take parameters to alter how they behave.


What is a parameter? A parameter is something you can attach to the end of a function to change how it behaves. For example, if you had a function that added two numbers together, AddTogether[X,Y], you would replace X with 1 and Y with 2, and then get 3 as the answer. Another example would be a function that counted how many hours of a particular Hours code an employee had worked. This would have two parameters: the employee, and the Hours code. So it may look something like this: CountHours[Employee1,BH]


The new functions and their parameters are as follows:

Function

Description

Parameters

Example

HOLPAYDAYSN

This function will return the number of days worked

Date: the date at which the period to search will end

Number of weeks: the number of weeks back to look

HOLPAYDAYSN[@01.01.2001,52]

This example would return the number of days worked between 1st Jan 2001 and 52 weeks prior to that date

HOLPAYHOURSN

This function will return the number of hours worked

Date: the date at which the period to search will end

Number of weeks: the number of weeks back to look

Hours code (optional): you can look for a specific Hours code with this function – you can specify multiple codes by separating them with a semi-colon (‘;’)

HOLPAYHOURSN[@01.01.2001,52,BH]

This example would return the number of hours worked on the ‘BH’ code between 1st Jan 2001 and 52 weeks prior to that date

HOLPAYWEEKSN

This function will return the number of weeks worked

Date: the date at which the period to search will end

Number of weeks: the number of weeks back to look

HOLPAYWEEKSN[@01.01.2001,52]

This example would return the number of weeks worked between 1st Jan 2001 and 52 weeks prior to that date

HOLPAYSTARTN

This function will return the start date of the period

Date: the date at which the period to search will end

Number of weeks: the number of weeks back to look

HOLPAYSTARTN[@01.01.2001,52]

This example would return the date 52 weeks prior to 1st Jan 2001

    • Related Articles

    • CALCAVEPAY function

      The CALCAVEPAY function can be used to calculate an employee's pay over a number of pay periods.  It takes 3 parameters, two of which are mandatory and the last of which is optional.  The three parameters are: The pay relationship(s) you want to ...

    • Changes to Holiday Pay calculations

      Holiday Pay by hour or by day can now be set at the Pay group level Employees take holidays in either days or hours. Flexipay therefore needs to know how to calculate the Holiday pay rate appropriate to the Employee. Prior to version 2.53.1.0, this ...

    • Holiday pay calculation changes

      From April 2020, the holiday pay calculation will be changed from a 12-week average to a yearly 52-week average. As a result, this will update custom calculations that use the existing HOLPAY calculation functions.  Note: Custom calculations using ...

    • Setting up a display view to view holiday pay changes

      To set up a Display view, open the System menu in the Flexipay toolbar, hover over the Maintain elements of pay option and click Maintain display views. This will open the Maintain display views window:   Click the Add button to add a new Display ...

    • Parental Bereavement Pay

      A new statutory allowance for parents who have lost a child is being introduced in April 2020. The Statutory Parental Bereavement Pay (SPBP) will follow the same administration process as other statutory payments, like paternity pay. The employee can ...