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.

Button

Description

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:

Lv 1

Lv 2

Lv 3

Seq

Description

1

1

1

0

Boarding Fees

1

1

1

1

Day Boarders

1

1

1

2

Full Boarders

1

1

1

3

Sub Total (and structure line description)

Grand totals can be given the name of the detail line if there is no general ledger code linked and the Sub Total flag is not selected. Otherwise the total is named Total Operating Surplus/(Deficit).

Inc P/L

If the report is a balance sheet report, include the net total of all profit and loss accounts for the period selected.

The profit and loss total is calculated from all general ledger accounts that have the Profit Loss Account flag set on the General tab. See General Ledger Maintenance - General tab.

Pg Brk

Add a page break to force a new page on commencement of this section in the finance report.

In the following P&L (profit and loss) example, a page break has been added for all sections except the common ones:

• Tuition and 0110 - Gross Tuition
• 0130 - Discounts and 0150 - Other Discounts.

Comment

Comment for the report section.

To add a new structure lines in the finance report:

1. Click .

   A new row is added in the right-hand side of the Report Structure area.

   

2. Type in the values in the right-hand side fields.
3. Click the Detail tab to link general ledger accounts to the highlighted structure line. See General Ledger Finance Report Maintenance - Details tab.

Insert a new structure line above the highlighted line in the finance report.

Delete the highlighted detail entry in the finance report.

Rename the highlighted finance report structure line.

Note: Once you have allocated G/L codes to a structure line you must use this button to rename the line and not simply change the numbers in the grid.