Use Financial Reports to create and modify financial report definitions that are used to produce such financial reports as a Balance Sheet or Income Statement. The reports are defined and also produced from this screen. Use the Report Options tab to define the report and the filters that you can use to restrict the data. Use the Output Options tab to produce the report.
The formats that are used to produce the financial reports are based on definitions created and maintained in Financial Reporting Rows.
The overall format of the rows printed in the financial reports is based on the Financial Reporting Rows definition created for each report. This includes the Headings, Subheadings, Subtotals and Totals that appear throughout the reports. The user controls the Headings, Subheadings, Subtotals, and Totals used in the reports through the report definition created in Financial Reporting Rows.
Defining and Producing a Financial Report
Select Financials | General Ledger | Financial Reports. The Report Options tab appears.
In Row Format, select the format for the rows that you want to define. There are two formats included in the System:
Standard Balance Sheet – represents a typical Balance Sheet format
Standard Income Statement – represents a typical Income Statement format
In Column Format, select the format for the columns that you want to define. The predefined column formats include the following:
YTD Balances – Year-to-date balances in a single column for the period entered.
Current and YTD Balances – Current period activity/balance and year-to-date balances printed side-by-side for the period entered. The current period amount is the period balance for balance sheet accounts (assets, liabilities, or owner’s equity) and period activity for income statement accounts (revenue, expense). For the current period column, if a Financial Report Caption is entered for the period in Calendar, it will be used as column header. If a Financial Report Caption is not entered, the column header will be “Current Period.”
Current Year vs. Prior Year – Current period activity/balance and year-to-date balances printed for current year vs. prior year. The current period amount is the period balance for balance sheet accounts (assets, liabilities, and owner’s equity) and period activity for income statement accounts (revenue, expense).
Current and YTD Balances with % - Current period activity/balance and year-to-date balances printed with percentages. For percentages to print you must specify one row as a Pct Total row in Financial Reporting Rows (typically you would use Total Revenue or Total Assets as a Pct Total row). The current period amount is the period balance for balance sheet accounts (assets, liabilities, or owner’s equity) and period activity for income statement accounts (revenue, expense). For the current period column, if a Financial Report Caption is entered for the period in Calendar, it will be used as column header. If a Financial Report Caption is not entered, the column header will be “Current Period.”
Rolling 3 Periods – current period - 2, current period – 1, and current period activity/balance and quarter-to-date and year-to-date balances. This column format is intended for use with income statement accounts (revenue, expense). For the current period column, if a Financial Report Caption is entered for the period in Calendar, it will be used as column header. If a Financial Report Caption is not entered, the column header will be “Period – 2”, “Period – 1” and “Current Period.”
Current and YTD Budget Variance - Current period and year-to-date actual amount, budget amount, and variance amount between actual and budget. The current period actual amount is the period balance for balance sheet accounts (assets, liabilities, or owner’s equity) and period activity for income statement accounts (revenue, expense). This column format requires a budget version to be entered.
Current and YTD Budget Variance with % - Current period and year-to-date actual amount, budget amount, and variance amount between actual and budget and a percentage of variance amount divided by budget amount. If budget amount is zero, the variance percentage is zero. The current period actual amount is the period balance for balance sheet accounts (assets, liabilities, or owner’s equity) and period activity for income statement accounts (revenue, expense). This column format requires a budget version to be entered.
Current and YTD vs. Prior Year Variance with % - Period-to-date and year-to-date actual amount for current year and prior year, with variance amount between current year and prior year, with percentage of variance amount divided by prior year amount. If prior year amount is zero, the variance percentage is set to zero.
YTD by Period – Year-to-date amount by period. The amount printed is the actual amount for periods up to and including the current period, and budget amount for remaining periods. The actual amount is the period balance for balance sheet accounts (assets, liabilities, or owner’s equity) and period activity for income statement accounts (revenue, expense). For the current period column, if a Financial Report Caption is entered for the period in Calendar, it will be used as column header. If a Financial Report Caption is not entered, the column header will be “Current Period.” This column format requires a budget version to be entered.
Current and YTD Budget to Forecast Comparison - Actual amount, budget amount, and forecast amount print for current period and year-to-date. The current period actual amount is the period balance for balance sheet accounts (assets, liabilities, or owner’s equity) and period activity for income statement accounts (revenue, expense). This column format requires a budget version and forecast budget version to be entered.
Budget Forecast Actual Comparison – Year-to-date actual amount, year-to-date budget amount, a variance amount between actual and budget and a percentage of variance amount divided by budget amount. If budget amount is zero, the variance percentage is zero. This column format also prints the sum of the actual amount balance for the year-to-date plus the forecast amount for the remaining year (all remaining periods). This column format is intended for use with income statement accounts (revenue, expense). This column format requires a budget version and forecast budget version to be entered.
Budget Forecast Variance with % - Year-to-date budget amount, remaining year budget amount, total of annual budget amount, year-to-date actual amount, remaining year forecast amount, and total of year-to-date actual amount plus the remaining year forecast amount. This statement format also prints a variance amount between total of annual budget amount and total of year-to-date actual amount plus the remaining year forecast amount and a variance percentage of actual amount + forecast amount – annual budget amount divided by the annual budget amount. This column format is intended for use with income statement accounts (revenue, expense). This column format requires a budget version and forecast budget version to be entered.
In Period, select the period on which to report.
In Precision, select the precision to use for the report. The predefined options include the following:
Cents – the data will display in dollars and cents ($1234.56)
Dollars – the data will display in whole dollars ($1234)
Thousands – the data will display in thousands ($1)
Select the Print Zero Balance check box if you want accounts with a zero balance to be displayed on the report.
In Budget Version, specify the name of a budget. This is the Budget Version defined in Budget and Statistical Versions.
Note: The following column formats require a selection in Budget Version:
Current and YTD Budget Variance
Current and YTD Budget Variance with %
YTD by Period, Current and YTD Budget to Forecast Comparison
Budget Forecast Actual Comparison
Budget Forecast Variance with %
In Forecast Budget Version, specify the name of a forecasted budget version. This is the Budget Version that will be used as Forecast. This Budget Version is created by using the Budget and Statistical Versions screen.
Note: The following column formats require the selection of a Forecast Budget Version:
Current and YTD Budget to Forecast Comparison
Budget Forecast Actual Comparison
Budget Forecast Variance with %.
The Budget Version and the Forecast Budget Version must be different.
In Detail Level, select how you want the detailed information to be presented on the report. Account Groups in the system are defined one time for all internal companies and are used across all internal companies. Therefore, the Filter area of the Report Options tab contains a copy of Accounts Groups (excluding the Account segment) for each internal company defined in the current System. The options include the following:
Account – Select this option to display the information by account
Detail – Select this option to display the detailed transactions
Summary – Select this option to display the details with a summary transaction for each account
Select the Consolidate Dimensions check box when the desired result is to have one line per account for all dimensions associated with that account.
Click Select All to select all the filters listed in the Filter area.
Click Clear All to clear all the filters listed in the Filter area. Then you may use the grid and select the filters individually.
On the Output Options tab, specify the following settings:
In Destination, select the destination of your report. The options include the following:
Viewer – Select this option to have the report display on the monitor. When you select this option, the report is displayed as a PDF file.
Printer – Select this option to have the report print to a printer as a PDF file.
Click View Report to run the report.
Note: For more information about the Report Actions area, see Reports Overview.
Click the X in the upper-right corner of the screen to close the screen.
See also Reconciling Account Balances.
A: No. You can define an unlimited number of financial reports.