Output of the Reconciliation Process

The Check Exception table is used to store records of disbursements that are not successfully matched with a bank's record during the automated Check Reconciliation process. Each record on the Check Exception (CHKEXCP) table includes a corresponding Exception Code and Exception Reason, indicating what caused the record to fail during the reconciliation process.

Conditions that cause a disbursement to be written to the exception table include:  

• Instrument Not Found in Financial System (the check information sent by the bank cannot be located in the Advantage application)

• Bank Amount Greater than Book Amount (from system's records on the Check Reconciliation table)

• Book Amount (from system's records on the Check Reconciliation table) Greater than Bank Amount

• Check Cancelled in Financial System

• Check Stale Dated, Escheated, or Voided in Financial System

• Record Deleted from Exception Table

• Non-Sufficient funds

• Check Stopped in Financial System

• Check Undeliverable in Financial System

The Check Reconciliation process moves records from the Check Reconciliation table to the Paid Checks table if the Cleared Date is populated and the Status is not Disbursed/ Warranted. Records are moved to the Paid Checks table with their current Status (for example, Paid or Cancelled) on the Check Reconciliation table.  All fields of this table are protected. Records can only be moved from the Paid Checks table to the Check Reconciliation table, by using the Move to CHREC action on the Paid Check Restore Mass Update page. Please refer to "Paid Check Restore" topic or the "Restore a Record on Paid Check Restore" topic for more information.

This page replicates the Paid Check (PDCHK) page with an additional Attachment field where single or multiple check images can be manually uploaded.

Please refer to the "Paid Checks with Attachments" topic for more information.

Check Image Load is used to track check images that are pending attachment to the appropriate Paid Check record.

Please refer to the "Check Image Load" topic for more information.

This report lists all records and corresponding exception codes resulting from the automated Check Reconciliation process.  

For more on the Check Reconciliation process, please refer to the CGI Advantage Accounts Payable Run Sheets guide for Check Reconciliation chain jobs.

This report summarizes the number of records reconciled and the exception records that were generated by the current run of the Check Reconciliation process.  

For more on the Check Reconciliation process, please refer to the CGI Advantage Accounts Payable Run Sheets guide for Check Reconciliation chain jobs.

The Warrant Reconciliation Transaction Exception Report provides a list of the Warrant Reconciliation transaction records that was not submitted to Final generated by the current run of the Generate Warrant Reconciliation Transaction process.

For more on the Generate Warrant Reconciliation Transaction process, please refer to the CGI Advantage Accounts Payable Run Sheets guide for Check Reconciliation chain jobs.