Microsoft Solomon Cash Manager
Course 8367: One day;Instructor-led

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 cash but are not captured in other Microsoft Solomon 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 Solomon 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 Solomon. 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 Solomon.

• 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 Solomon 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 Solomon 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 Solomon 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.