A format that allows for rent collection processing with First Union National Bank. It is similar to the regular NACHA file layout, except it includes an additional line for the balancing amount for the sum of each transaction.
The Balanced NACHA file layout consists of the following records:
File Header Record Format for All Entries
The File Header Record designates physical file characteristics and identifies the immediate origin and destination of the entries contained within the file. In addition, this record includes date, time and file identification field which can be used to identify the file uniquely.
Field # |
Position From/To |
Size |
Contents |
Data Element Name |
Data Element Definition |
Requirement |
1 |
01-01 |
1 |
'1' |
Record Type Code |
The Record Type Code identifies the following types of records: 1-File Header 5-Company/Batch Header 6-Entry Detail 7-Entry Detail Addenda 8-Company/Batch Control 9-File Control |
Mandatory |
2 |
02-03 |
2 |
'01' |
Priority Code |
A Constant |
Mandatory |
3 |
04-13 |
10 |
'bTTTTRRRRC' |
Immediate Destination |
Destination Routing Number Note: From Direct Rent Setup |
Mandatory |
4 |
14-23 |
6 |
'bXXXXXXXXX' |
Immediate Origin |
Origin Routing Number |
Mandatory |
5 |
24-29 |
6 |
YYMMDD |
Transmission Date |
File Creation Date |
Mandatory |
6 |
30-33 |
4 |
HHMM |
Transmission Time |
File Creation Time |
Optional |
7 |
34-34 |
1 |
'A' |
File ID Modifier |
Provides unique identification of file content for files with same date and time. |
Mandatory |
8 |
35-37 |
3 |
'094' |
Record Size |
Indicates the number of characters contained for each record when recorded or transmitted in the fixed format (always "094"). |
Mandatory |
9 |
38-39 |
2 |
'01' |
Blocking Factor |
The Blocking Factor defines the number of physical records within a block (a block is 940 characters). For all files moving between a DFI (Depository Financial Institution) and an ACH Operator (either way), the value "10" must be used. If the number of records within the file is not a multiple of ten, the remainder of the block must be nine filled. |
Mandatory |
10 |
40-40 |
1 |
'1' |
Format Code |
This field has been provided for future format variations (i.e., data transmission). As currently defined, the format for files containing paperless entries will be value '1'. |
Mandatory |
11 |
41-63 |
23 |
Alphabetic |
Destination |
Destination name Note: This name is pulled from eSite—Setup—Property—Direct Rent Setup. |
Mandatory |
12 |
64-86 |
23 |
Alphabetic |
Origin |
Origin Name Note: This name is pulled from eSite—Setup—Property—Direct Rent Setup. |
Mandatory |
13 |
87-94 |
8 |
'ESITEACH' |
Reference Code |
This field is available for information pertinent to the company. AMSI uses this to store an identifier as to which program created the file. |
Optional |
Company/Batch Header Record Format for All Entries
The Company/Batch Header Record identifies the Company and briefly describes the prearranged paperless debit or credit. In addition, this record contains the Transit Routing/ABA number of the Originating DFI and may indicate the intended effective date of all transactions within the batch. This information applies to all subsequent entry detail records in the batch.
Field # |
Position From/To |
Size |
Contents |
Data Element Name |
Requirement |
1 |
01-01 |
1 |
'5' |
Record Type Code |
Mandatory |
2 |
02-04 |
3 |
'2XX' |
Service Class Codes: 200-ACH entries mixed debit and credit 220-ACH credits only 225-ACH debits only Note: The AMSI file always uses 200. |
Mandatory |
3 |
05-20 |
16 |
Alphanumeric |
Company Name Note: This name is pulled from eSite—Setup—Property—Direct Rent Setup. |
Mandatory |
4 |
21-40 |
20 |
Alphanumeric |
Company Directory Data Note: This name is pulled from eSite—Setup—Property—Direct Rent Setup, Property Name field. |
Optional |
5 |
41-50 |
10 |
Alphanumeric |
Fed ID Note: This name is pulled from eSite—Setup—Property—Direct Rent Setup. |
Mandatory |
6 |
51-53 |
3 |
'XXX' |
Standard Entry Classes: PPD - Consumer debit and credits CCD - Corporate debits and credits CIE - Customer initiated entry CTX - Corporate Trade Exchange Note: In eSite, ePay and WebPay use PPD, MICR uses ARC. |
Mandatory |
7 |
54-63 |
10 |
Alphanumeric |
Company Entry Description Note: AMSI always uses PAYMENT. |
Mandatory |
8 |
64-69 |
6 |
YYMMDD |
Company Descriptive Date Note: This is the date the ACH file was created. |
Optional |
9 |
70-75 |
6 |
YYMMDD |
Effective Entry Date Note: This is the date the ACH file was created. |
Mandatory |
10 |
76-78 |
3 |
'000' |
Settlement Date Note: This date is pulled from eSite—Setup—Property—Direct Rent Setup, Days Offset Date field. |
Mandatory |
11 |
79-79 |
1 |
'1' |
Originator Status Code |
Mandatory |
12 |
80-87 |
8 |
TTTTAAAA |
Originating DFI Identification Note: This is the first 8 digits of the Origin ABA number pulled from eSite—Setup—Property—Direct Rent Setup—Origin ABA Number field. |
Mandatory |
13 |
88-94 |
7 |
Numeric |
Batch # Note: Batch numbers are created sequentially. For instance, first batch is 0000001, second batch is 0000002, and so on. |
Mandatory |
Entry Detail Record for CCD, CIE and PPD Entries
Entry Detail records contain the information sufficient to relate the entry to the Receiver or Customer (individual DFI account number, identification number, and the debit or credit as indicated by the Transaction Code).
Field # |
Position From/To |
Size |
Content |
Data Element Name |
Data Element |
Requirement |
1 |
01-01 |
1 |
'6' |
Record Type Code |
Previously defined - Entry Detail |
Mandatory |
2 |
02-03 |
2 |
Numeric |
Transaction Code |
The two digit code in the ACH record that determines whether an entry is a debit or a credit to a DDA account, savings account, or general ledger account, or whether an entry is a credit to a loan account. Note: AMSI always uses these transaction codes; 27, 28, 37 or 38. |
Mandatory |
3 |
04-11 |
8 |
TTTTAAAA |
Individual Bank ID |
First 8 digits of ABA Number from scanned check. |
Mandatory |
4 |
12-12 |
1 |
Numeric |
Check Digit |
This is the last digit of the ABA Number. |
Mandatory |
5 |
13-29 |
17 |
Alphanumeric |
Bank Acct. Number |
DDA Number |
Mandatory |
6 |
30-39 |
10 |
$$$$$$$$cc |
Amount |
Payment Amount |
Mandatory |
7 |
40-54 |
15 |
Alphanumeric |
Individual ID Number |
This field contains the accounting number by which the individual is known to the company. Note: AMSI uses Company, Property, Building, Unit and Resident ID. |
Mandatory |
8 |
55-76 |
22 |
Alphanumeric |
Individual Name |
Resident/Tenant Name |
Mandatory |
9 |
77-78 |
2 |
Blank |
Bank Discretionary Data |
AMSI uses '01' |
Mandatory |
10 |
79-79 |
1 |
Numeric |
Addenda Record Indicator |
Value - '0' or '1'. This field contains the count of any Entry Detail Addenda Records associated with the Entry Detail Record. A value '0' means no such record is present. Note: AMSI uses 0. |
Mandatory |
11 |
80-94 |
15 |
Numeric |
Trace Number |
Positions 1-8=origin routing number Note: This number is pulled from eSite—Setup—Property—Direct Rent Setup—Origin ABA Number field. Positions 9-15=detail number (0000001 for the first entry, 0000002 for the second entry, and so on. |
Mandatory |
Balancing Entry Detail Record for CCD, CIE and PPD Entries
Balance Entry Detail records contain one balancing line with the sum of each payment transaction record.
Field # |
Position From/To |
Size |
Content |
Data Element Name |
Data Element |
Requirement |
1 |
01-01 |
1 |
'6' |
Record Type Code |
Previously defined - Entry Detail |
Mandatory |
2 |
02-03
|
2 |
Numeric |
Transaction Code |
The two digit code in the ACH record that determines whether an entry is a debit or a credit to a DDA account, savings account, or general ledger account, or whether an entry is a credit to a loan account. Note: AMSI always uses transaction code 22. |
Mandatory |
3 |
04-11 |
8 |
TTTTAAAA |
Destination ABA Number |
From eSite — Direct Rent Setup — Destination ABA # |
Mandatory |
4 |
12-12 |
1 |
Numeric |
Check Digit |
This is the last digit of the ABA Number. |
Mandatory |
5 |
13-29
|
17 |
Alphanumeric |
Bank Acct. Number |
In eSite, Bank Account number from Bank Book setup |
Mandatory |
6 |
30-39 |
10 |
$$$$$$$$cc |
Amount |
Payment Amount |
Mandatory |
7 |
40-54 |
15 |
Alphanumeric |
Individual ID Number |
This field contains the accounting number by which the individual is known to the company. Note: This will be blank for the Balancing entries. |
Mandatory |
8 |
55-76 |
22 |
Alphanumeric |
Bank Book Account Description |
In eSite, the Bank Book Account Description |
Mandatory |
9 |
77-78 |
2 |
Blank |
Bank Discretionary Data |
AMSI uses '00' |
Mandatory |
10 |
79-79 |
1 |
Numeric |
Addenda Record Indicator |
Value - '0' or '1'. This field contains the count of any Entry Detail Addenda Records associated with the Entry Detail Record. A value '0' means no such record is present. Note: AMSI uses 0. |
Mandatory |
11 |
80-94 |
15 |
Numeric |
Trace Number |
Positions 1-8=origin routing number Note: AMSI uses 0. Positions 9-15=detail number (0000001 for the first entry, 0000002 for the second entry, and so on). |
Mandatory |
Entry Detail Addenda Record Format for CCD, CIF, CTX and PPD Entries
Addenda Records are used by the originating company to supply additional financial information about the Entry Detail Records accompanying the ACH transaction. Addenda records must be in consecutive ascending order. Note that AMSI does not use Addenda Records.
Field # |
Position From/To |
Size |
Contents |
Data Element Name |
Requirement |
1 |
01-01 |
1 |
'7' |
Record Type Code |
Mandatory |
2 |
02-03 |
2 |
'05' |
Addenda Type Code - Constant |
Mandatory |
3 |
04-83 |
80 |
Alphanumeric |
Payment Related Information - allows for transmission of information formatted in accordance with ANSI formats or NACHA - endorsed banking conventions |
Optional |
4 |
84-87 |
4 |
Numeric |
Special Addenda Sequence Number - consecutively assigned to each special addenda record following an Entry Detail Record. |
Optional |
5 |
88-94 |
7 |
Numeric |
Entry Detail Sequence Number - Ascending sequence number section of the Entry Detail Records trace number. |
Mandatory |
Company/Batch Record Format for All Entries
The Company/Batch control contains the counts, hash totals, and total dollar controls for the preceding detail entries within the indicated batch.
Field # |
Position From/To |
Size |
Contents |
Data Element Name |
Data Element |
Requirement |
1 |
01-01 |
1 |
'8' |
Record Type Code |
Previously defined |
Mandatory |
2 |
02-04 |
3 |
'2XX' |
Service Class Codes |
Code values are as follows: 200-ACH entries mixed debit and credit 220-ACH credits only 225-ACH debits only Note: AMSI uses 200. |
Mandatory |
3 |
05-10 |
6 |
Numeric |
Entry/Addenda Count |
This count is a tally of each Entry Detail Addenda Record processed within the batch. |
Mandatory |
4 |
11-20 |
10 |
Numeric |
Entry Hash |
The eight digit Transit/ABA numbers of the Entry Detail Records, within the batch, are accumulated into this 10-character field. |
Mandatory |
5 |
21-32 |
12 |
$$$$$$$$$$cc |
Total Debit Entry Dollar Amount |
This is the total amount of money being debited within the specific batch, which are the 627 records for debit to a checking account or 637, which are debits to a savings account. |
Mandatory |
6 |
33-44 |
12 |
$$$$$$$$$$cc |
Total Credit Entry Dollar Amount |
This is the total amount of money being credited to the specific HOA account, which are the 622 records for crediting your HOA’s checking account here at CAB. |
Mandatory |
7 |
45-54 |
10 |
########## |
Company Identification |
Same as field 5 in the '5' record of Company/Batch Header Record. |
Mandatory |
8 |
55-73 |
19 |
Blank |
|
|
Mandatory |
9 |
74-79 |
6 |
Blank |
|
|
Mandatory |
10 |
80-87 |
8 |
TTTTAAAC |
Originating Financial Institution |
Note: This number is pulled from eSite—Setup—Property—Direct Rent Setup—Origin Name field. |
Mandatory |
11 |
88-94 |
7 |
Numeric |
Batch Number |
Same as header |
Mandatory |
File Control Record Format for All Entries
The File Control Record contains dollar, entry, and hash total accumulations from the Company/Batch Control Records in the file. This record also contains counts of the number of blocks and batches within the file.
Field # |
Position From/To |
Size |
Contents |
Data Element Name |
Data Element |
Requirement |
1 |
01-01 |
1 |
'9' |
Record Type Code |
Previously defined |
Mandatory |
2 |
02-07 |
6 |
Numeric |
Batch Count |
The value of this field must be equal to the number of Company/Batch Header Records in the file. |
Mandatory |
3 |
08-13 |
6 |
Numeric |
Block Count |
For AMSI, this number is always a multiple of 10. Total number of records in the batch. |
Mandatory |
4 |
14-21 |
8 |
Numeric |
Entry/Addenda Count |
This count is a tally of each Entry Detail Record and each Entry Detail Addenda record processed within the file. |
Mandatory |
5 |
22-31 |
10 |
Numeric |
Entry Hash |
The eight digit Transit/ABA numbers of the Entry Detail Records, within the file, are accumulated into this 10-character field. |
Mandatory |
6 |
32-43 |
12 |
$$$$$$$$$$cc |
Total Debit Entry Dollar Amount |
This is the total amount of money in the debit records, which are the 627 records for debit to a checking account or 637, which are debits to a savings account. |
Mandatory |
7 |
44-55 |
12 |
$$$$$$$$$$cc |
Total Credit Entry Dollar Amount |
This is the total amount of money in the credit records, which are the 622 records for crediting your HOA’s checking account here at CAB. *Debits and credits must equal** |
Mandatory |
8 |
56-94 |
39 |
Blank |
Reserved |
|
Mandatory |
Field # |
Position From/To |
Size |
Contents |
Data Element Name |
Data Element |
Requirement |
1 |
01-94 |
94 |
'9999' |
Record Type Code |
As many number of rows full of 999999 to make the number of records a multiple of 10 (if the number of records equals 18, there will be 2 rows of 99999 Batch Fillers). |
Mandatory |
See Also
Copyright © 2018 Infor. All rights reserved. www.infor.com.