First Trust CSV BACS
The export file is compliant with CSV Standard 2 for Credit files only.
CSV Standard 2 (Credit Files Only)
Each record contains 5 fields (each separated by a comma)
Field 1 – Beneficiary NSC (NN-NN-NN with length 8 digits)
NSC is the bank sort code
Field 2 – Beneficiary Account Number ( Numeric with length 8 digits)
Field 3 – Beneficiary Name (Alphanumeric with max length 18 chars contained in parentheses)
Field 4 – Amount ( Numeric with format pounds.pence)
Field 5 – Beneficiary Reference (or Roll Number) (Alphanumeric with max length 18 chars contained in parentheses)
Field 6 – Spaces or empty field contained in 'quotes'
Examples:
"98-01-10","08312043","LINDA LENDRUM",239.12,"ddddddddref"," "
"93-86-25","05904053","L McCRISKEN",219.01,""," "
"93-80-17","62784048","SA & JE WYLIE",66.49,"salary 001"," "
"95-03-95","61143409","SARAH RACHEL McDONALD",147.01,""," "
"09-01-26","05533478","M. SMYTH",205.74,"",""