Cash Manager in Microsoft Dynamics SL 7.0

Code: 8829
Course duration: 1 days
Price:

8829: Cash Manager in Microsoft Dynamics SL 7.0 (1 Day)

About this Course

This one-day course explores the features and benefits of the Microsoft Dynamics SL Cash Manager module. Students discuss how to classify transactions by account type, view cash balances, reconcile bank accounts, and project cash flows.

Understanding these topics allows students to access current cash balance information instantly while entering transactions, which may help with tracking what is in the bank on a daily basis.

The course also includes: transfering funds between different cash accounts, managing money effectively while accurately displaying critical information at a moment's notice, reconciling bank statements according to schedule and business demands, and assembling daily cash balances from subsidiary databases into a "consolidated" database, so cash account balances for the entire organization are available to view in one application.

Students reconcile at the check/deposit level and enter transactions that affect cash but are not captured in other Microsoft Dynamics SL modules, such as bank service charges, wire transfers, or other cash transaction types. This is an essential course for all end-users, consultants, and implementers who want to learn about this core module of the Microsoft Dynamics SL Financial system.

Classroom training provides in-depth learning via hands-on interaction. Through demonstrations, presentations, and classroom activities, students can receive hands-on experience with instruction from our certified staff and increase productivity and efficiency by learning tips and tricks from product specialists.

Audience Profile

Cash Manager training is recommended for anyone who plans to implement, use, maintain, consult, or support Microsoft Dynamics SL. The course is targeted toward data entry clerks, administrators, office managers, CEOs, and consultants who need to understand the technical aspects of Cash Manager and gain foundational knowledge of the application functionality.

At Course Completion

Course completion objectives are:

  • Ledger accounts.
  • View the results of the transactions and Daily Cash Balances.
  • Identify the appropriate use for the Reconciling options for the batches entered in Cash Account Transactions.
  • Perform the Bank Reconciliation process to reconcile Cash Manager balances to a bank statement.
  • Reconcile checks and deposits from Accounts Payable, Payroll, and Accounts Receivable.
  • Set up the Bank Reconciliation Import function.
  • Perform Cash Forecasting using what-if transactions and scenarios.
  • Troubleshoot and correct operator input errors including incorrect period to post, entries to incorrect accounts, and understanding transactions created in related modules and their effect on the Cash Manager account balances.

Course Outline

Module 1: Overview

