Oracle R12 Cash Management

Course Contents - DAY 1

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: OVERVIEW OF ORACLE CASH MANAGEMENT

• Cash Management Business Functions
• Bank Reconciliation
• Cash Forecasting
• Cash Transaction Sources
• The Need for Cash Management

Session 2: BANK RECONCILIATION

• Overview of Bank Reconciliation
• Reconciliation Process

Session 3: CASH MANAGEMENT SET UP

• Set Up Steps in Accounts Payable
• Set Up a Cash Clearing Account
• Define a Bank Payment
• Set Up Steps in Accounts Receivable
• Set Up Steps in Cash Management
• Set Up Bank Transaction Codes
• Exercises
• Set up a Cash Clearing Account
• Set up Receivables Activities
• Define a Receipt Class
• Set Up Oracle Cash Management
• Set Up Bank Transaction Codes

Session 4: RECONCILIATION

• Import a Bank Statement File
• Automatically Reconcile to an Imported Bank Statement
• Manual Reconciliation of Remaining Statement Lines
• Exceptions
• Reconcile Journal Entries
• Reconcile Payments
• Reconcile Receipts
• Reconcile Other Transactions
• Create a Miscellaneous Transaction
• Create a Receipt
• Create a Payment
• Post to the General Ledger
• Reconciliation Open Interface
• Reconcile Tolerances
• Unreconcile Lines
• Delete Statement Lines
• Clearing
• Exercises:
• Enter and Submit Payment Batch
• Format and Confirm Payment Batch
• Enter Receipt Batches
• Import a Bank Statement File
• Automatically Reconcile to Imported Bank Statement
• Create a Miscellaneous Activity
• Reconcile Receipts
• Reconcile a GL Journal Entry
• Reconcile a Manually Raised Cheque
• Manual Reconciliation of Remaining Statement Lines

Session 5: BANK STATEMENT INTERFACE

• Bank Statements
• Bank Statement Load
• Bankline Statement File Format
• Field Mapping
• Set Up Steps for SQL*Loader
• Set Up Transaction Codes
• SQL*Loader Import Script

Session 6: ENTER AND UPDATE MANUAL BANK STATEMENTS

• Enter a Bank Statement Manually
• Enter Bank Statement Lines
• Update a Bank Statement
• Exercises
• Manually Enter a Bank Statement
• Receipt Exceptions
• Recalculate

Session 7: CASH FORECASTING

• Create a Forecast Template
• Generate a Forecast
• Drill Down From a Forecast
• Export a Forecast
• Create a New Forecast by Making a Duplicate
• Amend a Template
• Delete a Forecast
• Delete a Forecast Template
• Exercises
• Define a Forecast Template
• Generate a Forecast

Session 8: CASH MANAGEMENT INTERFACES

• Reconciliation Open Interface
• Forecasting Open Interface

Session 9: INQUIRIES AND REPORTS

• Inquiries
• Inquire on a Bank Statement
• Inquire on Available Transactions
• Inquire on Payments
• Inquire on Receipts
• Inquire on Bank Transmissions
• Reports
• Bank Statement Reports
• Cash Forecasting Reports
• Bank Reconciliation Reports
• Exercises
• Run Inquiries
• Run Reports