ABAFILE EFT Output Format
For full details of the ABAFILE format, contact the Australian Bankers Association. The following tables show field size and justification.
ANZ,NAB, and WBC all use the standard ABA file format. These banks use transaction code 50 or 13 depending on if the payment is a debit or credit.
ABAFILE (ANZ, NAB, WBC)
Standard Record Type 0
| Name | Starting Position | Length | Value or Notes |
|---|---|---|---|
| Record Type 0 | 1 | 1 | 0 |
| Blank | 2 | 17 | Must be blank-filled |
| Reel Sequence Number | 19 | 2 | 01 |
| User Financial Institution | 21 | 3 | bank_addr_mst.bank_code
Must be an approved financial institution abbreviation |
| Blank | 24 | 7 | Must be blank-filled |
| User preferred name of user supplying file | 31 | 26 | apparms_mst.EFT_user_name
Must not be all blanks |
| User Identification Number of user supplying file | 57 | 6 | apparms_mst.EFT_user_number
Must be User Identification Number assigned by APCA and User Financial Institutions. Must be numeric. Right justified. Zero filled |
| Description of file contents | 63 | 12 | "VENDOR PMT" |
| Date to be processed | 75 | 6 | Today()
The date when transactions are released to all financial institutions |
| Blank | 81 | 40 | Must be blank-filled. |
Standard Record Type 1
| Name | Starting Position | Length | Value or Notes |
|---|---|---|---|
| Record Type 1 | 1 | 1 | 1 |
| BSB Number | 2 | 7 | vendor_mst.EFT_bank_num
Format ###-### |
| Account number | 9 | 9 | vendor_mst.account |
| Indicator | 18 | 1 | blank |
| Transaction Code | 19 | 2 | 13 or 50 |
| Amount | 21 | 10 | glbank_mst.check_amt |
| Title of Account | 31 | 32 | parms_mst.company |
| Reference | 63 | 18 | glbank_mst.ref_num+'-'+glbank_mst.check_num |
| BSB Number | 81 | 7 | bank_addr_mst.bank_number
Format ###-### |
| AccountNumber | 88 | 9 | bank_hdr_mst.branch_code |
| Name of Remitter | 97 | 16 | parms_mst.company |
| Amount of withholding Tax | 113 | 8 | 00000000 |
ABAFILE (HSBC, Bankwest)
These banks use the records above, but in addition to those standard records, they request one last record of Type 1 (Transaction Code = 13) that totals all the payments into one credit record with the format shown here:
| Name | Starting Position | Length | Value or Notes |
|---|---|---|---|
| Record Type 1 | 1 | 1 | 1 |
| BSB Number | 2 | 7 | bank_addr_mst.bank_number
Format ###-### |
| Account number | 9 | 9 | bank_hdr_mst.branch_code |
| Indicator | 18 | 1 | blank |
| Transaction Code | 19 | 2 | 13 |
| Amount | 21 | 10 | dbl_NegativeAmtTotal |
| Title of Account | 31 | 32 | parms_mst.company |
| Reference | 63 | 18 | "Creditor Payments" |
| BSB Number | 81 | 7 | bank_addr_mst.bank_number
Format ###-### |
| AccountNumber | 88 | 9 | bank_hdr_mst.branch_code |
| Name of Remitter | 97 | 16 | parms_mst.company |
| Amount of withholding Tax | 113 | 8 | 00000000 |
ABAFILE (CBA)
This bank uses the standard formats shows above, but it requires two records for each transaction (Transaction Code = 50 followed by this one with Transaction Code = 13):
| Name | Starting Position | Length | Value or Notes |
|---|---|---|---|
| Record Type 1 | 1 | 1 | 1 |
| BSB Number | 2 | 7 | bank_addr_mst.bank_number
Format ###-### |
| Account number | 9 | 9 | bank_hdr_mst.branch_code |
| Indicator | 18 | 1 | blank |
| Transaction Code | 19 | 2 | 13 |
| Amount | 21 | 10 | DomCheckAmt |
| Title of Account | 31 | 32 | parms_mst.company |
| Reference | 63 | 18 | "Payment" |
| BSB Number | 81 | 7 | bank_addr_mst.bank_number
Format ###-### |
| AccountNumber | 88 | 9 | bank_hdr_mst.branch_code |
| Name of Remitter | 97 | 16 | parms_mst.company |
| Amount of withholding Tax | 113 | 8 | 00000000 |