File Format changes have been updated in the file format guides
The following two changes apply to New Zealand Balance and Transaction Reporting:
- We’ve added new transaction codes and transactions descriptions to prepare our systems for the possibility that the Reserve Bank of New Zealand reduces the Official Cash Rate to zero or negative in 2021
- In response to your feedback to make it easier for you to identify international payments and same day cleared payments, we have changed the transaction description for these payments. Descriptions have changed from ‘TT’ to ‘SCP’ or ‘Inward IMT’ depending on the payment type.
If you use BAI file format, please see below for details of new transaction codes.
Please review the below changes to the file format you use and arrange to update your accounting or ERP systems with the new codes where applicable to ensure your systems are prepared. For an updated copy of the ANZ Transactive Global file formats, refer to Online Resources.
Table 1 – Summary of Changes
| File Format | Transaction Description | Narrative | Transaction Code | Aux Dom | Source Code | BAI Code | Credit Interest Rate |
|---|---|---|---|---|---|---|---|
| NZ Statement File |  |
|
|||||
| Statement File | |
|
|
|
|
||
| CSV | |
|
|
||||
| MT940 | |
|
|||||
| BAI2 | |
|
|
||||
| SAP / Multicash | |
|
|
|
International payment and same day cleared payment descriptions
Descriptions have changed from ‘TT’ to ‘SCP’ or ‘Inward IMT’ depending on the payment type. If you use the BAI file format, the new transaction codes are being added to the file you receive. Your BAI files will start including these new codes from 13 December 2020 - please contact your Technology/Finance team(s) to add the new codes for inward international payments and same day cleared payments.
Changes by File Format
NZ Statement File(s) – Transaction File
- New Transaction Codes in the Transaction Record: refer to Column C in Table 2
- New Source Code for inward International Payments in the Transaction Record: refer to Column E in Table 2
Statement Files
Changes to the Statement Transaction File:
- New Transaction Types in Field 8: refer to Column A in Table 2
- New descriptions included at the end of the Narrative field and new source code ‘IF’ at the beginning of the Narrative for International payments: refer to Column B in Table 2
- New Transaction codes in Field 14: refer to Column C in Table 2
- New Aux Dom’s for inward International Payments and SCP’s in the Transaction Record in Field 14: refer to Column D in Table 2
Changes to the Statement Balance File:
- Credit Interest rate in Field 14 if negative will have a negative symbol ‘-‘ e.g. -0.25
- Credit interest Accrued in Field 17 if negative will have a negative symbol ‘-‘ e.g. -10.00
CSV
Change to the Balance Summary CSV Report:
- Credit Interest rate if negative will have a negative symbol ‘-‘ e.g. -0.25
Changes to the CSV Account Statement:
- New descriptions in the Transaction Description Fields: refer to Column A in Table 2
- New descriptions included at the end of the Narrative field and new source code ‘IF’ at the beginning of the Narrative for International payments: refer to Column B in Table 2
MT940
- New Transaction Descriptions in Field 61 Supplementary Details: refer to Column A in Table 2
- New descriptions included at the end of the Transaction Narrative field in field 86 and new source code ‘IF’ at the beginning of the Narrative for International payments: refer to Column B in Table 2
BAI2
- New BAI codes in Field 2 of the Transaction Detail Record: refer to Column F in Table 2
- For Field 7 of the Transaction Detail Record new descriptions included at the end of the Narrative and new source code ‘IF’ at the beginning of the Narrative for International payments: refer to Column B in Table 2
SAP / Multicash
- New descriptions in Field 6 Note to Payee 1: refer to Column A in Table 2
- New descriptions included at the end of the Long Statement Narrative fields 18/ 23 and new source code ‘IF’ at the beginning of the Long Statement Narrative for International payments: refer to Column B in Table 2
- New Transaction codes used in Fields 34 and 35: refer to Column C in Table 2
- New Aux Dom’s for Inward International Payments and SCP’s used in Field 28: refer to Column D in Table 2
Table 2 – Descriptions and Code Changes
| (A)
Transaction Description |
(B)
Narrative |
(C)
Transaction Code |
(D)
Aux Dom |
(E)
Source Code |
(F)
BAI Code |
(G)
Explanation |
|---|---|---|---|---|---|---|
| NEG CR INT | NEG CR INT CHG NEGATIVE CREDIT INTEREST CHARGE | 00 (no change) |
654 | Negative credit interest is charged. | ||
| TSF INT | TSF NEG CR INT TRANSFER NEG CREDIT INTEREST | 220 | 654 | The negative credit interest charge is being transferred to another account. | ||
| INT REV | NEG CR INT REV NEGATIVE CREDIT INT REVERSAL | 270 | 354 (no change) |
Negative credit interest charge has been reversed. | ||
| TSF INT | TSF NEG CR INT TRANSFER NEG CREDIT INTEREST | 271 | 354 (no change) |
Negative credit interest charge has been transferred to another account (credit). | ||
| INT ADJ | NEG CR INT ADJ ADJUSTED NEGATIVE CREDIT INT CHARGE | 221 | 654 | Adjustment to negative credit interest. | ||
| NEG CR INT | SO NEG CR INT SETOFF NEGATIVE CREDIT INT CHARGE | 189 | 659 (no change) |
Negative credit interest is charged for setoff facility. | ||
| SO INT RV | SO NEG CR INT RV SETOFF NEGATIVE CREDIT INT REVERSAL | 190 | 359 (no change) |
Negative credit interest charge has been reversed for setoff facility. | ||
| SO INT ADJ | SO NEG CR INT ADJ ADJUSTED SETOFF NEG CREDIT INT CHG | 191 | 354 (no change) |
Adjustment to negative credit interest for setoff facility. | ||
| SCP | SCP CLEARED FUNDS SAME-DAY CLEARED PAYMENT | 62 (no change) |
5D | DC (no change) |
169 | SCP has been deposited. |
| INWARD IMT | IF INWARD IMT INWARD INTERNATIONAL PAYMENT | 62 (no change) |
5I | IF | 208 | International payment has been deposited. ‘IF’ will appear at the beginning of the Narrative Field. |