Use the Structure tab to:
...
Expand | ||
---|---|---|
| ||
To open the Structure tab:
|
...
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. |
Bal Sht Only | Select if this report is a balance sheet report. |
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. |
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:
| |
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. |
|
|
|
|
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. |
|
|
|
|
Description | Description for the heading or account line. |
|
|
|
|
Detail | Select to display:
|
|
|
|
|
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. |
|
|
|
|
Sub Total | Select to sub-total all the structure lines in the same group that are above the position that it is placed. |
|
|
|
|
| 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. |
|
|
|
|
Pg Brk | Add a page break to force a new page on commencement of this section in the finance report.
|
|
|
|
|
Comment | Comment for the report section. |
|
|
|
|
Right-hand grid area buttons
Button | Description | |||
---|---|---|---|---|
To add a new structure lines in the finance report:
| ||||
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. |