Consolidation Audit
The Consolidation company has an additional report not available to subsidiaries; the Consolidation Audit.
Consolidation > Processing > Consolidation Audit
The purpose of this report is to allow finance staff to inspect the data in the consolidation company and back-track the figures to the subsidiaries. The report can either be a printed report, or alternatively it can be exported to Excel.
The Excel version can be particularly helpful in that it shows subsidiary schools 'side by side', together with a total column. In addition there are 3 worksheets for
- Actual
- Budget
- Variance
An example is shown below:
The selection criteria form is shown below:
If you select to Export by Department, a further pop-up question box will be displayed asking if you want Excel to show Department Report Categories, with sub-totals.
It is important that the Consolidation Process is run before this report to ensure up to date data is reported.
Related topics: