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