World Class Financial Reporting with FRx Report Writer

Document Sample
World Class Financial Reporting with FRx Report Writer Powered By Docstoc
					World Class Financial Reporting
   with FRx Report Writer


            Elisa R. Vick
      elisa.vick@cistech.net
Agenda
• Overview
• FRx Demonstration
  – Design features (required)
    • Rows
    • Columns
  – Design features (optional)
    • Trees
    • Security
    • Excel Linking
    • Report Wizard
    • Report Manager
Agenda (continued)
• Optional add-ons
  – Report Server
  – Webport
• Q&A
FRx Overview
• FRx is a financial report writer that assists
  in the ease of monthly report creation.
• Data is loaded directly from your General
  Ledger into SQL tables where the
  information is pulled into FRx for your
  design use.
• Benefits:
  – Reports are designed using components
    which have a spreadsheet feel so you can
    begin the design process with limited training.
FRx Overview (continued)
• Benefits (continued):
  – Using FRx, you can create consolidated
    reports across companies whether the
    companies’ information is all kept in one
    accounting system or if the companies reside
    on different accounting systems.
  – FRx supports multi-currency including
    translation tables.
  – Design formats are shared by all users but
    can be secured if necessary. One format can
    be used in multiple reports.
FRx Overview (continued)
• Benefits (continued):
  – FRx produces presentation quality reports
    utilizing various formatting options.
FRx Designer Demonstration
   FRx Building Blocks (required)




Rows and columns are
required formats in FRx
report design. Catalogs
are used to tie together
the different formats
used to create a report.
FRx Row Formats




                  Rows define the lines
                  (or rows) of your report.
                  Typically they depict
                  your G/L accounts or a
                  calculation.
Row Formats (cont.)
                      There are
                      various format
                      options within
                      a row format
                      including
                      summing up
                      rows within a
                      report and
                      performing
                      complex
                      calculations
                      such as
                      division,
                      multiplication
                      and if/then
                      statements.
Row Formats (cont.)
                      There are various
                      print options in
                      column F of the
                      row format. These
                      options allow you
                      to control print
                      features such as
                      non-printing rows
                      and the printing of
                      currency symbols
                      on specific rows.
Row Formats (cont.)




             Column H allows you to specify
             your G/L account or accounts for
             the row by either using the
             dropdown feature or by manually
             typing the account into the field.
Column Layouts




• Column layouts define the columns of your
  report.
Column Layouts (cont.)




There are many types of columns you can include in a report.
Some types are related specifically to a report generated with
transaction detail.
Column Layouts (cont.)




      •Column layouts also include:
         •Headings on which you may use predetermined codes
         which will be populated based on the report date
         •Special formatting
         •Current period or YTD information
         •Filtered data on specified attributes
Catalogs




•   The catalog ties together your row, column and tree (if included)
    to create the report.
•   The catalog includes:
     – Options for specifying detail level
     – Output options (i.e. view report on the screen, export to excel,
        etc.)
     – Default report date
     – Report formatting options such as Header and Footer and
        rounding options.
FRx Designer Demonstration
   Reporting Trees



Reporting Trees are an
optional format that can
be used in report design
to either segregate a
report into different
units (i.e. cost centers
or departments) or to
create consolidated
financial statements.
    Reporting Trees
Below are two reporting trees. The top tree depicts a tree which is consolidating
two companies but not breaking them out by department. The bottom tree is for
one company but the report will be available for viewing at the department level.
FRx Security




You can turn on FRx security so you are able to secure access to the different
formats. Security is based on user logins that must be set up within FRx once
security is turned on.
FRx Security




Once security is turned on, you can secure branches of your tree so users only
have access to view data for their departments.
Linking to External Spreadsheet




If you do not have budget or forecast data loaded into your G/L, then you can use
an external spreadsheet such as Excel to bring in budget and forecast data.
Report Wizard

 The icon above allows you to open
 FRx Report Wizard
Report Wizard




  The Report Wizard walks you through the
  design of some basic reports utilized by
  most companies.
Report Manager

 The icon above allows you to open
 FRx Report Manager.
Report Manager




FRx Report Manager allows you to consolidate Reports as well as non-FRx
documents and files into one workbook. You can then generate all reports
together and send out financial statements in a report book fashion or you can
print the entire design.
Report Manager




Using Report Manager, you can organize your reports and files to suit your needs
by creating new folders and inserting the documents necessary for reporting.
FRx Designer Demonstration
FRx Report Server



    FRx Report Server
    allows you to run
    reports offline on a
    separate server.
    You can also
    schedule reports to
    be run at a specific
    time. Once reports
    are complete, they
    can be viewed,
    printed or e-mailed.
FRx WebPort
• Expands and improves report distribution processes
  via Web-Based Services

• Allows reports to be published directly from FRx
  Designer or Launcher to the WebPort (IE 6.0
  Minimum Required)

• Provides administrative functions for report
  maintenance (security, report grouping, etc.)

• Allows users in different locations easy access to
  reports.
FRX WEBPORT – AUTOMATICALLY PUBLISH TO WEB
FRx WebPort™




               Web Server
                Address
FRx WebPort™
FRx Benefit Review
• User friendly graphical interface
• Presentation quality reports
• Drilldown from summary all the way to
  transaction detail
• Bring in data not stored in your G/L using the
  spreadsheet linking functionality
• Trees allow you to create detailed reports by
  department and to create consolidated reports
• Building blocks (rows, columns and trees) can
  be re-used multiple times
FRx Benefit Review (cont.)
• Report Wizard allows you to quickly create basic
  reports
• Report Manager allows you to combine multiple file
  types into one report book for easy review and
  distribution of information
• Security allows controlled access to reports or pieces
  of reports if using a tree
• Report server allows scheduling of reports and
  uninterrupted work flow.
• WebPort allows users to view reports without having
  to install FRx Designer or Drilldown viewer
FRx Designer Demonstration