Microsoft FRx Report Design Essentials I

Novice Microsoft FRx users

Intermediate and experienced Microsoft FRx users who would like to refresh their skills or develop broader product proficiency

FRx Software Corporation product resellers and consultants

Understand basic navigation and report creation in Microsoft FRx

Drill down, analyze, print and export from FRx Drilldown Viewer

Efficiently create and distribute many financial reports including:

Trial balances

Balance Sheets

Transaction detail reporting

Trended reports

Side-by-side presentation

Relational reporting

Actual vs. Budget

Rolling quarters

Know some tips and tricks for increasing speed and accuracy of month-end close

Create presentation quality reports

Understand security settings within Microsoft FRx

Understand many ways to improve your company's financial reporting package

Basic knowledge of accounting principles

Microsoft FRx Overview & Basic Reporting eCourses

Exam Microsoft FRx certification exam:

About FRx Software Corporation products

Terminology

Demo company account structure

Sample report demonstration

Understand the terminology used in class

Have a high level understanding of rows, columns, trees and how they relate to each other in the catalog

Generate a catalog to FRx DrillDown Viewer and navigate to the various reports and drill down levels

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

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

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

Review basic report design concepts

What's Wrong?

Recognize common errors in reports

Correct errors in report design

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

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

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

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

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

Review basic report design concepts

Modify Building Blocks

Modify an existing report

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

Detailed Balance Sheet

Comparative Balance Sheet

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

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

Summary Income Statement

Trended Income Statement

Current & YTD Trended Income Statement

Over/(Under) Budget Income Statement

Favorable/(Unfavorable) Budget Variances

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

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

Defining a Base Row

Multiple Base Row Definitions

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

Using Account Filters in the Column Layout

Restricting columns to specific Tree Units in the Column Layout

Side by Side Reporting with Filters

Side by Side Reporting with a Reporting Tree

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

Naming conventions

Chain to Catalog ID functionality

Report archive options

E-mail distribution methods available in Microsoft FRx

FRx WebPort distribution

FRx Report Manager Demonstration

Chaining Report Catalogs

Chain catalogs for easier report generation

Understand the common methods for creating an archive of reports

Distribute reports via E-mail

Have a high level overview of WebPort and Report Manager, optional components available with Microsoft FRx

Importing a .tdb file

Troubleshooting a report

Broken Income Statement

Correct design errors in an existing report

Rebuilding the GL Index (.G32 file)

Compacting the Microsoft FRx Databases

Getting additional help

Report Design Guidelines

Rebuilding the GL Index

Compacting the Microsoft FRx Databases

Delete the .G32 file, forcing it to rebuild

Compact the Microsoft FRx Databases

Understand where to get additional help

Understand basic report design guidelines

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

Think creatively about report display

How does FRx Report Launcher differ from FRx Report Designer

What are the functions available in FRx Report Launcher

Use FRx Report Launcher to generate a Catalog

Row Formats

Column Layouts

Reporting Trees

Catalog of Reports

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

Use the padlock to secure a component

Activate Microsoft FRx security and create users and groups

Assign users or groups to Microsoft FRx components

Report Book design

Properties - General

Headers and Footers

Security

Distribution

Publishing

File or Report Properties

Report Options

FRx DrillDown Viewer display