Input for the Reconciliation Process

The Check Reconciliation (CHREC) table is updated by Manual Disbursement (MD) and Automated Disbursement (AD/EFT) transactions. One record is inserted to Check Reconciliation for each disbursement. Each record contains disbursement data such as vendor, check/EFT amount, and status.

Note: Records can also be added to the Check Reconciliation table from the Paid Checks table by using the Move to CHREC action on the Paid Check Restore Mass Update table. This situation occurs when the status of a record on the Paid Checks table needs to be changed to perform additional actions or to rectify a mistake that happened at the Bank. Please refer to "Paid Check Restore" topic or the "Restore a Record on Paid Check Restore" topic for more information.

The Recently Reconciled field on the Check Reconciliation table is used to identify the reconciled records during the current Check Reconciliation process run. This is a protected field on Check Reconciliation. The default value is not checked, which indicates that the record has not been reconciled by the Check Reconciliation process. This field is automatically checked, when the record is reconciled by the Check Reconciliation process.

Changes can be made to various fields on the Check Reconciliation record via the Check Status Update page. If the Check Reconciliation Manual Update Tracking parameter on the Application Parameters table is set to Yes, then an audit record is automatically added to the Check/Deposit Manual Update Tracking table if a manual update is made to Check Reconciliation via the Check Status Update page.  

The Check Exception (CHKEXCP) table holds records that failed the comparison between the bank file and the Check Reconciliation table for all previous runs of the automated Check Reconciliation process. The Check Exception table also holds records from the bank file until comparison between the bank records and the Check Reconciliation records are completed.

Records are added to this table as a result of the Check Reconciliation process. It cannot be manually entered. Generally, records are removed from this table when a record has been reconciled through the Check Reconciliation chain jobs. However, sometimes it may be necessary to delete a record from this table. If it has been determined that a record needs to be deleted, you can mark the record for deletion using the Check Exception Update link. If a record is marked for deletion and the Check Reconciliation Manual Update Tracking (CHK_RECON_MNL_UPD_TRKG) parameter on the Application Parameters table is set to Yes, then an audit record is automatically added to the Check/Deposit Manual Update Tracking table.  

The Recent Record field on the Check Exception table is used to identify the exception records that are generated during the current Check Reconciliation Process run. The CHREC Load Process sets the value to False (‘0’ Zero) for the existing records before loading the XML file at the start of this process.