Checkbook Reconciliations List View
- Tom Williams
- Janice Dannenberg (Unlicensed)
A Checkbook Reconciliation is a balancing of two sets of records:
- A Bank Statement, supplied by the bank
- The financial records recorded in your system.
A checkbook reconciliation is a useful financial control to confirm the checkbook control accounts within the general ledger are accurate and to protect against fraud. Reconciliations are useful for explaining the difference between two financial records or account balances. Some differences may be acceptable because of the timing of payments and deposits. Unexplained or mysterious discrepancies, however, may warn of fraud or bad accounting practices. Companies may reconcile their records daily, monthly, or annually.
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: 2020.01.13 and newer
Page Header
| Toolbar Icons | Description |
|---|---|
| Delete | Deletes the selected record(s). When clicked, users will be prompted with: "Are you sure you want to delete the selected records?". Click "OK" to confirm, or "Cancel" to return without deleting. WARNING: Records cannot be recovered once they are deleted! |
| Edit | Opens the record view of the selected record. |
| Excel |  Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported. |
| 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 | Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).
|
| Help | Opens the online WIKI help page for the current page.
|
| 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. Linked Database Field: ERPx_MFCheckbookReconciliation.BankBalanceDate |
| Checkbook | Identifies the Checkbook assigned to the transaction. Linked Database Field: ERPx_MFCheckbookReconciliation.CheckbookSK |
| Checkbook Currency | The Currency ID of the Checkbook. Linked Database Field: ERPx_MFCheckbook.CurrencySK |
| Checkbook Description | Shows the value in the 'Checkbook Description' of the Checkbook assigned to the transaction. This value is set in the Checkbook Master File. |
| 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. This is a calculated field and not stored in the database. |
| 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.This is a calculated field and not stored in the database. |
| 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.This is a calculated field and not stored in the database. |
| Created | Identifies the Created Date & Time of the record, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedDate |
| Created By | Identifies the name of the user that created the record. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedBy |
| Last Updated | Identifies the Last Updated Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_MFCheckbookReconciliation.LastUpdated |
| Last Updated By | Identifies the name of the user that last updated the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Linked Database Field: ERPx_MFCheckbookReconciliation.LastUser |
| Reconcile to Balance | Identifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation is targeting. Linked Database Field: ERPx_MFCheckbookReconciliation.Amount |
| Status | Identifies the Status of the transaction. Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionStatusSK |
| Transaction | Identifies the unique Transaction ID for each transaction. Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionID |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.