Holiday pay calculation changes

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 the CALCAVEPAY function will not automatically change and must be changed manually. For example, “CALCAVEPAY[12, ‘Q’]” should be changed to “CALCAVEPAY[52, ‘Q’].

A new feature has been added as an alternative to custom calculations to provide a holiday pay calculation. 

You can use the following new Employee fields that have been added to provide some data on the new values:

Holiday pay type (D = Days, H = Hours – H is the default)
Total holiday pay (This includes overtime, bonus and commission)
Total basic pay (This excludes overtime, bonus and commission)
Total holiday days (This will add up the field Period days worked)
Total holiday hrs (This will add up the Period hours worked field, and any hours from Rates marked as Worked and Hourly)
Holiday pay rate (this is calculated using the above fields)
Standard days worked (this field is manually set, and is for the standard value of days worked in the period)
Period days worked (This is the period value for days worked within the period, and is either set using the above field or manually if the Standard days worked field is zero)

For this to work, starting in the 2020 tax year, the Include in average pay for holiday pay checkbox should be ticked for any Additions that the Holiday is calculated from (e.g. their Salary):



The Holiday pay rate can be used to set up a new Addition relationship with a rate of pay element. The holiday pay addition can be set up with a Holiday pay addition type:




A new calculation has been added to the Payroll calculation to calculate Holiday pay. This will take effect from the start of the 2020 tax year. It will look back through the archive and add up Pay and Hours, taking into account any changes in the Pay group.




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