Trial Balance Multi Academy Trust DRCR

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

This Report is similar to the Trial Balance Multi Academy Trust Report but the balances are split into debit and credit amounts.

An example of the Report is displayed below:

The columns on the Report are as follows:

• Opening Year Balance [Year]: This displays the opening balances for the specified Year split into debit and credit amounts.
• Current Period Movement [Period]: This displays the total movement in the specified Period split into debit and credit amounts.
• Cumulative Movement YTD [Period/Year]: This displays the total movement for the specified Year up to and including the specified Period split into debit and credit amounts.
• Closing Balance YTD [Year]: This is split into debit and credit amounts.

The debit amount is calculated as: Opening Year Balance [Year] DR amount plus Cumulative Movement YTD [Period/Year] DR amount.

The credit amount is calculated as: Opening Year Balance [Year] CR amount plus Cumulative Movement YTD [Period/Year] CR amount.

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 DRCR

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 Cost and cannot be changed.
• Group 1 Level: This field will default to 4 and cannot be changed.
• Group 2 Dimension: This field will default to Detail and cannot be changed.
• Group 2 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] DR and CR columns, e.g. where 6 is added, the movement in Period 6 will be displayed in these columns.

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

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.