Consolidation/Group
How to setup a Group?
To setup multiple files for each entity, add a group and then assign the files to the group.
To add a group, you firstly need to click on the edit icon that appears next to the organisation:
You then have an option to add a group and assign the organisation to the group.
This will add a 3rd layout of reporting, meaning you can report by group, entity or division. The organisation flowchart will then reflect 3 layers as per the following example. Note that the flowchart can be accessed by clicking on "Add Division" which appears under the organisation drop down at the top of the screen.
Consolidated/Group Reporting
You can export the reports to excel to view the group report. An option appears at the bottom of the relevant features (eg Actual v Budget) called "Export Group" and once exported, it will produce the group report in excel with various worksheets including an organisation comparison. You can exclude "inter-group" accounts under Chart of Accounts which will exclude any values that appear within an organisation.
You can also view the group reports and charts under Dashboards.
How to exclude Inter-Entity accounts?
Under Chart of Accounts, you can exclude Inter Entity or Inter Group transactions from the group reports as shown below;
Inter-entity will remove the divisional account values when you filter your reports at the "All Divisions" level.
Inter-group will remove the organisation account values when you export the group report to excel.