If you load electronic bank statements into the Bank Statement Open Interface tables, you must import the bank statement information into the Cash Management Bank Statement tables before you can reconcile the statement detail lines.
Oracle Cash Management's Bank Statement Import program validates the information in the Bank Statement Open Interface tables and imports the validated bank statement information. If you import bank statements from bank accounts that are used by Oracle Treasury, the Bank Statement Import program also updates the bank account balances seen in Oracle Treasury. Additionally, the Bank Statement Import program can launch the AutoReconciliation program to perform an automatic reconciliation after the import process completes.
If you load intra-day bank statements, you must use the Intra-Day Bank Statement Import program to validate and import the information into the Cash Management Intra-Day Bank Statement tables.
After you have successfully imported the intra-day bank statements, you can include the information in your cash positioning in Oracle Treasury. Since intra-day information is not used for reconciliation, you cannot view the imported intra-day bank statements in Cash Management windows or reports. However, you can archive or purge the bank statements. When you import multiple intra-day bank statements within the same day, the Intra-Day Bank Statement Import program deletes the existing bank statement before importing the new bank statement.
You can use one of several ways to import data from the Bank Statement Open Interface tables into the Bank Statement tables.
Navigate to the Submit Request window.
Select the Bank Statement Loader program.
Choose the option of Load and Import.
Specify the other parameters as appropriate.
Submit your request.
Navigate to the Submit Request window.
Select the Bank Statement Loader program.
Choose the option of Load, Import and AutoReconciliation.
Specify the other parameters as appropriate.
Submit your request.
Navigate to the Submit Request window.
Select the Bank Statement Import program.
Note: Alternatively, you may submit the request directly from the Bank Statement Interface window by selecting AutoReconciliation from the Oracle E-Business Tools menu.
Enter the Bank Account Number for the statement you want to import.
Specify the range of statement numbers in the Statement Number From and Statement Number To fields.
Specify dates for the Statement Date From, Statement Date To, and GL Date fields.
The GL Date is the default date for all General Ledger journal entries generated by AutoReconciliation.
Submit your request. The Bank Statement Import program validates the data in the Bank Statement Interface tables, imports the validated information, and prints an AutoReconciliation Execution Report.
Review and correct any import validation errors, then repeat the steps above.
Navigate to the Submit Request window.
Select the Bank Statement Import and AutoReconciliation program.
Note: Alternatively, you may submit the request directly from the Reconcile Bank Statements window or Bank Statement Interface window by selecting AutoReconciliation from the Oracle E-Business Tools menu.
Enter the Bank Account Number for the statement you want to import.
Specify the range of statement numbers in the Statement Number From and Statement Number To fields.
Specify dates for the Statement Date From, Statement Date To, and GL Date fields.
Select a Receivable Activity and a 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 transactions that are in your bank statement. Choose:
No Action to handle manually.
Reverse to reverse receipt and reopen the invoices.
Debit Memo Reverse to create a debit memo that replaces the item closed by the original receipt.
Submit your request. The AutoReconciliation program validates the data in the Bank Statement Open Interface tables, imports the validated information, reconciles the bank statement, and prints an AutoReconciliation Execution Report.
Additional Information: You can get an AutoReconciliation Execution Report at any time by submitting a request using the Submit Request window.
Review and correct any import validation errors, then repeat steps above. Once any import validation errors have been corrected, the AutoReconciliation program submits a request to reconcile the bank statement.
Navigate to the Submit Request window.
Select the Intra-Day Bank Statement Loader program
Choose the option of Load and Import.
Specify the other parameters as appropriate.
Submit your request.
See: To Submit the Intra-Day Bank Statement Loader Program
Navigate to the Submit Request window. Alternatively, you may submit the request directly from the Bank Statement Interface window by selecting AutoReconciliation from the Tools menu.
Select the Intra-Day Bank Statement Import program.
Enter the Bank Account Number for the statement you want to import.
Specify the range of statement numbers in the Statement Number From and Statement Number To fields. The list of values displays only intra-day bank statements that are within the range.
Specify dates for the Statement Date From and Statement Date To fields.
Submit your request. The Intra-Day Bank Statement Import program validates the data in the Bank Statement Interface tables, imports the validated information, and prints an AutoReconciliation Execution Report.
Review and correct any import validation errors, then repeat the steps above.