Defining Financial Reports
A report is defined by specifying the report objects FSG should use to build the report. The simplest reports are defined by a row set and a standard column set. Optionally, you can specify your own custom column set. Also, you can add a content set, row order, and/or display set to enhance the report or refine the information in the report. You can also specify the budget, encumbrance types, and currencies to include on a report.
Once you define and save a report, you can use it any time -- to run the report, define a report set, or copy and save it as a new report.
Note: You can also define ad hoc financial reports, as necessary, to meet one-time reporting needs. You create ad hoc reports from the Run Financial Reports window.
Prerequisites
Define a row set.
Optionally, define column sets, row orders, content sets, and display sets.
To define a financial report:
1. Navigate to the Define Financial Report window.
2. Enter a Name, report Title, and Description for your report. The report title is what FSG will print at the top of the report.
3. Enter the Row Set and Column Set to use for the report.
4. (Optional) Enter the Content Set, Row Order, and/or Display Set to use for the report.
5. (Optional) Enter Segment Override values for the account segments you want to override. When you enter a segment override value, FSG produces a report for the specific value you specify. For example, assume you have a report definition which produces a combined assets report for four companies. If you modify the report definition to add a segment override for company 02, then FSG will print an assets report for company 02 only.
Note: If a segment you override is subsequently disabled, the Segment Override definition becomes invalid and you must redefine your report.
6. (Optional) Enter a default Currency for the report. FSG uses this currency only for those rows and columns to which you did not assign a currency when you defined row and column sets.
7. (Optional) Select a Rounding Option to use for calculations in the report:
Calculate Then Round: FSG performs calculations before any rounding.
Round Then Calculate: FSG rounds values before they are used in calculations.
8. (Optional) Select a Level of Detail for the report. There are three options, which correspond to the levels of detail you can assign to rows and columns. If you specify a level of detail for your report, FSG will only print those rows and columns with matching levels of detail.
Note: If you do not enter a level of detail for a report, the system will assume the level of detail is Financial Analyst.
9. Enter an Output Option for your report:
Text: Produces a report in standard text form (no tab-delimited columns). If you download the report to a spreadsheet, you must manually parse the report columns. The default is Text.
Tab-Delimited: Produces a report whose columns are delimited by tabs, making it easier to import the report into a spreadsheet.
Spreadsheet: Produces a report designed specifically for downloading to GL Desktop Integrator.
10. If the row or column set has control values assigned, you can assign budgets, encumbrance types, and currencies to those values.
See Also
Running Financial Reports
Defining Financial Report Sets
Defining Row Sets
Defining Column Sets
Copying Report Objects
Defining Ad Hoc Reports
Including Budgets, Encumbrances, and Currencies in an FSG Report
Defining Content Sets
Defining Row Orders
Display Groups
Defining Display Sets
Standard Column Sets
Overview of Financial Statement Generator