Microsoft Dynamics GP 9.0 Bank Reconciliation

Code: 8510
Course duration: 1 days

8510: Bank Reconciliation I in Microsoft Dynamics GP 9.0 (1 Day)

About this Course

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 Profile

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.


Before attending this course, students must have:

  • General knowledge of Microsoft Windows
  • Basic knowledge of accounting principles

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

Course Outline

Module 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.


  • Bank Reconciliation Features and Benefits
  • Bank Reconciliation Overview and Roadmap Integration

After completing this chapter, students will 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

Module 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.


  • 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

Lab : Modify existing Bank Reconciliation Setup selection

Lab : Add a new Checkbook

After completing this chapter, students will 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

Module 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.


  • 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

Lab : Enter and Post the Outstanding Check

Lab : Enter a Check Transaction

Lab : Enter a Miscellaneous Check

Lab : Enter a Bank Transfer

Lab : Enter a Deposit without Receipts

Lab : Enter a Deposit with Receipts

After completing this chapter, students will 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

Module 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.


  • 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

Lab : Reconcile the Checkbook to the Bank Statement

After completing this chapter, students will be able to:

  • Reconcile your checkbook to your bank statement
  • Enter adjustments for Miscellaneous Transactions and Cleared Differences
  • Print Reconciliation Preview Reports

Module 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.


  • 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

Lab : Remove Bank Transaction History
After completing this chapter, students will 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

Module 6: Appendix: 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.


  • Using SmartLists
  • Creating Objects
  • Using the Search Button
  • Saving New Objects as Favorites

Lab : Create a SmartList Inquiry

Lab : Export the results to Microsoft Excel

After completing this chapter, students will 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

Module 7: Appendix: Case Study

This case study is a comprehensive lab that reinforces the concepts learned in the Bank Reconciliation class.


  • 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 will 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

Guaranteed to Run

2020-11-02 09:00 to 2020-11-06 17:00
Attend Online
2020-09-24 09:00 to 2020-09-25 17:00
Attend Online
09:00 to 17:00
Attend Online
2020-09-07 09:00 to 2020-09-11 17:00
Attend Online
2020-08-25 09:00 to 2020-08-28 17:00
Attend Online
2020-08-24 09:00 to 2020-08-28 17:00
Attend Online
09:00 to 17:00
Attend Online
09:00 to 17:00
Attend Online
2020-08-18 09:00 to 2020-08-21 17:00
Attend Online
2020-08-17 09:00 to 2020-08-21 17:00
Attend Online
09:00 to 17:00
Attend Online
09:00 to 17:00
Attend Online

Course Reviews

No reviews found for this course.

Be the first to write a review