| Course OutlineModule 1: Introduction 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 Great Plains application. Lessons - Bank Reconciliation Features and Benefits
- Bank Reconciliation Overview and Roadmap
- Integration
Module 2: Setup ProceduresThis 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. Lessons - 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
After completing this chapter, students will be able to: Module 3: Daily ProceduresThis 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. Lessons - Transactions entered in Other Modules
- Transactions entered in Bank Reconciliation
- Bank Transaction Entry
- Enter Receipt Transactions
- Bank Transfer Entry
- Create Deposits Checklist
- Bank Deposit Entry
After completing this chapter, students will be able to: Module 4: Reconcile Bank StatementsThis 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. Lessons - 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 : 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 RecordsThis 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 Great Plains 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. Lessons - 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 : 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: ConclusionThis chapter discusses the key points that have been covered throughout this course. Lessons - User-defined fields in Checkbook Maintenance window
- Customizing transactions types and numbers
- Unlimited number of Checkbooks
- Enter cash transactions, assign receipts to deposits, and reconcile your checkbooks
- Cash, check, or credit cards receipts can be entered
- Enter or void checks, withdrawals, receipts, or increase and decrease adjustments and simultaneously update the General Ledger
- Funds can be transferred from one checkbook to another
- Cash transactions in other modules, such as Receivables Management, Payables Management, Payroll, Sales Order Processing and Invoicing automatically update Bank Reconciliation
- Preview reports allow you to view your work in progress during the reconciliation process
- Reports can be printed after posting and reprinted later to create a permanent audit trail of your transactions
- Changing and deleting checkbook records
Module 7: Appendix: SmartListThis appendix discusses the use of SmartList to access financial data. There are also optional exercises that can be completed by students if time permits. Lessons - Using SmartLists
- Creating Objects
- Using the Search Button
- Saving New Objects as Favorites
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 8: Appendix: Canadian InformationThis chapter focuses on sales and purchase taxes specific to Canadian businesses. Setting up tax details and tax schedules and calculating taxes on transactions is included in this section. In addition, creating two customer and customer classes (US and Canada) for each customer or customer in order to maintain separate sub-ledgers and balance to Bank Reconciliation is covered in this section. Based on country-specific needs, this chapter is optional for classroom presentation. Lessons - Purchasing Tax Details and Schedules
- Sales Tax Details and Schedules
- Customer Classes
- Customer Classes
Module 9: Appendix: Case StudyThis case study is a comprehensive lab that reinforces the concepts learned in the Bank Reconciliation class. Lessons - 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
- SmarList
|
| |