The purpose of this chapter is to introduce the Cash Manager module of Microsoft Dynamics( SL product and training course. This chapter introduces the windows and processes that are used to complete the accounting cycle in Cash Manager.Also, it is important to note that this chapter is optional and can be skipped at the instructor's discretion. If the instructor feels that each student's background provides sufficient experience in these topic areas, then the instructor reserves the right to skip this chapter.

Lessons

  • Course Description
  • Module Overview
  • Cash Manager Process Flow
  • Other Features

After completing this chapter, students will be able to:

  • Understand the goals of this course.
  • See how the General Ledger module fits into the suite of available modules for the Microsoft Dynamics SL system.
  • Follow the flow of transactions through the General Ledger.

Module 2: Active Overview

This chapter examines the core processes used in the General Ledger module. The chapter introduces each step in the accounting cycle, briefly discusses its purpose, and primary features, and focuses on its function in the accounting cycle. It is not intended to provide a detailed primer on each of these topics.This chapter is optional and can be skipped at the instructor's discretion. If the instructor feels that each student's background provides sufficient experience in these topic areas, then the instructor reserves the right to skip this chapter.

Lessons

  • Establishing a Cash Account
  • Cash Transactions
  • View Cash Account Balances
  • Bank Reconciliation

After completing this chapter, students will be able to:

  • Identify the basic processes required to create a Cash Account.
  • Understand the processes involved in the Cash Manager accounting cycle.
  • View the results of transactions.

Module 3: Cash Account Maintenance

This chapter examines the setup of cash manager accounts. The purpose of this chapter is to describe the information required for accounts and discuss the criteria for tracking a cash account in the Cash Manager module. The importance of establishing a correct beginning balance for an account is discussed.

Lessons

  • Procedures for Maintaining Cash Accounts
  • Cash Account Maintenance
  • Establish beginning balances

Lab : Establish a New Cash Account

  • Create a New Account in the Chart of Accounts and add the account to track in Cash Manager.

After completing this chapter, students will be able to:

  • Understand which accounts should be tracked in Cash Manager.
  • Define accounts in Cash Manager.
  • Determine the beginning balance for an account.
  • Understand the purpose of the Cash Manager Integrity Check.

Module 4: Entry Types

This chapter examines the setup of Entry Types. The reasons for creating various entry types and the specific uses of system defined entry types are discussed. This chapter also explores the impact of the settings for an entry type in the data entry process.

Lessons

  • Procedures for Maintaining Entry Types
  • Types of Entry Types
  • Entry Type Maintenance window

Lab : Define Entry Types

  • Create new Entry Types for tracking miscellaneous transactions

After completing this chapter, students will be able to:

  • Understand how entry types are used.
  • Define Entry Types for tracking transactions.

Module 5: Cash Account Transactions and Transfers

This chapter discusses the fields and features of the Cash Transaction and Transfers windows. This chapter examines how the Entry Types are used and the processes required to update cash account balances. Integration of the Cash Manager module with the Microsoft Dynamics SL Accounts Payable, Accounts Receivable, and Payroll modules is discussed.

Lessons

  • Procedures for entering Cash Account Transactions
  • Cash Manager Process Flow
  • Processing Payments in AR
  • Procedures for Entering Cash Account Transfers

Lab : Cash Account Transactions

  • Enter example transactions for an account directly in Cash Manager

Lab : Cash Account Transfers

  • Transfer funds from one account to another in a single step

After completing this chapter, students will be able to:

  • Decide when to use the Release GL Batches window versus releasing batches from the data entry window.
  • Understand the criteria for a batch to display in the Release GL Batches window.
  • Release batches using the Release GL Batches window.
  • Reprint individual batch control reports or ranges of batch control reports

Module 6: Posting Transactions

Use the recurring invoice feature to make repetitive documents more efficient. This chapter shows how to define a recurring item and execute the process to create the transaction each period.

Lessons

  • Procedures for using Recurring Items
  • Recurring Item Maintenance
  • Generate Recurring Items

Lab : Recurring Items

  • Create a recurring item for a weekly fee
  • Generate the recurring transaction

After completing this chapter, students will be able to:

  • Determine when transactions should be defined as Recurring Items.
  • Set up Recurring Items.
  • Process Recurring Items to generate a batch.

Module 7: Cash Account Inquiry

The objective of this chapter is to examine the series of windows available for viewing account balances and drilling down to the transaction details. The Inquiry windows access cash account balances without having to print financial statements or reports. Learn to view balances and drill down to the details of the source transactions.

Lessons

  • Daily Cash Balance Window

Lab : Viewing Cash Balances

  • Use the Daily Cash Balance Inquiry window to view account balances and transactions entered in previous chapters

Lab : Entering and Viewing Cash Transactions

  • Enter additional transactions in the Cash Account Transaction window
  • Use the Daily Cash Balance Inquiry window to view account balances and locate transactions

Lab : Locating Cash Transactions in the General Ledger

  • Use Initialize Mode to view cash transactions in the General Ledger module

After completing this chapter, students will be able to:

  • Understand how to locate cash balances and transactions.
  • Understand how and when cash balances are updated.

Module 8: Bank Reconciliation

This chapter describes how to complete the Bank Reconciliation process. Students enter additional transactions that are found on the bank statement, clear ranges of checks and deposits, and learn to default information regarding cleared items.

Lessons

  • Procedures for performing Bank Reconciliation
  • Bank Reconciliation Window
  • Un-Clearing a transaction
  • Deleting a Bank Reconciliation
  • Bank Reconciliation Reports

Lab : Perform Bank Reconciliation

  • Complete the Bank Reconciliation process using a sample bank statement

After completing this chapter, students will be able to:

  • Understand the steps involved in the Bank Reconciliation process.
  • Perform the Bank Reconciliation.

Module 9: Bank Reconciliation Import

Set up the system to import a file transmitted from the bank to automatically clear checks and deposits. Associate un-matched transactions with specific items in the database. Complete the Bank Reconciliation process.

Lessons

  • Clear Check/Deposit Import Setup
  • Clear Check/Deposit Import
  • Clear Checks/Deposits

Lab : Complete the Clear Check/Deposit Import Setup Window

  • Define the settings for a bank import file

After completing this chapter, students will be able to:

  • Set up the system to import bank reconciliations.
  • Import a Bank Reconciliation file.
  • Clear imported items.

Module 10: Cash Flow Projections

This chapter introduces the concept of what-if reporting allowed in Cash Manager. Enter transactions that are used for reporting purposes. Students review how to combine the potential transactions with actual data to produce a Cash Flow Projection report.

Lessons

  • Procedures for Maintaining Cash Flow Items
  • Cash Projections
  • Cash Flow Projection Report

Lab : Enter Cash Flow Items

  • Enter potential expense and revenue transactions and generate a report using the potential items

After completing this chapter, students will be able to:

  • Understand how to use Cash Flow Items.
  • Define Cash Flow items for use in reporting.
  • Produce a Cash Flow Projection report.

Module 11: Month End and Closing

This chapter describes creating a closing checklist to ensure all transactions and activities have been completed for the accounting period, producing appropriate audit trail reports, and correcting an out of balance condition. The chapter demonstrates how to close only Cash Manager, or all modules for the period. This chapter also discusses the detail retention and deletion options.

Lessons

  • Balance the Cash Manager Module
  • Correct an Out of Balance Condition
  • Close for the Month or Year
  • Delete Cash Manager Detail
  • Perform Cash Manager Integrity Check

After completing this chapter, students will be able to:

  • Understand Month-End processes and procedures.
  • Balance Cash Manager.
  • Decide when to close Cash Manager for the period.
  • Execute the Closing process for all modules.
  • Delete detail for all modules.
  • Understand the CA Integrity Check and when to use it.

Module 12: Consolidation

This chapter discusses the Cash Manager consolidation process. Students take information from different databases with similar and differing periods, calendar years, and chart of account structures, and create a consolidated set of data for reporting purposes.

Lessons

  • Procedures for performing Consolidations
  • Generate Consolidation File
  • Read consolidation File

After completing this chapter, students will be able to:

  • Understand Month-End processes and procedures.
  • Decide when and if the Consolidation process is necessary.
  • Define Consolidation accounts.
  • Define Source and Destination databases.
  • Generate and Read the Consolidation File.

Module 13: Appendix: Cash Manager Setup

This appendeix describes the defaults and user options defined in the Cash Manager Setup window. Even though these options are typically not changed after the product is implemented, students review default values and processes through the settings in this window.

Lessons

  • Cash Manager Setup Checklist
  • Cash Manager Implementation Worksheet
  • Cash Manager Setup Window

After completing this chapter, students will be able to:

  • Understand the decisions that need to be made prior to setting up the Cash Manager module.
  • Define options in the CA Setup window that affect processing.

Module 14: Appendix: Cash Manager Case Study

This appendix includes a case study of Cash Manager. The case study allows students to practice what you have learned in a comprehensive exercise. The case study is organized such that each task builds on the previous task.Based on country-specific needs, this chapter is optional for classroom presentation.

Lessons

  • Beginning Balances
  • Enter Cash Transactions
  • Perform a Reconciliation

After completing this chapter, students will be able to:

  • Set up and maintain Cash Manager.
  • Achieve a comprehensive understanding of how the various parts of Cash Manager are interconnected.

Before attending this course, students must have:

  • General knowledge of Microsoft Windows.
  • Knowledge of Basic navigation functions in Microsoft Dynamics SL.
  • Completion of the General Ledger training course is required. Attendance at Accounts Payable and/or Accounts Receivable training courses recommended.

*E-Tek is an authorized Prometric testing center, offering official Microsoft certification exams at its Secaucus, New Jersey (NJ) location.

Course Reviews

No reviews found for this course.

Be the first to write a review