Oracle Cash Management Key Concepts (High level List)

Cash Management Key Concepts
(Below Topics will be explained in this blog in detail in future posts)

Knowing About:

• Cash Management Over View
• Bank Model 

1	Key concepts:
		Reconciling Bank Accounts
		Cash Forecasting
		Cash positioning
		Cash Pools
2	Cash Management Security
		Security model
		Creating security profiles
		Creating security grants
3	Setting Up Cash Management:
		Setup General Ledger
		Set up related Applications: Ap, AR, Treasury, Payroll etc
		Setup Oracle Cash Management
4	Creating Bank Accounts
		Defining banks
		Defining bank branches
		Creating bank accounts
		Defining bank transactions codes
		Defining bank account signing authorities
5	Bank Transfers
		Describing how to set up bank transfers
		Creating a bank transfer
		Settling a bank transfer
		Creating a bank account transfer template
		Creating bank statement cash flows
6	Reconciling Bank Statements
		Reconciling bank statements manually and automatically
		Recording exceptions and reversals
		Reconciling corrections and adjustments to bank errors
		Clearing and unclearing transactions
		Transferring bank reconciliation transactions to your general ledger
		Explaining archiving and purging
7	Cash Pools
		Creating cash pools
		Viewing cash pools
		Updating cash pools
8	Cash Positioning
		Creating cash positioning worksheets
		Generating cash positions from worksheets
		Generating a cash leveling proposal
		Viewing cash position results
		Exporting cash position results to your spreadsheet application
		Viewing cash positions in Discoverer
9	Cash Forecasting
		Defining a cash forecast template
		Generating a cash forecast
		Modifying a cash forecast
		Exporting a cash forecast to your spreadsheet application
		Identifying implementation considerations
		Using cash forecasting reports
10	Accounting Events
		Describing the accounting flow in Oracle Cash Management
		Describing the key concepts of Oracle Sub ledger Accounting
		Describing how to set up Oracle Sub ledger Accounting for Cash Management
		Creating manual journal entries
11	Balances and Interest
		Maintaining bank account balances
		Creating and assigning interest rate schedules to bank Accounts
		Creating reports for interest calculations and account balances
12	Cash Management Accounting Entries
13	Oracle Cash Management Period end Closing
14	Important Reports to Run From Time to time

 

Automating Bank Reconciliation with Cash Management

How Oracle Cash management Works in Automating Bank Reconciliation:

Step 1: Work with Bank for Automatic reconciliation process

·         Let your bank know that you plan to automate their reconciliation process. Do the paper work & their approval process. Obtain certain things from bank

• A Sample File
• Transaction Codes 
•  Bank Statement Mapping

Step 2: Set up Bank Account & Branch name in Accounts Payable Module

Step3:  Setup Transaction Codes Provided by Bank in Cash Management Module

Step4: Map your bank statement Information (from Bank) against the right accounts in Oracle

Step5: Bring Sample file into Oracle

• Bank Statement Loader Program: Bring your technical guys to use this program & bring this files into Oracle 
•  Bank Statement Import Program: To bring this file information directly into Oracle Cash Management

Step 6: Run Auto Reconciliation Program

• The Program reconciles the imported Bank Statement lines to the outstanding AP & AR transactions 
• If the program doesn’t find a match, it marks the bank statement line with an error and allows you to manually address that transaction 
•  The Program creates an auto reconciliation execution report that shows the exceptions & Provides descriptive reasons why the line was not able to be reconciles automatically