The standard import format that is utilized in ABR is defined below. It consists of two header rows, which are not utilized by the ABR import process. These rows are reserved for comments or notations.
Additional rows after the two headers are data lines. Each data line contains the following fields (in the sequence given):
• Group
• Account ID
• Account Number
• Type
• Sort Code
• Currency
• Entry Date
• As At
• Amount
• TLA Code
• Cheque Number
• Status
• Description
Of the fields provided, the following fields are not utilized by Advanced Bank Reconciliation:
• Group
• Account ID
• Type
• Currency
• As At
• Status
The ‘TLA Code’ field is used to identify the transaction type, as shown in the table on the following page.
Transaction ‘TLA’ Codes:
The file format is summarized in the following table:
