This page is updated by the Manual Disbursement and Automated Disbursement documents. One record is inserted on this page for each disbursement. Each record contains disbursement data such as Check/EFT number, Amount, and Status. The Check Reconciliation Process moves records from this table to the Paid Checks (PDCHK) table.
The Check Reconciliation process compares check records on the Check Reconciliation (CHREC) table to records on the Check Exception (CHKEXCP) table, which contains both today's bank file records in addition to any records that have failed prior reconciliation processing. If a match is found between the Check Reconciliation (CHREC) table and the Check Exception (CHKEXCP) table, and the record on CHREC has a Status of Disbursed/Warranted, the Status is then changed to Paid. The record is then moved from CHREC to the Paid Checks (PDCHK) table. If a match is not found, or if a match is found but the CHREC Check Status is anything other then Disbursed/Warranted, an exception record is added to CHKEXCP. The exceptional records remain on the CHKEXCP until they have been reconciled or manually marked for deletion.
Banks do not send EFT data along with the check data in the bank file. However, visibility of EFT payments is available on the Check Reconciliation (CHREC) table until the EFT has cleared the bank. The Cleared Date is calculated during the AD process by adding the lag days to the Check Date populated on the CHREC table when the EFT documents are processed to Final. The Check Reconciliation process compares the Cleared Date of the EFT record on the Check Reconciliation (CHREC) table to today's date. If the date has been bypassed, the EFT record's status is changed to Paid and subsequently moved to the Paid Checks (PDCHK) table.
Note: Records can also be added to the CHREC page from the Paid Checks (PDCHK) table by using the Move to CHREC action on the Paid Check Restore (PDCHKRES) table. This situation occurs when the status of a record on the Paid Checks (PDCHK) table needs to be changed to perform additional actions or to rectify a mistake that happened at the Bank. The Paid Check Restore (PDCHKRES) table allows authorized users to move records from the Paid Checks (PDCHK) table to the Check Reconciliation (CHREC) table. When the records are moved to the CHREC table, the Status field is set to Disbursed/Warranted and the Cleared Date field is set to blank even for the EFT records. Check/EFT records can then be moved to the Paid Check table by changing the Status to Paid, setting the Cleared Date field and running the Automated Check Reconciliation batch process.
A Back hyperlink is available that allows users to navigate to the previous page without going back to Page Search. The Back hyperlink on the Check Reconciliation (CHREC) page is disabled when the user transitions to this page from Page Search. It is enabled if the user transitions from other pages that allow the user to transition to CHREC. Currently, users can transition to CHREC from Paid Check Restore and Vendor Transaction History. For example, the user is on the Vendor Transaction History page and selects the Check Reconciliation hyperlink. When this is done, the Back hyperlink on CHREC is enabled allowing the user to return to Vendor Transaction History.
This page provides links to the Check Status Update, Check Writer Payment, Check Exception and Disbursement Detail Query pages.
To find out how to change a status of a check, go to Change a Check Status.