0345 4506120

Oracle Cash Management

This Oracle Cash Management course is designed for implementation team members, managers and end users of Oracle Cash Management.

Who will the Course Benefit?

This Oracle Cash Management course is designed for implementation team members, managers and end users of Oracle Cash Management.

Learning Objectives

By the end of this course delegates will have the skills to carry out the initial set up steps and to use Oracle Cash Management for daily bank reconciliation and the creation and running of cash forecasts. They will also understand the integration between Oracle Cash Management and Oracle Payables and Receivables.

The delegate will practise:

  • Setting up a Cash Clearing Account
  • Setting up Receivables Activities
  • Defining a Receipt Class
  • Setting up Cash Management
  • Setting up Bank Transaction Codes
  • Entering Payments - Cheque Run
  • Entering Receipt Batches
  • Importing a Bank Statement File
  • Automatically Reconciling to an Imported Bank Statement
  • Manually Reconciling Remaining Statement Lines
  • Manually Entering a Bank Statement
  • Defining a Forecast Template
  • Generating a Forecast

Pre-Requisites

A general awareness of the Accounts Payable and Accounts Receivable functions in the delegate's own organization would be advantageous.

Course Content

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

Oracle Cash Management Training Course

View Course Contents - DAY 1 (continued)

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

Oracle Cash Management Training Course

View Course Contents - DAY 1 (continued)

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

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include