Reconciling Bank Statements Automatically
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 file with a SQL*Loader script. See: Importing Bank Statements.
- Bank Statement Import and AutoReconciliation: Use this program to import and reconcile a bank statement in the same run.
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 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.
To reconcile a bank statement automatically:
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 Oracle Receivables before you can reconcile them automatically in Cash Management. For more information on Automatic Lockbox, see your Oracle Receivables User's Guide.
2. 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 Special menu.
3. Select the AutoReconciliation program.
4. Enter the Bank Account Number for the statement you want to reconcile.
5. Enter a statement number range in the following fields:
- 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.
6. 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: 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.
7. Select a Receivable Activity and Payment Method to create Miscellaneous Receipts for differences that AutoReconciliation encounters when matching remittance batches within tolerances.
8. Specify how to handle any NSF or rejected receipts that are in your bank statement. Choose:
- No Action: to resubmit the check or request for transfer later
- Reverse: to reopen the invoice
10. 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.
11. 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.
1. Select AutoReconciliation from the Oracle Applications Special menu. The Submit Automatic Reconciliation window appears.
Note: When you submit from the Reconcile Bank Statements window, the Bank Account Number, Statement Number From, Statement Number To, Statement Date From, and Statement Date To fields do not 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.
2. Select your Options. You may choose to Import, Reconcile Only, or Import and Reconcile.
3. Optionally, change the default entries for Bank Account Number, Statement Number From, Statement Number To, Statement Date From, and Statement Date To fields.
4. Select the GL Date, Receivable Activity, Payment Method, and NSF Handling.
6. 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.
7. 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.
See Also
Submitting a Request
Reviewing Reconciliation Errors
Reviewing Reconciled Transactions
Reconciling Bank Statements Manually
About Bank Statement Validation
Multi-Currency Handling
Multi-Currency Matching
Importing Bank Statements
Recording Exceptions
Entering Reversals
Cash Management Reports
Setting Up Oracle Cash Management
Defining System Parameters
Matching Bank Statement Lines with Transactions
Entering Bank Statements Manually