Free tool

52-week average holiday pay calculator

Work out a week's holiday pay for someone whose pay changes week to week, using the 52-week rule from gov.uk. Example figures are filled in so you can see how it works.

Calculate holiday pay

Figures stay in your browser. Nothing you type is sent anywhere.

For a worker with variable pay, a week's holiday pay is their average weekly pay over the last 52 weeks in which they were paid. Skip weeks with no pay and count further back, but never more than 104 weeks.

How to use it

  1. Open the worker's payslips in your payroll software and list their gross pay for each week, newest first.
  2. Include basic pay, regular overtime and commission. Bonuses are not usually included. gov.uk's 2020 guidance says weeks paid with statutory pay such as sick or maternity pay instead of regular pay are left out, so treat those like weeks with no pay.
  3. Type 0 for a week with no pay. The calculator skips it and keeps counting back.
  4. Enter the days they normally work each week and the holiday days you want to price.

Paid monthly? gov.uk's guidance says that in most cases you cannot simply use 12 months of pay. Turn each month into weekly figures first (monthly pay divided by hours worked in the month, times the hours in each week), as shown in our 52-week average guide, then enter them week by week or use From totals with the pay and hours for those weeks.

The 52-week rule in plain English

Since 6 April 2020, holiday pay for workers whose hours or pay vary has been based on a 52-week reference period. Before that it was 12 weeks. The idea is simple: holiday should be paid at what the worker normally earns, so taking leave does not leave them worse off.

StepWhat to do
1Start from the last complete week before the holiday begins.
2Count back 52 weeks in which the worker was paid. A week with no pay does not count.
3If you reach 104 weeks before finding 52 paid weeks, stop and use the paid weeks you found.
4Add up the pay from the counted weeks and divide by the number of counted weeks.
5That is one week's holiday pay. A common way to get a day's pay is to divide by the normal working days; check with Acas if the pattern is unusual.

Which pay goes in

gov.uk describes the "normal" rate of pay as including commission, regular overtime payments, and payments related to length of service or professional qualifications. It does not usually include bonus payments.

There is one more distinction. For regular-hours workers, at least 4 weeks of the 5.6-week statutory entitlement must be paid at the normal rate, and the remaining 1.6 weeks can be paid at the basic rate. For irregular-hours and part-year workers, all leave must be paid at the normal rate, unless the employer uses rolled-up holiday pay for them.

A worked example

Sam works variable shifts behind a bar. In the 52 paid weeks before their holiday, Sam earned £19,734.00 for 1,716 hours, including regular overtime. That is an average of £11.50 an hour. A 30-hour holiday week should therefore be paid at 30 × £11.50 = £345.00.

If the payslip shows £330.00, Sam was paid at the basic rate of £11.00 an hour, and the holiday looks £15.00 short. Whether that is a problem depends on Sam's working pattern and which part of their leave this was, which is exactly what is worth checking with your payroll provider.

Doing this for every holiday

Working this out by hand for one person is fine. Doing it for every holiday, for every member of staff, every month, is where it falls apart. If you run payroll in Xero, Holiday Pay Check reads your payslips and does this for each holiday automatically, with the workings shown.

Questions

How do you calculate 52-week average holiday pay?

Add up the worker's pay from the 52 most recent weeks in which they were paid, then divide by the number of those weeks. Weeks with no pay are skipped and you count further back, up to a maximum of 104 weeks.

What if the worker has fewer than 52 weeks of pay?

Use the average for the full weeks they have worked. If someone has been paid in 20 weeks, the average is based on those 20 weeks.

Does the 52-week average include overtime?

For leave that must be paid at the 'normal' rate, yes: regular overtime and commission count. Bonuses usually do not. Regular-hours workers must get at least 4 weeks a year at the normal rate; the remaining 1.6 weeks can be paid at the basic rate.

How do I work out a day's holiday pay?

Divide the average week's pay by the number of days the worker normally works in a week. For someone averaging £400 a week over 5 days, that gives £80. This is one common approach; the right method can depend on the worker's pattern, so check with Acas or your payroll provider if unsure.

Is this calculator legal advice?

No. It applies the method described on gov.uk to the figures you enter. For a specific case, check with Acas or your payroll provider.

Sources: gov.uk, Holiday pay; gov.uk, Calculating holiday pay for workers without fixed hours or pay.