Xero

Getting an annual leave report out of Xero Payroll UK

How to get an annual leave report from Xero Payroll UK: the Leave Requests report, what is missing, workarounds, and what a six-year holiday record needs.

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

Xero Payroll UK has a Leave Requests report that lists leave requested, approved and taken, for everyone or one employee. It does not have a UK Leave Balances report or a Leave Transactions report, and Xero has said neither is on its immediate roadmap. To get a full annual leave report, especially one that will serve as your six-year holiday record, you combine the Leave Requests report with each employee's leave tab and Xero's payroll reports.

Key points

  • Xero released the Leave Requests report in UK Payroll on 8 May 2024. It is in the Reports Centre for users with the Payroll Admin role.
  • Xero said it lists leave requested, approved and taken, for all employees or a single employee.
  • Xero said it "is not the equivalent of the Leave Balances report".
  • UK Leave Balances report: forum idea with 184 votes when we checked on 16 November 2026. Xero, 27 November 2025: "isn't on our immediate roadmap".
  • UK Leave Transactions report: forum idea with 78 votes when we checked on 16 November 2026. Xero, 27 November 2025: "not currently set in our roadmap".
  • Xero said balances can be viewed on individual payslips or each employee's leave tab.
  • From 6 April 2026, employers must keep detailed records of annual leave and holiday pay for at least 6 years.

What reports exist in Xero Payroll UK

Here is what we could confirm from Xero's public pages and forum on 16 November 2026.

WhereWhat it showsSource
Leave Requests reportLeave requested, approved and taken, all employees or oneXero forum reply, 8 May 2024
Employee leave tabOne employee's leave and balanceXero forum reply, 27 November 2025
PayslipsLeave balance at that pay dateXero forum reply, 27 November 2025
Xero MeEmployees check their own leave balances and submit requestsXero UK payroll features page
Payroll Activity Summary, Gross to NetPayroll totals over a period you chooseXero forum reply, 27 November 2025

Xero's UK features page also says you can "View a wide range of payroll reports to get valuable information on payroll activity, transactions, remuneration", and lists a calendar view that includes "leave and holiday".

The Leave Requests report

This is the closest thing to an annual leave report in Xero Payroll UK. When Xero announced it on 8 May 2024, its community manager said it lists leave requested, approved and taken, for all employees or a single employee, and that it is available from the Reports Centre to users with the Payroll Admin role.

What we could not confirm: the exact columns, whether it shows hours or days, the date filters, and the export formats. Check Xero's help centre for the current layout, and run it once for a short period to see what you get before relying on it for a full year.

What does not exist for UK

ReportStatus for UK Payroll (votes as of 16 November 2026)Xero's latest reply
Leave Balances reportNot available. Idea has 184 votes, status Accepted27 Nov 2025: "isn't on our immediate roadmap"
Leave Transactions reportNot available. Idea has 78 votes, status Accepted27 Nov 2025: "not currently set in our roadmap"
Forecasted leave balancesNot available. Idea has 94 votes, status Not in pipeline11 Aug 2025: "not something we're planning to develop in the near term"
Holiday pay against the 52-week averageNot available. Idea has 94 votes, status Accepted27 Nov 2025: "not a feature we have planned"

When Xero moved the 52-week idea to Accepted, it said this was "to show it's formally on our radar". It is not a promise to build it.

The Leave Balances idea itself says that report "is available in the AUS version of Xero". That is worth knowing because search results often bring up Australian help articles. If an article mentions a Leave Balances or Leave Transactions report, check which country's payroll it is for.

For more on balances specifically, see our Xero leave balance report guide.

What a good annual leave report should contain

From 6 April 2026, gov.uk says employers must keep detailed records of annual leave and holiday pay for a minimum of 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 the records. gov.uk also says employers may have to pay a fine if they cannot show they kept records.

Acas lists what to record:

  • holiday taken
  • holiday carried over from previous years
  • holiday pay, with details of what is included, such as bonuses or commission
  • any payments in lieu of holiday, such as paying for unused holiday when someone leaves

So a useful annual leave report, one that works as your record, covers both sides: the days and the money. Our holiday pay records guide explains the rule in more detail.

Suggested columns

ColumnWhyWhere to look
EmployeeWhoLeave Requests report or leave tab
Leave datesWhenLeave Requests report, if shown; otherwise the leave tab
Days or hours takenHow muchLeave Requests report, if shown; otherwise the leave tab
Leave typeAnnual leave or otherLeave Requests report, if shown; otherwise the leave tab
Pay run it was paid inLinks leave to payPayslips or pay run
Holiday pay paidHow muchPayslip
What the pay includedAcas asks for thisPayslip lines
Carried overAcas asks for thisYour own record or leave tab
Payment in lieuLeaversFinal payslip
Date the record was madeSix-year clockYou

Most of the first rows can usually be found somewhere in Xero, but check what the Leave Requests report actually shows in your account. The last few rows usually need your own notes.

