End of Day BTR - Summary of file changes – ANZ Digital Services Help

As part of the simplification programme, we are building solutions where most of the functions of the service remain the same as now. However, the End of Day Balance and Transaction Reporting (EOD BTR) files will not deliver a like for like service.

Change Summary

There are several changes that will impact all customers using the EOD BTR service.

ANZ File Format specifications

All the files that ANZ receive and send from our customers are guided by publicly available file format specifications. These are the specifications that ANZ is using as a baseline for all our analysis and presenting the changes to the services.
Please refer to the ANZ Host to Host File Format document for a full list of file specifications - Section 9 BTR File Formats (ANZ Transactive):
ANZ Fileactive Host-to-Host File Formats.

EOD BTR - File Types

FILE TYPE	FILES SENT	CHANGES WITHIN THE FILE
CSV	Balance File	Body only
CSV	Transaction File	Body only
SAPGEN	Balance File	Body only
SAPGEN	Transaction File	Body only
SINBTR	Balance & Transaction File	Header Record Record Type 00—known as File Header Body – Three record types Record Type 10—known as Account Header Record Type 15—known as Transaction Record Record Type 50—known as Account Trailer Record Trailer Record Record Type 99—known as File Trailer Record

CSV Files

CSV File Structure

The CSV File format consists of two separate files: a balance file that contains balance records for all accounts, and a transaction file that contains transaction records for accounts. To successfully import the new CSV file format, you will need to account for the following changes. The EOD BTR has the following file structures:

If you refer to the File Structure diagram above, you will note only changes in the Body in the Balance and Transaction files.

CSV File Change Details

CSV - AUD Account Change Details

Balance File

The following table describes the change to the Account name field.

FIELD	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	MAX SIZE	NATURE OF CHANGE
5	Account Name Name of account registered with ANZ	Alpha	Optional	16	Different naming convention – the name will now be the Account title.

Transaction File

The following table describes the change to the Account name field, Short description of transaction, Reference, Narrative and Trace ID.

FIELD	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	MAX SIZE	NATURE OF CHANGE
5	Account Name Name of account registered with ANZ	Alpha	Optional	16	Different naming convention – the name will now be the Account title.
8	Short Description of transaction E.g., Cheque, Payment, Transfer, etc.	Alpha	Mandatory	10	Transaction Types - please refer to End of Day BTR - Technical Details for a detailed list of changes.
9	Reference E.g., Cheque Number, Invoice Number etc.	Alpha	Optional	18	Additional details improve the reconciliation of individual items.
11	Narrative 160 character narrative	Alpha	Optional	160	Additional details improve the reconciliation of individual items.
13	Trace Id ANZ Internal trace line	Alpha	Mandatory	16	The information will vary in length.

CSV - Foreign Currency Account Change Details

ANZ will now send your Foreign Currency Account Balance and Transaction files separately, as such ANZ will need to confirm if your organisation is able to receive multiple files a day and confirm the naming conventions.

Balance File

The following table describes the change to the Account name field.

FIELD	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	MAX SIZE	NATURE OF CHANGE
5	Account Name Name of account registered with ANZ	Alpha	Optional	16	Different naming convention – the name will now be the Account title.

Transaction File

The following table describes the change to the Account name field, Short description of transaction, Reference, and Narrative.

FIELD	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	MAX SIZE	NATURE OF CHANGE
5	Account Name Name of account registered with ANZ	Alpha	Optional	16	Different naming convention – the name will now be the Account title.
8	Short Description of transaction E.g., Cheque, Payment, Transfer, etc.	Alpha	Mandatory	10	Currently the Transaction Types are either DEBIT or CREDIT. New Transaction Types - Please refer to End of Day BTR - Technical Details Transaction Code to BAI Code Mapping section 23.2
9	Reference E.g., Cheque Number, Invoice Number etc.	Alpha	Optional	18	The field is currently blank. Additional details improve the reconciliation of individual items.
11	Narrative 160 character narrative	Alpha	Optional	160	Additional details improve the reconciliation of individual items.

