BOA - Bank of America

 

Header Record      
Field Name Type Length Description
Field Type     Mandatory field
Company Name   35

Mandatory field
Company Bank Account name from the Company Bank Details window
e.g. XYZ Company Pty Ltd
Company ID Alpha/Numeric 10

Mandatory field
Identifies the Company ID sending the file (and is used in the payment acknowledgment payment process).
Note: The ID supplied in this field is used for Data Segregation.

Company EFT key from the field on the Bank of America Parameter window.
Company EFT Key Alpha/Numeric 4

Mandatory field
Date the file was created. Must be prior or equal to system date.

System date when the process is run in the format CCYYMMDD.
Creation Date Numeric 6 Mandatory field
Use the Direct Credit Date keyed in on the EFT Processing window followed by payroll.csv.
e.g. 201108 Payroll.csv, 271108 Payroll.csv etc
File Name Alpha/Numeric 32 Mandatory field
Identifies the original file name
Use the Direct Credit date keyed in on the EFT Processing window followed by payroll.csv.
e.g. 201108 Payroll.csv, 271108 Payroll.csv etc.
Test/Production Indicator Alpha   Mandatory field
Determines whether this is a test or production file
On the EFT Processing window:
when the Test Run field is Y add TEST
when the Test Run field is N add PROD

 

Detailed Transaction Record      
Field Name Type Length Description
Field Type Alpha/Numeric 1 Mandatory field
Fixed value must be TRN
Transaction Type   1 Mandatory field
Defines the type of transaction
Fixed value must be ACH
Alternate Transaction Type   1 Optional
Defines the additional type of transaction
U.S. ACH Company ID Alpha/Numeric 10 Defines the US ACH Company ID
Branch Code Alpha/Numeric 4 Defines the Originator Bank Branch Code
E.g. 6008 = Bank of America London
Branch Code from the field on the Bank of America Parameter window.
Originator Account Alpha/Numeric 31

Mandatory field
Defines the Bank of America Originator Bank Account Number.
This should be your standard Bank of America account number and not your local account number (if used).
Example Belgium:

BOFA: 12345678
Local: 1231234567812

Position 1 - 6 of the Company BSB Number from the Company Bank Details window. e.g. 030253 upto the 9 digits of the Company Bank Account Number from the Company Bank Details window.
e.g. 320400600 the full number would be 030253320400600
ABA Routing Number for US Alpha/Numeric 9 Defines the Originator Bank Branch Code
Originator Account Currency Alpha/Numeric 3 Mandatory field
Defines the currency of the Originator Account
Fixed value must be NZD
Payment/Collection Indicator Alpha/Numeric 3 Mandatory field
COL = Collection
PAY = Payment
Defines whether the transaction will be a payment
(Debit from the Originators Account) or a collection (Credit to the Originators Account)
Transaction Handling Code Alpha/Numeric 1

Mandatory field
C = Payment and Remittance Combined
D = Payment Only
N = Check Issues File Only (US and Canada only)
P = ACH Pre note Only (US)
U = Split Remittance
Defines a code for payment and remittance handling.

Fixed value must be D
Posting Indicator Alpha/Numeric 1

Optional
Used for International Transactions only
C = Consolidated Posting
S = Single (Itemised) Posting

Defines how the items are posted on the account statements. If not supplied default will be applied.

Posting Indicator Code from the field on the Bank of America Parameter window.
If consolidated tick box is completed add C
If Single (itemised) Tick Box is completed add S
Consolidated Reference Alpha/Numeric 16 Optional
Used for International Transactions only
Defines a reference to assist with the reconciliation of Consolidated account statement postings.
Priority Indicator Alpha/Numeric 1

Optional
Used fro International Transactions only
1 = Normal
2 = Urgent
3 = Same Day Value (by agreement only)

Defines the priority of the transaction
Transaction Reference Alpha/Numeric 16

Mandatory field
Defines the reference for the transaction. This must be unique for each item. Any duplicate uploaded over a 45 day period will be rejected.
It may be possible to use up to 30 characters under special circumstances. Please liaise with your implementation officer.
If this number is to be used for check transactions then the right hand 10 characters (maximum) must be numeric.

