Consolidation Features

Consolidate Data in Sheet option in the sheet allows you to run consolidation directly from the sheet. Consolidate Data in Sheet provides a simple and user-friendly way to set up and execute data consolidation rules for sheet data. This feature is designed to improve efficiency and ensure accuracy when working with financial data across various entities and groups.

Overview of Key Features

• Carry Forward Rule: This rule enables the seamless transfer of closing balances from the previous year to the opening balances of the new year. By automating this process, users can ensure consistency in their financial data without manual intervention.

• v26.02: Auto Mapping Rule: This rule automatically transforms and aligns data across dimensions based on predefined mapping logic. This automation eliminates manual intervention and ensures consistent posting of data from source structures to target structures.

  • Standard Rules provide direct, dimension‑to‑dimension mapping, where values are posted to the same metric without requiring complex logic.

  • Advanced Rules support more complex transformations, enabling output to be posted to a different metric than the source.

  • Movements (Balance Sheet Only) & Interco Sync help with Intercompany (Interco) reconciliation.

  For more information, see Auto Mapping Rules.

• Currency Conversion Rule: This rule allows users to handle currency conversions on demand, ensuring accurate financial reporting across multiple currencies. Exchange rates can be preset and maintained under Rates, enabling quick and precise conversions whenever required.

• Group Consolidation Rule: This rule is used to consolidate data from the entity level to the group level, following the configured ownership structure. By defining ownership hierarchies and consolidation rules, users can aggregate financial data efficiently while maintaining compliance with predefined structures.