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.

Topics

• Using the "Add Rows from Chart of Accounts" feature to automatically populate the row format with account numbers and descriptions
• Using wildcards or ranges to summarize data
• Using the Normal Balance field and how C's affect the account presentation
• Using underscores and totals
• Using Header Codes to automatically update column headers each month
• Use of the BASE Period and Year in the Column Layout to ease maintenance
• Setting the Report Date to an option that automatically progresses through the year for ease of report maintenance
• Defining a detail level in the Catalog
• Introduce the default Formatting options
• Using existing building blocks to speed setup time
• Using the View, Subtotals function in FRx DrillDown Viewer

• Detailed Trial Balance
• Summary Trial Balance

• Create a new Row Format either manually or with Add Rows from Chart of Accounts
• Add format codes and related information to a row
• Create a new Column Layout designed for current and year to date results
• Add column headers, using either header codes or text
• Create a new Catalog, defining the detail level, report date, building blocks and formatting as desired

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.

• Using the Add Rows from Chart of Accounts function to quickly create a basic template
• How proper placement of C's in the Account Balance column of the Row Format will flip the balance of an account for presentation
• How the presentation of the accounts included determine the math for related TOT or CAL formulas
• How to use a Special Format Mask on a row formula to determine display
• Using system defined or custom fonts for emphasis
• Working with rounding options

• Detailed Income Statement

• Understand the use of "C" in the Row Format
• Add a TOT or CAL format code and related information to a row
• Add a Special Format Mask to a row
• Define the font for a given row
• Edit the report header using either codes or text
• Define a font for a report header
• Define rounding options

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.

• Characters used with Add Reporting Units
• Segment hierarchy
• Defining a segment range
• Adding custom units to a tree
• The default Reporting Tree
• Relating Reporting Trees to Row Formats
• How trees define multiple reports in a single catalog
• Using check rows to insure all accounts are included
• Rounding options and how they relate to calculations
• How to relate description or underscore rows to other rows
• Exception reports and how they work

• Creating Reporting Trees
• Departmental Income Statement

• Understand the symbols used in Reporting Trees
• Create a basic Reporting Tree using Add Reporting Units from Chart of Accounts
• Define the hierarchy when building a Reporting Tree on multiple segments in the account mask
• Limit the range of a segment when building a Reporting Tree
• Add new units to a Reporting Tree
• Modify the hierarchy of a Reporting Tree
• Understand how Reporting Trees relate to the Row Format
• Relate rows in the Row Format
• Add a check row or exception report to verify report accuracy
• Define rounding in the catalog

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

Topics

• Review basic report design concepts

Labs

• What's Wrong?

After completing this module, students will be able to:

• Recognize common errors in reports
• Correct errors in report design

Topics

• How to create a Column Layout based on current and prior results
• Defining unit hierarchy when building a Reporting Tree
• How to split a segment to create a virtual segment in Reporting Trees
• Adding custom units to a Reporting Tree
• Generating specific Reporting Tree units
• Using header and footer codes in the Catalog

Labs

• This year vs. last year Income Statement
• Income Statement by Location

• Create a multiple year Column Layout
• Add column header text that will span multiple columns
• Dynamically print the year in the column header
• Define the account segment hierarchy when building a Reporting Tree
• Add custom units to a Reporting Tree
• Create a Reporting Tree containing a virtual reporting segment
• Set specific Reporting Tree units to automatically generate
• Understand the difference between using Save As and Clone to copy an existing catalog

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.

• Creating a transaction detail Column Layout
• Restricting a column to either debit or credit activity
• Restricting a column to display beginning balances
• Generating a Catalog to the Microsoft Office Excel output option
• How report presentation varies between Microsoft Excel and FRx DrillDown Viewer

• Cash Transaction Details
• Debit/ Credit Details

