Consolidation Sheet

Consolidation sheet add more features to the exisiting sheet. On enabling a sheet to consolation sheet, you unlock many actions and options to simplify your consolidation and carry on from one place. When the Consolidate Data in Sheet option in enabled, some metrics mandatory for consolidation get created. Within enabling consolidation, we have additional options, which can be enabled and disabled as required. These options include : Maintain as YTD Balance, Track Interco detail, Enable Auto Journals and Elimination. This will be used in setting up the Action to run rule for consolidation.

To enable Consolidation in sheet, the sheet is required is have the following fields : Time, Version, Entity, Partner Unit, Group, Dataset, Account, Flow. Any other fields can also be added to the sheet. Some default metrics will be created on checking the consolidation option. They include : Entity Input , Entity GAAP Adjustments, Entity Equity Adjustment, Eliminations, Group Journals, Group Adjustments, Total Consol and Reporting Override Input. Any other metrics can also be added to the sheet. Like every sheet, the metrics are accessible from the Sheet Details, Metrics tab.

The Action tab, beside metrics is where the rules are setup and enabled.