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
-
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.
