Consolidation Sheet

The Consolidation Sheet adds more features to the existing sheet. By enabling a sheet as a consolidation sheet, you unlock many actions and options to simplify your consolidation process and manage everything from one place.

When the Consolidate Data in Sheet option is enabled, some mandatory metrics for consolidation are created. Additionally, there are options that can be enabled or disabled as required, including Maintain as YTD Balance, Track Interco Detail, Enable Auto Journals, and Elimination. These options are used to set up the actions to run rules for consolidation.

To enable consolidation in a sheet, the sheet must include the following dimensions: Time, Version, Entity, Partner Unit, Group, Dataset, Account, and Flow. Other dimensions can also be added to the sheet.

Some default metrics will be created when the consolidation option is checked, including Entity Input, Entity GAAP Adjustments, Entity Equity Adjustment, Eliminations, Group Journals, Group Adjustments, Total Console, and Reporting Override Input. Additional metrics can also be added to the sheet. As with every sheet, the metrics are accessible from the Sheet Details tab under Metrics.

The rules are set up and enabled in the Action tab, located beside Metrics.