Balance Sheet Cross Tab Detailed

The Balance Sheet Cross Tab Detailed Report provides Balance Sheet information at Detail Code level for Full Year or Year-to-Date Actuals.

The Report will display totals for the Debtors Control account, the Creditors Control account and surplus/deficits as well as overall totals.

It is similar to the Balance Sheet Cross Tab Summary but is broken down into Detail Code level.

The details are displayed in a tabular format, an example of which is displayed below:

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: Balance Sheet Cross Tab Detailed

Click on the  button and the following Parameters and Criteria will be displayed in a Grid at the bottom of the form:

Parameters

The Parameters for this Report are as follows:

• Cost Centre Set: This field will default to 1 and cannot be changed.
• Currency Code: The default Currency Code will be added to this field 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 3 and cannot be changed.
• Year: Ensure the required 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 provide details that is up to and including this Period, e.g. adding 6 will include details from Period 1 to 6 inclusive.

Where the Report is to include details for the full year, the last Period for the year should be added , i.e. 12.

Criteria Fields

The Criterion for the Report is as follows:

• Cost code: This defines the Cost Centre codes to be included on the Report and it is recommended that this is not changed.  Where a change is required, a different Cost Centre can be added to the Value field.  Alternatively the Cost Centre can be searched for and selected by clicking on the Find Criteria button to the right of this field.

Click on the  button.