CONTENTS
1 INTRODUCTION .................................................................................................... 4
1.1 About this guide................................................................................................................................. 4
1.2 Scope ............................................................................................................................................... 4
1.3 Online Help ....................................................................................................................................... 4
1.4 Online Resources ............................................................................................................................... 4
1.5 Further Assistance.............................................................................................................................. 4
1.6 File Formats Overview (Payables) ........................................................................................................ 5
2 AU DOMESTIC PAYMENTS FILE FORMATS ................................................................. 6
2.1 ABA File Format ................................................................................................................................. 6
2.1.1 Import Methods ........................................................................................................................... 6
2.1.2 ABA File Layout and Character Set ................................................................................................. 6
2.1.3 Descriptive record (0) .................................................................................................................. 7
2.1.4 Detail record (1) .......................................................................................................................... 7
2.1.5 Batch Control Record (7) .............................................................................................................. 9
2.2 AU Domestic Payments CSV Detail Import ............................................................................................ 10
2.2.1 CSV File Layout and Character Set ................................................................................................ 10
2.2.2 Detail Record ............................................................................................................................. 10
3 NZ DOMESTIC PAYMENTS FILE FORMATS ............................................................... 11
3.1 NZ Domestic Payment CSV (Full File Import) ........................................................................................ 11
3.1.1 File Layout and Character Set ....................................................................................................... 11
3.1.2 Descriptive Record ...................................................................................................................... 11
3.1.3 Detail Record ............................................................................................................................. 12
3.1.4 Batch Control Record................................................................................................................... 13
3.2 NZ Domestic Payments CSV Detail Import (with Control Record) ............................................................ 14
3.2.1 File Layout and Character Set ....................................................................................................... 14
3.2.2 Descriptive Record ...................................................................................................................... 14
3.2.3 Detail Record ............................................................................................................................. 14
3.2.4 Batch Control Record................................................................................................................... 15
3.3 NZ Domestic Payments CSV Detail Import (without Control Record) ........................................................ 16
3.3.1 File Layout and Character Set ....................................................................................................... 16
3.3.2 Detail Record ............................................................................................................................. 16
4 SINGLE PAYMENTS FILE FORMATS ......................................................................... 17
4.1 MT101 File Format (Australia & New Zealand)....................................................................................... 17
4.1.1 File Naming Convention ............................................................................................................... 17
4.1.2 MT101 File Layout and Character Set ............................................................................................ 17
4.1.3 Character Set ............................................................................................................................. 17
4.1.4 Sequence A – General Information ................................................................................................ 18
4.1.5 Sequence B – Transaction Detail Record ........................................................................................ 19
4.1.6 Clearing System Codes ................................................................................................................ 21
4.2 WIRS file format (Australia only) ......................................................................................................... 22
4.2.1 File Naming Convention ............................................................................................................... 22
4.2.2 WIRS File Layout and Character Set .............................................................................................. 22
4.2.3 Character Set ............................................................................................................................. 22
4.2.4 Detail Record ............................................................................................................................. 23
4.2.5 Miscellaneous Field Format Specifications ...................................................................................... 24
4.2.6 Account with Institution Country ISO Code..................................................................................... 24
4.2.7 Conditional field rules: ................................................................................................................. 24
4.3 NZ International Payment CSV file format (New Zealand only) ................................................................ 25
4.3.1 File Naming Convention ............................................................................................................... 25
4.3.2 NZ International CSV File Layout and Character Set ........................................................................ 25
4.4 BPAY File format (Australia only) ......................................................................................................... 28
4.4.1 BPAY File Layout and Character Set .............................................................................................. 28
4.4.2 File Header Record ...................................................................................................................... 28
4.4.3 Payment Instruction Record ......................................................................................................... 29
4.4.4 File Trailer Record ....................................................................................................................... 30
5 BTR AND RETURNED ITEMS FILE FORMATS ............................................................ 31
5.1 BAI File ............................................................................................................................................ 31
5.1.1 Reserved Characters ................................................................................................................... 31
5.1.2 BAI File Layout ........................................................................................................................... 31
5.1.3 File Header Record ...................................................................................................................... 32
5.1.4 Group Header Record .................................................................................................................. 32
5.1.5 Account Identifier and Summary Status Record (03) ....................................................................... 33
5.1.6 Transaction Detail Record (16) ..................................................................................................... 34
5.1.7 Continuation Record (88) ............................................................................................................. 35
5.1.8 Account Trailer Record (49) ......................................................................................................... 35
5.1.9 Group Trailer Record (98) ............................................................................................................ 36
5.1.10 File Trailer Record (99) ............................................................................................................. 36
5.2 Statement Files................................................................................................................................. 37
5.2.1 Statement Balance File Format ..................................................................................................... 37
2