This two-day instructor-led course provides students with the knowledge and skills to build basic and advanced financial statements using Management Reporter.
Target Audience:
This course is intended for partners, end users, IT professionals or accounting professionals who build and maintain the organization's financial reporting package.
Pre-requisites:
Before attending this course, it is recommended that students have:
General knowledge of the Windows operating system
Basic knowledge of accounting principles and procedures
Prior knowledge in building financial statements
At Course Completion:
After completing this course, students will be able to:
Explore the demonstration entity and sample reports
Export the sample reports as a template for their own report design
Design basic report building blocks in Report Designer including:
- Row definitions
- Column definitions
- Reporting tree definitions
Associate the building blocks in a variety of report definitions including:
- Trial Balance reports
- Income Statements
- Variance reports
- Balance Sheets
- Statements of Cash Flow
- Consolidation reports
Discover the power and flexibility of reporting trees to present financial results at the responsibility level (i.e. by accounting segment or dimension and combinations thereof)
Apply worksheet linking to report on data maintained in Microsoft Office Excel
Use report output and distribution options including Report Viewer
Implement security including customized roles, groups, and users
This module introduces PerformancePoint 2007 Management Reporter and briefly looks at how it connects to the source general ledger system. In addition, students generate a pre-defined sample report in Report Designer and review its contents in Report Viewer. The associated building blocks are then explored in Report Designer.
Lessons
Welcome
Demo Reports
Building Blocks
After completing this module, students will be able to:
Access Management Reporter
Explore the sample reports
Review the building blocks used in a report
Module 2: Navigation
In this module each of the primary components of the user interface is explored. In addition, students define a new building block group that stores the reports, rows, columns, and reporting trees created during the training.
Lessons
Menu Bar
Toolbars
Navigation Pane
View Pane
Building Block Groups
After completing this module, students will be able to:
Use the menu bar commands
Change the toolbar options
Change the navigation pane display
Recognize the view pane
Create a building block group
Module 3: Detailed Trial Balance
This module explains how to create the row, column, and report definition, then save and generate the report in Report Designer. The report is then reviewed using drill down to transaction level in the Report Viewer.
Lessons
Create a New Row Definition
Create a New Column Definition
Create a Trial Balance Report Definition
View the Trial Balance
After completing this module, students will be able to:
Create a detailed trial balance row definition
Define a current and year to date column definition
Build a trial balance report definition
Review the generated report in Report Viewer
Module 4: Detailed Income Statement
This module explains how to design a detailed income statement that reports monthly and year to date results. Students start with the detailed trial balance row definition, and then modify it adding headers, underscores, and sub-totals. When students define the report definition, the completed income statement row definition is associated with the existing current and year to date column definition, and then report headers, font styles, and rounding options are selected. This module also examines adding customized folders to the Report Library in Report Viewer.
Lessons
Modify a Row Definition
Modify a Report Definition
Customise the Display in Report Viewer
After completing this module, students will be able to:
Modify existing row definitions
Create a new report from an existing report definition
Organise the Report Library
Module 5: Working with Trees
This module introduces how to build and maintain a reporting tree, an optional building block in basic report designs. Reporting trees allow users to define reports based on responsibility centres within the organisation and create rollups that are independent of the chart of accounts.
Lessons
Two Level Segment Based Reporting Trees
Departmental Income Statement
Reporting Tree Symbols
Multi Level Reporting Trees
Other Reporting Tree Options
Reporting Trees in Dimension based Systems
After completing this module, students will be able to:
Create a basic two level, segment based, reporting tree
Add a reporting tree to an existing report
Work with the characters used in reporting trees
Create a multiple level reporting hierarchy
Access other reporting tree options
Create reporting trees in dimension based accounting systems
Module 6: Review Plus
This module explores the sample reports and associated building blocks included in the demonstration data, introducing valuable design tips and tricks. The export and import functions are then used to move a sample report and its building blocks into the files used for an upcoming training exercise.
Lessons
View the Demo Report Definitions
Wildcards and Ranges
Export and Import Building Blocks
After completing this module, students will be able to:
Access and work with the sample report definitions
Use wildcards and ranges in row, column, and reporting tree definitions
Utilise the export and import functions in building block groups
Module 7: Side by Side Reporting
This module explains two methods for filtering data into columns: the account filter and the reporting unit. The account filter method is based on accounts or dimensions, while in the reporting unit method, data in the column definition is related to units in a reporting tree. Row filtering is also introduced by using the related units function in the row definition.
Lessons
Divisional Income Statement
Row Modifiers
Unit Restrictions in the Row Definition
Rotate the Building Blocks
After completing this module, students will be able to:
Design reports that utilize account filters to present data in a side-by-side format
Create reports that present reporting unit data in a side-by-side format
Determine when each of the two methods is better suited to the report design
Apply row modifiers to the row definition
Report on individual tree units in the row definition
Investigate the flexibility of building blocks and their content
Module 8: Relational Reporting
This module explains the use of both single and multiple base row format codes in the row definition and how to define a column calculation that reports data in relationship to the base row (s).
Lessons
Define a CBR Column Definition
Define a CBR Row Definition
Multiple CBR Rows
After completing this module, students will be able to:
Define a calculated column that uses CBR (calculation on base row)
Apply the CBR format code to one or more rows in the row definition
Module 9: Variance Reporting
This module explains how to design column definitions that report on two common types of variance presentations: over/(under) and favourable/(unfavourable). The XCR print control is introduced to support favourable/(unfavourable) variances when the type of account being reported needs to be considered (i.e. income versus expense accounts).
Lessons
Over/(Under) Variances
Favorable/(Unfavorable) Variances
Design Review
After completing this module, students will be able to:
Create an over/(under) variance column definition and associated report
Define a report that displays favorable/(unfavorable) variances
Write column calculations formulas to support either variance presentation
Module 10: Balance Sheet Reporting
This module looks at how to define a row definition that presents all general ledger accounts in a balance sheet style report. The effect of rounding and how to account for it in the report design is also introduced. Two balance sheet presentations are designed through the column definition: year to date and current year to date compared to prior year end results.
Lessons
Create a Balance Sheet Row Definition
Create a Balance Sheet Column Definition
Create the Report Definition
Sample Balance Sheets
After completing this module, students will be able to:
Construct a balance sheet row definition
Design a year to date column definition
Associate the building blocks in a report definition
Open the sample reports to review additional balance sheet designs
Module 11: Statements of Cash Flow
In this module of training, students begin by reviewing a sample cash flow report. Additionally, the training shows how to fine tune a basic cash flow’s design to accommodate the FASB style of reporting that breaks out activity typically assigned to a single general ledger account, such as separating loan proceeds from loan payments. Students are also introduced to the combined link method of reporting on data in an Office Excel worksheet compared to prior year end results.
Lessons
Sample Statement of Cash Flow
Review the Cash Flow Building Blocks
Generating the Statement of Cash Flows
FASB Style Statement of Cash Flow
After completing this module, students will be able to:
Access the sample cash flow statements included in the demonstration data
Implement the design of a statement of cash flow report
Look at the effect of the calculation priority setting
Complete a FASB style statement of cash flow using a combined link in the row definition
Module 12: Consolidation Reporting
This module explains how to design a reporting tree that accesses both the sample entities, Fabrikam, Inc. (FW) and Fabrikam Canada, Inc. (FWC). This reporting tree is then associated with a column definition to present the entities activity in a side-by-side or consolidating format. Intercompany eliminations are added to the design in two methods: accounts filters in the column definition and external worksheet linking.
Lessons
Consolidation Overview
Multi-Entity Reporting Trees
Consolidating Column Definitions
Consolidating Row Definitions
Consolidating Report Definition
Sort Commands
External Worksheet Linking
Consolidating Balance Sheet with Separate Link
After completing this module, students will be able to:
Explore the basics of multi-company reporting in Management Reporter
Create a reporting tree that connects to multiple entities
Create a consolidating column definition
Modify a row definition to support multi-company accounts
Define a consolidating or consolidated report
Add sorts commands to a row definition
Utilise the separate link method of accessing data in an Excel worksheet
Module 13: Report Output and Distribution
This module explains how to design a reporting tree that accesses both the sample entities, Fabrikam, Inc. (FW) and Fabrikam Canada, Inc. (FWC). This reporting tree is then associated with a column definition to present the entities activity in a side-by-side or consolidating format. Intercompany eliminations are added to the design in two methods: accounts filters in the column definition and external worksheet linking.
Lessons
Output Type
E-mail Settings
Other Options and Exception Reports
Report Viewer Distribution
After completing this module, students will be able to:
Choose from four output types available
Distribute reports using email settings and recipients defined in the reporting tree or report definition
Generate an exception report to list missing or duplicate accounts or dimensions based on the row definition's design
Access report distribution options within the Report Viewer
Module 14: Security
This module explains how to create users and assign them to one of four security roles: Administrator, Designer, Generator, or Viewer. Group and entity assignments applicable to users and report access in Report Viewer is also explored.
Lessons
Defining Users and Roles
Working with Groups and Entities
Report Viewer Security
Generator Functionality
After completing this module, students will be able to:
Create users and select security permissions
Create groups and assign users
Modify Report Library permissions
Module 15: Maintaining Management Reporter
This module explains how to use the Tools menu options.
Lessons
Tools Menu Options
After completing this module, students will be able to:
Change a user password (when using application authentication only)
Protect building blocks
Review and update the security account policy (administrators only)
Review and release checked out building blocks (administrator and designer roles only)
Refresh cached data
Module 16: Migration
This module explains how to migrate data from Microsoft FRx 6.7 into Management Reporter.
Lessons
Overview
Migration Steps
After completing this module, students will be able to:
Perform a migration of data from Microsoft FRx 6.7
Configure migrated entities in Management Reporter
Validate the migrated data
Module 17: Appendix
This module supplies supplemental topics.
Lessons
Report Wizard
Structure and Special Characters
After completing this module, students will be able to:
Use the Report Wizard to define basic financial statements
Explore the relationship of special characters in the structure of the row definition and reporting tree definition
