Xero guides

Does Xero calculate holiday pay on a 52-week average?

What Xero Payroll UK says it does with holiday pay, what it does not report on, and how to check a past holiday against the 52-week average by hand.

Updated 16 November 2026 · 10 min read · Sources checked against gov.uk and Acas

Xero says its UK payroll handles holiday pay calculations, including the 52-week average for irregular hours. What it does not give you is a report that checks each past holiday against the 52-week average and shows the workings. If you want to see whether a particular holiday was paid at the right rate, you have to rebuild the average yourself from Xero's payroll reports, or use a tool that does it for you.

Key points

  • Xero's UK guide on summer holiday pay says holiday pay calculations "including the 52-week average and rolled-up pay for irregular hours, are handled for you".
  • Xero has no report that lists each past holiday next to the 52-week average it should have been paid at.
  • A product idea asking for that report had 94 votes when we checked on 16 November 2026. Xero replied on 27 November 2025 that it is "not a feature we have planned".
  • Xero's suggested workaround is to run the Payroll Activity Summary or Gross to Net report over a 52-week period and work it out from there.
  • The rules come from gov.uk: average pay over the last 52 weeks in which pay was paid, counting back up to 104 weeks.
  • A hand check shows you where to look. Your accountant or Acas can help you decide what to do about it.

What Xero says it does with holiday pay

It is worth starting with what Xero itself says, because a lot of online advice either overstates or understates it.

Xero's UK guide on summer holiday pay says: "Holiday pay calculations, including the 52-week average and rolled-up pay for irregular hours, are handled for you". The same guide says "Xero brings payroll, leave and pay records together".

Xero's UK payroll features page says employees can use the Xero Me app to "access their own payslips and P60, submit timesheets and check leave balances", that staff can send leave requests, and that managers with the right access can approve leave requests. It also mentions a calendar view of "leave and holiday".

On the leave side, Xero's staff have said on its product ideas forum that each employee's leave balance can be seen on their payslips and on their leave tab in Xero Payroll.

So we are not saying Xero ignores holiday pay. It clearly deals with leave and holiday pay inside the pay run. Our point is narrower, and it is about checking.

What we could not confirm

We could not confirm Xero's help centre articles on UK holiday pay and leave from its public pages, so we have not described the exact settings, menus or calculation steps Xero uses inside a pay run. For example, we could not confirm from Xero's public pages how it handles the count back to 104 weeks, or a worker with less than 52 weeks of pay. If you need those details, check Xero's help centre or ask Xero support.

What Xero does not report on

Here is the gap. Say a bar worker on variable hours took a week off in March. You want to know:

  1. What were their average weekly earnings over the 52 paid weeks before that holiday?
  2. Which weeks were counted, and which zero-pay weeks were skipped?
  3. Was overtime or commission included?
  4. What did the payslip actually pay for that week of holiday?
  5. Is there a difference, and how big?

Xero does not have a report that answers those five questions for each holiday, for each worker. That is the report people have asked for on Xero's own forum.

The forum ideas and Xero's replies

Xero runs a public product ideas forum where users vote. Three ideas are directly relevant. Vote counts are as we saw them on 16 November 2026 and will change.

Idea on Xero's forumVotesXero's replyDate of reply
Run a report to calculate holiday pay based on a 52 week average94"not a feature we have planned"27 Nov 2025
UK Payroll: Leave Balances Report184"isn't on our immediate roadmap"27 Nov 2025
UK Payroll: Show forecasted leave balances94"not something we're planning to develop in the near term"11 Aug 2025

On the 52-week report idea, Xero marked the status as Accepted, which on that forum means it is on Xero's radar. It is not a promise to build it. In the same reply Xero said it had explored several options to automate holiday pay calculations, and suggested running "the Payroll Activity Summary or Gross to Net report over a 52 week period" as a workaround.

Earlier, in May 2024, Xero's community manager said the product team was looking into this area and was inviting users to test a prototype. The later reply in November 2025 is the most recent position we found.

The leave balances idea is covered in more depth in our guide to seeing all staff leave balances in Xero.

The rules you are checking against

Before you check anything, be clear on the rule. These points come from gov.uk.

  • For irregular-hours and part-year workers, holiday pay is the worker's average pay from the previous 52 weeks, only counting weeks in which they were paid.
  • If no pay was paid in a week, count back another week, so the rate is based on 52 weeks in which pay was paid. Count back no more than 104 weeks.
  • If a 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.
  • For irregular-hours and part-year workers, all leave must be paid at the normal rate of pay, for leave years starting on or after 1 April 2024.
  • For regular-hours workers, at least 4 weeks of the 5.6 weeks' statutory entitlement must be paid at the normal rate, and the remaining 1.6 weeks at a basic rate.
  • Normal pay includes commission, regular overtime, and payments linked to length of service or professional qualifications. It does not usually include bonuses.

Our guide to the 52-week average goes through each of these in more detail, including what counts as normal pay.

How to check a holiday payment by hand using Xero reports

This method follows the workaround Xero itself suggested. It takes time, so start with the workers most likely to be affected: people on variable hours, regular overtime or commission.

Step 1: Pick one holiday

Choose one period of holiday for one worker. Note the dates and the pay run it was paid in.

Step 2: Work out the 52-week window

Find the week the holiday started. Count back 52 weeks from the week before. That is your first window.

Step 3: Run a report over that window

Xero's suggestion is the Payroll Activity Summary or the Gross to Net report, run over the 52-week period. Run it for the one employee if you can.

