Training Class Descriptions

Financial Reporting Extender II (FRx) Class

Return to Class List

The two-day Report Design Essentials II course builds on the basic report design skills learned in Report Design Essentials I. Using Microsoft® Business Solutions for Analytics-FRx® you learn advanced report design including linking to external worksheet data, linking row formats, multi company consolidations, currency translation reporting and cash flow. A combination of instructor guided exercises and practice tutorials allow students to master their report design skills.

A thorough understanding of these topics allows you to master the advanced report design techniques necessary to create a more comprehensive suite of financial and management reports. You learn how to use links to extract data from a variety of sources including non-financial metrics maintained outside the general ledger. This course also teaches you how to move into cutting edge technology, using OLAP and XRBL output options. These skills enable you to take control of the financial reporting process, allowing you to be more productive and efficient in the way you create, generate and distribute financial information, which in turn will help you to enable internal and external stakeholders to make well informed decisions.

After completing this course, students should be able to:

 

• Have a renewed understanding of basic FRx report design concepts
• Explore ways to efficiently create and distribute many financial reports including:
• Linking to an external worksheet data
• Statement of Cash Flow
• Using full accounts or multiple segments in reports
• Allocation reporting
• Linking Row formats
• Relational reporting
• Multi-company consolidations
• OLAP (Online Analytical Processing) output
• XBRL (extensible Business Reporting Language) output
• Advanced formatting tips and tricks

 

Agenda

8:00—8:30 Continental Breakfast each day

 

Day 1 

 

1. Introduction and product overview
2. Concept Overview
3. Linking to External Worksheets
4. Gross Profit per Unit—Practice
5. Full Account Code and Multiple Segments
6. Defining Departments in the Row Format—Practice
7. Statements of Cash Flow
8. FASB Style Statement of Cash Flow—Review
9. Allocations
10. Modified Allocation of Corporate Expenses—Practice

 

Day 2 

 

1. Row Linking
2. Row Linking Income Statement—Practice
3. Relational Reporting
4. Multiple Base Row Definitions & Using Statistical Information as a Base Row
5. Additional Formatting Concepts
6. Consolidations
7. OLAP Output
8. XBRL
9. Currency Translation
10. Review

           

4:30—5:00 FRx Q & A each day

Return to Class List