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
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 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 ...
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 ...