Use this screen to generate financial statements. You can print balance sheets, income statements, and statements of cash flows. When you set up financial statements on the Manage Financial Statements screen, you specify contents and descriptions for each report line.
In addition to the general ledger account balances for any period in the selected fiscal year, the financial statements can display prior period balances, balances for the same period or periods in the prior year, or comparative budget data.
You can print financial statements at any time. We recommend that you generate preliminary versions of the financial statements early in the closing process to identify potential adjustments. After post all journals, calculate indirect rates, and compute and post revenue, generate the financial statements for distribution to management.
You must create G/L report tables before you run financial statements with comparison columns. Therefore, if you want to select comparison columns, you must run the Create General Ledger Report Tables process before printing your financial statements.
Before you generate a statement of cash flows, completely reconcile the bank accounts and all other balance sheet and income statement items. The statement of cash flows should be one of the last reports run when you are closing a period.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.
Enter, or click to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Enter, or click to select, the financial statement code of the financial statement that you want to generate. Costpoint provides a default balance sheet, income statement, and statement of cash flows. The financial statement codes for those default statements are Balsht, Incstm, and Cshflw.
If you elected to create a separate statement of comprehensive income on the Configure General Ledger Settings screen and the Manage Financial Statements screen, you can also select the financial statement code for that report.
The financial statements you select need not be the primary statements.
Select a selection option from the drop-down list. This option is also used as the first sorting level for the financial statements. Valid options are:
Organization — Select this option to generate standard financial statements by organization based on balances stored in the Financial Statement Summary table. Organization is the only valid option for statements of cash flows, and you should only generate statements of cash flows for balance sheet-level organizations.
Reference 1 — Use this option only if you use Reference 1 in data entry. Costpoint generates the reports using balances stored in the Reference Summary table for the reference numbers you select.
Reference 2 — Use this option only if you use Reference 2 in data entry. Costpoint generates the reports using balances stored in the Reference Summary table for the reference numbers you select.
Alternate Reporting — Use this option to produce financial statements for alternate reporting structures. You define alternate reporting structures by using Reference 1 as an alternate structure. Accounts and organizations are linked to the reference numbers in the Org Account Reference Structure table. Costpoint uses that table to assign account balances to the correct components of the alternate structure.
Reorganization — Use this option to produce financial statements for reorganizations. Reorganization structures are stored in the Reorganization Organization Link table. Costpoint uses balances stored in the Financial Statement Summary table for the organizations that are linked to the selected reorganizations.
Use this drop-down list to select the range of selection values to include. Valid options are:
All — Select this option to include all selection values. The Start and End fields are disabled for this option. This is the default.
One — Select this option to include only one selection value and then enter that value in the Start field. The End field is disabled for this option.
Range — Select this option to include a contiguous range of selection values. Enter the beginning value for the range in the Start field and enter the ending value of the range in the End field.
From Beginning — Select this option to include a range of selection values that begins with the first of all the available values and ends with the value that you enter in the End field. The Start field is disabled for this option.
To End — Select this option to include a range of selection values that begins with the value that you enter in the Start field and ends with the last of all the available values. The End field is disabled for this option.
The values entered in these fields vary depending on the type of values you choose to select by and your selection in Option. Enter the starting and/or ending IDs for the range of selection values you want to include on your financial statements. Depending on your selection in Option, one or both of these fields may be inactive.
Enter, or click to select, the fiscal year for which you want to print financial statements.
Use this drop-down list to select the range of accounting periods to include. Valid options are:
All — Select this option to include all accounting periods. The Start and End fields are disabled for this option. This is the default.
One — Select this option to include only one accounting period and then enter that accounting period in the Start field. The End field is disabled for this option.
Range — Select this option to include a contiguous range of accounting periods. Enter the beginning accounting period for the range in the Start field and enter the ending accounting period of the range in the End field.
From Beginning — Select this option to include a range of accounting periods that begins with the first of all the available accounting periods and ends with the accounting period that you enter in the End field. The Start field is disabled for this option.
To End — Select this option to include a range of accounting periods that begins with the accounting period that you enter in the Start field and ends with the last of all the available accounting periods. The End field is disabled for this option.
If your selection in F/S Code is for a balance sheet, you must select One in Option.
Enter the starting and/or ending periods for the range of accounting periods in the selected fiscal year to include on the report. Depending on your selection in Option, one or both of these fields may be inactive. The End Date fields display the ending dates for the periods you select.
This field displays your selection in the (Select By) field. That selection is the primary sort for the financial statement.
Select this check box if you want the financial statement to group data by your selection in the (Select By) field.
Designate the level to which you want the financial statements to roll up. For example, if you select Organization in the (Select By) field, enter the organization level to which you want the financial statement to roll up account balances.
Select this check box to display a column showing year-to-date balances. This check box is available only when your selection in F/S Code is for an income statement.
Select this check box to display a column identifying the percent of sales on each line. This check box is available only when your selection in F/S Code is for an income statement. The column divides each line item by the amount on the subtotal line for Revenue/Sales for current amounts.
Select this check box to include optional comparison columns on financial statements. To make sure your report displays the most current comparative information, run the Create General Ledger Report Tables process before you generate a financial statement with using this option.
This comparison option is available only if you select One in Option for Accounting Period. It is a valid option for the INCSTM and BALSHT financial statement codes. Select this option to print balances for the period immediately preceding the one selected for the financial statement.
This comparison option is valid for the INCSTM and BALSHT financial statement codes. Select this option to display balances for the period in the previous fiscal year that corresponds to the period selected for the financial statement. If you select this option for a balance sheet report, the report displays year-to-date balances as selected period in the previous fiscal year. For income statements, the report displays balances for the corresponding period or periods in the prior fiscal year.
This option is valid for the INCSTM and BALSHT financial statement codes. Use it to display budgeted amounts for the period or periods selected. For example, if an income statement is run for period 1-3, comparative budget columns contain a summarization of budgets for periods 1, 2, and 3 of the designated fiscal year. Balance sheet reports display a summarization of budgeted amounts as of the period selected. Currently, budget columns are available when you generate financial statements by organization or alternate organization only. Costpoint stores budgeted amounts by account/organization and period in the Org/Acct Budget table. The budget revision used for comparison is is the one you selected the last time you ran the Create General Ledger Report Tables process for the periods you are reporting on.
If you need to generate financial statements that include information from more than one budget revision, you must run the process to create G/L report tables multiple times. For example, if you want financial statements for an alternate reporting structure to use a different budget revision than those for organizations, you must run the Create General Ledger Report Tables process for one budget revision, generate financial statements, and then run the Create General Ledger Report Tables process for the second budget revision before generating the other set of financial statements.
Select this check box to round amounts to whole currency units (whole U.S. dollars, for example), rather than showing decimal digits.
To generate the financial statement, enter the report options you want and then click Print Financial Statements on the Action menu.