Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Use the Structure tab to:

...

Expand
titleOpening 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.

...

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

 

Anchor
O_12621
O_12621

 

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

Image RemovedImage Added

To add a new finance report:

  1. Click Image Removed Image Added.
    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.

Image RemovedImage Added

Delete the highlighted finance report.


Right-hand grid area fields

Field

Description

 

 

 

 

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.
    Image Modified

 

 

 

 

Comment

Comment for the report section.

 

 

 

 


Right-hand grid area buttons

Button

Description

Image Modified

To add a new structure lines in the finance report:

  1. Click Image Modified.
    A new row is added in the right-hand side of the Report Structure area.
    Image Modified
  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.

Image Modified

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

Image Removed

Image Added

Delete the highlighted detail entry in the finance report.

Image Modified

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.