To check holiday pay in Xero Payroll, take each holiday taken in the month, work out the worker's average weekly pay over the previous 52 paid weeks, and compare that with what the payslip shows. Focus on workers with variable hours, overtime or commission, because their pay is the most likely to differ. Save your workings each time, because holiday pay records must now be kept for six years.
Key points
- Check once a month, after the pay run is finalised, and only for holidays taken that month.
- Start with irregular-hours and part-year workers, and anyone on regular overtime or commission.
- Compare the 52-week average (paid weeks only, counting back up to 104 weeks) with the holiday pay on the payslip.
- Include commission, regular overtime and payments for length of service or qualifications. Leave out bonuses unless advised otherwise.
- A gap is a reason to review, not proof of an underpayment. A person decides.
- From 6 April 2026, records of annual leave and holiday pay must be kept for at least 6 years.
Why a monthly check
Xero's UK guide says holiday pay calculations, including the 52-week average for irregular hours, are handled for you. What Xero does not give you is a report that lists each past holiday with the average behind it and the workings. A product idea asking for that report had 94 votes when we checked on 16 November 2026, and Xero replied on 27 November 2025 that it is not a feature they have planned. We cover that in more detail in does Xero calculate holiday pay on a 52-week average.
So the check is on you. Doing it monthly keeps it small: you only look at holidays taken since the last check, and the records build up as you go.
The monthly checklist
Run through this after each month's pay runs are finalised.
| Step | What to do | Done |
|---|---|---|
| 1 | List every holiday taken in the month, by worker | |
| 2 | Mark which workers are irregular-hours, part-year, or get overtime or commission | |
| 3 | For each marked worker, find the 52-week window before the holiday | |
| 4 | Remove weeks with no pay and count back to replace them, up to 104 weeks | |
| 5 | Add up the pay that counts towards normal pay | |
| 6 | Divide by the number of paid weeks to get the weekly average | |
| 7 | Compare with the holiday pay on the payslip | |
| 8 | Mark any gap as "Review" with a note | |
| 9 | Save the workings with the date and your name | |
| 10 | Pass anything marked Review to the person who decides |
Fitting it into your month
A routine is easier to keep if it has a fixed place in the month. One way to set it up, as a suggestion rather than a rule:
| When | What |
|---|---|
| Pay day | Finalise the pay run as normal |
| Next working day | Run the checklist for holidays taken in the pay period |
| Same day | Save the dated workings file |
| Within a week | The person who decides looks at anything marked Review |
| End of month | Note the outcome against each Review item |
Agree who owns each line. In a small business the bookkeeper often does the check and the owner or manager decides, but that split is up to you. What matters is that the person checking and the person deciding are both named, and that nothing marked Review sits without an outcome for months. If you run more than one Xero organisation, keep a separate file for each, so records do not get mixed up.
Which workers to check
Not everyone needs the same attention.
Check every month
- Irregular-hours workers. People whose hours vary week to week, such as casual bar, kitchen or events staff. For leave years starting on or after 1 April 2024, gov.uk says all their leave must be paid at the normal rate of pay.
- Part-year workers. People who work only part of the year, such as seasonal staff. Same rule as irregular-hours workers.
- Anyone with regular overtime. gov.uk says normal pay includes regular overtime.
- Anyone on commission. Commission is part of normal pay.
Check occasionally
- Regular-hours workers with extras. For these workers, at least 4 weeks of the 5.6 weeks' statutory entitlement must be paid at the normal rate, which can include regular overtime and commission. The remaining 1.6 weeks can be at a basic rate.
- Staff who get length-of-service or qualification payments. These count towards normal pay.
Lower priority
- Salaried staff on fixed pay with no overtime, commission or extras. Their normal pay rarely changes, so differences are less likely.
If you are not sure which group a worker falls into, our irregular hours guide explains the definitions, and Acas can help.
What to compare
For each holiday, you need two numbers.
Number 1: the 52-week average. From gov.uk:
- Use the average pay from the previous 52 weeks, only counting weeks in which the worker was paid.
- If a week had no pay, count back another week. Go back no more than 104 weeks.
- If the worker has less than 52 weeks of pay, use the average for the full weeks they have worked.
- A week usually runs Sunday to Saturday, but can be another 7-day period if that is how the worker's pay is calculated.
Number 2: what was actually paid. The holiday pay shown on the payslip for the pay run that covered the holiday.
What counts towards normal pay
| Payment | Include? | Source |
|---|---|---|
| Pay for hours worked | Yes | gov.uk |
| Regular overtime | Yes | gov.uk |
| Commission | Yes | gov.uk |
| Length of service payments | Yes | gov.uk |
| Professional qualification payments | Yes | gov.uk |
| Bonuses | Not usually | gov.uk |
If a payment does not fit neatly, such as an allowance or an occasional overtime shift, ask your accountant. Our overtime and commission guide goes further.
Getting the figures out of Xero
Xero's own suggested workaround, in its 27 November 2025 forum reply, is to run the Payroll Activity Summary or Gross to Net report over a 52-week period. We could not confirm from Xero's public pages whether those reports break pay down week by week, so you may also need the individual payslips or pay runs to see which weeks had no pay. Check Xero's help centre for the current layout.
If you pay monthly, turning monthly pay into weekly figures needs care. Check with Acas or your payroll provider for the right approach.
A worked example
This example is made up to show the method. The numbers are chosen so they add up cleanly.
The worker: Sam works irregular hours behind a bar, paid weekly. Sam gets regular overtime on busy weekends and commission on events they sell. Sam's leave year started after 1 April 2024, so all of Sam's leave is paid at the normal rate.
The holiday: Sam takes one full week of holiday in October.
Step 1: find the window. Counting back 52 weeks from the week before the holiday, Sam had 3 weeks with no pay (Sam was not on the rota). Those 3 weeks do not count. Count back 3 more weeks, so the window covers 55 weeks and contains 52 paid weeks. That is well within the 104-week limit.
Step 2: add up the pay that counts, over the 52 paid weeks.
| Payment | Total over 52 paid weeks | Weekly average |
|---|---|---|
| Pay for hours worked | £11,960.00 | £230.00 |
| Regular overtime | £2,184.00 | £42.00 |
| Commission | £1,560.00 | £30.00 |
| Bonus (Christmas, one-off) | £500.00 | Left out |
| Total that counts | £15,704.00 | £302.00 |
The £500 Christmas bonus is left out, because bonuses are not usually included in normal pay.
Step 3: work out the weekly average. £15,704.00 divided by 52 paid weeks is £302.00 a week.
Step 4: compare with the payslip. The payslip for that week shows holiday pay of £230.00. That matches the average for hours worked only, as if overtime and commission were left out.
Step 5: the gap. £302.00 minus £230.00 is £72.00 for that week. If Sam had taken two weeks, the gap would be £144.00.
Step 6: mark it. Mark the holiday as Review with a note: "Holiday paid at £230.00. 52-week average including regular overtime and commission is £302.00. Possible shortfall £72.00. Bonus of £500.00 excluded. Window: 55 weeks, 3 zero-pay weeks skipped."
Step 7: pass it on. The person who decides checks whether the overtime really was regular, whether anything in Sam's contract changes the picture, and what to do next. That is a judgement call, and it may need your accountant.
A second case: a newer worker
If Sam had only joined 30 weeks before the holiday, and was paid in all 30, you would use the average for those 30 full weeks instead of 52. The method is the same; only the number of weeks changes.
Part weeks
This example uses a full week of holiday. Turning a weekly average into a daily or hourly rate for part weeks depends on the worker's pattern. Check with Acas or your payroll provider on the right method.
How to record the check for the six-year rule
From 6 April 2026, employers must keep detailed records of annual leave and holiday pay for at least 6 years from the date they were made, for example the number of annual leave days taken and how much holiday pay was paid. Employers can choose how to create, maintain and keep these records. gov.uk says employers may have to pay a fine if they cannot show they kept records.
A simple record for each holiday you check could include:
| Field | Example |
|---|---|
| Employee | Sam |
| Holiday dates | One week in October |
| Weeks of holiday | 1 |
| Pay run it was paid in | October week 2 |
| Holiday pay on payslip | £230.00 |
| Weeks used for average | 52 paid weeks, 55-week window |
| Zero-pay weeks skipped | 3 |
| Pay included | Hours, regular overtime, commission |
| Pay left out | £500.00 one-off bonus |
| Weekly average | £302.00 |
| Difference | £72.00 |
| Status | Review |
| Checked by and date | Name, date |
| Outcome | Filled in once a person has decided |
Keep each month's checks as a dated file. Do not overwrite them. Store them somewhere backed up that you will still have access to in six years, even if you change payroll software or bookkeeper. Our holiday pay records guide covers this in more detail.
Red flags
These are signs a holiday is worth a closer look:
- Holiday pay matches basic pay exactly for someone who regularly gets overtime or commission.
- The same holiday rate every time for someone whose hours vary a lot.
- Holiday pay drops after a quiet spell, which can mean zero-pay weeks were counted instead of skipped.
- A seasonal or part-year worker paid holiday at a lower rate than their working weeks.
- Rolled-up holiday pay not shown separately on the payslip. Acas says it must be.
- Rolled-up holiday pay used for regular-hours workers. gov.uk says employers cannot do this.
- A bonus included in the average without anyone deciding it should be.
- No record of how the figure was worked out.
Common mistakes
- Counting all 52 calendar weeks. Weeks with no pay are skipped and replaced with earlier weeks, up to 104 weeks back.
- Using only basic pay. Regular overtime and commission count towards normal pay.
- Including one-off bonuses. Bonuses are not usually included.
- Checking only salaried staff. They are the least likely to be affected.
- Treating a gap as a confirmed debt. Mark it for review and let a person decide, with advice where needed.
- Saving the answer but not the workings. Six years from now, the workings are what show how the number was reached.
- Checking once a year. A yearly check is a big job and easy to put off. Monthly keeps it small.
Making the monthly check quicker
For one or two workers, you can do the sums with our free holiday pay calculator. For a whole payroll, Holiday Pay Check connects to Xero Payroll with read-only access, works out the 52-week average for each holiday taken, marks possible underpayments as Review with workings, and keeps a dated six-year record per employee. See how it works. A person still decides what happens next, and none of this is legal advice.
Sources
- gov.uk, "Holiday entitlement: Holiday pay": https://www.gov.uk/holiday-entitlement-rights/holiday-pay
- gov.uk, "Calculating holiday pay for workers without fixed hours or pay": https://www.gov.uk/government/publications/calculating-holiday-pay-for-workers-without-fixed-hours-or-pay
- Acas, "Rolled-up holiday pay": https://www.acas.org.uk/irregular-hours-and-part-year-workers/rolled-up-holiday-pay
- legislation.gov.uk, Employment Rights Act 2025, section 35: https://www.legislation.gov.uk/ukpga/2025/36/section/35
- Xero UK, "Summer holiday pay: Handling staff time off": https://www.xero.com/uk/guides/summer-holiday-pay-staff/
- Xero product ideas, "UK Payroll: Reporting - Run a report to calculate holiday pay based on a 52 week average": https://productideas.xero.com/forums/967118-payroll-expenses/suggestions/45241594
Xero is a trademark of Xero Limited. This guide is general information, not legal advice.
Questions
Which workers should I check first?
Start with anyone whose pay changes from week to week: irregular-hours and part-year workers, and anyone who gets regular overtime or commission. Their holiday pay depends on a 52-week average, so it is the most likely to drift from what a payslip shows. Salaried staff on fixed pay with no extras are lower priority.
How often should I check holiday pay?
We suggest once a month, straight after the pay run is finalised. You only need to check holidays taken in that month, so the job stays small. A monthly routine also builds the record you need to keep for six years.
What do I compare when checking holiday pay?
Compare the average weekly pay over the last 52 paid weeks, counting back up to 104 weeks, with the holiday pay shown on the payslip. Include commission, regular overtime and payments for length of service or qualifications. Bonuses are not usually included.
How long do I need to keep holiday pay records?
From 6 April 2026, employers must keep detailed records of annual leave and holiday pay for at least 6 years from the date they were made. That includes things like the number of leave days taken and how much holiday pay was paid. You can choose how you keep them.
What should I do if I find a possible underpayment?
Mark it for review and check your workings first. If it still looks short, speak to your accountant, payroll provider or Acas before deciding what to do. This checklist helps you find issues; it is not legal advice.
General information about UK holiday pay, not legal advice. For a specific case, speak to Acas or your payroll provider.



