Reconciliation Import File Trailer Record

Column

Position

Column Name

Type/Size

Comment

1

1-4

Record Type

String (4)

Value = ATRL

2

5-34

Agency ID

String (30)

Your unique agency number or alpha code.

3

35-84

Agency Name

String (50)

Your agency name.

4

85-94

Records

Integer (10)

Number of records in this file, excluding the trailer record.

5

95-106

Total Original Balance

Decimal (12)

Total balance of accounts at time of placement.

6

107 - 118

Total Current Balance

Decimal (12)

Total current balance of accounts placed.

7

119-126

Created Date

Date (CCYYMMDD)

File creation date.