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	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!} 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.
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. Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.
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). The bolded view is the default view, which will determine the view will automatically display in when opened.
Help	Opens the online WIKI help page for the current page. This icon is only visible on pages that are documented in the online help.
Inquiry Criteria	Opens Inquiry Criteria window where users can define the following criteria: Checkbook: a multi-select combo box to limit the data that is returned to one or more selected checkbooks. A blank assumes All. Balances as of From: a text box to enter a starting date for reconciliation transactions. A blank assumes All. Balances as of To: a text box to enter an ending date for reconciliation transactions. A blank assumes All. Include Open Transactions: a Yes/No lookup to identify if the results include Open (unposted) reconciliation transactions. This defaults to "No" but can be changed to "Yes".
Print	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	Identifies the Checkbook assigned to the transaction.
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 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	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.
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.
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.
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.
Reconcile to Balance	Identifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation was targeting.
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

Page Header

Related Topics

Page Definitions

Technical Details

Browser not supported