The Trial Balance Details by Cost Centre Report is a listing of all Cost Centre balances within the General Ledger 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 each Cost centre for the specified Year.
- Current Period Movement [Period]: This displays the total movement for each Cost Centre in the specified Period.
- Cumulative Movement YTD [Period/Year]: This displays the total movement in each Cost Centre 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 Detailed by Cost Centre
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 should not be changed.
- Group 2 Dimension: This field will default to Cost and cannot be changed.
- Group 2 Level: This field will default to 0 and should not 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.
- Group 3 Dimension: This field will default to Detail and cannot be changed.
- Group 3 Level: This field will default to 0 and cannot be changed.
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.
