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.

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.