Bank Reconciliation in Microsoft Dynamics GP 2013 Training Course

Course 805751 Day

Course OverviewThis course explores the processes required to manage cash receipts, cash disbursements, and other transactions that affect checkbook balances. It also shows you how to perform the checkbook reconciliation process in the Bank Reconciliation module, ensuring accuracy of your financial data and its relation to your financial institution statements.

AudienceCourse 80575: Bank Reconciliation in Microsoft Dynamics GP 2013 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.

Course OutlineModule 1: Overview and Setup ProceduresThis module gives students a general overview of the features and benefits of using the Bank Reconciliation in an integrated environment. It also focuses on the setup procedures for Bank Reconciliation, and the options available to customize it to reflect the way your organization does business. This module also covers entering beginning balances for each checkbook in preparation for using Bank Reconciliation.Lessons

Features and Benefits

Bank Reconciliation Setup

Checkbook Maintenance

Transfer Existing Checkbooks to Bank Reconciliation

Lab : Bank Reconciliation SetupLab : Checkbook SetupAfter completing this module, students will be able to:

Identify the features and benefits available in 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: Daily ProceduresThis module defines the ways that transactions can be entered and posted in Bank Reconciliation. The different types of transactions, receipts, and deposits that may be entered in Bank Reconciliation are discussed. This module also explains how each type of transaction may update the cash account balance in the General Ledger, the checkbook balance in Bank Reconciliation, or both.Lessons

Bank Transaction Entry

Enter Checks, Withdrawals and Adjustments

Enter Receipt Transactions

Miscellaneous Checks

Bank Transfer Entry

Deposit with Receipts

Deposit without Receipts

Clear Unused Receipts

Lab : Enter an Outstanding CheckLab : Enter a Check TransactionLab : Enter a Cash ReceiptLab : Printing a CheckLab : Enter a Bank TransferLab : Enter a Deposit with ReceiptsLab : Enter a Deposit without ReceiptsAfter 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 StatementsThis module examines the steps that are required to reconcile a checkbook to the bank statement using Bank Reconciliation. The process to enter miscellaneous transactions and adjustments during the reconcile process is also covered in this module. Time is also spent discussing the transaction posting that occurs during the reconcile process.Lessons

Reconcile Bank Statements

Select Bank Transactions

Enter Adjustments and Reconcile

Lab : Reconciling a CheckbookAfter 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 RecordsThis module examines the functionality available to maintain Bank Reconciliation records. The processes to void transactions, transfers, and deposits are covered. Time is also spent discussing the procedure for changing and deleting records and how to remove historical information from Bank Reconciliation and the effects of removing this type of history is discussed. The inquiry windows and some reports that can be generated from Bank Reconciliation are also discussed.Lessons

Voiding Transactions

Deleting Checkbooks

Removing History

Using Inquiries

Report Options and Printing

Report Groups

Report List

Lab : Removing HistoryAfter completing this module, students will be able to: