The purpose of the Checkbook Reconciliation Inquiry is to view Checkbook Reconciliations. All checkbook reconciliations, both open and posted can be viewed from here.
Software Version: 2020.01.13 and newer
Page Header
| Toolbar Icons | Description |
|---|---|
| Delete | Error rendering macro 'excerpt-include' : No link could be created for 'Delete LV - Global'.
|
| Excel | Error rendering macro 'excerpt-include' : No link could be created for 'Excel - Global'. |
| Grid Layout | Error rendering macro 'excerpt-include' : No link could be created for 'Grid Layout'. |
| Help | Error rendering macro 'excerpt-include' : No link could be created for 'Help - Global Icon'. |
| Inquiry Criteria | Opens Inquiry Criteria window where users can define the following criteria:
|
| Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. | |
| Refresh | Re-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria. |
| Fields | Description |
| Balance as of | Identifies the date that the 'Bank Balance' was calculated thru for the reconciliation. This would be the statement date if reconciling from a bank statement. This defaults to blank but is required before any transactions can be added to the Grid. This date must be <= the 'Transaction Cutoff' date but it is not required to be in an open fiscal period. |
| Checkbook | Error rendering macro 'excerpt-include' : No link could be created for 'Checkbook - List View/Inquiry Field'. |
| Checkbook Currency | The Currency ID of the Checkbook. Linked Database Field: ERPx_MFCheckbook.CurrencySK |
| Checkbook Description | Error rendering macro 'excerpt-include' : No link could be created for 'Checkbook Description - List View/Inquiry Field'. |
| Cleared Adjustments | Identifies the sum of all the Adjustment transactions that were included on the reconciliation, in the checkbook's currency, displayed in the currency format. |
| Cleared Deposits | Identifies the sum of all the deposit transactions (Deposits and Transfer: Receipt transactions) that were included on the reconciliation, in the checkbook's currency, displayed in the currency format. |
| Cleared Payments | Identifies the sum of all the payment transactions (Payments and Transfer: Sent transactions) that were included on the reconciliation, in the checkbook's currency, displayed in the currency format. |
| Created | Error rendering macro 'excerpt-include' : No link could be created for 'Created (Date & Time) - List View/Inquiry'. |
| Created By | Error rendering macro 'excerpt-include' : No link could be created for 'Created By- List View / Inquiry'. |
| Last Updated | Error rendering macro 'excerpt-include' : No link could be created for 'Last Updated (Date & Time) - List View/Inquiry'. |
| Last Updated By | Error rendering macro 'excerpt-include' : No link could be created for 'Last Updated By - List View/Inquiry'. |
| Reconcile to Balance | Identifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation was targeting. |
| Status | Error rendering macro 'excerpt-include' : No link could be created for 'Status - List View/Inquiry Field'. Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionStatusSK |
| Transaction | Error rendering macro 'excerpt-include' : No link could be created for 'Trans. ID - List View/Inquiry Field'. Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionID |
Deleting a Reconciliation does not impact the general ledger, it just un-assigns the checkbook transactions that were on the reconciliation and removes the reconciliation from history. Users can delete the last reconciliation for a checkbook with no restrictions. However, if a reconciliation is selected for delete, and there are posted reconciliations where the 'Bank Balance as of' occurred after the selected reconciliation, then all those reconciliations must be deleted as well. For example, if you reconcile as of the last day of each month, and your last reconciliation was as of 8/31/19, and you want to delete the 7/31/19 reconciliation, you must select both the 7/31/19 and 8/31/19 reconciliations for deletion.