WBCNZ - Westpac Corporate Online

This layout can be used for both manual payments and the standard Payrun when the Bank File Format on the Company Bank Details screen is set to PAY64, and Program Control PAY64 is set to WBCNZ.

The file is created in a Comma Separated Value (CSV) format, however it will have a .TXT extension on the file.

The file contains a Header record which defines the some information on the Company and the due date for the Detail records that follow.

Each Detail record represents an individual payment or direct debit containing both credit and debit details. The detail record can also contain other details to appear on the payee's/ payer's statement.

 

Header Record
Field Number Maximum # of Characters Character Type Field Name / Description Preceda Value
1 1 Alphanumeric Record Type Fixed value - "A"
2 6 Numeric Sequence Number Each record should have a unique sequence number for ease of identification.
3 2 Numeric Origin Bank First two characters of the BSB Number on the Company Bank Details record
4 4 Numeric Origin Branch 3rd to 6th character of the BSB Number on the Company Bank Details record
5 30 Alphanumeric Customer Name First 16 characters of the Company's Account Name on the Company Bank Details record
6 6 Numeric Customer Number Leave Blank
7 20 Alphanumeric Description Leave Blank
8 6 Numeric Due Date

Direct Credit Date on the EFT Processing or Process All Payments screen

  • Format = DDMMYY

9 105 Alphanumeric Spare Leave Blank

 

Detailed Transactional Record
Field Number Maximum # of Characters Character Type Field Name / Description Preceda Value
1 1 Numeric Record Type Fixed value - "D"
2 6 Numeric Sequence Number Each record should have a unique sequence number for ease of identification.
3 2 Numeric Bank First two characters of the BSB Number on the employee's Bank Details record
4 4 Numeric Branch 3rd to 6th character of the BSB Number on the employee's Bank Details record
5 8 Numeric Account Account Number on the employee's Bank Details record
6 4 Numeric Suffix Suffix on the employee's Bank Details record
7 2 Numeric Transaction Code

Transaction Code

  • '52' = Salary - Main Net Bank Account

  • '50' = General Credit - Bank Splits
8 2 Alphanumeric MTS Source

Fixed value - "DC" - Direct Credit

Denotes that the file is Direct Credit file and must be the same for all transactions in one file (whether transaction is a credit or debit)
9 15 Numeric Amount Amount of transaction (in cents) without a decimal point.
10 20 Alphanumeric Payee Name First 20 characters of the Account Name on the Employee's Bank Details record
11 12 Alphanumeric Payee Particulars

Reference Data or descriptive information relating to the transaction

Particulars from employee's Bank Details record
12 12 Alphanumeric Payee Analysis Code

Analysis Code or further descriptive information relating to the transaction

Code from employee's Bank Details record
13 12 Alphanumeric Payee Reference

Reference Code or further descriptive information relating to the transaction

Reference from employee's Bank Details record
14 2 Numeric Payee Bank First two characters of the BSB Number on the Company Bank Details record
15 4 Numeric Payer Branch 3rd to 6th character of the BSB Number on the Company Bank Details record
16 8 Numeric Payer Account First seven characters of the Account Number on the Company Bank Details record
17 4 Numeric Payer Suffix 8th and 9th characters of the Account Number on the Company Bank Details record
18 20 Alphanumeric Payer Name First 16 characters of the Company's Account Name on the Company Bank Details record
19 42 Alphanumeric Spare/ Filler Leave Blank