KFS Check Reconciliation (Cancellation, Stale, Clear) File
- Modesto Sevilla
- Warren Liang
- Keiko Takahashi
- Maribeth Bradberry
Introduction
This page is based on the Check Cancellation File Functional Specifications located at P:\SystemDev\KUALI Project\A-2 Functional Spec Documents\_Feeder Systems\SBS PDP Upload - Business Process.doc
Revision History
Version | Date | Author | Description |
|---|---|---|---|
1.0 | 01/21/16
| Modesto Sevilla | Initial specification |
| 2.0 | 04/27/17 | Modesto Sevilla | Modified to be utilized by Aperek and besides cancellation, use it for stale dating and clearing. |
Functional Description
The Check Cancellation File process enables the external systems to cancel an existing disbursed paper check. The file format is based on the Check Reconciliation file format currently used by Wells Fargo Bank.
Requirements
- The check cancellation file process will need to provide:
- Check Number
- Payee ID
- Check Amount
- Use a flat file format (Check Reconciliation format).
- Naming convention for the file is kfschkcancel_[XFER Account]_[YYYYMMDDHHMMSSS].data Ex. kfschkcancel_kfssb_201601211622212.data
- File must be uploaded to XFER (SFTP server)
Uploading Payment Batch Files Through Secure FTP
Instructions are found on the page KFS SFTP Instructions To Upload and Download Files.
Flat file layout for the check reconciliation file (80 characters long)
- Composed of three record types
- Header Record
- Detail Record
- Trailer Record
HEADER
| Field Name | Format | Length | Begin Column | End Column | Comments/Values |
|---|---|---|---|---|---|
| Record Type | AlphaNumeric | 3 | 1 | 3 | 'H1 ' |
| Account Number | AlphaNumeric | 10 | 4 | 13 | '*6858' for SBS '*4741' for Aperek Call KFS help desk for full bank account# |
| Report ID | AlphaNumeric | 3 | 14 | 16 | 'R12' |
| Print Date | Numeric | 6 | 17 | 22 | MMDDYY - Today's Date |
| Begin Date | Numeric | 6 | 23 | 28 | MMDDYY - Today's Date |
| End Date | Numeric | 6 | 29 | 34 | MMDDYY - Today's Date |
DETAIL
| Field Name | Format | Length | Begin Column | End Column | Comments/Values |
|---|---|---|---|---|---|
| Record Type | AlphaNumeric | 3 | 1 | 3 | 'R12' |
| Check Number | AlphaNumeric | 10 | 4 | 13 | Left justified |
| Transaction | AlphaNumeric | 3 | 14 | 16 | '037' - Cancel '057' - Clear '007' - Void 'STL' - Stale 'STP' - Stop Payment |
| Issue Date | Numeric | 6 | 17 | 22 | MMDDYY - Check date when check was issued |
| Check Amount | Numeric | 10 | 23 | 32 | Left Zero Filled, Decimal point implied. Ex. '0000007651' is 76.51 |
| Paid Date | Numeric | 6 | 33 | 38 | MMDDYY - Fill this in for Cleared checks (i.e. 057), leave blank otherwise. |
TRAILER
| Field Name | Format | Length | Begin Column | End Column | Comments/Values |
|---|---|---|---|---|---|
| Record Type | AlphaNumeric | 3 | 1 | 3 | 'T1 ' |
| Credit Count | Numeric | 6 | 4 | 9 | '000000' |
| Credit Amount | Numeric | 11 | 10 | 20 | '00000000000' |
| Debit Count | Numeric | 6 | 21 | 26 | Left Zero Filled. The total number of Detail transactions Ex. '000311' |
| Debit Amount | Numeric | 11 | 27 | 37 | Left Zero Filled, Decimal point implied. The summation of the check amounts in the Detail transactions Ex. '0000007651' is 76.51 |
Sample File
