ACCOUNT RECONCILEMENT - ISSUE INPUT FILE FORMAT - DATA TRANSMISSION |
|
|
|
|
(File sent to bank) |
|
|
|
|
Customer Name |
|
|
|
Account Number |
|
Date |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
To ensure accurate implementation and/or timely revision, please supply the desired information and return to your Treasury Sales |
|
Officer within 10 days. |
|
|
|
|
|
|
|
|
|
|
REQUIRED FILE SPECIFICATIONS |
|
|
|
|
File Type (check one) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Data Field Content |
|
|
|
|
|
|
|
|
Character Only |
|
All numeric fields are Right Justified Zero Filled (RJ/ZF). |
|
|
|
|
|
|
HEADER RECORD FORMAT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The use of a Header Record must precede all Detail Records for this and each subsequent account. |
|
|
On stacked accounts Header Records are required and must precede all Detail Records for this and each subsequent account. |
|
|
|
|
|
|
|
|
|
|
Position |
Field Description |
|
|
Field Size |
Type |
|
|
|
|
|
|
|
|
|
|
01-20 |
|
RECONCILIATIONHEADER (literal) |
|
|
20 |
Alpha |
|
|
|
|
NC - 0001, FL - 0003, SC - 0004, GA - 0005, VA - 0007, MD - 0014 |
|
|
|
|
|
|
|
|
CT - 0020, CTZ (TX, TN, AL, MS) - 0028, MTZ - 0042, PTZ - 0044 |
|
|
|
21-24 |
|
Bank Number |
DE - 0049, DC - 0052, PA, NY, NJ - 0075 |
|
04 |
Numeric (RJ/ZF) |
|
|
|
|
|
|
|
|
|
|
25-37 |
|
Account Number |
|
|
|
13 |
Numeric (RJ/ZF) |
|
|
|
|
|
|
|
|
|
|
38-49 |
|
Total Dollar Amount of File or all Zeros (without the decimal point) |
|
|
|
12 |
Numeric (RJ/ZF) |
|
|
|
|
|
|
|
|
|
|
50-54 |
|
Total Item Count of File or all Zeros (without the commas) |
|
05 |
Numeric (RJ/ZF) |
|
|
|
|
|
|
|
|
|
|
55-80 |
|
Filler |
(check one) |
|
|
blank |
26 |
Alphanumeric |
DETAIL RECORD |
All standards are assumed unless otherwise indicated. |
|
|
Position |
Field Description |
|
|
|
|
Max. Field Size |
|
|
Std. |
Other |
|
|
|
|
|
|
Type |
|
|
|
|
|
|
|
|
|
|
01-13 |
|
Account Number |
|
|
|
13 n/a |
Numeric (RJ/ZF) |
|
|
|
|
|
|
|
|
|
|
14-23 |
|
Check Serial Number |
|
|
|
|
10 |
Numeric (RJ/ZF) |
|
|
|
|
|
|
|
|
|
|
24-33 |
|
Check Amount (without the decimal point) |
|
|
10 |
Numeric (RJ/ZF) |
|
|
|
|
|
|
|
|
|
|
34-41 |
|
Issue Date (YYYYMMDD-std.) |
|
|
|
08 |
Numeric |
|
|
|
|
|
|
|
|
|
|
|
42 |
|
Void Indicator (V-std.) |
Other (except X or -) |
01 n/a |
Alphanumeric |
|
|
|
|
|
|
|
|
|
|
43-72 |
|
Additional Data (SSN, payee name, etc.) |
|
|
30 |
Alphanumeric |
|
|
|
|
|
|
|
|
|
|
73-80 |
|
Filler (same as above) |
|
|
|
08 |
Alphanumeric |
|
|
|
|
|
|
|
|
|
|
To ensure the most expedient return of your reconcilement information, checks and bank statement, please transmit your input files |
|
immediately after checks are written. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
For technical |
Format Approved: |
|
|
|
|
|
|
assistance, please |
________________________________________________________________________________________ |
__________________________ |
call your Customer |
Customer Signature |
|
|
|
|
Date |
|
Service Representative |
________________________________________________________________________________________ |
__________________________ |
at 1-800-222-3862, |
Customer Technical Contact (please print) |
|
|
|
Phone |
|
option 795. |
|
|
|
|
|
|
|
|
|
|
|
Bank Use: |
This customer-completed form MUST accompany all profiles used in account set-up. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
revised 08-06-07 |
|
|
|
|
|
|
|
|