Balanced NACHA File Layout

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:

ClosedFile 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

 

ClosedCompany/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

 

ClosedEntry 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

ClosedBalancing 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

ClosedEntry 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

 

ClosedCompany/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

ClosedFile 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

 

ClosedBatch Filler Records

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

eSite File Layouts Overview

Direct Rent Overview

Direct Rent ACH File Layouts

Direct Rent and ePay

Direct Rent and ChexDirect

Direct Rent Tab

ePay Overview

Ledger Overview

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.