Printing Financial Reports - Specify Report Parameters

Screen ID: 

Screen Title: 

Panel Number:

LGLFILB

Financial Statement Report

673

images\673g_shg.gif

Click here to magnify

 

 

This second screen is used to specify which data will appear in different columns of the report selected on the previous screen. Any settings changed on this screen will be retained for the next time the report is run.

While the Financial Report Configuration feature is used to define how G/L account balances will appear on financial reports, this screen lets you define which balances will appear. For example, do you want to see figures from the current month? From last month? For the next three quarters? From this same time last year?

CU*BASE offers much flexibility in defining financial reports, so that you can get exactly the data you need in exactly the format you want. However, with flexibility comes complexity! The trickiest part about using these definition screens is that no single field is ever used by itself. Often it is the combination of different codes in different fields that will produce the most satisfactory report. Don't be surprised if it takes some practice and repeated trial and error before you get just the look you want!

  • CU*TIP: A maximum of 7 columns of data can be configured to print on a report. However, calculation options such as the “Pct” feature can add additional columns to the report so that 7 columns of account balance data may not fit. In addition, the CPI (characters per inch) setting on the final printing screen will affect the number of columns that can be printed on the page.

Specifying Reporting Periods for Financial Reports

While there are many different ways to indicate which figures you would like to see on the columns of your report, here are the most commonly used:

  1. In the Type field, use any of the Report Type codes to indicate which period should be printed. (This is the easiest and quickest method.)
    SEE ALSO: Method 1 - Using Report Type Codes

OR

  1. Use the Begin and End fields to specify a different period on each of the columns.
    SEE ALSO: Method 2 - Using the "Begin" and "End" Fields

In addition to these two basic methods, other fields are available for performing mathematical calculations on the data printed in the report:

Using the "Begin +/-" and "End +/-" Fields for Reporting Budget Periods

Using "Math +/-" Calculations

Using "% Val" Percentage Calculations

Using Pct for Percentage of Gross Income

Using Pct for Net Change Ratios

Combining Methods for Printing Budget Figures

Using the Current Period Begin and End Fields

IMPORTANT: No matter which method you choose, a date (yymm) must be entered in the Current Period Begin and Current Period End fields at the top of the screen. This gives the system a “reference point” for all other fields and codes used on this screen.

In effect, these fields are used to say to the system “it is now November” (or October, or whatever you wish), and all other codes are measured from that point in time. The most common method is to put the actual current date into these fields, but any year and month can be used.

  • NOTE: The Current Period Begin field will not be available when printing a balance sheet.

Field Descriptions

Field Name

Description

Current Period Begin

(Does not appear for balance sheet reports.) Enter a date (yymm) to specify the beginning of the period you wish the system to consider as the “current” period.

  • This field, along with the Current Period End field, gives the system a point of reference for all other fields and codes on the screen. In effect, the field lets you tell the system when “today” is, and all other codes are measured from that point in time.

Current Period End

Enter a date (yymm) to specify the end of the period you wish the system to consider as the “current” period.

  • This field, along with the Current Period Begin field, gives the system a point of reference for all other fields and codes on the screen. In effect, the field lets you tell the system when “today” is, and all other codes are measured from that point in time.

Type

This is used to specify which figures will print on each of the 7 columns on the report.

SEE ALSO: Using Financial Report Type CodesMethod 1 - Using Report Type Codes

Begin

Use this field to enter a beginning date for up to 7 different columns.

SEE ALSO: Method 2 - Using the "Begin" and "End" Fields

End

Use this field to enter an ending date for up to 7 different columns.

SEE ALSO: Method 2 - Using the "Begin" and "End" Fields

Y/E

This field is used to indicate whether year-end (13th period) closing figures should be used when calculating the balances to be displayed in a column (Y=Yes, N=No). This will only be necessary if the ending period for that column is also defined as your credit union's fiscal year-end period.

  • Remember that year-end closing entries zero out income and expense account balances. Say you are printing a financial report which compares budget figures to actual figures for an entire year. This field should be set to “N” on the column showing actual figures so that the year-end entries would not cause the account balances to appear as zero.

SEE ALSO: Monthly and Yearly G/L Processing - "Closing the Books"

%

This field is used to display an extra field on the report showing either percentage of gross income, or the net change ratio between columns on the report.

SEE ALSO: Using "Pct" for Percentage of Gross IncomeUsing "Pct" for Net Change Ratios

Begin +/-

End +/-

Use these fields to define a period for the report that is a specific number of months before (-) or after (+) the Current Period Begin defined above. For example, three months after the begin date would be entered as “+03” while three months before the begin date would be entered “-03” in this field.

SEE ALSO: Using the "Begin +/-" and "End +/-" Fields for Reporting Budget Periods

Math +/-

This field is used to request a mathematical calculation using other columns on the report.

SEE ALSO: Using "Math +/-" Calculations

% Value

This field is used to make projections based on actual figures. Actual figures are multiplied by the figure in this field and the result of the calculation will appear in the column.

SEE ALSO: Using "% Val" Percentage Calculations