Admin, Bank Accounts, Import Service, File Formats

Service Type (NZ)

WBC Corporate Online CSV

Sample File

TRANSACTION DATE,ACCOUNT NUMBER,ACCOUNT NAME,CCY,CLOSING BALANCE,AMOUNT,TRANSACTION CODE,NARRATIVE,SERIAL

20130821,032515285179,"Clients Receipts",AUD,+15674.40,-340.00,209,"DIRECT DEBIT RETURNED 200813 LODGEMENT REF 12350 ANSWER 6 ",0200813

20130821,032515285179,"Clients Receipts",AUD,+15674.40,-50.00,209,"DIRECT DEBIT RETURNED 200813 LODGEMENT REF 11555 ANSWER 6 ",0200813

20130821,032515285179,"Clients Receipts",AUD,+15674.40,-257.30,209,"DIRECT DEBIT RETURNED 210813 LODGEMENT REF 13466 ANSWER 6 ",0210813

20130821,032515285179,"Clients Receipts",AUD,+15674.40,-152.00,209,"DIRECT DEBIT RETURNED 210813 LODGEMENT REF 12439 ANSWER 6 ",0210813

20130821,032515285179,"Clients Receipts",AUD,+15674.40,+68.94,262,"DEPOSIT DE DRAW DECRBAL DE DRAW ID456167 AUSTRALIANPREMIERFINANCEP",DECRBAL

20130821,032515285179,"Clients Receipts",AUD,+15674.40,+10778.49,262,"DEPOSIT DE DRAW DECRBAL DE DRAW ID456167 AUSTRALIANPREMIERFINANCEP",DECRBAL

BPAY

Details Record

FieldField NameLengthFormatComments
1Customer Reference Number20 ANThe number by which the Biller identifies the account that is being paid.
2Payment Instruction Type2NA code indicating the type of instruction: 05 = Payment, 15 = Error Correction and 25 = Reversal.
3Amount12 NThe date of the Payment or Error Correction, 2 digits of cents implied.
4Date of Payment8 NThe date that the Payment or Error Correction was accepted by the Payer Institution, in DD/MM/YY format.
5Time of Payment8 NThe time that the Payment or Error Correction was accepted by the Payer Institution, in HH:MM:SS format.
6Payment Method3 N

A code indicating the method of Payment: 001 = Debit Account, 101 = Visa, 201 = MasterCard and 301 = Other Credit Card.

7Transaction Receipt Number21ANThe receipt number provided to the customer on successful completion of a payment.

Example of the above

546309,05,1.00,03/07/06,22:18:39,001,BBL200607030010712478

546317,05,32.00,03/07/06,22:19:16,001,ANZ20060703477748

533666,25,20.00,03/07/06,22:20:03,201,STG2006070322335