The purpose of the Checkbook Reconciliations List View is to show open reconciliation transactions in a Status of ‘New’ or ‘Approved’ and create new transactions to balance a checkbook. From here, users can add new reconciliations, edit existing reconciliations or delete unposted reconciliations. When a reconciliation is Posted, the checkbook balance may be updated and the Checkbook Transaction Inquiry is updated with the reconciliation information. Checkbook reconciliations do not make journal entries when posted.
Software Version: YYYY.MM.DD and newer
Page Header
| Toolbar Icons | Description |
|---|---|
| Delete | Error rendering macro 'excerpt-include' : No link could be created for 'Delete LV - Global'. |
| Edit | Error rendering macro 'excerpt-include' : No link could be created for 'Edit - Record View'. |
| Excel | Error rendering macro 'excerpt-include' : No link could be created for 'Excel - Global'. |
| Favorites |   Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline.
|
| 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'. |
| Mass Update | Opens the mass update dialog, which allows to mass update the following properties: Status |
| New | Opens a new blank record for data entry. |
| Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. | |
| 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 are 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 are 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 are 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 is targeting. |
| Status | Error rendering macro 'excerpt-include' : No link could be created for 'Status - List View/Inquiry Field'. Linked Database Field: ERPx_ |
| Transaction | Error rendering macro 'excerpt-include' : No link could be created for 'Trans. ID - List View/Inquiry Field'. Linked Database Field: ERPx_ |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.