Oracle R12 Cash Management
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
1 Day
-
Start date
Different dates available
Delegate pack consisting of course notes and exercises Manual Experienced Instructor Refreshments
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Subjects
- Management
- Accounts
- Forecasting
- IT
- Import
- Cash Management
- IT Management
Course programme
Introduction
This course is designed to give individuals the knowledge to set up and use Oracle Cash Management.
Delegates will learn how to import bank statements, reconcile them and post updated information to the Oracle General Ledger.
Delegates will also learn how to create cash forecasts.
Pre-Requisites
- A general awareness of the functions of Accounts Payable and Accounts Receivable in the delegates own organisation would be beneficial.
Who Should Attend
- Designed for Implementation Team Members, Managers and End Users of Oracle Cash Management
Course Objectives
Candidates will practice the following:
- 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
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
- 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
- Unreconciled 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
Additional information
- Recommended for Implementation Team Members, Managers and End Users
- Designed to give individuals the knowledge to set up and use Oracle Cash Management
- Delegates will gain knowledge and learn how to import bank statements
- GUARANTEED LOWEST PRICE IN THE INDUSTRY
- Develop skills and learn how to create cash forecasts
- Courses delivered by world class Oracle training instructors in luxury venues
- Oracle R12 Cash Management includes material and manuals
- Book Online or Call 01344 203999 to speak to a Oracle training advisor today
Oracle R12 Cash Management