Cash Manager in Microsoft Dynamics SL 2011 (80321)

Printer-friendly version
Vendor: 
Microsoft
Subject: 
ERP
Course Contents: 

Module 1: OverviewThis module introduces the Cash Manager software module of Microsoft Dynamics SL 2011. It introduces the windows and processes that are used to complete the accounting cycle in Cash Manager. This module is optional and can be skipped at the instructor's discretion.  Lessons

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

After completing this module, students will be able to:

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

Module 2: Active OverviewThis module examines the core processes that are used in Cash Manager. The purpose is to introduce each step in the accounting cycle, briefly discuss its purpose and primary features, and focus on its function in the accounting cycle. Please note that this chapter is not intended to provide you with a detailed primer on each of these topics. This module is optional and can be skipped at the instructor's discretion. Lessons

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

After completing this module, 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 MaintenanceThis module examines the setup of cash manager accounts. The purpose 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 : Cash Account Maintenance

  • Establish a New Cash Account

After completing this module, 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 TypesThis module examines the setup of Entry Types. It discusses reasons for creating various entry types and the specific uses of system defined entry types. It 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 : Entry Types

  • Define Entry Types

After completing this module, students will be able to:

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

Module 5: Cash Account Transactions and TransfersThis module 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 and Transfers

  • Cash Account Transactions
  • Cash Account Transfers

After completing this module, students will be able to:

  • Enter transactions for Cash Accounts.
  • Enter transfers between Cash Accounts.
  • Understand how Cash Manager balances are updated.

Module 6: Recurring ItemsUse the recurring invoice feature to make repetitive documents more efficient. This module illustrates 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

  • Generate a Recurring Transaction

After completing this module, 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 InquiryThis module examines 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. Here you will learn to view balances and drill down to the details of the source transactions. Lessons

  • Daily Cash Balances
  • Inquiry Windows

Lab : Cash Account Inquiry

  • Viewing Cash Balances
  • Entering and Viewing Cash Transactions
  • Locating Cash Transactions in the General Ledger

After completing this module, students will be able to:

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

Module 8: Bank ReconciliationThis module 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 : Bank Reconciliation

  • Perform Bank Reconciliation

After completing this module, students will be able to:

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

Module 9: Bank Reconciliation ImportIn this module you will set up the system to import a file transmitted from the bank to automatically clear checks and deposits. You will also associate un-matched transactions with specific items in the database and complete the Bank Reconciliation process.Lessons

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

Lab : Bank Reconciliation Import

  • Complete the Clear Check/Deposit Import Setup Window

After completing this module, 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 ProjectionsThis module 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 : Cash Flow Projections

  • Enter Cash Flow Items

After completing this module, 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 ClosingThis module 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. It demonstrates how to close only Cash Manager, or all modules for the period. It 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 module, students will be able to:

  • Explain the 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.
  • Explain the CA Integrity Check and when to use it.

Module 12: ConsolidationThis module discusses the Cash Manager consolidation process. You will take information from different databases with similar and differing periods, calendar years, and chart of account structures, then create a consolidated set of data for reporting purposes.Lessons

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

After completing this module, students will be able to:

  • Decide when and if the Consolidation process is necessary.
  • Define Consolidation accounts.
  • Define Source and Destination databases.
  • Generate and Read the Consolidation File.

Objective: 

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.

Prerequisites: 

Before attending this course, students must have:

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

Benefits: 

After completing this course, students will be able to:

  • Create Cash Account Transactions to update Cash Manager and General 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.
Audience: 

This course is intended 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, and consultants who need to understand the technical aspects of Cash Manager and gain foundational knowledge of the application functionality.

Materials Available: 
Yes
Duration: 
8 hours
For more information on Cash Manager in Microsoft Dynamics SL 2011 (80321) please feel free to contact us online or call us at 416-513-1535.