About Apex InfoTech Information Services Products Consulting Online Courses Certifications Course Schedule Reserve your seat Search Apex InfoTech Home Page
Course ScheduleSearch by Course NumberPrint this documentEmail this documentRegister for this course

Microsoft Dynamics SL Requisitions

Course 8532: One day; Instructor-led

Introduction
This one-day course explores the features and benefits of the Microsoft DynamicsT Solomon Bank Reconciliation module. You learn how to enter bank accounts, import bank transactions and reconcile a bank statement against the General Ledger.

Understanding these topics allows you to import transactions into Bank Reconciliation from other Solomon modules as well as import transactions from the bank. You can reconcile bank statements easily according to your schedule and your business demands. Reconcile bank statements quickly and easily from a central location and at any time of the month, including daily processing, through the Reconciliation window, which shows all related activity for a specified period.

Reconcile Solomon transactions at the check/deposit level against the bank statement without the complexity of cash balance management. This is an essential course for all end-users, consultants, and implementers who want to learn about this 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 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.

Top of page
Audience
Bank Reconciliation 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 Bank Reconciliation and gain foundational knowledge of the application functionality.

Top of page
At Course Completion
After completing this course, students should be able to:

• Set up the Bank File Import function.

• Set up bank accounts to be used in Bank Reconciliation.

• Import Solomon transactions from Accounts Receivable, Accounts Payable, Purchasing and General Ledger.

• Reconcile checks from Accounts Payable and Payroll; deposits from Accounts Receivable; Journal entries from General Ledger.

• Perform the Bank Reconciliation process to reconcile General Ledger balances to a bank statement.


Top of page
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.


Top of page
Microsoft Certified Professional Exams
No Microsoft Certified Professional exams are associated with this course currently.

Top of page
Course Materials
The courseware includes a comprehensive workbook.

Top of page
Course Outline
Chapter 1: Overview

The purpose of this chapter is to introduce you to the Bank Reconciliation module of Microsoft Solomon product and training course. This chapter introduces the windows and processes that are used to complete the accounting cycle in Bank Reconciliation.

Main Topics

• Course Description.

• Module Overview.

• Bank Reconciliation Process Flow.

• Other Features.

After completing this chapter, students should be able to:

• Understand the goals of this course.

• See how the Bank Reconciliation module fits into the suite of available modules for the Microsoft Solomon system.

• Follow the flow of transactions through Bank Reconciliation.

Chapter 2: Overview Checklist

This chapter examines the core processes that are used in the Bank Reconciliation module. The purpose of this chapter is to provide an overview of the Bank Reconciliation process steps in the form of a checklist and provide information about how sub modules interact with Bank Reconciliation.

Main Topics

• Sub module interaction with Bank Reconciliation

• Bank Reconciliation Process Checklist

After completing this chapter, students should be able to:

• Understand how transactions are used in Microsoft Dynamics Solomon Bank Reconciliation.

• Understand the Bank Reconciliation process.

• Understand how Bank Reconciliation interacts with the other financial modules.

Chapter 3: Bank Reconciliation Setup

Understand the defaults and user options defined in the Bank Reconciliation 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. As exercises in this manual are cumulative, this is not an optional chapter.

Main Topics

• Introduction

• Bank Reconciliation Setup

• Bank File Import

Lab: Bank Reconciliation Setup

• Create a bank import file in .csv format

• Complete BR Setup

After completing this chapter, students should be able to:

• Understand the decisions that need to be made prior to setting up the Bank Reconciliation module.

• Define options in the BR Setup window that affect processing.

• Define the Bank File Import format

Chapter 4: Bank Account Maintenance

This chapter examines the setup of Bank Reconciliation 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 Bank Reconciliation module.

Main Topics

• Procedures for Maintaining Cash Accounts.

• Cash Account Maintenance.

Lab: Establish a New Cash Account

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

After completing this chapter, students should be able to:

• Define accounts in Bank Account Maintenance

Chapter 5: Reconciling Bank Accounts

This chapter describes the process of performing a bank reconciliation. The purpose is to walk through the process of importing transactions and performing the reconciliation of the bank statement against General Ledger.

Main Topics

• Procedures for Bank Reconciliation

• Module Transaction Import

• Reconciliation

• Bank File Import

• Bank Reconciliation Closing

Lab: Complete a Bank Reconciliation

• Complete a Bank Reconciliation

After completing this chapter, students should understand:

• How to import transactions from other Solomon modules.

• How to perform a bank reconciliation

• How to import a bank transaction file

• How to close Bank Reconciliation

For more information or to give feedback, send e-mail to info@OneApex.com or call 949-597-2100