Bills - Batch payment report account number and sort code
When processing a batch payment report on Xero and exporting to excel to upload to the bank, separate the Account number and sort code - it currently processing them as one number omitting any zero's and this creates an incorrect bank account number, so makes the report useless.
Ruth Accounts
shared this idea
-
Fiona Mallion
commented
Has anyone got anywhere with this? Don't like having to manipulate the data downloaded before uploading csv to bank. Would prefer to have it come out of Xero as separate Sort Code and Account Number to begin with. Thank you
-
Ian Hurlstone
commented
Having to manually separate the sort code and account number from the 14-digit string is annoying and time-consuming. We have to enter the two elements into a new csv before importing into NatWest Bankline systems. Their systems do not allow for a single 14-digit string. Please can you urgently prepare a second export type for UK users of NatWest. I have spoken to NatWest support and they cannot offer any simple work-around.
Ian Hurlstone
24/02/2026 -
Jonathan Cross
commented
I agree Ruth. The CSV Xero produces is not compatible to our bank and makes the function of paying bills very time consuming.
The report needs the flexibility to be edited and saved as a template and produce fields in a set order to comply with the banks software.
