Contents of the Print Financial Statements Screen
Use the fields and options to configure the Print Financial Statements screen.
Identification
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, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.
Field | Description |
---|---|
Parameter ID |
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 on the screen, such as PERIOD or QUARTERLY. When you save your record, all the selections made on 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 on the screen, you can override the defaults. |
Description |
Enter, or click to select, a parameter description of up to 30 alphanumeric characters. |
Selection Ranges
F/S Code
Field | Description |
---|---|
Start |
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 By)
Field | Description |
---|---|
(Select By) |
Make 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:
Note: For statements of cash flows, the only valid organizations are balance sheet-level organizations.
|
Option |
Use this drop-down list to select the range of selection values to include. Valid options are:
|
Start/End |
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. |
Fiscal Year
Field | Description |
---|---|
Start |
Enter, or click to select, the fiscal year for which you want to print financial statements. |
Accounting Periods
Field | Description |
---|---|
Option |
Use this drop-down list to select the range of accounting periods to include. Valid options are:
If your selection in F/S Code is for a balance sheet, you must select One in Option. |
Start/End |
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. |
Sort By
Field | Description |
---|---|
1st Sort |
This field displays your selection in the (Select By) field. That selection is the primary sort for the financial statement. |
Group By |
Select this check box if you want the financial statement to group data by your selection in the (Select By) field. |
Options
Level
Field | Description |
---|---|
Include Level __ and Below |
Designate the level to which you want the financial statements to roll up. For example, if you select Organizationin the (Select By) field, enter the organization level to which you want the financial statement to roll up account balances. |
Show
Field | Description |
---|---|
Year To Date |
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. |
Percentage of Sales |
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. |
Comparison Column |
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. |
Prior Period |
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. |
Prior Year |
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. |
Budget |
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. |
Amounts In Whole Currency Units |
Select this check box to round amounts to whole currency units (whole U.S. dollars, for example), rather than showing decimal digits. |
Generate the Financial Statement
To generate the financial statement, enter the report options you want and then click Print Financial Statements on the Action menu.