Oracle Cash Management
Course
In London-City
Description
-
Type
Course
-
Location
London-city
This course is designed to give delegates the knowledge to set up and use Oracle Cash Management. They 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. 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 AccountSetting up Receivables ActivitiesDefining a Receipt ClassSetting up Cash ManagementSetting up Bank Transaction CodesEntering Payments - Cheque RunEntering Receipt BatchesImporting a Bank Statement FileAutomatically Reconciling to an Imported Bank StatementManually Reconciling Remaining Statement LinesManually Entering a Bank StatementDefining a Forecast TemplateGenerating a Forecast
Facilities
Location
Start date
Start date
About this course
A general awareness of the Accounts Payable and Accounts Receivable functions in the delegate's own organization would be advantageous.
Reviews
Subjects
- Cash Management
- Import
- Forecasts
Course programme
Course Contents - DAY 1Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Cash Management Business Functions
- Bank Reconciliation
- Cash Forecasting
- Cash Transaction Sources
- The Need for Cash Management
- Overview of Bank Reconciliation
- Reconciliation Process
- 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
- 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
- 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
- Enter a Bank Statement Manually
- Enter Bank Statement Lines
- Update a Bank Statement
- Exercises
- Manually Enter a Bank Statement
- Receipt Exceptions
- Recalculate
- 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
- 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
Oracle Cash Management