Printing Financial Reports - Specify Report Parameters
Screen ID: Screen Title: Panel Number: |
LGLFILB Financial Statement Report 673 |
|
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:
-
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
-
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 "% 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.
|
Current Period End |
Enter a date (yymm) to specify the end of the period you wish the system to consider as the “current” period.
|
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. |
End |
Use this field to enter an ending date for up to 7 different columns. |
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.
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 |