NAB Connect Consolidated File Format Specification

1 NAB ConnectConsolidated File Format SpecificationsFebruary 20222 | NAB Connect Consolidated File Format SpecificationContents1. Introduction Document Purpose Important Notice 32. Account Information Functional Description Record Formatting Rules File Structure NAI file record types Examples NAI Codes and Descriptions 73. Direct entry (AUS) Functional Description BECS File Format Make the most of your Direct Entry File Example Direct Entry File Functional Description BECS file layout - Debits and or Credits 174.

2 DE returns report (dishonour) 175. BPAY reporting Functional Description BPAY Remittance Report BPAY Remittance File (BRF) BPAY Remittance Statement (BRS) 236. BPAY batch Functional Description BPAY Batch file Format BPAY Batch Results file Format Functional Description NAB EFTPOS (EB165) File Format 277. Merchant reporting NAB EFTPOS (FX165) File Format 308. International payment file Functional Description General Structure Character Set Currency List International Payment file 36 NAB Connect Consolidated File Format Specification | Document PurposeThis document describes the file formats currently supported by NAB Connect and should be used as a reference when integrating NAB Connect with customer Important NoticeThe NAB Connect Consolidated File Formats is the presentation of file formats for files and reporting that are currently supported by NAB use of the information contained in this document by

3 You is solely at Your risk. NAB is not responsible or liable for any loss or damage You may suffer in connection with the installation or attempted development of the file formats mentioned within this Account InformationLast updated: November Functional DescriptionThe account information files are based on the National Account Information (NAI) electronic data transmission files are comma delimited and do not contain fixed length fields. The Format identifies the start and end of the file being sent, the date, the account number and the type of each document provides:The NAI file Format Specification The NAI codes and descriptionsYou need this information if you want to import account information received electronically into another software application.

4 You should also refer to the instruction for that Record Formatting RulesEach record has the following attributes:1. All records are up to 80 characters in length including a terminating CRLF (carriage return/ line feed).2. Each record is identified by a 2-digit Record Type Code. This code is the first field in a Fields are free Format within Field delimiters are commas (,) or slashes (/). Slashes are only used as delimiters for the last field in a record; no delimiter is used where the last field is Fields not used are identified by adjacent delimiters6. An amount and its sign are included in the same field.

5 A sign is only used if the amount is negative and when used, trails the All amount fields include two decimal places but do not include the decimal point itself. Leading zeroes are not Any control totals in the account, group and file trailer records that are negative will have a leading Introduction4 | NAB Connect Consolidated File Format File Structure1. The logical file for each customer is bounded by an 01 and a 99 record. Each execution of this program will create a file for each eligible customer; where there are no relevant account records at the time of the run, the file will comprise only these two records.

6 The date in the 01 record is only the creation date and does not refer in any way to the value date of the data Within the file, a new group (bounded by an 02 and a 98 record) is used for each Originator/As - Of Date (see below) combination in the customer s data. As many groups as required may be used. There can be many different As-Of dates within one file. If a group contains identical Originator/As - Of date combination as supplied in a previous logical file any data for the same accounts will supersede the previous logical Within a group, a new account block (bounded by an 03 and a 49 record) is used for each different account.

7 As many blocks as required may be Transactions within an account block are ordered according to their transaction type, reference number, amount (descending) and sequence 88 records are generally used if the record exceeds 80 characters (including CRLF) when all fields are put to the record. In this case, a slash (/) must be put as the delimiter of the last field that will fit completely on the record, a new record started (an 88 record), and the data continued on the new record. This process may be repeated as necessary. In certain situations, an 88 record may be used when the previous line is less than 80 NAI file record typesRecordTy p e01 File header02 Group header03 Account identification and summary status16 Transaction detail49 Account trailer88 Continuation (optional)98 Group trailer99 File trailerRecord type 01 File HeaderThe first record in the file is the File typeAlways 01.

8 Sender identificationNot identificationNext recipient of file. For files provided by NAB Connect , this is always creation dateSystem date, Format creation timeSystem time, Format hhmm. Expressed in AEST using a 24-hour clock. For End- of-day (Main) files this will be 0000 .File sequence numberAlways record lengthNumber of characters in each : This includes the two-character Record type and the record delimiter (if any).Blocking factorNumber of physical records in a Connect Consolidated File Format Specification | 5 Record Type 02 - Group HeaderThe first record in each group of records is the Group header.

9 If follows either the File header record (record type 01 ) or a Group trailer record (record type 98 ).FieldDescriptionRecord typeAlways 02 .Ultimate receiver identificationAs for the Receiver identification field in the File header (record type 01 ) record. For files provided by NAB Connect , this is always identificationOriginator of file - for NAB, this is the bank ID, an 8-character alphanumeric field used by the NAB to identify banks. NAI uses the SWIFT code as this identifierGroup statusAlways 1 (original).As-of dateStatement date in Format timeFor the intraday file this is the time the file was last refreshed in Format hhmm.

10 For all other files it is always 0000 .Record Type 03 - Account identifier and summary statusThe first record for each account is the Account identifier and summary status record. It follows either a Group header (record type 02 ) or an Account trailer (record type 49 ) typeAlways 03 .Commercial account numberCustomer commercial account number at the bank of origin. For NAB, this is your bank account number. It excludes the BSB number for NAB domestic codeSWIFT currency codesThree-digit account summary code, refer account summary codes on page expressed with two implied decimal places and optional trailing sign.