Microsoft FRx Features

Microsoft FRx for comprehensive financial reporting and analysis to help improve decision making and productivity of your business.

Microsoft FRx is a comprehensive financial reporting and analysis application that helps you manage all financial aspects of your business, with little or no information technology (IT) involvement. Microsoft FRx can help you increase the productivity and effectiveness of everyone involved in the reporting process, giving your people the information they need to support their decisions.

Feature overview

Accounting intelligence

Microsoft FRx helps users understand fiscal periods, chart of accounts structures, transaction details, and various types of balances. A built-in link to the general ledger helps your staff run reports based on predefined accounting information. In addition, accounting features and intelligence simplify processes by recognizing concepts such as current and year-to-date amounts, debit versus credit balances, and posted or unposted transactions. This helps ensure that every report is complete and accurate.

Flexibitlity trio: Provide better information management. Microsoft FRx offers a powerful and flexible system of three building blocks: Row Format, Column Layout, and Reporting Trees. Once created, these building blocks can be saved and mixed and matched in other reports.

• Row Format - Specify the data source and what you want to do within each row of a report. By using a link to the general ledger, your staff can select individual or a range of accounts or a list of discontinuous accounts to be included in a report.
• Column Layout - Specify the data source and select the column type. Combined with Row Format, Column Layout makes it easy for users to include period actuals, budget data, statistical amounts, and other types of data in a report — either from the general ledger or from other data sources such as a spreadsheet. Users also can apply calculations across columns, making it easy to include variances, projections, and percentages in reports.
• Reporting Trees - Create a hierarchical picture of your organization. A powerful auto-build function constructs Reporting Trees in seconds — directly from your chart of accounts. Easy drag-and-drop functionality enables users to create alternative structures and multiple rollups of various accounts without having to make modifications to the general ledger or chart of accounts.

Customizable reports: Use out-of-the-box customizable report templates or start from scratch using the building-block approach and auto-build functionality.

FRx Report Designer: Create, generate, view, distribute, and manage financial reports from your desktop without additional help from your information technology (IT) department.

FRx Report Launcher: Select pre-designed reports, specify the output option, and generate needed reports on demand.

FRx DrillDown Viewer: Receive attractive, easy-to-understand reports that make it simple to analyze performance by company, individual departments, or divisions, or against goals and budgets.

Importing and exporting data: Combine spreadsheet contents with general ledger data in a single report. Automatically export financial data from a finished FRx DrillDown Viewer report into a spreadsheet for additional what-if analysis while keeping formulas and underlying detail intact.

Add-on features

FRx Report Manager:  Automates the time-consuming process of manually compiling, organizing, printing, and distributing report books containing many different document and file types.

FRx Currency Translation: You can create multiple exchange rate tables using Microsoft FRx, or you can access the exchange rate table information maintained in your general ledger. The Monthly Rates Table supports month-end and monthly average rates for automatic or manual currency translation calculations in your reports, so you do not have to accumulate and average your daily rates. Currency Translation allows you to create financial statements based upon the "home" currency set up in your general ledger, and translate it into other currencies for reporting and further analysis, while the data in your general ledger remains untouched.

FRx WebPort: FRx WebPort lets you publish, store, and manage Microsoft FRx and non-Microsoft FRx reports, such as Microsoft Excel and Microsoft PowerPoint documents.

FRx Report Server: Schedule reports for automatic generation and distribution using a separate server. This frees workstations for other tasks and eliminates the time and expense associated with hard-copy reports.