Checkbook Reconciliations List View
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 | |
Edit | |
Excel | |
Favorites | |
Grid Layout | |
Help | |
Mass Update |
|
New | |
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 | Linked Database Field: ERPx_MFCheckbookReconciliation.CheckbookSK |
Checkbook Currency | The Currency ID of the Checkbook. Linked Database Field: ERPx_MFCheckbook.CurrencySK |
Checkbook Description | |
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 | Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedDate |
Created By | Linked Database Field: ERPx_MFCheckbookReconciliation.CreatedBy |
Last Updated | Linked Database Field: ERPx_MFCheckbookReconciliation.LastUpdated |
Last Updated By | 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 | Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionStatusSK |
Transaction | Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionID |
Related Topics