/
General Ledger Finance Report Maintenance - Structure tab

General Ledger Finance Report Maintenance - Structure tab

Use the Structure tab to:

  • view the general ledger finance reports that are defined and the structure of each
  • add new reports
  • maintain existing finance reports.

 

 Opening the Structure tab

To open the Structure tab:

  1. Select Module > General Ledger > Finance Report Maintenance from the main menu.
    The Structure tab of the General Ledger Finance Report Maintenance window is displayed.
    Tip: You can also access General Ledger functions by clicking .

    Note: You can use the centre splitter to display more of the left-hand side or the right-hand side of the Report Structure area. See Using the centre splitter in the Introduction manual.

Example

The following report structure shows an example of a tiered report layout with sub-totals at each level:

Report Structure

 

 

 

Lv 1

 

Lv 2

 

Lv 3

 

...

 

Seq

 

Description

Detail

Credit

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)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


General Ledger Finance Report Maintenance - Structure tab key fields and buttons
Left-hand grid area key fields

Field

Description

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.

Left-hand grid area buttons

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.


Right-hand grid area fields