| 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 |
|
|
|
|
|
|
|
|
Share
Report
All responses (
Answers (
335
