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

Was this article useful?

How to add a new report to the TMS report menu

Reporting on Multi-line Tables

Contact