Free holiday pay template

Manual holiday pay doesn’t have to be hard.

With our easy-to-use holiday pay template, you can work out holiday pay using the new 52-week pay reference period, for zero hours or variable pay.* Download the Excel for quick holiday pay calculations.

Zero-hour workers

Variable pay workers

Weekly workers**

Download now

*incl. overtime/commission variable hours. Based on the BEIS guidance, this template will work out holiday pay for weekly paid workers.
**monthly, fortnightly or 4-weekly paid workers can also use this template. However, you must ensure you have records for each worked week. This is because the new holiday law uses pay each week when pay is on a different frequency. Complete the last whole worked week that relates to your payday.

automated holiday pay

Had enough of spreadsheets and calculators?

Whilst our holiday pay template does the calculation for you, it still takes a long time to enter all the data. You also need to do the calculation every time holiday is taken because the calculation will change. You will also need to repeat for each worker, each week!


That’s why we designed paiyroll® to fully automated holiday pay for you. Whether you are a bureau or an employer, with paiyroll® you will love how employees book holidays, managers approve it and pay is added automatically according to the new holiday legislation. This works for zero-hours workers, variable overtime and commission work patterns.

Just contact us or use live chat to find out how, so you never have to calculate holiday pay again!

ai payroll software.
real human support.

paiyroll® turns your employee data into payroll instantly using automation powered by artificial intelligence.

100% automated payroll for all pay elements incl. holiday pay, tax codes, salary pro-rata, NI and NMW.

Works with API or upload any spreadsheet (no edits needed!).

Payroll processing time is reduced by 75%, saving you 3 days a week!

Try it for free