Microsoft Dynamics GP Bank Reconciliation
Course 8510: One days;
Instructor-Led
On This Page
Introduction
The one-day Microsoft Dynamics GP Bank
Reconciliation course explores the accounting cycle and the
processes required to manage cash receipts, cash disbursements, and
other transactions that affect checkbook balances. This course shows
you how to perform the reconciliation process, ensuring accuracy of
your financial data and its relation to your financial institution.
A thorough understanding of these topics allows
you to reconcile your checkbooks with your bank statements, keeping
information consistent and accurate. You will learn to use
comprehensive reporting features to preview data in different ways
prior to performing the reconciliation process and as well as the
Checkbook Register report which may be printed at any time. This
course also teaches you how to define default values that
automatically populate data fields and gather the information you
need to make better business decisions by exploring powerful inquiry
and lookup functions.
Audience
Customers wanting to learn the basic features and
to develop a working knowledge of the typical day-to-day procedures
required to effectively use Microsoft Dynamics GP Bank
Reconciliation.
Bank Reconciliation training is recommended for
anyone who plans to implement, use, maintain, consult, or support
Microsoft Dynamics GP. The class is targeted toward data entry
clerks, administrators; office managers, CEOs, and consultants who
need to understand the technical aspects of Bank Reconciliation and
gain foundational knowledge of the application functionality.
At Course Completion
After completing this course, students should be
able to:
| • |
Customize the setup of
Bank Reconciliation to fit your business needs |
| • |
Perform all Bank
Reconciliation related data entry functions including bank
transactions, bank deposits, and bank transfers |
| • |
Perform maintenance on
Bank Reconciliation documents and maintenance records such
checkbooks |
| • |
Print standard reports
for audit trail purposes, financial analysis, and to verify
data entry |
| • |
Identify the impact of
the Bank Reconciliation module on other modules |
| • |
Troubleshoot and correct
input errors including incorrect posting date or incorrect
document amounts |
| • |
Perform the bank
reconciliation process |
Prerequisites
Before attending this course, students must have:
| • |
General knowledge of
Microsoft Windows |
| • |
Basic knowledge of
accounting principles |
Student Materials
The student materials include a comprehensive
workbook and other necessary items for this class.
Course Outline
Chapter 1: Overview
This chapter gives students a general overview of
the features and benefits of using the Bank Reconciliation module in
an integrated environment. It also focuses on the integration of
this module with other modules in the Microsoft Dynamics GP
application.
Main Topics
| • |
Bank Reconciliation
Features and Benefits |
| • |
Bank Reconciliation
Overview and Roadmap Integration |
After completing this chapter, students should be
able to:
| • |
Identify the features
and benefits available when using Bank Reconciliation |
| • |
Discuss integration that
takes place between Bank Reconciliation and other modules
within the application |
| • |
Identify the navigation
used to access the windows for transactions, reports,
routines, and inquiries in Bank Reconciliation |
Chapter 2: Setup Procedures
This chapter focuses on the setup procedures for
the Bank Reconciliation module. You examine in detail the options
available to customize this module to reflect the way your
organization does business. Time is spent discussing the benefits of
using a default checkbook to ease data entry. You set up checkbooks
so that you can track the information that is crucial in your
company. The last step is to enter Beginning Balances for each
checkbook in preparation for using the Bank Reconciliation module.
Once your Bank Reconciliation setup has been defined, there are many
reports available to document the selected preferences.
Main Topics
| • |
Bank Reconciliation
Setup Checklist |
| • |
Company, Financial, and
Posting Setup Procedures |
| • |
Bank Reconciliation
Setup and Options |
| • |
Checkbook Maintenance |
| • |
Bank Reconciliation
Setup Reports |
| • |
Transfer Existing
Checkbooks to Bank Reconciliation |
Labs
| • |
Modify existing Bank
Reconciliation Setup selection |
| • |
Add a new Checkbook |
After completing this chapter, students should be
able to:
| • |
Customize settings for
the Bank Reconciliation module Set up Checkbooks |
| • |
Transfer existing
checkbooks to Microsoft Dynamics GP to begin using the Bank
Reconciliation module |
Chapter 3: Daily Procedures
This chapter defines the ways that transactions
can be entered and posted in Bank Reconciliation. You explore the
different types of transactions, receipts and deposits that may be
entered in this module. This chapter explains how each type of
transaction may update the cash balance in the General Ledger, the
checkbook balance in Bank Reconciliation or both.
Main Topics
| • |
Transactions entered in
Other Modules |
| • |
Transactions entered in
Bank Reconciliation |
| • |
Bank Transaction Entry |
| • |
Enter Receipt
Transactions |
| • |
Enter Miscellaneous
Checks |
| • |
Bank Transfer Entry |
| • |
Create Deposits
Checklist |
| • |
Bank Deposit Entry |
Labs
| • |
Enter and Post the
Outstanding Check |
| • |
Enter a Check
Transaction |
| • |
Enter a Miscellaneous
Check |
| • |
Enter a Bank Transfer |
| • |
Enter a Deposit without
Receipts |
| • |
Enter a Deposit with
Receipts |
After completing this chapter, students should be
able to:
| • |
Understand how
transactions entered in other modules affect Bank
Reconciliation |
| • |
Enter the different
types of transactions in Bank Reconciliation |
| • |
Enter and post deposits |
Chapter 4: Reconcile Bank Statements
This chapter examines the steps necessary to
reconcile a checkbook to your bank statement. The process to enter
miscellaneous transactions and adjustments during the reconcile
process is covered in detail. Time is spent discussing the
transaction posting that occurs during the reconcile process.
Main Topics
| • |
Reconciling Bank
Statements Checklist |
| • |
Reconcile Bank
Statements |
| • |
Select Bank Transactions |
| • |
Enter Adjustments for
Miscellaneous Transactions |
| • |
Print Preview Reports |
| • |
Enter Adjustments for
Cleared Differences |
| • |
Reconcile the Checkbook |
Labs
| • |
Reconcile the Checkbook
to the Bank Statement |
After completing this chapter, students should be
able to:
| • |
Reconcile your checkbook
to your bank statement |
| • |
Enter adjustments for
Miscellaneous Transactions and Cleared Differences |
| • |
Print Reconciliation
Preview Reports |
Chapter 5: Maintaining Records
This chapter examines the functionality available
to maintain Bank Reconciliation records. The process to void
transactions, transfers and deposits is covered in detail in this
section. Time is spent discussing the procedure for changing and
deleting records. You see how to remove historical information from
Microsoft Dynamics GP and the effects of removing this history.
Retrieving information is explored in detail in this chapter. Time
is also spent discussing the inquiry windows and reports that can be
generated from the Bank Reconciliation module.
Main Topics
| • |
Voiding a Bank
Transaction |
| • |
Voiding a Bank Transfer |
| • |
Voiding a Deposit |
| • |
Deleting a Checkbook |
| • |
Removing History |
| • |
Retrieve Information |
| • |
Creating Report Options |
| • |
Creating and Printing
Report Groups |
Labs
| • |
Remove Bank Transaction
History |
After completing this chapter, students should be
able to:
| • |
Void bank transactions,
transfers, and deposits Change and delete checkbook records |
| • |
Remove historical bank
reconciliation information Inquire and report on bank
information |
Appendix A: SmartList
This appendix discusses the use of SmartList to
access financial data. There are also optional exercises that can be
completed by students if time permits.
Main Topics
| • |
Using SmartLists |
| • |
Creating Objects |
| • |
Using the Search Button |
| • |
Saving New Objects as
Favorites |
Labs
| • |
Create a SmartList
Inquiry |
| • |
Export the results to
Microsoft Excel |
After completing this chapter, students should be
able to:
| • |
Use SmartLists to access
valuable financial data |
| • |
Create new SmartList
objects |
| • |
Use the Search button to
manage the information in a view |
| • |
Explain the various
options that are available when using SmartLists |
Appendix C: Case Study
This case study is a comprehensive lab that
reinforces the concepts learned in the Bank Reconciliation class.
Main Topics
| • |
Verify Posting Setup |
| • |
Create a new Checkbook |
| • |
Enter a Bank Transfer |
| • |
Enter Bank Transactions |
| • |
Entering Receipts |
| • |
Create Bank Deposits |
| • |
Bank Adjustments |
| • |
Void Transactions |
| • |
Reconcile |
| • |
Print Reports |
| • |
Balance to General
Ledger |
| • |
SmartList |
After completing this chapter, students should be
able to:
| • |
Understand the necessary
processes to set up and manage their Bank Reconciliation
module |
| • |
Have more confidence in
their ability to use Bank Reconciliation in their company |
