Course 80572A:

General Ledger in Microsoft Dynamics GP 2013

Length:1 Days
Published:May 02, 2013
Language(s):English
Audience(s):Information Workers
Level:200
Technology:Microsoft Dynamics GP 2013
Type:Course
Delivery Method:Instructor-led (classroom)
About this Course
This course explores the accounting cycle and the processes required to enter financial data into the system. It covers how to set up general ledger accounts, enter general ledger transactions, and post the transactions. This course also shows how to perform additional functions such as account reconciliation, budgeting, allocation, period-end procedures and year-end closing procedures.
Audience Profile
This course is intended for customers and partners that want to learn the basic features and understand the typical day-to-day procedures of General Ledger. The class is targeted toward data entry clerks, administrators, office managers, CEO's, accountants, and consultants who need to understand the technical aspects of Microsoft Dynamics GP General Ledger and understand how to use it in accordance with the rest of the system
At Course Completion
After completing this course, students will be able to:
  • Customize General Ledger settings
  • Set up a chart of accounts including posting, unit and allocation accounts
  • Enter and post transactions using transactional or batch posting methods
  • Perform key inquiries and print reports in General Ledger
  • Maintain records in General Ledger
  • Print financial statements and other key reports to manage a business
  • Complete period and year-end procedures
Course OutlineModule 1: Overview and SetupThis module provides a general overview of the features and benefits of using General Ledger in an integrated environment and focuses on how General Ledger integrates with other functional areas in the Microsoft Dynamics GP application. This module also focuses on the setup procedures and different types of accounts in General Ledger, and how to define budgets for accounts using Microsoft Dynamics GP or Microsoft Excel.Lessons
  • Features and Benefits
  • General Ledger Setup
  • Account Categories
  • Posting Account Setup
  • Unit Account Setup
  • Fixed Allocation Account Setup
  • Variable Allocation Account Setup
  • Account Segment Setup
  • Mass Modify Chart of Accounts
  • Define the Retained Earnings Account
  • Set Up Budgets
  • Budget Maintenance
  • Combining Budgets
  • Quick Journal Setup
  • Transaction Matching Setup
  • Entering Beginning Balances
Lab : Enter a Posting AccountLab : Enter a Unit AccountLab : Enter a Fixed Allocation AccountLab : Enter a Variable Allocation AccountLab : Account Segment SetupLab : Mass Modify Chart of AccountsLab : Create a Blank Budget in ExcelLab : Importing a Budget from ExcelLab : Quick Journal Setup
After completing this module, students will be able to:
  • Identify the features and benefits available in General Ledger.
  • Discuss integration that takes place between General Ledger and other modules.
  • Customize settings for General Ledger.
  • Enter a chart of accounts; including posting, unit, fixed allocation and variable allocation accounts.
  • Define a retained earnings account and understand the options available.
  • Enter budget information.
  • Create Quick Journal entries to speed data entry and minimize errors.
  • Enter beginning balances for a chart of accounts.
Module 2: Daily ProceduresThis module defines the ways that transactions can be entered and posted in General Ledger. It explores the difference between transaction level and batch level posting, and the methods for posting batches. It also demonstrates how to use clearing entries to transfer the balance of an account that is no longer being used to another account.Lessons
  • Batch Entry
  • Transaction Entry
  • Calculate Taxes in General Ledger
  • Clearing Transaction Entry
  • Budget Transaction Entry
  • Quick Journal Entry
  • Linking Transactions
  • Batch Recovery
Lab : Transaction Entry, Unit AccountsLab : Transaction Entry, Allocation AccountsLab : Transaction Entry, Recurring TransactionsLab : Clearing EntryLab : Budget Transaction EntryLab : Quick Journal Entry
After completing this module, students will be able to:
  • Enter transactions involving posting, unit and allocation accounts.
  • Print edit lists and post transactions.
  • Enter and post clearing and quick journal transactions.
  • Use Transaction Matching for analysis purposes.
Module 3: Additional FunctionalityThis module examines how to use Multidimensional Analysis, Intercompany functionality and set up Organizational Structures to use account security.Lessons
  • Multidimensional Analysis Groups and Codes
  • Assign Analysis Groups to Accounts
  • Multidimensional Analysis Transactions
  • Define Intercompany Relationships
  • Entering Intercompany Transactions
  • Organizational Structures Setup
  • Define Organizational Relationships
  • Assign User Classes to the Organizational Structure
  • Assign Users to the Organizational Structure
  • Assign a Range of Accounts to the Organizational Structure
  • Assign an Individual Account to the Organizational Structure
  • Activating Account Security
Lab : Multidimensional AnalysisLab : Organizational Structure SetupLab : Organizational Tree SetupLab : Organizational Structure, User SetupLab : Organizational Structure, Mass Assignment
After completing this module, students will be able to:
  • Use the functionality available in Multidimensional Analysis.
  • Set up Analysis Groups and Analysis Codes.
  • Enter transactions using Analysis Codes.
  • Retrieve analysis information from posted transactions.
  • Set up Intercompany relationships.
  • Use the Intercompany functionality to enter and process transactions.
  • Trace intercompany transaction back to the originating entry.
  • Define discrete business entities using Organizational Structures.
  • Define relationships between multiple business entities.
  • Define account security levels based on their organizational structure.
Module 4: Maintaining RecordsThis module examines the functionality available to maintain General Ledger records. There is a lesson that focuses on correcting posted entries as well as changing and deleting account records. Information about the reconcile features in General Ledger are discussed, including the capability of reconciling to other sub-ledgers. Inquiries and reports are also discussed in this module.Lessons
  • Correcting a Posted Transaction
  • Change, Inactivate, and Delete Account Records
  • Reconcile
  • Reconcile to GL
  • Remove History
  • Archive Matched Transactions
  • Account Rollups
  • Using Inquiries
  • Report Options and Printing
  • Report Groups
  • Report List
After completing this module, students will be able to:
  • Correct posted entries
  • Change and delete records
  • Use inquiries to retrieve information
  • Use Account Rollup Inquiry
  • Set up report options and report groups for reporting purposes
Module 5: Period-End ClosingThis module examines the process of closing an accounting period and the fiscal year. The steps necessary to complete each phase of the closing process are discussed for the end of a period as well as a fiscal year. The module also looks at financial statements typically printed at the end of periods. Time is spent examining what actually takes place during the closing process and the two approaches that an organization may use for this process.Lessons
  • Period-End Closing
  • Year-End Closing
  • Quick Financial Statements
  • Printing Financial Statements
  • Advanced Financial Analysis
Lab : Quick Financial SetupLab : Quick Financial, Report Options
After completing this module, students will be able to:
  • Complete period-end processes for an accounting period in General Ledger
  • Consolidate periods and be aware of the effects of performing the consolidation process
  • Complete the processes that should be performed at the end of a fiscal year.
  • Create and print quick financial statements
  • Understand basic concepts of using Advanced Financial Analysis
Before attending this course, students must have:
  • General experience using Microsoft Windows
  • Basic understanding of accounting principles
  • Attend the Introduction to Microsoft Dynamics GP course or have some basic knowledge of Microsoft Dynamics GP
Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:

Find a Microsoft Learning Partner near you

Find Training Near You

Location:

Eg: Seattle, WA or Paris, France