Worked example: one employee's year

Here is how a year might look for one employee once the two sides are joined.

Leave datesDays takenPaid in pay runHoliday pay on payslip
13 to 17 April5April£550.00
6 to 7 August2August£220.00
21 to 23 December3December£330.00
Total10£1,100.00

The sums: 5 + 2 + 3 = 10 days, and £550.00 + £220.00 + £330.00 = £1,100.00. On a fixed £110 a day, 10 x £110 = £1,100.00, so the totals agree.

For staff on fixed pay that check is enough. For staff on variable pay it is not, because the right holiday pay for each period depends on the 52-week average before it. Our 52-week average guide explains that check.

Workarounds

1. Leave Requests report plus payroll reports

  1. Run the Leave Requests report for the period, for all employees.
  2. Run the Payroll Activity Summary or Gross to Net report for the same period. Xero suggested these on 27 November 2025, in reply to the 52-week idea.
  3. Join the two in a spreadsheet by employee and pay run.
  4. Add carried-over days and any payments in lieu from your own notes.
  5. Save it with the date.

This gives you the days and the pay together. It takes time, and the join is where mistakes creep in.

2. Leave tab, employee by employee

For balances, open each employee's leave tab and note the figure and the date. This is the method Xero itself points to. It is fine for five staff. It becomes slow for fifty.

3. Payslips as the record

Each payslip shows the balance at that date. Keeping payslips is part of a record, but on its own a pile of payslips does not show leave taken by date in one place.

4. A connected app

Some apps connect to Xero Payroll and build the report for you from the same data. If you use one, check it has read-only access and that you can export the result, so the record stays yours.

Checking the joined report against a payslip

Once you have joined the leave and pay reports, test the join before you trust it. Pick three rows at random, ideally one for a full-time worker, one for a part-timer and one for someone with variable pay. For each row:

  1. Open the payslip for the pay run you matched it to.
  2. Check the leave dates fall inside that pay period.
  3. Check the holiday pay on the payslip matches the figure in your report.
  4. Check the balance on the payslip is what you would expect after that leave.
  5. Note any row where the figures do not agree, and why.

If two or three rows are wrong, the join is probably wrong, not the payroll. Common causes are leave that crosses two pay periods, leave entered after the pay run closed, and a mix of hours and days between the two reports. Fix the join and test again before you save the report as your record.

How often to run it

  • Monthly, after the pay run, so any gap is found while it is fresh.
  • At the end of each leave year, before balances reset or carry over.
  • When someone leaves, so the payment in lieu is in the record.
  • When you change a setting, such as the leave year or a holiday group, so you have a before and after.

Common mistakes

  • Following an Australian help article. Leave Balances and Leave Transactions reports exist in Australian payroll, not UK.
  • Treating the Leave Requests report as a balances report. Xero says it is not the equivalent.
  • Keeping only the days. Acas lists holiday pay and payments in lieu as part of the record.
  • Not recording what holiday pay included. Acas asks for details such as bonuses or commission.
  • No date on the record. The six years run from the date the record was made.
  • Relying on old forum replies. Xero's position has changed over time. Check the date of any reply.
  • Leaving it to year end. A year of joining reports by hand is much harder than a month.

Checking the pay side

Holiday Pay Check connects to Xero Payroll with read-only access, reads employees, pay runs, payslips and leave, checks each holiday taken against the 52-week average with the workings, and keeps a dated six-year record per employee. You can see pricing or try the free calculator on one holiday first.

Sources

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

Questions

Is there an annual leave report in Xero Payroll UK?

There is a Leave Requests report, released in UK Payroll on 8 May 2024. Xero said it lists leave requested, approved and taken, for all employees or one employee, and is available from the Reports Centre to users with the Payroll Admin role. Xero also said it is not the equivalent of a Leave Balances report.

Can I run a Leave Balances report in Xero UK?

Not when we checked on 16 November 2026. A forum idea asking for one had 184 votes, and Xero said on 27 November 2025 that it isn't on the immediate roadmap. Xero said balances can be viewed on individual payslips or each employee's leave tab.

Is there a Leave Transactions report in Xero UK?

Not when we checked on 16 November 2026. A forum idea asking for a UK Leave Transactions report had 78 votes, and Xero replied on 27 November 2025 that it is not currently set in the roadmap. Help articles you may find for a Leave Transactions report are for Australian payroll.

What should an annual leave record include?

Acas lists holiday taken, holiday carried over from previous years, holiday pay, and any payments in lieu of holiday. For holiday pay, Acas says to give details of what is included, such as bonuses or commission. From 6 April 2026 these records must be kept for at least 6 years.

How do I see holiday pay alongside leave taken in Xero?

The Leave Requests report covers the leave. For the pay, Xero has suggested running the Payroll Activity Summary or Gross to Net report over the period you need. You then join the two yourself, by employee and date.

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