• Understand how wildcards in the Row Format display multiple accounts
• Add transaction details to the Column Layout design
• Restrict a column to include debit or credits only
• Define a column to present beginning balances for the period
• Generate a report directly to Excel
• Understand how the 'format as Excel outline' option affects the output

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

• Printing reports from FRx DrillDown Viewer
• Sending reports
• Export options in FRx DrillDown Viewer

• Viewing/ Printing Account Detail
• Using the Send feature
• Export Options

• Print a financial or detail report from FRx DrillDown Viewer
• Send a report from the FRx DrillDown Viewer
• Export a report using Formatted Excel
• Export a report using standard Excel
• Export a report to an HTML format

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

• Understand the specification set (.F32) file
• Defining the active spec set in the Company Information settings
• Navigation in the Specification Sets window
• Learn to "save as" between spec sets
• Learn to export and import between spec sets

• Saving between Spec Sets
• Export and Import between Spec Sets

• Assign a specification set to a company
• Create a new spec set
• Move building blocks between spec sets

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

Topics

• Review basic report design concepts

Labs

• Modify Building Blocks

After completing this module, students will be able to:

• Modify an existing report

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.

Topics

• Account Sets
• Presentation of Balance Sheet accounts (using C in the Normal Balance)
• Defining Year to Date Income in the Balance Sheet
• Using the XD code to suppress drill down on specific rows
• Using column G of the Row Format to define placement in the Column Layout
• Using the Rounding Adjustments function
• Using XD in the Column Layout to suppress GL details

Labs

• Detailed Balance Sheet
• Comparative Balance Sheet

After completing this module, students will be able to:

• Create a variety of Column Layouts for use in Balance Sheet reporting
• Define or modify Account Sets
• Understand data presentation in Balance Sheet reporting
• Suppress a row in the Row Format from drill down to account or transaction details
• Understand Rounding Adjustments and how to work with them
• Define specific column placement for information in the Row Format
• Suppress details in GL type columns

This chapter introduces several variations of the standard Income Statement.

Topics

