Contents
- Configure AHP behaviour on company pay elements
- Reporting
- View current rate
- Paying AHP
- Importing historic data
- Non weekly pay periods
Introduction
Average Holiday Pay (AHP) ensures employees don’t lose income when taking holiday. It’s calculated using average weekly earnings over the last 52 worked weeks (up to 104 calendar weeks if needed). Only weeks where the employee was paid and not on holiday or receiving statutory payments are included.
Some payments, like expense reimbursements, may be excluded from the calculation.
Configure AHP behaviour on company pay elements
The system default pay elements are set up with the below Average Holiday Pay behaviour.
| Order | ID | Name | AHP |
| 1 | days | Days (system default) | Include |
| 1 | hours | Hours (system default) | Include |
| 1 | salary | Salary (system default) | Include |
| 1 | shifts | Shifts (system default) | Include |
| 13 | holiday | Holiday (system default) | Veto |
| 15 | ahp | Holiday (AHP) (system default) | - |
| 20 | ta | Termination Award (system default) | Veto |
| 26 | expense | Expense (system default) | Exclude |
| 101 | ssp | Statutory Sick Pay (system default) | Veto |
| 102 | smp | Statutory Maternity Pay (system default) | Veto |
| 103 | spp | Statutory Paternity Pay (system default) | Veto |
| 104 | shpp | Shared Parental Leave (system default) | Veto |
| 105 | sap | Statutory Adoption Pay (system default) | Veto |
| 106 | sncp | Statutory Neonatal Care Pay (system default) | Veto |
| 106 | spbp | Statutory Parental Bereavement Pay (system default) | Veto |
| 201 | reverse | Net to Gross (system default) | Include |
| 602 | pension_salary_sacrifice | Pension Salary Sacrifice (system default) | Include |
| 801 | ruhp | Rolled up holiday pay (system default) | - |
| 999 | other | Other (system default) | Exclude |
These can be edited in Company Setup > Pay Elements > click on the edit button next to the required pay element or you can click + Add pay element to create a new one.
| Note: changing pay element configuration will change how all historic payments affect future calculations. For example, refreshing the report after a configuration change may result in different values. We recommend downloading the report before making changes to run a comparison. |
Average Holiday Pay behaviour options:
- Include - this payment will be added to the total earnings for AHP.
- Exclude - this payment will not be added to the total earnings for AHP.
- Veto - this indicates that the pay period in which this payment is made does not represent a normal earnings period and therefore the entire earnings period should be excluded from the AHP calculation. This is usually used for Statutory Sick Pay or Statutory Parental Pay.
Reporting
In Reports > Payroll > Average Holiday Pay Report or in Pay > Pay run > Reports > Average Holiday Pay Report you can find the employee's details, their total eligible earnings each pay period and the last column shows the Weekly AHP value as calculated at the selected pay date.
A pay period with a blank indicates that period was not normal, either because there were no eligible payments or the payslip included veto payments - this is excluded form the AHP calculation.
A pay period showing 0 indicates the employee was paid but their eligible pay was reduced for some reason (e.g. over payment deduction) - this is being included in the AHP calculation.
The report can be downloaded as a CSV, Excel or PDF
View current rate
You can view the current AHP rate for an employee in both weeks and days by clicking the AHP rate button when editing an employee’s payment.
The Average holiday pay rate /day / week for that employee on that pay date will be displayed.
| Note: By default, empty pay runs are excluded from AHP. If a payslip has payments but totals £0 gross, it may be included. To exclude a £0 gross payslip from AHP calculation, add a VETO AHP Pay element. |
Paying AHP
To pay AHP go to the employees record in Enter Payments tab on the pay run and click + Add payment
In Payment type select the default Holiday (AHP) or a pay element you created for the average holiday pay. The Description can be overwritten and you will be required to enter the amount of holiday days you wish to process. The Rate field is automatically calculated and cannot be overwritten.
| Note: The employee's daily AHP rate is calculated by dividing the Weekly AHP rate by the number of days in the employee's working pattern. If no custom work pattern is set on the salary, the company default work pattern is used. |
Importing historic data
Historic payments which support the AHP calculation can be imported using the templates attached at the end of the article. These values can be found in the Adjustments section of an employee’s page. As they are used in the calculation they are also visible in the report.
System figures take precedence over imports, i.e. you cannot replace a real payslip figure by importing a different one.
| Note: When re-importing data, please include all required dates and values. Any new import will overwrite previously imported data for an employee. |
There are two supported imports:
Full import
The per period earnings for AHP for every normal period are imported. These are treated in the same way as in system payments for the calculation.
Periods with no earnings are considered not normal and should be excluded from the import, but £0 payments are included in the calculation.
| Note: Import only the required periods. Any period imported with a Pay Date and a blank Pay will display an AHP of 0 for that period. |
Please use the ahp_per_period import template and complete the following fields:
- Pay ID/ Employee Code - enter the employee's RTI Payroll ID or Employee Code
- Pay Date - enter the pay date the earnings relate to
- Pay - enter the amount for AHP calculation in the relevant pay run
Partial import
Where it is not possible to obtain per period earnings, the customer can import the AHP rate as it was on the migration date, along with the number of weeks this applies to.
Importing £500 with a 10 week count has the same impact as importing £500 separately for each of the last 10 weekly pay periods.
Please use the YTD import template and complete the following fields for the AHP calculation:
- Employee AHP valid at - enter the pay date when this AHP value was valid
- Employee AHP value - enter the employee’s weekly AHP amount
- Employee AHP week count - specify the number of weeks the AHP value applies to
- Employee AHP scheme - this field can be ignored, as currently only one AHP scheme is supported
Non weekly pay periods
The legislation is defined in weeks. Where the employee is paid on a monthly, quarterly, biannual or annual basis the values are adjusted in some way to achieve a weekly rate. The system uses the following calculations to convert from monthly pay to a weekly value, where N is the number of normal pay periods:
Monthly |
|
Quarterly |
|
Biannual |
|
Annual |
|
Comments
0 comments
Article is closed for comments.