SAPGEN Files

SAPGEN File Structure

The SAP/Multi-cash File format consists of two separate files: a balance file that contains balance records for all accounts and a transaction file that contains transaction records for accounts. To successfully import the new SAP/Multi-cash file format you will need to account for the following changes. The EOD BTR has the following file structures:

If you refer to the File Structure diagram above, you will note only changes in the Body in the Balance and Transaction files.

SAPGEN Change Details

SAPGEN - AUD Account Change Details

Balance File

The following table describes the change to the Statement Number and Account name field.

FIELD	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	MAX SIZE	NATURE OF CHANGE
3	Statement Number Consecutive number starting with 1 and reset at the start of a new year.	Numeric	Mandatory	5	Continuation statement number from the legacy system.
10	Account Name Name of account registered with ANZ	Alpha	Mandatory	16	AU Domestic Accounts: Account Short Name now populated.

Transaction File

The following table describes the changes to the Statement Number, Note to Payee1/Transaction Type, Cheque Number/Note to Payee 2, Note to Payee 3-8 and Note to Payee 14.

FIELD	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	MAX SIZE	NATURE OF CHANGE
3	Statement Number Consecutive number starting with 1 and reset at the start of a new year	Numeric	Optional	5	Continuation statement number from the legacy system.
6	Note to Payee 1 Transaction Type.	Alpha	Optional	27	Transaction Types - please refer to Appendix A for a detailed list of changes.
10	Cheque Number\Note to Payee 2 If the transaction relates to a cheque the field will contain the Cheque Number. Leading zeroes are not included in the cheque number. For all other transaction types this field contains the 1st 16 characters of the Note to Payee 2 field.	Alpha / Numeric	Optional	16	Additional details that will improve the reconciliation of individual items. Different Transaction Types if this field are not populated with a Cheque Number.
17	Note to Payee 2 18 character reference	Alpha	Optional	27	Additional details that will improve the reconciliation of individual items.
18 - 23	Note to Payee 3-8	Alpha	Optional	160	Note to Payee 3 through to Note to Payee 8 – Additional details that will improve the reconciliation of individual items.
29	Note to Payee 14 Trace ID of the transaction	Alpha	Optional	27	Note to Payee 14 – Trace ID – The information will vary in length.

SAPGEN - Foreign Currency Account Change Details

Balance File

The following table describes the change to the Statement Number and Account name field.

FIELD	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	MAX SIZE	NATURE OF CHANGE
3	Statement Number Consecutive number starting with 1 and reset at the start of a new year.	Numeric	Mandatory	5	Continuation statement number from the legacy system.
10	Account Name Name of account registered with ANZ.	Alpha	Optional	16	AUD Foreign Currency Accounts: Full Account Name now populated. FCA Accounts offshore: Account Name no longer populated.

Transaction File

The following table describes the changes to the Bank Code, Statement Number, Note to Payee1/Transaction Type, Cheque Number/Note to Payee 2, Note to Payee 2 and Note to Payee 3-8.

FIELD	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	MAX SIZE	NATURE OF CHANGE
3	Statement Number Consecutive number starting with 1 and reset at the start of a new year	Numeric	Optional	5	Continuation statement number from the legacy system.
6	Note to Payee 1 Transaction Type.	Alpha	Optional	27	Transaction Types - Please refer to End of Day BTR - Technical Details Transaction Code to BAI Code Mapping section 23.2
10	Cheque Number\Note to Payee 2 If the transaction relates to a cheque the field will contain the Cheque Number. Leading zeroes are not included in the cheque number. For all other transaction types this field contains the 1st 16 characters of the Note to Payee 2 field.	Alpha / Numeric	Optional	16	Additional details improve the reconciliation of individual items. Different Transaction Types if this field are not populated with a Cheque Number.
17	Note to Payee 2 18 character reference	Alpha	Optional	27	Additional details improve the reconciliation of individual items.
18 - 23	Note to Payee 3-8	Alpha	Optional	160	Note to Payee 3 through to Note to Payee 8 – Additional details improve the reconciliation of individual items.

