Add a Financial Report Header

Use the Financial Reports Header Maintenance (GHH) program to add, change, and delete headers for financial reports. See Background, Financial Report Examples, and Road Map for more information.

The program displays:

Field Name

Displays

Rpt no

The code or number that identifies the report

Title line 1

The first title line of the report

Type

The type of report

Prnt?

A check mark indicates the report is printed

Per end?

A check mark indicates this is a period-end report

Fmt no

The format used by this report

Org or org group

The GL organization or group of organizations

  1. Choose the appropriate options:

To

Do This

Add a report

Click Add. See step 2.

Delete a report

Highlight the line and click Delete. See Delete.

Copy a report

Highlight the line and click Copy. See Copy.

Display a report

Highlight the line and click Select or double click the line. See step 2.

Print the report listing

Click Print. See Print.

Exit the program

Click Exit.

  1. Enter data or change data in these fields:

Field Name

Type / Max Length

Action / Description

Report number

Required
5 alphanumeric

Enter a unique identifier.  for a new report or enter * to create a default record. See Create a Default Record for a Maintenance Program.

Note
When you print reports with the Financial Reports Print (GP) program, you can select a range of report numbers. Keep this in mind when you establish your numbering system. The program processes reports in numerical order. A report that accumulates amounts for use in another report must have a lower number than the one that uses the accumulated amounts.

This field cannot be changed after a report number is added.

Title line 1

Optional
56 alphanumeric

Enter a first title line to print at the top of the report.

Title line 2

Optional
56 alphanumeric

Enter a second title line to print at the top of the report.

Print?

Optional

Select if you plan to print this report or leave blank to suppress printing and use this report only for accumulating totals for other reports.

Page print?

Optional

If you selected Print?, select to print page numbers on the report or leave blank to not print them.

Period end?

Optional

Select to print the report when you run the GL Period-End Closing (GME) program or leave blank to exclude the report from period-end closing.

Note
You can also print period-end reports as a group if you select the Print only period-end reports? Program option in the Financial Reports Print (GP) program.

Format number

Required
5 numeric

Enter the report format to use with this report header or click the Lookup icon and use the standard lookup options to select the format from a list.

You can assign the same format number to more than one report header. You can also change information in the report format. See the next step.

Use the Financial Reports Format Maintenance (GFM) program to set up the format number, GL accounts, and totals that print on the report.

Report type

Required
2 alphanumeric

Select the code for the report type. The report type codes determine which columns print on the report.

You can select these report types:

Single Period

Multi-Period

Report Description

A

 

Balance Sheet

B

K

P & L: Actual to Last Year

C

L

P & L: Actual to Budget

D

M

P & L with Percentage Calculation

E

N

Statement of Change

F

 

Activity Report

G

 

Trial Balance

H

 

Budget Planner

I

J

P & L: Last Year to Actual to Budget)

 

O

History Report

 

P

Operating Report

 

R

Rolling forecast (available only for file output)

U

 

User defined

Note
Single-period reports prompt for one accounting period; multi-period reports prompt for a From Period and To Period.

Report types H, I, J, O and user-defined reports that exceed 185-characters in width will be printed with whole numbers. File output will respect the selected Round option.

Round option

Optional
1 numeric

Select the code for how you want to round the amounts printed on the report. If you leave the field blank, the system defaults to code 1.

For example, if the actual amount is 123456789012.34-, the rounded results are:

Code

Precision

Result

1

hundredths

123456789012.34-

2

tenths

123456789012.3-

3

ones

123456789012-

4

tens

12345678901-

5

hundreds

1234567890-

6

thousands

123456789-

Note
When you use a rounding option other than 1, the Financial Reports Print (GP) program prints All amounts rounded to [precision] in the report header.

The selected rounding option may be overridden when report width exceeds 185-characters. Whole numbers will appear for printed and spooled output; file output will include the decimal values specified by the round option.

Include commas?

Optional

Select if you want commas in numeric values or leave blank if you do not.

If you have very large numbers, you may want to leave blank. In this example, the actual amount with commas uses 19 print positions and without commas 16 positions:

With commas

123,456,789,012.34-

Without commas

123456789012.34-

If you have very large numbers, consider selecting a Round option instead.

Credit sign

Optional
1 alphanumeric

Select how you want to print negative numbers on the report:

Select

To

Example

(

Enclose a negative number in parentheses

(534.25)

-

Place a minus sign to the right of the negative number

534.25-

blank

Use neither

534.25

Note
If you select a file as your output device in the Financial Reports Print (GP) program, you can select the Change negative sign? Program option to place the negative sign before the number rather than after it. Some spreadsheet programs and other 3rd-party software expect this placement of the sign.

Cons code

Required
1 alphanumeric

Select

To prepare

C

Consolidated reports

If you select D for the Print field in the Financial Reports Format Maintenance (GFM) program, account titles, amounts, and subtotals print for each organization.

S

Individual reports for each organization

B

Both types of reports

Org or org group

Optional
8 alphanumeric

Enter a GL organization code, enter an organization group, or click the Lookup icon and then click Organization to select the organization or Group to select the organization group from a list.

When you print a report for an organization group, the report includes a section or line for each organization in the group.

You can select a different organization or organization group in Financial Reports Print (GP) program.

Note
If you print a report for a consolidation, the report includes data for that organization only and not for the organizations that consolidate to that organization.

  1. Choose the appropriate options:

To

Do This

Delete a saved record

Click Delete.

Display additional fields for a type U report

Click Other info. See steps 4 through 7, below.

Enter notes for this header

Click Notes. See Enter Notes.

Change the report format

Click Format dtl. See Add a Financial Report Format. Click OK to return to this program.

Return to the list of reports

Click OK. See step 1.

Exit the program

Click Exit.

  1. Enter or change data in these fields:

Field Name

Type / Max Length

Action / Description

Column detail 1 - 9

Optional
1 alphanumeric

Select the data that you want to print in each column:

Select

To print

A

Period to date last year

B

Period to date actual

C

Period to date budget

D

Year to date last year

E

Year to date actual

F

Year to date budget

G

Total budget

H

Variance; see step 5 for additional prompt

I

Percentage; see step 6 for additional prompt

L

Last period actual

K

Last period budget

T

Account title/description

You can select as many columns as are appropriate for your report. You can select data (for example, Period to date actual) to print in more than one column.

  1. (Conditional) If you selected H (variance) for any column, select how you want to calculate the variance:

Field Name

Type / Max Length

Action / Description

First column

Optional
1 numeric

Select the column to subtract from.

If you want to subtract column 1 from column 2, select 2 in this field.

Second column

Optional
1 numeric

Select the column to subtract.

If you want to subtract column 1 from column 2, select 1 in this field.

  1. (Conditional) If you selected I (percentage) for any column, select how you want to calculate the percent:

Field Name

Type / Max Length

Action / Description

First column

Optional
1 numeric

Select the column that is the dividend.

If you want to divide column 1 into column 2, select 2 in this field.

Second column

Optional
1 numeric

Select the column that is the devisor.

If you want to divide column 1 into column 2, select 1 in this field.