Report Design Essentials - I

Basic Knowledge of Accounting Principles.

Training Type: Classroom
Duration: 18hrs


Sub Topic


Report Design Essentials I

  • Overview and Introduction
  • Creating a Trial Balance
  • Creating an Income Statement
  • Reporting Trees
  • Review
  • Transaction Detail Reporting
  • Using FRx Drilldown Viewer
  • Working with Specification Sets
  • Balance Sheets
  • Income Statement Variations
  • Relational Reporting
  • Side by Side Reporting
  • Report Distribution
  • What's Wrong?
  • Troubleshooting
  • Advanced Concepts

18 Hours

Module 1: Overview and Introduction

This 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: Creating a Trial Balance

This chapter focuses on one of the most basic and essential reports, a trial balance that shows the general ledger activity for the month and/or year. A trial balance is a starting point for analyzing and reconciling account balances and activity. Once your trial balance is in balance, Income Statements and Balance Sheets, which group together certain natural or main accounts to report assets, liabilities, revenues, and expenses, may be created.

Module 3: Creating an Income Statement

This chapter focuses on another primary financial statement, the Income Statement. Income Statements may be detailed or summarized and may also compare current performance to budgeted projections or previous results.

Module 4: Reporting Trees

This chapter examines Reporting Trees, what they are, why to use them and most importantly, how to create and maintain them.
Reporting Trees are created by defining a number of related attributes, such as the company name and account mask. Tree depth and complexity is up to the report designers needs and may include security items, email addresses, links to external spreadsheet data and more

Module 5: Review

This chapter allows students to review the concepts learned thus far in class by correcting some errors or omissions in a report.

Module 6: More on Reporting Trees

This chapter continues with the concepts learned thus far, and expands that knowledge with more complex building blocks and catalog settings.

Module 7: Transaction Detail Reporting

This chapter looks at transaction details and the specific columns that work with them. These allow for reporting on such items as source journal, transaction date and transaction reference number. Common column restrictions are also introduced.

Module 8: Using FRx DrillDown Viewer

This chapter shows students some additional functionality available within FRx DrillDown Viewer.

Module 9: Working with Specification Sets

This chapter focuses on Specification sets; the file that contains all the building blocks created during report design.

Module 10: What we Know

This chapter allows students to review the concepts learned so far by taking a concept quiz and modifying an existing report.

Module 11: Balance Sheets

This chapter focuses on Balance Sheet design, another primary financial report. Students learn about Account Sets and how to create them, as well as functionality designed to keep Balance Sheets in balance.

Module 12: Income Statement Variations

This chapter introduces several variations of the standard Income Statement.

Module 13: Relational Reporting

This chapter introduces 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, however this concept may be used for any report that requires reporting on a relationship between elements.

Module 14: Side by Side Reporting

This chapter continues working with Income Statement designs by introducing a side by side presentation of departmental data.

Module 15: Report Distribution

his chapter introduces a variety of topics related to report distribution

Module 16: What's Wrong?

This chapter gives students an opportunity to correct a report containing some basic report design flaws.

Module 17: Troubleshooting

This chapter shows students how to perform basic maintenance within Microsoft FRx.

Module 18: Advanced Concepts

This chapter introduces some creative uses for Microsoft FRx reports and previews some reports taught in the Report Design Essentials II course.

Our Customers

Always and forever at your Service