Cash Manager in Microsoft Dynamics SL 6.5
Course 8547: One day; Instructor-Led
Introduction
This one-day course explores the features and benefits of the Microsoft
DynamicsT 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.
Audience
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.
At
Course Completion
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.
Prerequisites
• 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.
Microsoft
Certified Professional Exams
No
Microsoft Certified Professional exams are associated with this course
currently.
Course
Materials
The courseware includes a comprehensive workbook.
Course
Outline
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.
Main Topics
• 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.
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.
Main Topics
• 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.
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.
Main Topics
• 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.
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.
Main Topics
• 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:
• 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.
Main Topics
• 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.
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.
Main Topics
• 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.
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.
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.
Main Topics
• 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.
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.
Main Topics
• 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.
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.
Main Topics
• 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.
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.
Main Topics
• 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.
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.
Main Topics
• Procedures
for performing Consolidations.
• Generate Consolidation File.
• Read consolidation File.
After completing this chapter, 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.
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.
Main Topics
• 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.
For more information or to give feedback, send e-mail to info@OneApex.com or call 949-597-2100
 |
 |
 |