Use the Direct Credit Date keyed in on the EFT Processing window as CCYYMMDD followed by a counter to 6 digits.

e.g. 20081120000001, 20081120000002 etc.

The following pay cycle would 20081127000001, 20081127000002 etc.
Receiving Party Mail Handling Code Alpha/Numeric 2 Optional
Cheque/Draft instructions only.
Normally used in the U.S. and Asia only.
Accepted values
Rm = Return to Remitter
FM = Foreign Mail
HD
OD = Overnight back to remitter (US Checks)
RD = Overnight to vendor (US Checks)
OD and RD must be re-arranges with Bank before sending.
Ordering Party Name Alpha/Numeric 35

Mandatory field
Defines the name of the Ordering Pary.
Note: A PAT ID can be supplied in this field if prefixed with a # (Hash/Pound sign). Only use with agreement of your implementation officer.

Company Bank Account Name from the Company Bank Details window.

e.g. XYZ Company Pty Ltd
Ordering Party (Entity) ID Alpha/Numeric 15 Optional
Defines the ID/Identifier code fro the Ordering Party
Ordering Party Address 1 Alpha/Numeric 35 Optional
Defines the first address line for the Ordering Party
Ordering Party Address 2 Alpha/Numeric 30 Optional

Defines the second address line for the Ordering Party
Ordering Party City Name Alpha/Numeric 30 Optional
Defines the city for the Ordering Party
Ordering Party State Code Alpha/Numeric 2 Mandatory field for U.S. and Canadian Ordering Parties if the address is provided.
Defines the U.S. State code or Canadian Province code for the Ordering Party
Ordering Party Zip/Postal Code Alpha/Numeric 11 Optional
Defines the zip or postal code of the Ordering Party.
Note: For cheques and drafts, the cheque print (TROY) file only supports up to 9 characters. This data will be truncated for those transaction types.
Ordering Party ISO Country Code Alpha/Numeric 2 Mandatory
Defines the country of the Ordering Party.
Fixed Value must be NZ
Receiving Party Name Alpha/Numeric 70

Mandatory
Defines the name of the Receiving Party
Note: A PAT ID can be supplied in this field if prefixed with a # (Hash/Pound sign).

Employee's Bank Account Name on the Bank Details window.

e.g. Peter Rabbit
Receiving Party ID Alpha/Numeric 20 Optional
Defines the ID/Identifier code for the Receiving Party.
May be used for US checks and printed advices to print a vendor number.
Receiving Party Address 1 Alpha/Numeric 35 Conditional
Defines the first address line for the Receiving Party.
Must be present for checks, drafts and split remittance.
Receiving Party Address 2 Alpha/Numeric 35 Optional
Defines the second address line for the Receiving Party
Receiving Party City Name Alpha/Numeric 30 Conditional
Defines the city of the Receiving Party.
Must be present for checks, drafts and split remittance - not all 30 characters can map for these transaction types.
Receiving Party State Code Alpha/Numeric 2 Conditional
Defines the U.S. State code or Canadian Province code for the Receiving Party. Mandatory if the address is supplied and U.S. or Canada.
Mandatory for checks, drafts and split remittance.
Receiving Party Zip/Postal Code Alpha/Numeric 11 Optional
Defines the zip or postal code of the Receiving Party
Receiving Party ISO Country Code Alpha/Numeric 2 Mandatory
Defines the country of the Receiving Party
Fixed value must be NZ
Effective Entry Date Numeric 8

Mandatory field
Effective Entry (Value Date) of the transaction.
Must not be prior to transmission date through EFD.

Direct Credit Date keyed in Job Submission parameters from the EFT Processing process. Keyed as DDMMYY but must be changed to CCYYMMDD
Transaction Description Alpha/Numeric 10 Optional
Normally used for US ACH transactions. Describe type of transactions - such as CORP PMT. Please refer to your EDI Implementation Officer.
Transaction Currency Code Alpha/Numeric 3 Mandatory

Defines the currency code of the transaction.