We could not confirm from Xero's public pages exactly which columns each report shows or whether they break pay down week by week. If the report only gives you totals for the whole period, you will also need the individual payslips or pay run details to see which weeks had pay and which did not. Check Xero's help centre for the current layout of each report.

Step 4: Remove the weeks with no pay, and count back

List each week and the pay for it. Any week with no pay does not count. For each one you remove, add an earlier week, until you have 52 weeks in which pay was paid, or until you reach 104 weeks back.

If the worker has been with you for less than 52 weeks, use the full weeks they have worked.

If you pay monthly rather than weekly, turning monthly pay into weekly figures needs care. Check with Acas or your payroll provider on the right approach for your pay pattern.

Step 5: Add up the pay that counts

From the paid weeks, add up:

  • basic pay for hours worked
  • regular overtime
  • commission
  • payments for length of service or professional qualifications

Leave out bonuses unless you have been advised they should be included.

Step 6: Work out the weekly average

Divide the total by the number of paid weeks you used (52, or fewer for a newer worker). That is the average weekly pay.

Step 7: Compare with what was paid

Look at the payslip for the pay run that included the holiday. Compare the holiday pay shown with the weekly average multiplied by the number of weeks of holiday.

If the payslip shows less, mark it for review. Do not treat it as a confirmed underpayment yet. There may be a reason, such as a contract term, a different week pattern, or a payment you have classified differently.

Step 8: Keep your workings

Save the report, your list of weeks and your sums with the date you did the check. 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. Our holiday pay records guide explains what that covers.

For a worked example with numbers, and a routine you can run each month, see how to check holiday pay in Xero.

A quick comparison

TaskWhat Xero offers (from its public pages)What you do yourself
Record leave and include it in a pay runYes, Xero says holiday pay calculations are handled for youMake sure leave is entered correctly
See one employee's leave balanceLeave tab and payslips; Xero Me for employeesNothing extra
See every past holiday with its 52-week average and workingsNo report for thisRebuild the average from reports and payslips
Pull payroll totals over 52 weeksPayroll Activity Summary or Gross to Net, as Xero suggestsSplit into weeks, skip zero-pay weeks, count back
Keep a six-year record of each checkNot something we found on Xero's public pagesSave your workings somewhere safe

When to ask your accountant

A hand check is a good way to find where problems might be. It is not legal advice, and it does not decide what you owe. Speak to your accountant, payroll provider or Acas when:

  • your check shows a possible shortfall and you need to decide what to do about it
  • you are not sure whether a worker counts as irregular-hours or part-year
  • a worker gets payments you cannot easily classify, such as an allowance or a one-off payment
  • your bonuses are frequent enough that they might be regular
  • you have rolled-up holiday pay in place and are not sure it was set up correctly (Acas has guidance on rolled-up holiday pay)
  • the shortfall goes back several years, or affects a lot of staff

gov.uk's older guidance on workers without fixed hours also notes that where payments such as commission, bonuses and overtime are regular, they may need to be included, and that independent legal advice may be appropriate.

Common mistakes

  • Assuming "handled for you" means "checked for you". Xero says it handles the calculation in pay runs. That is different from having a report you can show someone that explains each holiday.
  • Counting 52 calendar weeks, including weeks with no pay. Zero-pay weeks are skipped and replaced with earlier weeks, up to 104 weeks back.
  • Leaving out regular overtime or commission. Both count towards normal pay according to gov.uk.
  • Including one-off bonuses. Bonuses are not usually included.
  • Treating every gap as an underpayment. A difference is a reason to look, not a conclusion. A person should decide.
  • Not saving the workings. Records of annual leave and holiday pay must now be kept for 6 years.
  • Relying on old forum posts. Xero's position on reports has changed over time. Look at the date of any reply you rely on.

Doing this for every worker

Checking one holiday by hand is manageable. Checking every holiday for every variable-hours worker each month is where it becomes a real job. You can try the sums for one worker with our free calculator.

If you want it done across your 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 for review with the workings, and keeps a dated six-year record. You can see how it works. A person still makes every decision.

Sources

Xero is a trademark of Xero Limited. This guide is general information, not legal advice.

Questions

Does Xero Payroll UK use the 52-week average for holiday pay?

Xero's own UK guide says holiday pay calculations, including the 52-week average and rolled-up pay for irregular hours, are handled for you. What Xero does not offer is a report that takes each past holiday and shows the 52-week average behind it with workings. If you want to see the numbers, you need to check them yourself or use another tool.

Is there a 52-week average holiday pay report in Xero?

Not that we could find when we checked on 16 November 2026. A product idea asking for one had 94 votes that day, and Xero replied on 27 November 2025 that it is not a feature they have planned. Xero suggested running the Payroll Activity Summary or Gross to Net report over a 52-week period instead.

How do I check a holiday payment in Xero by hand?

Run a payroll report covering the 52 weeks before the holiday, find the weeks in which the worker was paid, and add up the pay that counts towards normal pay. Divide by the number of paid weeks to get the weekly average, then compare that with what the payslip for the holiday shows. Keep a copy of your workings.

Which pay counts towards the 52-week average?

According to gov.uk, normal pay includes commission, regular overtime and payments linked to length of service or professional qualifications. It does not usually include bonuses. If you are unsure whether a particular payment counts, ask your accountant or Acas.

When should I ask my accountant?

Ask when you find a possible underpayment, when a worker has unusual pay such as irregular bonuses, when you are not sure whether someone is an irregular-hours worker, or when you need to decide how to put a shortfall right. A hand check tells you where to look. It does not replace professional advice.

General information about UK holiday pay, not legal advice. For a specific case, speak to Acas or your payroll provider.