The purpose of the Checkbook Reconciliation Record View is to identify all the checkbook transactions that have cleared the bank. From here, users can start a new reconciliation, assign all the transactions that are being reconciled (cleared), and edit the cleared amount of specific transactions if necessary. When a Reconciliation is Posted, the checkbook balance is updated and the Checkbook Transactions Inquiry is updated with the reconciliation information. Checkbook reconciliations do not make journal entries when posted.
Software Version: YYYY.MM.DD and newer
| Table of Contents | ||
|---|---|---|
|
...
| Toolbar Icons | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Delete |
| ||||||||
| Grid Layout |
| ||||||||
| Help |
| ||||||||
| New |
| ||||||||
| |||||||||
| Save & Refresh |
| ||||||||
| Header Fields | Description | ||||||||
| Adjustment Needed | A non editable text box that calculates the adjustment that would be needed to balance the checkbook based on the the current reconciliation information, in the checkbook's currency, displayed in the currency format. This is calculated as [Reconcile to Balance] - [Rec. & Cleared]. This label and field are only visible for transactions in the status of "New" or "Approved", they are not visible for Posted reconciliations. This amount must be be 0.00 to Approve and/or Post the transaction. How do alert users that they should fix it but not required them to?
This is a calculated field that is not stored in the database. | ||||||||
| Bank Balance as of | An editable date field to enter the date that the 'Bank Balance' is calculated thru. 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_#####.#####. | ||||||||
| Bank Balance | A non editable text box that displays the amount in the 'Reconcile to Balance' field, in the checkbook's currency, displayed in the currency format. This is informational only to assist in seeing how the 'Adjustment Needed' value is calculated. This label and field are only visible for transactions in the status of "New" or "Approved", they are not visible for Posted reconciliations. This is a calculated field that is not stored in the database. | ||||||||
| Checkbook | A single select lookup to select the Checkbook that is being reconciled. This defaults to blank but is required before transactions can be assigned to the reconciliation transaction. This is only editable for transactions in a Status of "New". If the checkbook is changed, any transactions currently "Included" on the reconciliation will be removed and the contents of the grid will refresh to reflect transactions for the updated checkbook. The lookup contains a blank value, the current assigned value, and all 'Active' checkbooks, sorted by Checkbook ID. The values in the lookup are displayed as:
Linked Database Field: ERPx_#####.#####. | ||||||||
| Cleared Adjustments | A text box to to show the sum of all the Adjustment transactions that have been marked as "Included" for this reconciliation, in the checkbook's currency, displayed in the currency format.. This is a calculated field that is automatically updated as Adjustment transactions are tagged / un-tagged as "Included". | ||||||||
| Cleared Deposits | A text box to to show the sum of all the Deposit transactions that have been marked as "Included" for this reconciliation, in the checkbook's currency, displayed in the currency format.. This is a calculated field that is automatically updated as Deposit transactions are tagged / un-tagged as "Included". | ||||||||
| Cleared Payments | A text box to to show the sum of all the Payment transactions that have been marked as "Included" for this reconciliation, in the checkbook's currency, displayed in the currency format.. This is a calculated field that is automatically updated as Payment transactions are tagged / un-tagged as "Included". | ||||||||
| Rec. + Cleared | A non editable calculated field that adds the current checkbook balance of all reconciled transactions to the cleared transactions from this transaction. This is the amount in the checkbook's currency, displayed in the currency format. This label and field are only visible for transactions in the status of "New" or "Approved" once values have been entered for:
This is a calculated field that is not stored in the database. | ||||||||
| Reconcile to Balance | An editable text box to enter the bank balance, in the checkbook's currency, displayed in the currency format. This defaults to 0.00 and is required to Approve and/or Post. If not, the message "Reconcile to Balance is required." will appear on Save. Linked Database Field: ERPx_#####.##### | ||||||||
| Status |
| ||||||||
Transaction Cutoff | A date field that identifies the 'date thru' used to select un-reconciled transactions in the grid. This is automatically updated anytime the 'Bank Balance as of' changes by adding the # of days from the '#Cutoff Days Preference' to the 'Bank Balance as of' date. Once this value has been assigned, it can be changed to any date >= 'Bank Balance as of' date. If not, the message, 'The Transaction Cuttoff date must be >= the Bank Balances as of date.' will be displayed on save. This is a calculated field that is not stored in the database. |
Page Detail
Un-Reconciled Checkbook Transactions Grid
| Toolbar Icons | Description | ||||||||
| Excel |
| ||||||||
| Edit Amounts | Opens the 'Edit Amounts' window to allow users to change the 'Cleared Amount' for a transaction. | ||||||||
| Include Transactions |
| ||||||||
| Remove Transactions |
| ||||||||
| Fields | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Checkbox |
| ||||||||
| Amount |
Linked Database Field: ERPx_#####.#####. | ||||||||
| Cleared Amount | A non-editable text box to displays the amount that is being reconciled (cleared the bank). This most often matches the transaction amount but will be different if there was a bank error or data entry error. The 'Cleared Amount' defaults from the 'Amount' for all "Included" transactions and can only be edited by clicking on the 'Edit Amounts' icon to open the 'Edit Amounts' window. This can only be edited for transactions that are included on the current reconciliation. Linked Database Field: ERPx_#####.#####. | ||||||||
Comment |
| ||||||||
| GL Date |
Linked Database Field: ERPx_#####.#####. | ||||||||
| Included | |||||||||
| Payee Name | |||||||||
| Reconciliation Group | |||||||||
| Reference |
Linked Database Field: ERPx_#####.#####. | ||||||||
| Trans. Date |
Linked Database Field: ERPx_#####.#####. | ||||||||
| Trans. Type |
Linked Database Field: ERPx_#####.#####. | ||||||||
| Transaction |
Linked Database Field: ERPx_#####.#####. |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...