UK Payroll - Export payment file in CSV format
UK Payroll: Payment file csv format
Lloyds bank doesn't accept .txt format. It would be great if we could download a csv payment file to upload the employee pays to the bank.
Hi everyone, thanks for providing your thoughts on this idea. We appreciate you sharing how important a CSV payment file is, as some banks don't accept the BACS file.
You might have seen from a related idea that our product team is currently testing a new feature to allow direct wage payments from Xero payroll.
While this is not exactly what you’re suggesting, an integrated payment feature would defeat the need for manual payment file exports. We'll be back to share more updates on this.
-
Laura Brown
commented
Manually editing the current bank payment file to match our bank's required format creates a risk of errors. It would be much safer and convenient if we had to option to export the payment file in the correct format, with no need to edit the information.
-
Monica Gilbertson
commented
If it helps, after a lot of to-ing and fro-ing between Xero and Revolut, I now use Xero's BACS Payment file download but Upload it to Revolut as a 'Faster Payments' option with the date I want the payments to be made - as Revolut say they do not support 3 day BACS. This works and does not have to be done 3 days in advance.
Various people I spoke to at Revolut didn't t know the difference between the 2 methods so it was really trial and error.
We used to upload BACS file OK into Barclays.net with no problem -
Stephen Cowley
commented
It is now July 2025.
I'm having the same problem.
My bank says contact Xero, Xero says contact the bank.
Has it been resolved? -
Kellie Mansill
commented
Hi All, thanks for your votes. 3 years later and Xero still does not support exporting payment files in CSV format
-
John Ross and Son Solicitors Chism
commented
Hi all, Has there been any progress with the implementation of a CSV file format to export for payroll? We also recently moved providers without realising the incompatible issue of the bank upload file format.
I have added our vote for this product idea hoping there will be an update? Thanks, Sara -
Alan Seiden
commented
Yes, not only for UK banks. I don't think any bank would accept the current format with the routing and account joined in a single column. At least allow the routing and account numbers to be split into separate columns.
-
Francesca May
commented
Has the faster payment file issue been resolved i just moved our payroll from sage HR to Xero and i can only use the 3 day payment file not the faster payment file which is absolutely ridiculous!
-
Andrew Simcock
commented
Very disappointed to have been misled by advertising that says online that bank uploads are supported by Xero - naming banks that DO NOT SUPPORT the files.
This is an easy fix, please develop and act on this.
-
Arulraj Ganesh
commented
It is madness that Xero seem reluctant/unwilling to create a standard CSV file showing Employee name, Bank account info and Net pay? with that i believe ANY upload file could be subsequently created for submission to the majority of banking instituitions.
Payroll is a staple part of every business and it would be "common sense" for this to be already available rather than the current "standard 18 format" that all banks i work with do not recognise!
-
Mike Bacon
commented
We use NatWest Bankline and it is not compatible with Xero export from payroll. This is really inconvenient and surely something Xero should prioritise. Could they comment please (and hopefully advise an ETA)
-
Adam Lynch
commented
The ability to customise a CSV output for Batch Payments as different banks want it in different format
-
Cleo Mayhall
commented
I am using Xero payroll for the first time and am so disappointed that the bank file isnt compatible. I have moved from a really old system which did have options to create different file types. I thought Xero was going to save me time - obviously not! I agree with other users here that it must be a simple change to modify the options.
-
Sheila Roper
commented
I have recently moved banks to Barclays.net as the facility with them to upload payroll and supplier files is extremely efficient.
Until today I was not aware that Xero payroll did not export the files in the correct format.
I am really disappointed with this and may look to have to move our business accounts back to Sage. I agree with comments from other users that surely this is an minor adjustment to enable Xero to download in the correct format -
Iwona Andryszewska
commented
We have this same problem with Santander Bank. Xero format doesn't match their as well.
-
Katrina Culshaw
commented
Trying to load Xero payroll BACS file into RBS Bankline and it appears that the files coming out of Xero Payroll (BACS/Faster Payments) are not compatible with Bankline. Does Xero generate a CSV file that would be compatible?
Also most banks seem to be moving towards the industry standard of BACSTEL-IP file so surely Xero will be embracing this as I believe it is to be a worldwde standard format.
If you load in a BACS or faster Payments file it just encounters errors. I have uploaded a picture of this.
I am struglling to understand why there is not compatibility. Does Xero not have other clients that experience the same problem with uploading from Xero to Bankline?
RBS also mentioned that there is an option to pay direct to bankline a salary from Xero - I am struggling to find this functionality. Does this need to be activated? At the moment there only seems to be the bank feed from RBS.
Surely Xero is desIgned to be compatible as it is meant to take the pain out of pay roll which to the most part it does.
The whole idea regarding wanting to export a payroll file is to limit human error and time spent in entering the information into the bank?
-
Anne Benison
commented
UK Bank upload: Please can you sort out the Bacs/faster payment facility in Payroll? It needs to be compatible with UK Banks to avoid having to manually enter 80 payments into the bank.....please please!
-
Rachel Whiteman
commented
Extremely disappointed to find out you can't export the payment file in csv format. This is a huge time saving feature and one in which would have dissuaded us from transferring to Xero had we known before hand. This needs to be a priority in the product ideas.
-
Rebecca Rotheram
commented
As mentioned below its crazy that bills can be downloaded to CSV but payroll cannot. I therefore can upload my supplier bills into Barclays but I am struggling with payroll another manual task from using XERO.
-
Kirsty Connelly
commented
I am going to have over 300 colleagues to pay soon my bank says it needs a BACSTEL IP format i hope this is rolled out soon i believe they would accept a csv too....
-
Aisha Parpia
commented
Need this to download as a csv or excel. Currently using a copy and paste mechanism to create the bank upload. And then using Vlookups to bank details, it leaves so much space for error!!