How to find the reconciliation date of a check, deposit or other bank transaction
Description
Cause
Resolution

To find the reconciliation date of a bank transaction create a custom report or custom export and filter on the reconciliation date. Be sure to include the check number or bank transaction number in the report as well as any additional information you may want on the report.

 

  1. CM, Transfer, Custom Exports
  2. Click New...
  3. Enter a Template Name
  4. Click Next
  5. Choose the Data Source (for example CM ALL Checks)
  6. Click Next
  7. Choose the desired information and be sure to include the ReconcileDate or ReconDate (depending on the Data source)
  8. Click Next
  9. Set desired sort criteria
  10. Click Next
  11. Set desired filters
  12. Click Done

Note:  Any item with the Reconciliation date of 1/0/1900 is a null date (no value) and means the item has not be reconciled

Use the reconciliation date field corresponding to the desired Data Source:



Data Source

Fields

CM All Checks

ReconcileDate

CM Bank Charges

ReconDate

CM Bank Credits

ReconDate

CM Bank Deposits

ReconDate

CM Cash Transactions

ReconcileDate

CM Credit Card Transactions

ReconcileDate

CM Payroll Checks

ReconcileDate

CM Vendor Checks

ReconcileDate



 

Steps to duplicate
Related Solutions