Bank Reconciliation in Microsoft Dynamics GP 2010

Code: 80222
Course duration: 1 days
Location Period
Secaucus, New Jersey (Virtual Instructor-Led) 12-08
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 12-08
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Instructor-Led) 12-08
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 12-08
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 12-08
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 12-08
09:00AM to 05:00PM
enroll
Attend Online 12-08
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 12-08
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 12-08
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 12-08
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 01-05
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 01-05
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led) 01-05
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Instructor-Led) 01-05
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 01-05
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 01-05
09:00AM to 05:00PM
enroll
Attend Online 01-05
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 01-05
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 01-05
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 01-05
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 02-09
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led) 02-09
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 02-09
09:00AM to 05:00PM
enroll
Mid-Town New York City (Instructor-Led) 02-09
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 02-09
09:00AM to 05:00PM
enroll
Attend Online 02-09
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 02-09
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 02-09
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 02-09
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 02-09
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 03-09
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 03-09
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 03-09
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led) 03-09
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 03-09
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 03-09
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 03-09
09:00AM to 05:00PM
enroll
Attend Online 03-09
09:00AM to 05:00PM
enroll
NYC-23rd Street (Instructor-Led) 03-09
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 03-09
09:00AM to 05:00PM
enroll

80222: Bank Reconciliation in Microsoft Dynamics GP 2010 (1 Day)

About this Course

The one-day Microsoft Dynamics GP Bank Reconciliation course explores the accounting cycle and the processes that are required to manage cash receipts, cash disbursements, and other transactions that affect checkbook balances. This course shows how to perform the reconciliation process. This guarantees accuracy of your financial data and its relation to your financial institution.


A thorough understanding of these topics enables 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 before performing the reconciliation process, and how to use 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 collect the information that you must have to make better business decisions by exploring powerful inquiry and lookup functions.

Audience Profile

This course is intended for customers who want 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 have to understand the technical aspects of Bank Reconciliation and gain foundational knowledge of the application functionality.

At Course Completion

After completing this course, students will be able to:

  • Customize the setup of Bank Reconciliation to fit their business needs.
  • Perform all Bank Reconciliation related data entry functions. This includes bank transactions, bank deposits, and bank transfers.
  • Perform maintenance on Bank Reconciliation documents and 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, such as incorrect posting date or incorrect document amounts.
  • Perform the bank reconciliation process.

Course Outline

Module 1: Overview and Setup Procedures

Thismodule 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 setup procedures for the Bank Reconciliation module, and the options available to customize this module to reflect the way your organization does business. Themodule also covers entering beginning balances for each checkbook in preparation for suing the Bank Reconciliation module.

Lessons

  • Features and Benefits
  • Bank Reconciliation Setup
  • Checkbook Maintenance
  • Transfer Existing Checkbooks to Bank Reconciliation

Lab : Overview and Setup Procedures

  • Bank Reconciliation Setup
  • Checkbook Setup

After completing this module, 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.
  • 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 2: Daily Procedures

Thismodule 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. Thismodule explains how each type of transaction may update the cash balance in the General Ledger, the checkbook balance in Bank Reconciliation, or both.

Lessons

  • Transaction Types in Bank Transaction Entry
  • Enter Checks, Withdrawals, and Adjustments
  • Enter Receipt Transactions
  • Miscellaneous Checks
  • Bank Transfer Entry
  • Deposits with Receipts
  • Deposits without Receipts
  • Clear Unused Receipts

Lab : Daily Procedures

  • Entering an Outstanding Check
  • Entering a Check Transaction
  • Entering a Cash Receipt
  • Printing a Check
  • Entering a Bank Transfer
  • Entering a Deposit with Receipts
  • Entering a Deposit without Receipts

After completing this module, students will be able to:

  • Enter the different types of cash transactions in Bank Reconciliation.
  • Print checks for miscellaneous items in Bank Reconciliation.
  • Enter bank transfers.
  • Enter and post deposits.

Module 3: Reconcile Bank Statements

Thismodule examines the stepsthat are requiredto reconcile a checkbook to the 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.

Lessons

  • Reconcile Bank Statements
  • Selecting Bank Transactions
  • Enter Adjustments and Reconcile

Lab : Reconcile Bank Statements

  • Reconciling a Checkbook

After completing this module, students will be able to:

  • Reconcile a checkbook to the bank statement.
  • Enter adjustments for miscellaneous transactions such as service charges or interest earned.
  • Account for cleared differences between the checkbook and the bank.
  • Print Reconciliation Preview reports.

Module 4: Maintaining Records

Thismodule examines the functionality available to maintain Bank Reconciliation records. The process to void transactions, transfers, and deposits is covered in detail. Time is spent discussing the procedure for changing and deleting records. How to remove historical information from Microsoft Dynamics GP and the effects of removing this history is demonstrated. Time is also spent discussing the inquiry windows and reports that can be generated from the Bank Reconciliation module.

Lessons

  • Voiding Transactions
  • Deleting Checkbooks
  • Removing History
  • Using Inquiries
  • Report Options and Printing
  • Report Groups
  • Report List

Lab : Maintaining Records

  • Removing History

After completing this module, 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 5: Appendix: Job Aids

This appendix includes job aids that are used in Bank Reconciliation. There is also a quiz to help evaluate what topic areas may need to be revisited.

Module 6: Appendix: Case Study

This case study is a comprehensive lab that can be used to reinforce the learning that occurred throughout the Bank Reconciliation class.

*E-Tek is an authorized Prometric testing center, offering official Microsoft certification exams at its Secaucus, New Jersey (NJ) location.

Guaranteed to Run

2018-03-07 09:00 to 2018-03-09 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
2017-12-11 09:00 to 2017-12-15 17:00
Attend Online
2017-12-04 09:00 to 2017-12-08 17:00
Attend Online
2017-12-04 09:00 to 2017-12-08 17:00
Attend Online
2017-11-27 09:00 to 2017-12-01 17:00
Attend Online
2017-11-27 08:00 to 2017-12-01 17:15
Attend Online

Course Reviews

No reviews found for this course.

Be the first to write a review