Batch Payments - Export file in a Santander-compatible format
The repsonse to my support case was to be told to post the bug here... seems a weird request, but sure...
"The best way to get our product team to consider this would be to create a new product Idea on this, which is submitted to our product team who then go ahead and make changed based in priority."
The santander batch file does not follow the santander format. In the past Santander used to accept the file anyway but they have now started rejecting it.
Bills > Make Payment > Pay from (santander), Method = Create Payment File
Batch Payment > Export Batch File > "Santander Connect BACS payments"
A file is generated (date).TXT with content like this:
PAYMENT,HEADER,25112024,,1
PAYMENT,MULTIBACS,09066612345678,mysupplier,401904,12345678,214.60,25112024,paymentref
PAYMENT,TRAILER,,
The import fails on Santander with message: Invalid Record Total information.
Modifying the file to include the total value of all transactions and the number of transactions solves this problem. This file works:
PAYMENT,HEADER,25112024,,1
PAYMENT,MULTIBACS,09066612345678,mysupplier,401904,12345678,214.60,25112024,paymentref
PAYMENT,TRAILER,214.60,1
note after the trailer 214.60 = total and 1 = number of transaction lines in this file.
See also: I've attached the Santander specification for the file format. See page 3, reference to column C and Column D.
-
Don Wiid commented
I'm experiencing the same, after 9 years of it working. Fairly trivial change, but involves manual intervention and introduces the chance of errors.
Thanks for posting the solution and specification!