Batch Payment - File compatible with Lloyds CBO
Any chance we could get compatibility to upload batch payments to Lloyds Commercial banking online without having to manipulate the batch file outside of Xero before uploading.
-
Steve Boothroyd
commented
Adding my vote to this.
I can see there are also numerous other posts about valid export files for direct import to various banks (Santander, Barclays etc.).
My suggestion would be a simple TXT or DAT file export option which is in the exact format of the current exportable format for BAC but with the top 4 header rows omitted, and the bottom 4 trailing rows omitted (including the contra row). This would leave purely the payment lines and I suspect would be compatible with the import processes of most banking systems.
Currently we have a fudge which allows us to import the BAC file directly to Lloyds CBO without any manipulation or post processing but this results in errors being thrown every time we import (due to the trailing rows). Whilst this works, it is far from ideal, as when there is a genuine error it is unlikely to be spotted.
This would seem to be a relatively simple but highly impactful change for many of us.
-
Neethi Sankaranarayanan
commented
Just let you know instead of creating BACS on CSV if you create as BACS it worked !!
-
James Crisp
commented
Or just any lloyds system. The fact that Xero's batch export files don't work with Lloyds, of the UK's biggest banks, is bizarre. Please Xero!
-
Emma Hayden- West
commented
Needs to happen. I'm sure it can't be that difficult to create one. You shouldn't have to manually edit a file in this day and age.
-
Nichola Dorlin
commented
How did you get round this Maria?
-
Maria Deacon
commented
Any chance we could get compatibility to upload batch payments to Lloyds Commercial banking online without having to manipulate the batch file outside of Xero before uploading.
1
Voted!