Importing Bank Statements
If you load electronic bank statements using SQL*Loader scripts, you must import the bank statement information to the Cash Management Bank Statement tables before you can reconcile the statement detail lines. You can use Cash Management's AutoReconciliation program to:
- Validate the information in the bank statement open interface tables.
- Import the validated bank statement information.
- Submit a request to perform an automatic reconciliation after the import process completes.
To import a bank statement with no AutoReconciliation:
1. Load your electronic bank statement into the bank statement open interface tables.
2. Navigate to the Submit Request window.
Note: Alternatively, you may submit the request directly from the Bank Statement Interface window by selecting AutoReconciliation from the Oracle Applications Special menu.
3. Select the Bank Statement Import program.
4. Enter the Bank Account Number for the statement you want to import.
5. Specify the range of statement numbers in the Statement Number From and Statement Number To fields.
6. 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. The date must be in an open or future-enterable Payables or Receivables period.
7. Submit your request. The Bank Statement Import program validates the data in the bank statement interface files, imports the validated information, and prints an AutoReconciliation Execution Report.
8. Review and correct any import validation errors, then repeat the steps above.
To import a bank statement and perform an automatic reconciliation in the same request:
1. Navigate to the Submit Request window.
2. 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 Applications Special menu.
3. Enter the Bank Account Number for the statement you want to import.
4. Specify the range of statement numbers in the Statement Number From and Statement Number To fields.
5. Specify dates for the Statement Date From, Statement Date To, and GL Date fields.
6. Select a Receivable Activity and a payment method to create Miscellaneous Receipts for differences that AutoReconciliation encounters when matching remittance batches within tolerances.
7. 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
8. Submit your request. The AutoReconciliation program validates the data in the bank statement interface files, imports the validated information, 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.
9. 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.
See Also
About Bank Statement Validation
Reviewing Bank Statement Interface Errors
Correcting Bank Statement Interface Errors
Loading Bank Statement Open Interface
Reconciling Bank Statements Automatically
About Bank Statement Open Interface
Multi-Currency Handling
Archiving and Purging Imported Bank Statements