Dynamic Tech Services, Inc.
Call Us: (800) 818-0574
Email Us: Info@DynamicTSI.com
This one-day course explores the features and benefits of the Microsoft Dynamics SL Cash Manager module. You learn how to classify transactions by account type, view cash balances, reconcile bank accounts, and project cash flows.
Understanding these topics allows you to access current cash balance information instantly while entering transactions, to help you track what is in the bank on a daily basis. Transfer funds between different cash accounts and manage your money effectively while accurately displaying critical information at a moment's notice. Reconcile bank statements easily according to your schedule and your business demands. Assemble 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. Reconcile bank statements quickly and easily from a central location and at any time of the month, including daily processing, through the Bank Reconciliation window, which shows all related activity for a specified period.
Reconcile at the check/deposit level and easily enter transactions that affect Dynamics SL cash but are not captured in other Microsoft Dynamics SL modules, such as bank service charges, wire transfers, or other cash transaction types that you create. 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 serious, in-depth learning thorough hands-on interaction. From demonstrations to presentations to classroom activities, you will receive hands-on experience with instruction from our certified staff of experts and increase productivity and efficiency by learning tips and tricks from product specialists.
Cash Manager training is recommended for anyone who plans to implement, use, maintain, consult, or support Microsoft Dynamics SL. The class is targeted toward data entry clerks, administrators, office managers, CEO's, and consultants who need to understand the technical aspects of Cash Manager and gain foundational knowledge of the application functionality.
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.
Setup 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.
General knowledge of Microsoft® Windows®.
Knowledge of Basic navigation functions in Microsoft Dynamics SL.
Completion of General Ledger training course required. Attendance at Accounts Payable and/or Accounts Receivable training courses recommended.
No Microsoft Certification exams are associated with this course currently.
The courseware includes a comprehensive workbook.
Chapter 1: Overview
The purpose of this chapter is to introduce you to 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.
Main Topics
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 Cash Manager module fits into the suite of available modules for the Microsoft Dynamics SL system.
Follow the flow of transactions through Cash Manager.
Chapter 2: Active Overview
This chapter examines the core processes that are used in the Cash Manager module. The purpose of this chapter 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 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.
Establishing a Cash Account.
Cash Transactions.
View Cash Account Balances.
Bank Reconciliation.
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.
Chapter 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.
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.
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.
Chapter 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.
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.
Understand how entry types are used.
Define Entry Types for tracking transactions.
Chapter 5: Cash 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.
Procedures for entering Cash Account Transactions.
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.
Enter transactions for Cash Accounts.
Enter transfers between Cash Accounts.
Understand how Cash Manager balances are updated.
Chapter 6: Recurring Items
Use the recurring invoice feature to make repetitive documents more efficient. This chapter shows you how to define a recurring item and execute the process to create the transaction each period.
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.
Determine when transactions should be defined as Recurring Items.
Set up Recurring Items.
Process Recurring Items to generate a batch.
Chapter 7: Cash Account Inquiries
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 allow you to view 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.
Daily Cash Balance Window.
Lab: Viewing Cash Balances
Use the Daily Cash Balance Inquiry window to view account balances and transactions entered in previous lessons.
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.
Understand how to locate cash balances and transactions.
Understand how and when cash balances are updated.
Chapter 8: Bank Reconciliation
In this lesson you learn to complete the Bank Reconciliation process. Enter additional transactions that are found on the bank statement. Clear ranges of checks and deposits, and learn to default information regarding cleared items.
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.
Understand the steps involved in the Bank Reconciliation process.
Perform the Bank Reconciliation.
Chapter 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.
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.
Set up the system to import bank reconciliations.
Import a Bank Reconciliation file.
Clear imported items.
Chapter 10: Cash Flow Projections
The objective of this chapter is to introduce the concept of what-if reporting allowed in Cash Manager. Enter transactions that are used for reporting purposes. Combine the potential transactions with actual data to produce a Cash Flow Projection report.
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.
Understand how to use Cash Flow Items.
Define Cash Flow items for use in reporting.
Produce a Cash Flow Projection report.
Chapter 11: Month End and Closing
Create a closing checklist to ensure all transactions and activities have been completed for the accounting period. Produce appropriate audit trail reports and lean to correct an out of balance condition. Close only Cash Manager, or all modules for the period. This chapter also discusses the detail retention and deletion options.
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.
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.
Chapter 12: Consolidation
This chapter discusses the Cash Manager consolidation process. 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.
Procedures for performing Consolidations.
Generate Consolidation File.
Read consolidation File.
Decide when and if the Consolidation process is necessary.
Define Consolidation accounts.
Define Source and Destination databases.
Generate and Read the Consolidation File.
Appendix A: Cash Manager Setup
Understand 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, you will gain understanding of default values and processes through the settings in this window.
Cash Manager Setup Checklist.
Cash Manager Implementation Worksheet.
Cash Manager Setup Window.
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.
