Report Design Essentials - II

1. Basic Knowledge Of Accounting Principles. In Addition, It is Recommended, But not Required, That Candidates Have Completed the Same.
2. Microsoft FRx Report Design Essentials I
Training Type: Classroom
Duration: 18hrs


Sub Topic


Report Design Essentials II

  • Overview and Introduction
  • Concept Overview
  • Linking to External Worksheets
  • Practice
  • Full Account Code & Multiple Segments
  • Rotate the Building Blocks
  • Statements of Cash Flow
  • Practice
  • Allocations
  • Practice
  • Review
  • Relational Reporting
  • Effective Dates
  • Additional Formatting Concepts
  • Consolidations
  • OLAP Output
  • XBRL
  • Currency Translation

18 Hours

Module 1: Overview and Introduction

his chapter gives students a general overview of the features and benefits of using Microsoft FRx for financial statement design. It also introduces the demo company that will be used in the course exercises.

Module 2: Concept Overview

This chapter contains a detailed list of all fields within the Row Format, Column Layout, Reporting Tree and Catalog. Basic report design concepts are reviewed, while advanced functionality is introduced.

Module 3: Linking to External Worksheets

This chapter allows students to complete reports that link to external worksheet data. Within Microsoft FRx there are two methods for "linking" to worksheets. The combined method allows for a single link to both the general ledger and the worksheet within the Row Format. The separate method works with one or more external links in the Row Format and requires the use of a Reporting Tree. Both methods are practiced in this chapter.

Module 4: Practice

This chapter contains practice tutorials to reinforce the students knowledge of linking methods covered in the previous exercises. Students modify an existing reports based on changes to the worksheet and additional data required on the reports.

Module 5: Full Account Code & Multiple Segments

This chapter introduces the concept of defining the Row Format on the full account code, a technique useful when designing reports based on specific grouping of responsibility centers such as department or location. It also introduces the concept of reporting on multiple segments within the row and how to define the related Reporting Tree.

Module 6: Rotate the Building Blocks

This chapter introduces an alternate report design concept. Students build a summary Income Statement where departmental data is presented in the Row Format, the Column Layout defines the key financial reporting data and the Reporting Tree is based on specific locations.

Module 7: Statements of Cash Flow

This chapter looks at how simple it is to design a Statement of Cash Flow using Microsoft FRx. In these exercises you work with partially created building blocks, and add the key cash flow reporting details

Module 8: Practice

This chapter contains a practice tutorial to reinforce the students knowledge of cash flow and worksheet linking design concepts covered in the previous exercises. Students modify the existing current and year to date Statement of Cash Flow to accommodate details for specific line items drawn from an external worksheet.

Module 9: Allocations

This chapter covers two distinct types of allocation reports. The first pulls data from the general ledger that will be used for an allocation journal entry, the second allocates financial results for reporting purposes only.

Module 10: Practice

This chapter contains a practice tutorial to reinforce the student's knowledge of advanced calculation concepts covered in the previous exercises.

Module 11: Row Linking

This chapter discusses reports built with the Row Linking functionality, wherein a Row Format pulls data from one or more Row Formats instead of, or in addition to, the general ledger.

Module 12: Practice

This chapter contains a practice tutorial to reinforce the student's knowledge of row linking design concepts covered in the previous exercises. Using row linking, summary and detailed Income Statements are built in a single catalog.

Module 13: Review

This chapter includes a fun way to review the report design concepts covered so far in class.

Module 14: Relational Reporting

This chapter reviews the concept of relational reporting, where one or more base rows and related column calculations are defined. Common uses of relational reporting include percentage of sales and percentage of total expenses. The exercises in this chapter focus on relationships to statistical data.

Module 15: Effective Dates

This chapter introduces the concept of using effective dates in the Catalog to dynamically control building blocks in relation to the report date.

Module 16: What's Wrong?

This chapter introduces advanced calculations using IF/THEN and IF/THEN/ELSE calculations in report design.

Module 17: Additional Formatting Concepts

This chapter introduces a variety of advanced report design topics.

Module 18: Consolidations

This chapter introduces the concept of reporting on multiple companies and their eliminating entries, in a single report. Two methods for reporting on elimination entries are included. In the first method, activity is stored in the general ledger in specific GL accounts. In the second method, total elimination amounts are pulled from an external worksheet

Module 19: OLAP Output

This chapter introduces students to OLAP (Online Analytical Processing) output options within Microsoft FRx. A brief hands-on with an OLAP cube is also included.

Module 20: XBRL

This chapter introduces XBRL (eXtensible Business Reporting Language) in Microsoft FRx. XBRL is a standardized financial reporting format that is clear and easy for anyone to interpret and analyze.

Module 21: Currency Translation

This chapter allows students to practice two methods of currency translation in reporting; using rates stored in an external worksheet and using DAX, the optional currency translation module available from Microsoft FRx.

Our Customers

Always and forever at your Service