You can use the AutoReconciliation program to automatically reconcile any bank statement in Oracle Cash Management. There are three versions of the program:
AutoReconciliation: Use this program to reconcile any bank statement that has already been entered in Cash Management.
Bank Statement Import: Use this program to import an electronic bank statement after loading the bank statement file into the Bank Statement Open Interface tables. See: Importing Bank Statements.
Bank Statement Import and AutoReconciliation: Use this program to import and reconcile a bank statement in the same run.
You can run these programs from the Submit Request window, the Reconcile Bank Statements window, or the Bank Statement Interface window. You can also import and automatically reconcile a bank statement from the Bank Statement Loader program, by using the option of Load, Import and AutoReconciliation. See: Loading the Bank Statement Open Interface Tables
After you run the program, you can review the AutoReconciliation Execution Report to identify any reconciliation errors that need to be corrected. This report is produced automatically, or you can run it 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 AutoReconciliation program.
Reconcile the statement lines manually.
Once you have reviewed your reconciliation results, you can transfer the accounting entries to your general ledger from Oracle Payables, Oracle Receivables, and Oracle Cash Management. If you use Oracle General Ledger, you can reconcile you General Ledger cash account balance to your bank account balance by running the GL Reconciliation Report.
Define your Reconciliation options. See: About Bank Reconciliation and System Parameters.
Note: If you do not use Oracle Receivables AutoLockbox, and your bank statement includes direct deposits or bank transfers, you must create the related receipts manually in Receivables before you can reconcile them automatically in Cash Management. See: Using AutoLockbox and Running AutoLockbox.
Navigate to the Submit Request window.
Note: Alternatively, you may submit the request directly from the Reconcile Bank Statements or Bank Statement Interface windows by selecting AutoReconciliation from the Oracle Applications Tools menu.
Select the AutoReconciliation program.
Enter the Bank Branch for the statements that you want to reconcile. This field is required.
Enter the Bank Account Number for the statement that you want to reconcile. If you do not enter a bank account number, you reconcile statements for the entire bank branch.
In the following fields, enter a statement number or select one from the list of values:
Statement Number From: the beginning statement number in the range of statements to be reconciled.
Statement Number To: the ending statement number in the range.
Enter dates in the following fields:
Statement Date From: the opening day of the bank statement period.
Statement Date To: the closing day of the bank statement period.
GL Date: (Required). The default date for all General Ledger journal entries generated by AutoReconciliation. The date must be in an open or future-enterable Payables or Receivables period.
Select an Organization or leave blank to reconcile transactions from all organizations.
Select a Receivable Activity and Payment Method to create Miscellaneous Receipts for differences that AutoReconciliation encounters when matching remittance batches or NSF transactions within tolerances.
Specify how to handle any NSF or rejected receipts that are in your bank statement. Choose one of the following actions:
No Action to resubmit the check or request for transfer later.
Reverse to reopen the invoice.
Debit Memo Reverse to create a debit memo that replaces the item closed by the original receipt.
Submit your request.
When the concurrent request is finished, review the AutoReconciliation Execution Report for reconciliation errors. Also review the Bank Statement Detail Report, which shows reconciled and unreconciled statement lines.
If any statement lines remained unreconciled, or you need to correct a reconciled line, use the Reconcile Bank Statement Lines window to manually reconcile those lines.
Transfer the accounting transactions you created during reconciliation for Payables and Receivables to your General Ledger.
Review the GL Reconciliation Report.
Select AutoReconciliation from the Oracle Applications Tools menu. The Submit Automatic Reconciliation window appears.
Euro fixed exchange rates default regardless of Foreign Currency Bank system parameters setup.
Cash Management does not select exchange rates for foreign bank statements that contain partial or complete exchange rates.
When you submit from the Reconcile Bank Statements window, then the Bank Account Number, Statement Number From, Statement Number To, Statement Date From, and Statement Date To fields appear on the Submit Automatic Reconciliation window. Also, the only available option from this window is to Reconcile Only. When you submit from the Bank Statement Interface window the only available options are to Import or Import and Reconcile.
Select your Options. You may choose to Import, Reconcile Only, or Import and Reconcile.
Optionally, change the default entries for Bank Account Number, Statement Number From, Statement Number To, Statement Date From, and Statement Date To fields.
Select the GL Date, Organization (optional), Receivable Activity, Payment Method, and NSF Handling.
Submit your request.
When the concurrent request is finished, review the AutoReconciliation Execution Report for reconciliation errors. Also review the Bank Statement Detail Report, which shows reconciled and unreconciled statement lines.
If any statement lines remained unreconciled, or you need to correct a reconciled line, use the Bank Statement Lines window to manually reconcile those lines.