• Summary Income Statement design
• Trended Income Statement design
• Using conditional statements in the Column Layout
• Using Account Modifiers in the Row Format to override the Column Layout
• Variance reporting (Over/(Under) and Favorable/(Unfavorable) methods
• Sort commands

Labs

• Summary Income Statement
• Trended Income Statement
• Current & YTD Trended Income Statement
• Over/(Under) Budget Income Statement
• Favorable/(Unfavorable) Budget Variances

After completing this module, students will be able to:

• Create a trended Column Layout
• Define conditional print controls in the Column Layout
• Use Account Modifiers in the Row Format to override Column Layout definitions
• Add a variance calculation to the Column Layout
• Understand XCR and how it is used for variance reporting
• Add a sort format code and its related information to a Row Format

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.

Topics

• Defining CBR (Base) rows in the Row Format
• Defining Column Layout calculations that work with CBR in the Row Format
• Suppressing CBR in detail reports

Labs

• Defining a Base Row
• Multiple Base Row Definitions

After completing this module, students will be able to:

• Define one or more CBR (base) rows in a Row Format
• Understand the proper placement of CBR rows
• Enter a calculated column in the Column Layout that references the CBR rows
• Suppress CBR calculations for account details when drilling down

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

Topics

• Using Account Filters in the Column Layout
• Restricting columns to specific Tree Units in the Column Layout

Labs

• Side by Side Reporting with Filters
• Side by Side Reporting with a Reporting Tree

After completing this module, students will be able to:

• Create a Column Layout using Account Filters
• Create a Column Layout using the Reporting Unit restriction
• Understand how these two methods of side by side reporting differ and when to use each

This chapter introduces a variety of topics related to report distribution.

Topics

• Naming conventions
• Chain to Catalog ID functionality
• Report archive options
• Email distribution methods available in Microsoft FRx
• FRx WebPort distribution
• FRx Report Manager Demonstration

Labs

• Chaining Report Catalogs
• After completing this module, students will be able to:
• Chain catalogs for easier report generation
• Understand the common methods for creating an archive of reports
• Distribute reports via Email
• Have a high level overview of WebPort and Report Manager, optional components available with Microsoft FRx

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

Topics

• Importing a .tdb file
• Troubleshooting a report

Labs

• Broken Income Statement

• Correct design errors in an existing report

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

Topics

• Rebuilding the GL Index (.G32 file)
• Compacting the Microsoft FRx Databases
• Getting additional help
• Report Design Guidelines

Labs

• Rebuilding the GL Index
• Compacting the Microsoft FRx Databases

After completing this module, students will be able to:

• Delete the .G32 file, forcing it to rebuild
• Compact the Microsoft FRx Databases
• Understand where to get additional help
• Understand basic report design guidelines

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

Topics

• Adding a Microsoft FRx report to Microsoft Office Outlook
• Adding report information to Excel and Microsoft Office Word documents
• Overview of Microsoft FRx Report Design Essentials II training class

After completing this module, students will be able to:

• Think creatively about report display

This appendix contains solutions to quizzes and tutorials completed during class.

This appendix covers the features and functionality of Microsoft FRx Report Launcher. Report Launcher is a separate Microsoft FRx component that allows users to generate reporting catalogs that have been created with FRx Report Designer.

Based on student needs, this appendix is optional for classroom presentation.

Topics

• How does FRx Report Launcher differ from FRx Report Designer
• What are the functions available in FRx Report Launcher

After completing this module, students will be able to:

• Use FRx Report Launcher to generate a Catalog

This appendix is intended for future reference and contains a recap of the functionality discussed in class.

Topics

• Row Formats
• Column Layouts
• Reporting Trees
• Catalog of Reports

This appendix provides an overview of the security options available in FRx Report Designer.

Topics

• Network security
• Padlock security
• How to activate security in Microsoft FRx
• How to create Microsoft FRx users and groups
• How to apply component security within Microsoft FRx

After completing this module, students will be able to:

• Use the padlock to secure a component
• Activate Microsoft FRx security and create users and groups
• Assign users or groups to Microsoft FRx components

This appendix introduces the five simple steps to Report Book creation and covers FRx Report Manager functionality.

Topics

• Report Book design
• Properties General
• Headers and Footers
• Security
• Distribution
• Publishing
• File or Report Properties
• Report Options
• FRx DrillDown Viewer display

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.

Lessons

• Basic Row Format review
• Working with TOTs and CALs in the Row Format
• How C's affect TOT and CAL rows and why to use them
• Defining a sort in the Row Format
• Relating rows to other rows
• Basic Column Layout review
• Defining a favorable/(unfavorable) variance Column Layout
• Working with BASE periods and years in the Column Layout
• Using "Add Reporting Units from Chart of Accounts" to build a Reporting Tree
• Using the split function to isolate a single account mask character
• Creating a new Reporting Catalog
• Defining report headers and footers
• Working with sub-totals in FRx DrillDown Viewer

Lab : Row Repair

Lab : Column Repair

Lab : Build a Tree

Lab : Build a Catalog

After completing this chapter, students will be able to:

• Understand basic Row Format design
• Correct design errors in an existing Row Format
• Understand basic Column Layout design
• Supply missing elements within a favorable/(unfavorable) Column Layout design
• Understand basic Reporting Tree design
• Split an account mask segment and create a tree based on a single character within the mask
• Understand basic Catalog settings
• Build a Catalog, defining the building blocks, headers and detail level

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.

Lessons

• Referencing external worksheet data
• Optional row modifiers
• Determining the period of data to be reported on
• Using the combined GL+Worksheet link in the Row Format
• Calculation priority with working with intersecting row and column calculations
• Adding an external worksheet link to the Row Format
• Proper syntax in combined vs. separate linking
• Using the optional row modifiers /CPO and /RPO when referencing worksheet data
• Designing Column Layouts that report on either/or data (i.e. either Actual or Budget) depending on the report date

Lab : Combined Worksheet Method

Lab : Separate Worksheet Method

After completing this chapter, students will be able to:

• Understand the difference between the combined link and separate linking methods and when to use either
• Add a combined link to the Row Format with related syntax
• Add a separate link to the Row Format with related syntax
• Understand when multiple separate links are required
• Understand how and when to use /CPO or /RPO
• Add conditional print controls to the Column Layout
• Create a Reporting Tree with external link (separate method) information
• Understand the "Use row format(s) and worksheet links from Reporting Tree" function

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.

Lessons

• Defining the GL+Worksheet link
• Working with the /CPO and /RPO row modifiers
• Using account and book code modifiers
• Advanced calculations and non-printing rows
• Modifying a Column Layout to link to worksheet data

Lab : Gross Profit per Unit

Lab : Modified Favorable/(Unfavorable) Budget Variances

After completing this chapter, students will be able to:

• Modify a combined GL+Worksheet link
• Modify the cell references used within a combined link
• Understand the use of /RPO when linking to a worksheet
• Add an account and/or book code modifier to a row in the Row Format
• Add non-printing (NP) GL or worksheet rows for use in calculations
• Add a complex, nested calculation to a Row Format
• Modify an existing Column Layout for WKS type links

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.

Lessons

• Defining a fully qualified account in the Row Format
• How a full account in the Row Format affects units in a Reporting Tree
• Defining a range of periods in the Column Layout
• Using conditional dates in the Column Layout
• Using a range in a calculated column in the Column Layout

Lab : Using Full Account Codes

Lab : Using Multiple Segments

After completing this chapter, students will be able to:

• Understand how full account codes can be used in the Row Format
• Understand how specific characters within the account mask can be defined in the Row Format
• Create a Reporting Tree with hooks (ampersands) matching the accounts defined in the Row Format
• Create a quarterly Column Layout
• Define boxes in the Row Format to highlight specific report areas
• Display text from the Reporting Tree in the body of the report through the Row Format
• Suppress page breaks between Reporting Tree units when printing reports

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.

Lessons

• Defining the Department segment in the Row Format
• Defining a Reporting Tree that recognizes the Department in the Row Format
• Using Account Filters in the Column Layout

Lab : Defining Departments in the Row Format

Lab : Unit Restrictions in the Row Format

After completing this chapter, students will be able to:

• Build a Row Format based on an account segment other than the natural account
• Create a Reporting Tree to work with the Row Format
• Use Account Filters in the Column Layout to define specific accounts in a side by side presentation
• Work with non-printing columns when defining a Column Layout

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.

Lessons

• Using "C" in the normal balance to properly state sources and uses of cash
• Using the beginning balance and year to date account modifiers
• Defining a non-printing check row
• Using specific placement calculations in the Row Format
• Designing Column Layout's that display the changes in activity for the time frame being reported on
• Defining calculation priority for intersecting row and column calculations

Lab : Monthly Statement of Cash Flow

Lab : Current and Year to Date Statement of Cash Flow

After completing this chapter, students will be able to:

• Understand the use of C in the Row Format when designing a cash flow statement
• Use account modifiers to define beginning and ending cash account balances
• Define Row Format calculations that place data in specific columns of the Column Layout
• Create a Column Layout defining current or current and year to date changes in cash
• Understand the calculation priority needed when designing a current and year to date Statement of Cash Flow

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.

Lessons

• Modifying an existing report design
• Using a combined GL+Worksheet link
• Using the /RPO row modifier
• Using non-printing check rows to validate report accuracy

Lab : FASB Style Statement of Cash Flow

After completing this chapter, students will be able to:

• Understand the use of C in the Row Format when designing a cash flow statement
• Use a combined GL+Worksheet link for details defined in an external spreadsheet
• Use account modifiers to define beginning and ending cash account balances
• Define Row Format calculations that place data in specific columns of the Column Layout
• Add a check row to verify worksheet data balances to GL data
• Understand the calculation priority needed when designing a current and year to date Statement of Cash Flow

Lessons

• Using specific column placement in Row Format calculation
• Column G restrictions in the Row Format
• Using Book Code modifiers in the Row Format
• How to work with full accounts in the Row Format when using a Reporting Tree
• Suppressing data from rolling up in the Reporting Tree
• Using multiple GL Links in the Row Format and Reporting Tree
• Presentation of external worksheet data in calculated columns
• Advanced calculations in the Column Layout
• Advanced formatting

Lab : Allocation Journal Entry

Lab : Allocation Reporting

Lab : Two-pass Allocation Reports

After completing this chapter, students will be able to:

• Understand how full accounts in the Row Format work in conjunction with a Reporting Tree
• Work with Book Code modifiers in the Row Format
• Understand the use of column G restrictions in the Row Format
• Define multiple GL Links in the Row Format and Reporting Tree
• Create a two-pass report, pulling data from an external worksheet created in the first pass
• Format vertical lines in a report

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

Lessons

• Modifying existing building blocks
• Use non-printing columns for period specific information
• Using print controls to determine active columns
• Using non-printing rows and specific column placement calculations in the Row Format

Lab : Modified Allocation of Corporate Expenses

After completing this chapter, students will be able to:

• Add non-printing CALC columns, hard coded to each period
• Use column print controls to determine which columns will add into a related average calculation
• Understand how column calculations recognize non-printing columns
• Define specific columns for display of information defined in the row

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.

Lessons

• Adding a Row Format link to a Row Format
• Using text labels for row codes
• Defining a Reporting Tree that relates to multiple Row Formats
• Advanced formatting concepts
• How rounding options work with Row Linking

Lab : Row Linking

Lab : Row and General Ledger Linking

After completing this chapter, students will be able to:

• Understand why to use text labels for row codes in the Row Format
• Define a Link to Row Format and the related row codes when designing a report based on Row Linking
• Create a Row Format using both GL and Row Format links
• Create a Reporting Tree that references multiple Row Formats
• Define a Catalog using a Row Linking design

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.

Lessons

• Linking to another Row Format
• Defining a Reporting Tree that can access multiple Row Formats
• Using the BASE+ concept in the Column Layout
• Rounding options when using Row Linking

Lab : Row Linking Income Statement

After completing this chapter, students will be able to:

• Design a Row Format that links to another Row Format
• Add text labels as needed for the design
• Create a Column Layout that dynamically pulls future budget data
• Create a Reporting Tree based on Row Linking
• Understand Tree rounding options when working with a Row Linking report design

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

Lessons

• Concept Review

Lab : Crossword Puzzle

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.

Lessons

• Defining the CBR or Base Row(s)
• Defining Column Layout calculations that work with CBR in the Row Format
• Using Reporting Unit restrictions in the Row Format vs. full account codes to restrict the data being reported on
• Using Reporting Unit restrictions in the Column Layout vs. Account Filters to restrict the data being reported on

Lab : Multiple Base Row Definitions

Lab : Using Statistical Information as a Base Row

After completing this chapter, students will be able to:

• Add one or more CBR format codes and related base row information to the Row Format
• Define a Column Layout with calculations that refer to the CBR rows
• Understand the difference between defining a Row Format based on full account codes vs. relating rows to a Reporting Tree
• Understand the difference between defining a Column Layout with account filters vs. relating columns to a Reporting Tree

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

Lessons

• Using save as to create multiple Column Layouts with simple updates to each
• Defining effective dates in the catalog

Lab : Variable Income Statement

After completing this chapter, students will be able to:

• Use the effective dates setting when defining a Catalog

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

Lessons

• IF/THEN/ELSE calculations in the Row Format
• IF/THEN/ELSE calculations related to Reporting Tree Units
• IF ABS (absolute value) calculations in the Column Layout

Lab : Using Conditional Statement

Lab : If-Then-Else and Reporting Tree units

Lab : Variance Reporting

After completing this chapter, students will be able to:

• Use conditional logic in Row Format and Column Layout calculations

This chapter introduces a variety of advanced report design topics.

Lessons

• Using column Z (Additional Text) in the Reporting Tree
• Working with Excel or Microsoft( Office Word( and Microsoft FRx
• Defining International Formats

Lab : Additional Descriptive Text

After completing this chapter, students will be able to:

• Define distinct text for each Reporting Tree unit, using the column Z of the tree
• Add the additional text defined in the Reporting Tree to Catalog headers or footers, or to the Row Format
• Understand how building block data can be manipulated in Excel then pasted back to Microsoft FRx
• Generate Microsoft FRx results to Excel, then use the mail merge function in Microsoft Word to present financial results in a document
• Define international formats and assign them to a company in Microsoft FRx

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.

Lessons

• Overview of multiple company consolidations in Microsoft FRx
• How to format amounts
• Assigning an international format to a report
• When is a Reporting Tree required
• Side-by-side (consolidating) Column Layout design
• Linking to external worksheet data

Lab : GL Eliminations

Lab : External Eliminations

After completing this chapter, students will be able to:

• Create a multi-company consolidation report
• Add account filters to eliminate specific accounts or ranges of account
• Link to an external worksheet containing elimination entries
• Create a side by side, consolidating Column Layout
• Define an International Format and assign it to a company
• Assign an International Format to Reporting Tree units

Lessons

• Microsoft FRx and OLAP
• Microsoft Local Cubes
• Microsoft Server Cubes
• Excel Pivot Chart and Excel Pivot Table output options
• Terminology in OLAP and Microsoft FRx
• Lab : Working with OLAP Cubes in Excel

After completing this chapter, students will be able to:

• Generate an FRx instant! OLAP ( Microsoft Local or Server Cube
• Generate an Excel Pivot Table or Excel Pivot Chart
• Understand how terminology in a Local Cube (Pivot Chart or Pivot Table) relates to Microsoft FRx terminology
• Work with Pivot Charts or Pivot Tables in Excel

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.

Lessons

• XBRL Overview
• Adding an XBRL link and related taxonomy file
• Assigning XBRL tags
• The XBRL Instance Document output option

Lab : Create an XBRL Document in Microsoft FRx

After completing this chapter, students will be able to:

• Add an XBRL Link and related taxonomy table to the Row Format
• Assign XBRL tags to all financial rows in the Row Format
• Generate a Catalog to the XBRL Instance Document output option
• Review the related output in Internet Explorer

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.

Lessons

• Using an external worksheet link to pull in translation rates
• Adding CTA (cumulative translation adjustment) to the Row Format
• Using column restrictions in the Column Layout to define formatting
• Defining the DAX rates path
• Activating DAX in the Catalog and Column Layout
• Assigning currency conversion format codes and related rate IDs

Lab : Translated Balance Sheet

Lab : Translated Balance Sheet using DAX

Lab : Translated Income Statement using DAX

After completing this chapter, students will be able to:

• Create a currency conversion report pulling translation rates from an external worksheet
• Define the rates database path in the company defaults
• Add currency conversion format codes and related rates to the Row Format
• Activate DAX in the Column Layout and select the related currency display codes
• Define currency conversion options in the Reporting Catalog

This appendix contains solutions to quizzes and tutorials completed during class.

This appendix covers three additional cash flow reports covering a variety of advanced design concepts, as well as a Full Year Forecast using effective dates in the Catalog.

Based on student needs, this appendix is optional for classroom presentation

This appendix is intended for students who are interested in a more detailed understanding of OLAP and available browsers.