General Ledger Finance Report Maintenance - Structure tab

INCOME (Lv 1)

1

0

0

0

0

Income

Fee Income (Lv 2)

1

1

0

0

0

Fee income

Tuition Fees

1

1

1

0

1

Tuition fees

Boarding Fees (Lv 3)

1

1

2

0

0

Boarding fees

Accommodation

1

1

2

0

1

Accommodation

Catering

1

1

2

0

2

Catering

Total Boarding Fees (Lv 3)

Administration Fees

1

1

3

0

1

Administration fees

Information Technology Levy

1

1

3

0

2

Information Technology

Total Fee Income (Lv 2)

Total INCOME (Lv 1)

Code

Unique code for the finance report.

Description

Description of finance report.

P/L Only

Select if this report is a profit and loss report.
Only profit and loss accounts are displayed in the list of available accounts.

Bal Sht Only

Select if this report is a balance sheet report.
Only balance sheet accounts are displayed in the list of available accounts.

Grd Tot Cred

Select if the total of the report is normally a credit and you do not want to show as negative. That is, with brackets around the amount.
For example, a profit and loss report where the profit figure would be a credit total but you want to show profits without brackets and losses with brackets.

Lv 1 Pg Brk

Select to enable a page break for every new level 1 heading entry.

To add a new finance report:

1. Click

   .
   A new report is added in the left-hand side of the Report Structure area.
   
   

2. Type in the values in the left-hand side fields.

3. Add new structure lines in the right-hand side fields, as outlined below.

Delete the highlighted finance report.

Lvl 1 - Lvl 6

Levels define the grouping and layout of sections on the finance report.
Three levels of grouping are available for the standard report. Six levels of grouping are available for custom reports.
Each level is successively indented on the layout of the report.
Although whole numbers are usually used as the level numbers, you can use numbers with up to 4 decimals if you want to insert new lines into the report.

Seq

Defines the individual detail lines within each group. You can use numbers with up to 4 decimals if you want to insert new lines into the report.
Note: Only report sections with a sequence number can have general ledger codes linked to them.
A heading section is identified by a blank or zero Sequence field.

Description

Description for the heading or account line.

Detail

Select to display:

• all general ledger codes linked to the report structure line

• total figures for each general ledger displayed, not just one total for all of the general ledger accounts linked to the line.
  For example:

• Administrative fees

• 0191 Infant School T.R. Levy

• 0192 Primary School T.R. Levy

• and so on.

• Information Technology Levy
  Clear to display the report structure line only. For example:

• Administrative fees

• Book, Subject & Photocopy Levies

• Information Technology Levy.
  Note: In this example, Book, Subject & Photocopy Levies appears on the report but with the Detail flag selected the general ledger codes appear instead.

Credit

Select to display credits without the reverse sign on the report. For example, Tuition fees 53009.00. This avoids the confusion from brackets being used for income, liability or ownership accounts.
If the field is cleared, and credits are posted to income accounts, the total appears with brackets, to indicate a negative quantity. For example, Tuition fees (53009.00).

Sub Total

Select to sub-total all the structure lines in the same group that are above the position that it is placed.
For example, the following three items are summarised in the fourth line: