This is a standard CSV format file. The fields are as follows:
Account
Transaction Date
Description
Debt Value
Credit Value
There is no sort code to be imported as it is hard-coded in the program as 40-51-62.
The currency is hard-coded as GBP.
Cheques are identified as follows:
First 4 chars of Description must be “CHQ.”
Next 6 chars of the Description is the cheque number.
For example, a cheque with cheque number of 1078 would have Description of “CHQ.001078”.