LOCKBOX FILE LAYOUT

The fields below with arrows indicate required values. All other fields in the layout can be zero filled or left blank as they are not used in the load process

FILE HEADER RECORD

Field / 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / 11
Data
Element
Name / Record
Type
Code / Processing
Date / Unused / Posting
Date / Unused / DFI
Account
Number / Unused / Company
Name / Unused / Receiving
DFI
Number / Unused
Position / 1-4 / 5-10 / 11-12 / 13-18 / 19 / 20-33 / 34-40 / 41-60 / 61 / 62-70 / 71-80
Length / 4 / 6 / 2 / 6 / 1 / 14 / 7 / 20 / 1 / 9 / 10
Contents / ‘1000’ / YYMMDD / Blank / MMDDYY / Blank / Numeric
Zero Filled / Blank / Alphanumeric / Blank / 0TTTTAAAA / Blank
six digit
date, year
first / six digit
date, month
first / The company’s
bank account
number / the name of the company / a zero preceding
the company’s
bank’s transit/ routing number
Example / 1000 / 000104 / 010400 / 00000111122222 / OUR COMPANY / 003130142

SAMPLE FILE HEADER RECORD ALIGNMENT

1 2 3 4 5 6 7 8
12345678901234567890123456789012345678901234567890123456789012345678901234567890 /
1000000104 010400 00000111122222 OUR COMPANY 003130142


ENTRY DETAIL RECORD

Field / 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / 11
Data
Element
Name / Record
Type
Code / Auxiliary
Number / Lock Box
Identification / Individual
Identification / Unused / Process
Control / Amount / Processing
Date
(Year First) / Processing
Date
(Month First) / Reference
Number / Unused
Position / 1-2 / 3-12 / 13-20 / 21-34 / 35 / 36-41 / 42-51 / 52-57 / 58-63 / 64-76 / 77-80
Length / 2 / 10 / 8 / 14 / 1 / 6 / 10 / 6 / 6 / 13 / 4
Contents / ‘60’ / Numeric
Zero Filled / TTTTAAAA / Numeric
Zero Filled / Blank / Numeric / Numeric
Zero Filled / YYMMDD / MMDDYY / Numeric
Zero Filled / Blank
serial number
or aux. amount
(zero if not used) / the company’s
lock box
number / your customer’s
account number / will be 20
for credits / six digit
date, year
first / six digit
date, month
first / the institution,
run, batch, and
sequence number of the transaction
Examples / 60
60
60 / 0000000300
0000000250
0000000500 / 51579000
51579000
51579000 / 00000000001111
00000000002222
00000000003333 / 20
20
20 / 0000010000
0000007500
0000008750 / 000104
000104
000104 / 010400
010400
010400 / 0011400400057
0011400400112
0011600700194

SAMPLE ENTRY DETAIL RECORD ALIGNMENT

1 2 3 4 5 6 7 8
12345678901234567890123456789012345678901234567890123456789012345678901234567890 /
6000000003005157900000000000001111 2000000100000001040104000011400400057 6000000002505157900000000000002222 2000000075000001040104000011400400112 6000000005005157900000000000003333 2000000087500001040104000011600700194

Individual Identification breakdown:

21 – 22 à Last two digits of tax year

23 – 24 à Tax Type

25 – 28 à Municipality Code

29 – 34 à Bill #

This info is created in the bill print process when setting up your MICR line to print on the bills.

FILE CONTROL RECORD

Field / 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10
Data
Element
Name / Record
Type
Code / Processing
Date / Total Debit
Entry Dollar
Amount / Total Credit
Entry Dollar
Amount / Total Auxiliary
Entry Dollar
Amount / Total Dollar
Amount in File / Entry
Count / DFI
Account
Number / Endpoint
Number / Unused
Position / 1-2 / 3-8 / 9-19 / 20-30 / 31-42 / 43-54 / 55-60 / 61-74 / 75-76 / 77-80
Length / 2 / 6 / 11 / 11 / 12 / 12 / 6 / 14 / 2 / 4
Contents / ‘90’ / YYMMDD / Numeric
Zero Filled / Numeric
Zero Filled / Numeric
Zero Filled / Numeric
Zero Filled / Numeric
Zero Filled / Numeric
Zero Filled / Numeric / Blank
six digit
date, year
first / blank if not used
(always blank) / the total amount
of payments / the total amount
of secondary field
(blank if no aux. amount is used) / The total amount
Received (including
Any aux. amount) / the total
number of
entry detail records / the company’s account
that is credited (same
as field 6 of the file header record)
Example / 90 / 000104 / 00000026250 / 000000001050 / 000000027300 / 000003 / 00001112223333 / 80

SAMPLE FILE CONTROL RECORD ALIGNMENT

1 2 3 4 5 6 7 8
12345678901234567890123456789012345678901234567890123456789012345678901234567890 /
90000104 000000262500000000010500000000273000000030000111222333380


COMPLETED LOCK BOX FILE

USING DATA FROM THE PREVIOUS RECORDS

SAMPLE LOCK BOX FILE ALIGNMENT

1 2 3 4 5 6 7 8
12345678901234567890123456789012345678901234567890123456789012345678901234567890 /
1000000104 010400 00001112223333 OUR COMPANY 003130142
6000000003005157900000000000001111 2000000100000001040104000011400400057
6000000002505157900000000000002222 2000000075000001040104000011400400112
6000000005005157900000000000003333 2000000087500001040104000011600700194
90000104 000000262500000000010500000000273000000030000111222333380

- 1 -