Page Comparison

...

1. KFS internal checks (PDP):
Run
1. Retrieve Bank of America (BOA) check file for Bank 15 and other FRS Memo Banks (04, 16, 17, 18).
2. Run FRS batch job J9615S95 to reformat bank transactions into FRS format.
3. Run FRS batch job(s) to process file against FRS check table.
1. Execute KFS Check Reconciliation Bank Process (Main Menu Tab, 1st column, Check Reconciliation, Check Reconciliation).
2. Format the check file, by selecting the account number, check number,status, amount and date.  This is usually the first 40 columns of each row.

3. Enter bank code (01, 04, 15, 16, 17, 18),  date range and a check status.

4. Execute KFS Check Reconciliation Bank Upload (
online screen and batch).
1. Administration Tab, 3rd column, Batch, Check reconciliation, check reconciliation bank Upload).  Enter file created above. 
   PRD-KFS-checkReconciliationJob runs when this upload is performed.
2. Notify Accounting management and staff that these procedures have been completed.
4. External system checks (Student Admin):
Run
1. Request that Student Financials staff produce monthly check file (SQR=UCSFOUTC).  This will put the file on  the saprod_rmt server, /apps/home/deposer/bursar/output90/kuali/Outstanding_checks_PSoft_ccyymmdd_hhmmss.txt.

2. Run KFS batch file transfer job: PRD-KFS-StudentRefundChecksFromPSOFTtoKFS.  This will transmit the job to the prd.batch.uconn.edu server, staging/cr/external/Outstanding_checks.PSoft_ccyymmdd_hhmmss.dat with an associated .done file. 

3. Run KFS batch job: PRD-KFS-externalCheckReconciliationJob.
4. Retrieve BOA check file for Bank 01.
5. Run FRS batch job J9615S80 to reformat bank transactions into FRS format.
6. Run FRS batch job(s) to process file against FRS check table.
1. Execute KFS Check Reconciliation Bank Upload (
online screen and batch).
1. Administration Tab, 3rd column, Batch, Check reconciliation, check reconciliation bank Upload).  Enter file created above.  checkReconciliationJob runs when this upload is performed.
2. Notify Accounting management and staff that these procedures have been completed
.

...

1. .

...

FRS Check Reconciliation job descriptions can be found in the following document 
1. FRS Bank Reconciliation Jobs

KFS Check Reconciliation Jobs and File Formats:

...

1. The PRD-KFS-externalCheckReconciliationJob file format description can be found in the following document: 
   1. KFS-External Check Load File Update Format
2. The KFS Check Reconciliation BOA Bank Upload (online screen and batch) file format description can be found in the following document:
   1. KFS-BOA Bank File Check Status Update Format

Additional Documentation for Check Reconciliation Module

Original Spec for Check Recon