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:

  • 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.
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:

  • 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.
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:

  • 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.

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.