The purpose of the (Record View Name) Record View is to enter and edit (Functional Area Transaction Types) transactions that are open (not posted) (assigned a Status of (list all included statuses as comma separated)). From here, users can (What functions can be done or launched from here). When transactions are posted from this list view, the (what subsidiary/subsidiaries) are updated. (Functional Area Transaction Types) transactions (make or do not make) journal 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 2023.MM.DD and 12.19 and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
Header Toolbar
(Grid Tab2 Name)
| Toolbar Icons | Description | Cancel||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Delete | Cancel - List View Edit
| Cancel - List View Edit |
| ||||||||||||
| Grid Layout |
| ||||||||||||||
| EditHelp |
| ||||||||||||||
| ExcelNew |
| ||||||||||||||
| FavoritesPrint |
| ||||||||||||||
| Grid LayoutSave & Refresh | Grid Layout
| Grid Layout |
|
A hyperlink for the (Field Name). Clicking on the hyperlink opens the (what does it open) page. This field is not editable. Linked Database Field: ERPx_#####.#####.
A label to show (describe what this shows). This (defaults or is calculated from or to) (describe what it defaults/calculates from). This is (always, never, or conditionally(required to Save or Approve and/or Post)) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is never editable. Linked Database Field: ERPx_#####.#####.
A single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####.
This lookup contains all the values in the (EnumerationClassName) Enumeration Class.
A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####
This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).
A (text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.
A Yes/No lookup to identify whether or not the feature is turned on. The value defaults to "Yes" but can be changed at anytime.
A value of "Yes" means that...
A value of "No" means that...
Page Detail
(Grid Name) Grid
...
A single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####.
This lookup contains all the values in the (EnumerationClassName) Enumeration Class.
...
A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####
This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).
...
A Yes/No lookup to identify whether or not the feature is turned on. The value defaults to "Yes" but can be changed at anytime.
A value of "Yes" means that...
A value of "No" means that...
This is disabled when the Status is Ready to Post or Posted. | |||||||||
| 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 0.00 to Approve and/or Post the transaction.
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 'Last Reconciled Date' and <= the 'Transaction Cutoff' date. This date is not required to be in an open fiscal period. Database Field: ERPx_MFCheckbookReconciliation.BankBalanceDate | ||||||||
| 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. If the Checkbook selected is already on an open (unposted) reconciliation transaction, the message "This Checkbook is already assigned to Reconciliation [ReconciliationTransID]." will be displayed on Save. 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:
Database Field: ERPx_MFCheckbookReconciliation.CheckbookSK | ||||||||
| Cleared | A non editable text box that shows the sum of the transactions that are currently 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 transactions are tagged / un-tagged as "Included". 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. | ||||||||
| Cleared Adjustments | A non editable text box that shows 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". This is a calculated field that is not stored in the database. | ||||||||
| Cleared Deposits | A non editable text box that shows the sum of all the Deposits (Deposits and Transfer: Receipt 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". This is a calculated field that is not stored in the database. | ||||||||
| Cleared Payments | A non editable text box that shows the sum of all the Payments (Payments and Transfer: Sent 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". This is a calculated field that is not stored in the database. | ||||||||
| Last Reconciled | A non editable text box that shows the 'Bank Balances as of' value from the last reconciliation for the Checkbook being reconciled. This label and value are only visible for reconciliation transactions in a Status of "New" or "Approved". | ||||||||
| Last Reconciled Amt. | A non editable text box that shows the 'Reconcile to Balance' of the the last reconciliation for the Checkbook being reconciled, 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. | ||||||||
| 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. Database Field: ERPx_MFCheckbookReconciliation.Amount | ||||||||
| Status |
Database Field: ERPx_MFCheckbookReconciliation.TransactionStatusSK | ||||||||
Transaction Cutoff | A date field that identifies the 'date thru' used to select un-reconciled transactions in the grid. This is initially auto set by adding the number of days from the '#Cutoff Days Preference' to the 'Bank Balance as of' date. Once this value has been assigned and the transaction is Saved, it can be overwritten if necessary to any date >= 'Bank Balance as of' date. However, this will be automatically reset anytime the 'Bank Balance as of' changes. This date must be >= '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. Database Field: ERPx_MFCheckbookReconciliation.TransactionCutoffDate |
Page Detail
Un-Reconciled Checkbook Transactions Grid
The un-reconciled Checkbook Transactions grid is used to show all the checkbook transactions that are part of the reconciliation. For Reconcile transactions in a Status of "New" or "Approved" this grid will contain all the checkbook transactions, for the selected Checkbook, that occurred on or before the 'Transaction Cutoff' date, that have not been reconciled. For Posted transactions, this grid will contain all the checkbook transactions that were included on the reconciliation.
| 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 |
| Field 1 | Field 2 | Field 3 | ||||||||
| Date Field | The date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####. | |||||||||||
| Hyperlink | A hyperlink for the (Field Name). Clicking on the hyperlink opens the (what does it open) page. This field is not editable. Linked Database Field: ERPx_#####.#####. | |||||||||||
| Label | A label to show (describe what this shows). This (defaults or is calculated from or to) (describe what it defaults/calculates from). This is (always, never, or conditionally(required to Save or Approve and/or Post)) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is never editable. Linked Database Field: ERPx_#####.#####. | |||||||||||
| Lookup (from an Enumeration) | A single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.#####. This lookup contains all the values in the (EnumerationClassName) Enumeration Class. | |||||||||||
| Lookup (non Enumeration) | A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled. Linked Database Field: ERPx_#####.##### This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include). | |||||||||||
| Text Field | A (text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####. | |||||||||||
| Yes/No Lookup | A Yes/No lookup to identify whether or not the feature is turned on. The value defaults to "Yes" but can be changed at anytime. A value of "Yes" means that... A value of "No" means that... | |||||||||||
| Amount |
Database Field: ERPx_MFCheckbookTransaction.Amount | |||||||||||
| 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. Database Field: ERPx_MFCheckbookTransaction.ReconciledAmount | |||||||||||
Comment |
Database Field: ERPx_MFCheckbookTransaction.Comment | |||||||||||
| GL Date |
Database Field: ERPx_MFCheckbookTransaction.GLDate | |||||||||||
| Included | A Checkbox to show which transactions are included on the reconciliation. This can only be updated using the 'Include Transactions' and/or 'Remove Transactions' icon, for reconciliations in a Status of "New". If the checkbox is checked the associated transaction is included on the reconciliation, if it is unchecked then the transaction has not been included. This value is not stored in the database. | |||||||||||
| Payee Name | The name entered as the Payee on Payments. This is only populated for Payment records. This is most often the value in the 'Payment Name' field on the AP Vendor, Fishermen, or Loan account Address master file. Database Field: ERPx_MFCheckbookTransaction.PayeeName | |||||||||||
| Reconcile Group | Identifies what group the transactions belong to on a bank statement. The groups are assigned as follows:
This is a calculated field that is not stored in the database. | |||||||||||
| Reference |
Database Field: ERPx_MFCheckbookTransaction.Reference | |||||||||||
| Trans. Date |
Database Field: ERPx_MFCheckbookTransaction.TransactionDate | |||||||||||
| Trans. Type |
Database Field: ERPx_MFCheckbookTransaction.TransactionTypeSK | |||||||||||
| Transaction |
Database Field: ERPx_MFCheckbookTransaction.TransactionID |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...