Xero - beautiful accounting software

Xero Business Community

Xero Business Community

Hi everyone, Come on over to the new discussions in Xero Central. It’s a more intuitive way to connect and chat all things business with one another. Ask questions, dish out answers, and get involved.

You can still view topics in the Xero Business Community to see all the useful knowledge that’s been shared there; and you can restart conversations you feel have been of huge value to you on Xero Central.

If you have brilliant ideas for innovations, you can keep on adding feature requests in the Xero Business Community, and voting on existing requests. There’s more in store, as we come up with the best way to take on your thoughts and share developments
Community > Payroll Feature Requests >

UK Payroll - Export RTI payroll file to Excel

Started by Bill Miller in Payroll Feature Requests | Idea

We have been using Xero Payroll since April 2015 and I need to use the information held in the RTI file (as submitted to HMRC, the UK tax authority) each month, in order to re-allocate salary costs (Net and Employer's) to separate budgeted departments, using an MJ.

At the moment we 'hack and slash' the RTI file to reduce it to a readable Excel file and then do the calculations.

It would be very handy (and less error-prone) if we could "Export RTI to Excel (cleaned-up)" from Payroll.

Would that be possible?
Many thanks,
Bill Miller
Official Xero Reply
It's been awhile since we've engaged in the convo here, so now in Jan 2021 just wanted to pop in with an update for you all. Currently, there's no plans to change the RTI file format in the foreseeable future. If this is a change you're keen on seeing, do add your support so we can feed this back to the team.

Depending on the info you're needing, you could have a look at the Payroll Activity Details report downloaded from a specific pay run or from the Reports tab (you can select a custom date range here).

Cassidy Hall (Community Manager)