Cash Management Setup Check List

Step No.	Step Description	Required?	Window Name(s)
Step 1	Set the Allow Reconciliation Accounting Payables Option.	Required	Payables responsibility: Payables Options
Step 2	Define your bank accounts and assign accounts.	Required	Payables or Receivables responsibility: Banks
Step 3	Set profile options.	Required	System administrator responsibility: System Profile Values
Step 4	Define system parameters.	Required	System Parameters
Step 5	Define bank transaction codes.	Optional	Bank Transaction Codes
Step 6	Set up the Bank Statement Open Interface.	Optional
Step 7	Set up the Reconciliation Open Interface.	Optional
Step 8	Set up the Forecasting Open Interface, including the Forecast Selection Criteria Descriptive Flexfield.	Optional	(multiple windows)
Step 9	Define cash forecasting templates.	Conditionally Required	Cash Forecast Templates
Step 10	Set up sequential document numbering for bank statements.	Optional	System Administrator responsibility: (multiple windows)
Step 11	Define request sets.	Optional	Request Set
Step 12	Define descriptive flexfields.	Optional	System Administrator responsibility: multiple windows

Automatic Reconciliation of Bank Statements

AutoReconciliation program is used for automatic reconciliation of any bank statement in Oracle Cash Management. There are three methods to run the program:

• AutoReconciliation: Used to reconcile the bank statement that has already been entered in Cash Management.
• Bank Statement Import: Used to import an electronic bank statement after loading the bank file with a SQL*Loader script.
• Bank Statement Import and AutoReconciliation: Used to import the electronic bank statement after loading the bank file and then reconcile a bank statement in the same run.

The AutoReconciliation Execution Report is produced automatically and is used to review the Autoreconciliation results and to identify any reconciliation errors that need to be corrected. You can run this report also 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.

Bank Statements AutoReconciliation Setup

Incomplete Bank Statements SQL Query

select
statement_number,
statement_date

from
ce_statement_headers

where
nvl(statement_complete_flag,'N')<>'Y'