_{WARNING: Records cannot be recovered once they are deleted!}

 The bolded view is the default view, which will determine the view will automatically display in when opened. 

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. 

• If this amount is 0.00 then the Checkbook is in balance with the bank.
• If this amount is positive, a positive adjustment is necessary before the Checkbook will balance to the bank balance.
• If this amount is negative, a negative adjustment is necessary before the Checkbook will balance to the bank balance.

This is a calculated field that is not stored in the database.

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

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.

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:

• [Checkbook ID] for Checkbooks in the Home Currency
• [Checkbook ID] - ([Checkbook Currency]) for checkbooks in a foreign currency

Database Field: ERPx_MFCheckbookReconciliation.CheckbookSK

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.

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.

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.

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.

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

A single-select standard lookup to assign the Transaction Status. This defaults to "New" but can be changed to "Approved" or "Ready to Post". This defaults to 'New' and is always required. This field is editable until the transaction is 'Ready to Post'. Updating the Status does the following:

• New: This is the default value. While in the Status of New all editable fields are open for edit, no posting/approval validations are performed, GL Dates are not assigned, and journal entries are not created. If the transaction was moved back from Approved to New, the GL Date will be assigned and a Journal Entry will exist.  
• Approved: Performs all the data validations required to post the transaction. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled except for the Status lookup (and any fields that are always editable), journal entries are created/updated, journal ID's are assigned to the journal entry, and blank 'GL Dates' are assigned.   
• Ready to Post: Runs the Approval validations. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled with the exception any fields that are always editable and updates the Transaction Status to "Posted".

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

Opens the 'Edit Amounts' window to allow users to change the 'Cleared Amount' for a transaction. 

 Because the Amounts for 'Deposits' and 'ACH Check Batches' are summarized from child records, the 'Cleared Amount' cannot be edited for 'Deposits' and 'ACH Check Batches'.

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

Shows the Comment entered for the transaction or transaction line. 

Database Field: ERPx_MFCheckbookTransaction.Comment

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.

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

Identifies what group the transactions belong to on a bank statement. The groups are assigned as follows:

• Deposit: for Deposits and Transfer: Receipt transactions
• Payment: for ACH, Checks, Draft, Manual and Wire payments and Transfer: Sent transactions
• Adjustment: for Adjustment transactions

This is a calculated field that is not stored in the database.

Identifies the Reference entered for the transaction. 

Database Field: ERPx_MFCheckbookTransaction.Reference

Identifies the date of the transaction.

Database Field: ERPx_MFCheckbookTransaction.TransactionDate

Transaction Types are used to differentiate unique types transactions within the system. Transactions with the same Transaction Type share the same record view pages and business rules. Transaction Types can be further classified using Transaction Classes. Every transaction in the system is assigned a Transaction Type.

Database Field: ERPx_MFCheckbookTransaction.TransactionTypeSK