Course Duration: 1 Day
About this Course
This 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.
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:
- Identify the impact of the Bank Reconciliation module on other modules.
- 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 as checkbooks.
- Print standard reports for audit trail purposes, financial analysis, and to verify data entry.
- Perform the bank reconciliation process in Bank Reconciliation.
- Microsoft Certification Exam MB3-701 -Microsoft Dynamics GP 2013 Financials
Prerequisites
Before attending this course, students must have:
- General knowledge of Microsoft Windows
- Basic knowledge of accounting principles
Course Outline
Module 1: Overview and Setup Procedures
Thismodule 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 customizeit to reflect the way your organization does business. Thismodule also covers entering beginning balances for each checkbook in preparation forusing Bank Reconciliation.
Lessons
· Features and Benefits
- Bank Reconciliation Setup
- Checkbook Maintenance
- Transfer Existing Checkbooks to Bank Reconciliation
Lab: Bank Reconciliation Setup
Lab: Checkbook Setup
After completing this module, students will be able to:
- Identify the features and benefits availablein 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 Bank Reconciliation.
- Set up checkbooks.
- Transfer existing checkbooks to Microsoft Dynamics GP to begin using Bank Reconciliation.
Module 2: Daily Procedures
Thismodule 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. Thismodule also explains how each type of transactionmay updatethe 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 Check
Lab: Enter a Check Transaction
Lab: Enter a Cash Receipt
Lab: Printing a Check
Lab: Enter a Bank Transfer
Lab: Enter a Deposit with Receipts
Lab: Enter 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 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 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 processes to void transactions, transfers, and depositsare covered. Time is also spent discussing the procedure for changing and deleting records andhow to remove historical information fromBank Reconciliationand 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 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.