Spreadsheets · Free download
Free Holiday Pay Tracker (UK)
A holiday pay tracker for UK employers who pay staff variable hours or variable pay and need to get the holiday figure right. It keeps a rolling 52-week record of gross pay and works out the average weekly pay to use for holiday, exactly the basis the Working Time Regulations expect where earnings change week to week. Weeks with no pay drop out of the average automatically, so leave and sick weeks do not drag the figure down. A built-in National Living Wage check flags anyone whose average slips below the minimum, and a plain-English notes tab walks through the awkward bits, including sleep-ins and how the 52-week averaging works. It is free to download and is a genuine head start on a fiddly calculation.
What's included
- A rolling 52-week record of gross weekly pay
- The average weekly pay to use for holiday, worked out for you
- Unpaid weeks excluded from the average automatically
- A built-in National Living Wage check
- A plain-English notes tab on sleep-ins and the averaging rules
How to use it
- Enter each employee and their weekly gross pay as the weeks pass.
- Leave a week blank where there was no pay; it drops out of the average.
- Read the average weekly figure to use for a week of holiday.
- Watch the National Living Wage check for anyone falling short.
Reflects the Working Time Regulations 1998 (as amended) and the 52-week holiday pay reference period. The National Living Wage figure is set in the tracker and should be checked and updated each April.
Questions
How is holiday pay calculated for variable pay?
For workers without fixed hours or pay, holiday pay is based on average weekly earnings over the previous 52 paid weeks, ignoring weeks with no pay. The tracker keeps that rolling average for you.
Is it really free?
Yes. Enter your email once and the Excel tracker downloads free.
Free and provided as-is. It is a head start, not professional advice, so always check anything you rely on is correct for your own situation. See the resource terms.