Bank statement reconciliation

Statement reconciliation provides a summary view of all open bank statements and gives information about the reconciliation status.

Reconciliation types

This table shows the types of reconciliation in Cash:

Reconciliation type Description
Reconciliation to Forecast Reconcile bank statements to cash forecast categories for a specific date. Optionally, journal entries can be created to post to Global Ledger.
Reconciliation to Cash Ledger Reconcile bank statement lines to cash ledger transactions that originated from Payables, Receivables, or Cash. Because the journal entries have been posted from previous processes, no journal entries are created unless there is a reconciliation variance.
Reconciliation to Other System Reconcile bank statements to transactions that are from a non-Infor system. You can manually create non-cash ledger transactions using an import process such as the Infor Spreadsheet Designer.

See Manually creating non-cash ledger transactions.

Reconcile by Amount

The Reconcile by Amount option enables reconciliation based solely on transaction amounts rather than standard line match criteria. This option is intended for use with small data sets where amount-based matching is appropriate.

When you select Reconcile by Amount:
  • The Line Match Field is automatically populated with the default value Reconcile by Amount <BankReconciliationMatchRule>.
  • You can modify the Line Match Field Value if required.
  • If Line Match Field is cleared, the field is automatically reset to the default value.

When the Reconcile by Amount option is cleared, the Line Match Field is also cleared. This behavior applies to both the Statement Line Match Field and the System Line Match Field.

Reconcile by Amount warnings and confirmations

When you select Reconcile by Amount, a warning message is displayed to indicate that this option overrides standard line match behavior and should be used only for small data sets.

When you save a reconciliation configuration with Reconcile by Amount enabled, a confirmation message is displayed to ensure that you understand the impact of using amount-based reconciliation.
Note: Reconcile by Amount overrides the standard Line Match Field behavior and reconciles transactions based on amount only. This option is intended for small data sets.

Actions

This table shows the actions that are available from the Actions menu:

Actions Description
Clear All Reconciliations Clear the reconciliation for bank statements that are in Reconciled status. Bank statement lines for the selected bank statement are included.
Close Statement When a statement is closed, it cannot be modified. This option is available only after the status of the bank statement is changed to Reconciled. A closed statement can be reopened.
Release Cash Ledger Transactions Release cash ledger transactions for a bank statement line. Cash ledger transactions that are created from bank statement lines are automatically reconciled.
Release Cash Ledger Transactions for an Account Release cash ledger transactions for all lines of a bank account. Cash ledger transactions that are created from bank statement lines are automatically reconciled.
Update Cash Code Position Update cash code cash positions and view cash code balances and cash code posting balances in Global Ledger.
Delete Open Reconciliation Transactions Remove unmatched cash and non-cash ledger transactions that are loaded into the reconciliation queue.
Create Reconciliation Balances Report Run the report for individual statements
Reconciling bank statement variances When amount differences exist between a bank statement line and the corresponding transaction in the other Infor system, the variance amounts must be posted to the variance GL account.