SINBTR Files

SINBTR File Structure

The BTR Singlefile consists of one file, containing the following record types:

File Header
Account Header
Transaction Record
Account Trailer Record
File Trailer Record

To successfully import the new SINBTR file format you will need to account for the following changes.
The SINBTR file has the following file structure:

If you refer to the File Structure diagram above, you will note only changes in the Body of the file.

SINBTR Change Details

SINBTR - AUD Account detailed changes

Account Record (Record Type 10)

The following table describes the change to the Statement Number and Account Name.

FIELD NAME	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	SIZE	POSITION	NATURE OF CHANGE
Statement Number	First 4 bytes of the Statement Number	Numeric	Mandatory	4	50 – 53	Continuation statement number from the legacy system.
Account Name	First 16 Characters of the Account Name	Alpha / Numeric	Mandatory	16	54 - 69	Different naming convention – the name will now be the Account title.

Transaction Record (Record Type 15)

The following table describes the changes to the Tran Type, Reference, Narrative, Aux Dom, EX Aux Dom and BAI Code.

FIELD NAME	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	SIZE	POSITION	NATURE OF CHANGE
Tran Type	Transaction type	Alpha	Mandatory	10	14 - 23	Please refer to End of Day BTR - Technical Details Transaction Code to BAI Code Mapping section 23.2
Reference	Transaction reference	Alpha	Optional	18	24 – 41	Additional details improve the reconciliation of individual items.
Narrative	Transaction narrative	Alpha / Numeric	Optional	160	58 – 217	Additional details improve the reconciliation of individual items.
Aux Dom	Aux_Dom	Alpha	Optional	10	245 – 254	Legacy system fills the blank spaces in between each of the fields specified with zeros, whereas now it will be blank.
EX Aux Dom	Ex_Aux_Dom	Alpha	Optional	10	255 – 264	Legacy system fills the blank spaces in between each of the fields specified with zeros, whereas now it will be blank.
BAI Code	From Translation	Numeric	Mandatory	3	255 – 264	Please refer to End of Day BTR - Technical Details Transaction Code to BAI Code Mapping section 23.2

SINBTR - Foreign Currency Account detailed changes

Account Record (Record Type 10)

The following table describes the changes to the Statement Number and Account Name.

FIELD NAME	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	SIZE	POSITION	NATURE OF CHANGE
Statement Number	First 4 bytes of the Statement Number	Numeric	Mandatory	4	50 – 53	Continuation statement number from the legacy system.
Account Name	First 16 Characters of the Account Name	Alpha / Numeric	Mandatory	16	54 - 69	Different naming convention – the name will now be the Account title.

Transaction Record (Record Type 15)

The following table describes the changes to the Tran Type, Reference, Narrative, Aux Dom, EX Aux Dom and BAI Code.

FIELD NAME	DESCRIPTION	ALPHA/ NUMERIC	MANDATORY/ OPTIONAL	SIZE	POSITION	NATURE OF CHANGE
Tran Type	Transaction type	Alpha	Mandatory	10	14 - 23	Please refer to End of Day BTR - Technical Details Transaction Code to BAI Code Mapping section 23.2
Reference	Transaction reference	Alpha	Optional	18	24 – 41	Additional details improve the reconciliation of individual items.
Narrative	Transaction narrative	Alpha / Numeric	Optional	160	58 – 217	Additional details improve the reconciliation of individual items.
Aux Dom	Aux_Dom	Alpha	Optional	10	245 – 254	Legacy system fills the blank spaces in between each of the fields specified with zeros, whereas now it will be blank.
EX Aux Dom	Ex_Aux_Dom	Alpha	Optional	10	255 – 264	Legacy system fills the blank spaces in between each of the fields specified with zeros, whereas now it will be blank.
BAI Code	From Translation	Numeric	Mandatory	3	255 – 264	Please refer to End of Day BTR - Technical Details Transaction Code to BAI Code Mapping section 23.2