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 -
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)
-
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!!
-
Charlotte Woodbridge
commented
I wonder which bank people are using who are having issues? I would agree that it is important to have this feature in xero, however I have managed to get around it.
I spoke to my bank (lloyds commercial banking) they helped me set up a template that works so I simply download bank payment file from xero (I have to delete a couple of lines from the bottom of the file but your banking support team will advise you on this - not all will have to do that) and it imports in fine, it literally takes seconds, and paying people is now the quickest part of my job!
Ideally xero will update this feature, but if they don't it may be worth taking matters into your own hands with your bank - as I have just read on here someone will have to manually pay 140 people and that is going to take an extremely long time, I would under no circumstances be doing that!Good luck, I hope you can get something sorted!
-
Sarah-Jane Martin
commented
I am soon going to have 140 employees to have to pay individually and we desperately need a fix on this to save time