Delete

 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

Favorites

Grid Layout

Help

Inquiry 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

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

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 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

Created By

Last Updated

Last Updated By

Reconcile to Balance

Identifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation was targeting.

Status

Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionStatusSK

Transaction

Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionID