Oracle 11i 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
• Set Up Steps in Accounts Receivable
• Set Up Steps in Cash Management
• Set Up Bank Transaction Codes
• Exercises
  • Set up a Cash Clearing Account
  • Define a Bank Payment
  • 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