Reconciling Bank Statements Automatically (Oracle Cash Management User's Guide)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

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:

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 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

9. Submit your request.

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.

To submit the programs from the Reconcile Bank Statements window or the Bank Statement Interface 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.

5. Submit your request.

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.

Reconciling Bank Statements Automatically

To reconcile a bank statement automatically:

To submit the programs from the Reconcile Bank Statements window or the Bank Statement Interface window:

See Also