Calculate average holiday pay  52 weeks
Legislation is changing in April 2020 so that holiday pay is
calculated over a 52week period, rather than a 12week period. Previously, six
functions were available to return holiday pay values based on a 12week
reference period. These functions are only able to calculate 12week periods,
thus are unable to calculate holiday pay as of April 2020.
In order to calculate the correct holiday pay following the
52week 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 1^{st} 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 semicolon (‘;’)

HOLPAYHOURSN[@01.01.2001,52,BH]
This example would return the
number of hours worked on the ‘BH’ code between 1^{st} 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 1^{st} 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 1^{st} Jan 2001

Related Articles
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 ...
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 ...
Holiday pay calculation changes
From April 2020, the holiday pay calculation will be changed from a 12week average to a yearly 52week 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 ...
Adding a pay rise in Flexipay
You can process pay rises in Flexipay by opening the Maintain pay rises window. Click System in the Flexipay tool bar, and click Maintain pay rises. First, add a pay rise by clicking the Add button. Second, select the element(s) of pay that you want ...