Automatic Reconciliation of Bank Statements

AutoReconciliation program is used for automatic reconciliation of any bank statement in Oracle Cash Management. There are three methods to run the program:

• AutoReconciliation: Used to reconcile the bank statement that has already been entered in Cash Management.
• Bank Statement Import: Used to import an electronic bank statement after loading the bank file with a SQL*Loader script.
• Bank Statement Import and AutoReconciliation: Used to import the electronic bank statement after loading the bank file and then reconcile a bank statement in the same run.

The AutoReconciliation Execution Report is produced automatically and is used to review the Autoreconciliation results and to identify any reconciliation errors that need to be corrected. You can run this report also whenever needed. You can also review reconciliation errors online.

After you automatically reconcile a bank statement and correct any reconciliation errors, you can run the Bank Statement Detail Report or use the View Bank Statements window to review reconciled and unreconciled statement lines. If lines remained unreconciled, you can:

• Update the bank statement and rerun the Automatic Reconciliation.

• Reconcile the statement lines manually.

Once you have finished reviewing and reconciling, you can transfer any Cash Management generated journal transactions to Oracle General Ledger from Oracle Receivables and Oracle Payables.

Bank Statements AutoReconciliation Setup