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. - CM, Transfer, Custom Exports
- Click New...
- Enter a Template Name
- Click Next
- Choose the Data Source (for example CM ALL Checks)
- Click Next
- Choose the desired information and be sure to include the ReconcileDate or ReconDate (depending on the Data source)
- Click Next
- Set desired sort criteria
- Click Next
- Set desired filters
- 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
|
|