Microsoft Dynamics GP Bank Reconciliation
Course 8510: One day;
Instructor-Led
Course Fee:
$499.00
Course Time: 1 day, 9:30 am - 4:30 pm, or 2 evenings, 6pm - 9pm
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
|
|
