Trial Balance Multi Academy Trust

The Trial Balance Multi Academy Trust Report provides Detail Code balances within the General Ledger at the multi Academy Trust level and includes an opening balance, movement totals and a closing balance for a specified Year.

An example of the Report is displayed below:

The columns on the Report are as follows:

• Opening Year Balance [Year]: This displays the opening balance for the specified Year.
• Current Period Movement [Period]: This displays the total movement in the specified Period.
• Cumulative Movement YTD [Period/Year]: This displays the total movement for the specified Year up to and including the specified Period.
• Closing Balance YTD [Year]: This is calculated as: Opening Year Balance [Year] amount plus Cumulative Movement YTD [Period/Year] amount.  That is the Year-to-Date balance for the specified Year, i.e. up to and including the specified Period.

To run the Report the following options should be added to these fields on the GL Job Request form:

• Report Master: Management Reports
• Report Folder: All Styles
• Report Style: Trial Balance Multi Academy Trust

Parameters

The Parameters for this Report are as follows:

• Currency Code: The default Currency Code will be added to this field and cannot be changed.
• Cost Centre Set: This field will default to 1 and cannot be changed.
• Group 1 Dimension: This field will default to Detail and cannot be changed.
• Group 1 Level: This field will default to 0 and cannot be changed.
• Year: Ensure the Year that the Report is to cover is added to this field - it must be in the full year format, e.g. 2018.
• Period: Ensure the required Period is added to this field.

The Report will detail information for this Period in the Current Period Movement [Period] column, e.g. where 6 is added, the movement in Period 6 will be displayed in this column.

It will also detail information up to and including this Period in the Cumulative Movement YTD [Period/Year] column, e.g. where 6 is added, the movement in Period 1 to Period 6 inclusive will be displayed in this column.

Criteria Fields

The Criterion for the Report is as follows:

• Cost code: This includes a range of Cost Centre codes to be included on the Report and can be changed if required.

Click on the  button.