National Bank of New Zealand File Specification

Outlined below is the file specification provided by the National Bank of New Zealand, with relevant notes added (in green) to demonstrate how it will work with the Greentree process:

You must have DirectLink installed on your internal system to download bank statement files direct from your bank's database. Several file types can be downloaded, however, the file used to input into your Greentree system for processing bank statements is the Transaction file, which contains all transactions that have been debited or credited to the selected account(s).

File Structure

Statement download files are in standard comma delimited format. All fields are separated by commas, and alphanumeric fields are delimited by double quotes. All records are separated by a carriage return/line feed character.

Transaction File Format

Each transaction file contains five different types of record:

Type 3 - Transaction record
Type 5 - Opening Balance record
Type 6 - Closing Balance record
Type 8 - Total debits/total credits record
Type 9 - Grand total debits/grand total credits record.

Transaction files may contain data on a number of individual accounts, as files are created per client, not per account.

The Transaction Record (Type 3) will convert to the Greentree Interface LINES section (fields highlighted in red indicate mandatory components required to support the Greentree interface process):

Field Number	Field Description	Field Format	Notes
1	Record Type	N(1)	'3
2	CMS ID	A(6)	Bank use only
3	Account Number	A(18)	The account number in 2-4-7-2 format, for example, 0605010123456 00 [bank-branch-account base-account suffix] Hyphens included. Surrounded by double quotes. Note: In Greentree, hyphens are stripped before running the process, so it does not matter if this number is entered against the bank account (CM Bank Account Maintenance) with or without hyphens.
4	Amount	A(17)	Transaction amount. Explicit decimal point. No '000 separators. Leading negative sign if the amount is a debit.
5	Serial Number	A(12)	The transaction serial number from the form MICR line (generally the cheque number).
6	Transaction Code	A(3)	The EDS (formerly Databank) transaction code. Values in the range 000-049 for debit transactions and 050-099 for credit transactions.
7	Particulars	A(12)	Particulars given to the transaction by its originator. If the Particulars field in the Originator side of the transaction was completed in DirectLink, it will appear here. MICR entries will report a unique number as all Banks move towards Item Image Processing. MICR includes non-electronic deposits, cheques and manual entries. Surrounded by double quotes.
8	Analysis Code	A(12)	Analysis code given to the transaction by its originator. If the Analysis Code field in the Originator side of the transaction was completed in DirectLink, it will appear here. Surrounded by double quotes.
9	Reference	A(12)	Reference given to the transaction by its originator. If the Reference field in the Originator side of the transaction was completed in DirectLink, it will appear here. Surrounded by double quotes.
10	Other Party	A(20)	The name of the other party to the transaction (if it is completed). The last 2 characters will be 'DL' if the transaction was a DirectLink batch. Surrounded by double quotes.
11	Transaction Date	A(8)	The date the transactions were processed through EDS (formerly Databank). DD/MM/YY or DD/MM/YYYY format. Surrounded by double quotes.
12	Originating Bank/Branch	A(7)	The bank & branch number of the originator of the transaction. BB-bbbb format (BB=bank number & bbbb = branch number). Surrounded by double quotes.

The Opening Balance Record (Type 5) will convert to the Greentree Interface HEADER section (fields highlighted in red indicate mandatory components required to support the Greentree interface process):

Field Number	Field Description	Field Format	Notes
1	Record Type	N(1)	'5
2	CMS ID	A(6)	Bank use only
3	Account Number	A(18)	The account number in 2-4-7-2 format, for example, 0605010123456 00 [bank-branch-account base-account suffix] Hyphens included. Surrounded by double quotes. Note: In Greentree, hyphens are stripped before running the process, so it does not matter if this number is entered against the bank account (CM Bank Account Maintenance) with or without hyphens.
4	Amount	A(17)	Opening balance amount. Explicit decimal point. No '000 separators. Leading negative sign if the amount is a debit.
5	Serial Number	A(12)	Blank
6	Transaction Code	A(3)	Blank
7	Particulars	A(12)	Always OPENING BALA
8	Analysis Code	A(12)	Blank
9	Reference	A(12)	Blank
10	Other Party	A(20)	Same as the account name from the Profile download file. Surrounded by double quotes.
11	Transaction Date	A(8)	The date the transactions were processed through EDS (formerly Databank). DD/MM/YY or DD/MM/YYYY format. Surrounded by double quotes.
12	Originating Bank/Branch	A(7)	Blank

The Closing Balance Record (Type 6) will convert to the Greentree Interface FOOTER section (fields highlighted in red indicate mandatory components required to support the Greentree interface process):

Field Number	Field Description	Field Format	Remarks
1	Record Type	N(1)	'6
2	CMS ID	A(6)	Bank use only
3	Account Number	A(18)	The account number in 2-4-7-2 format, for example, 0605010123456 00 [bank-branch-account base-account suffix] Hyphens included. Surrounded by double quotes. Note: In Greentree, hyphens are stripped before running the process, so it does not matter if this number is entered against the bank account (CM Bank Account Maintenance) with or without hyphens.
4	Amount	A(17)	Closing balance amount. Explicit decimal point. No '000 separators. Leading negative sign if the amount is a debit.
5	Serial Number	A(12)	Blank
6	Transaction Code	A(3)	Blank
7	Particulars	A(12)	Always CLOSING BALA
8	Analysis Code	A(12)	Blank
9	Reference	A(12)	Blank
10	Other Party	A(20)	Same as the account name from the Profile download file. Surrounded by double quotes.
11	Transaction Date	A(8)	The date the transactions were processed through EDS (formerly Databank). DD/MM/YY or DD/MM/YYYY format. Surrounded by double quotes.
12	Originating Bank/Branch	A(7)	Blank

The Total debits/total credits and Grand total debits/total credits records (Types 8 and 9) are not required to support the Greentree interface process, so they are not outlined here.