Oracle R12 Cash Management

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