Fixed value must be NZD
Transaction Amount Alpha/Numeric 18

Mandatory field
Defines the amount of the transaction.
It is recommended that you include a decimal point and two decimal places.

The amount of the employee's pay e.g. 5650.00
Charges Indicator Alpha/Numeric 5

Optional
This option may not be available for all countries and payment methods. Please confirm with your implementation officer.
BEN = All charges borne by beneficiary
OUR = All charges borne by transaction originator
SHARE = All changes shared by both parties
Defines the changes allocation for the transaction.

Fixed value must be OUR
Check Number Numeric 10 Conditional for Check transactions.
Defines the check number to be used. - see your implementation officer for country limitations. If not present then the right hand 10 characters (must be numeric) on the transaction reference number can be used (TRN 13)
Receiving Bank Name Alpha/Numeric 33 Mandatory except for Cheque/draft transactions
Defines the name of the Receiving Bank
Note: A PAT ID can be supplied in this field if prefixed with a # (Hash/Pound sign)
The 3 character Bank field from the corresponding employee's BSB Number from the employee's Bank Details window (position 39 of this field)
Look up BSB Number from the BSB Codes window.
Example
If BSB number is 020800, the Bank is BNZ
If BSB number is 010414, the Bank is ANZ etc.
Receiving Bank Qualifier Alpha/Numeric 2 Optional
Defines the Receiving Bank ID/Sort Code type
Fixed value must be NZ
Receiving Bank ID/Sort Code Alpha/Numeric 12 Conditional
We would normally expect to see a maximum of 11 characters except for China when we would expect to see 12 characters.
Defines the Receiving Bank ID/Sort Code to be used with the transaction.
It may be used with your electronic instruction but it is suggested that this information is always presented.
BSB Number from the employee's Bank Details window e.g. 302903
Receiving Bank SWIFT Address Alpha/Numeric 11 Conditional
Defines the Receiving Bank SWIFT address to be used with the transaction.
It may be used with your electronic instruction but is suggested that this information is always presented.
Receiving Bank Account Number Alpha/Numeric 35 Mandatory except for cheque/draft transactions.
Defines the Receiving Bank account number.
Note: Leading spaces should not be present in this field.
1st 7 digits of the employee's Bank Account Number - right justified and zero filled, then add one zero and the last 2 digits of the employee Bank Account Number.
Example
Account Advised as 123456712 format should be 1234567012
Account Advised as 1234512 format should be 0012345012
Receiving Bank Branch Number Alpha/Numeric 12 RESERVED FOR FUTURE USE
Defines the branch number of the Receiving Bank
Receiving Bank City Name Alpha/Numeric 30 Mandatory except for cheque/draft transactions
Defines the city of the Receiving Bank
The Bank Name field from the corresponding employee's BSB Number from the employee's Bank Details window. (position 39 of this file)
Look up BSB Number from the BSB Codes window.
Example
If BSB Number is 020800, the Bank Name is Christchurch.
If BSB Number is 010414, the Bank Name is Rotorua etc
Receiving Bank ISO Country Code Alpha/Numeric 2 Mandatory except for cheque/draft transactions
Defines the country of the Receiving Bank
Fixed value must be NZ

 

Unstructured Free Format Remittance Detail Record
Field Name Type Length Description
Record Type     Mandatory
Fixed value must be RDF
Remittance Type     Mandatory
Fixed value must be FTX
Text Alpha/Numeric 35 Mandatory
On the employees bank window, if the Particulars, Code and Reference have been completed then add these records for the corresponding transaction. Add
Particulars <<space>>Code<<space>>Reference
Truncate to 35 characters.
E.g. Peter Rabbis CODE34567 REF234567
If Particulars and Reference is used but not Code use Particulars <<space>>Reference etc

 

Footer Record
Field Name Type Length Description
Record Type     Mandatory
Fixed value must be BULKCSVTRAILER
Transaction Count Numeric 10 Mandatory
Defines the number of transactions in the file
Amount Hash Total Alpha/Numeric 15 Mandatory
The hash total of all Transaction Amounts in the file.