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

Browser not supported