This is a standard CSV format.
The first line is a header line, with the 4th field containing the date of the day’s transactions formatted as ‘CCYYMMDD’.
The second line is a column header line which is ignored.
All subsequent lines are detail lines with the following format:
Dummy field
Sort Code
Account Number
Dummy field
Value
CR/DR Identifier (If the CR/DR Identifier = “DR”, the value field is multiplied by -1)
Description
Cheque Number
Narrative