Consolidation Process

Before running any consolidated reports, it is essential that the ‘Process Consolidation’ is run.  This goes through each of the subsidiaries and imports the latest Sage data, mapping the data to the consolidation nominal accounts, departments and funds as it does so.  As an initial part of the process the system runs a ‘Data Check’ to ensure that no nominal accounts, etc. have been added to a subsidiary that have not been mapped to the consolidation company.  If any errors are found the consolidation process will be halted and reports displayed showing the errors (and how to correct them).

To process the consolidation, select

Consolidation > Process > Process Academies Consolidation.

The following form is displayed.

This will list all subsidiaries for the consolidation company.  Select the subsidiaries you wish to consolidate, normally ‘Select All’ to include each one.

Having selected the subsidiaries click ‘Process Consolidation’.  Provided no errors were detected the procedure will run automatically.  This may take a little while, depending on the number of subsidiaries and the number of transactions in Sage for each subsidiary, A progress message is shown in the bottom left of the main screen to keep you informed of progress.

Once the ‘Process Consolidation’ is complete, management and statutory reports for the Trust can be run in the usual way.