Financial Consolidation Model Overview


Return to Models Overview

Jedox Financial Consolidation significantly reduces the resources and time companies spend on creating a consolidated financial statement and reporting for the group from the separate financial statements of their subsidiaries. Through automation of standard as well as more complex consolidation measures it enables greater speed of group-wide reporting for international reporting standards such as IFRS, US GAAP, German GAAP and many more. The prebuilt finance application follows industry best practice to ensure a fast deployment, yet also offers great configurability and flexibility to meet custom management and reporting requirements.

The following key consolidation measures are supported by the Financial Consolidation application:
· Investments
· Non-Controlling Interests
· Debt Consolidation
· Intercompany elimination
· Elimination of dividends
· Automated postings for intercompany differences
· Posting Journal for automated and for manual journal entries

Test Drive the Financial Consolidation Model from the Jedox Marketplace.

Technical Documentation



Balance Sheet Cube

Profit and Loss Cube

Cash Flow Cube

Scope of Consolidation Cube

Exchange Rates_YTD Cube

Daily Exchange Rates Cube

Cash Flow Mapping Cube

         Consolidation Dimension

         Fact Cube Using Currency Conversion (Financial Consolidation)

Business Logic

KPI Calculations (by Version) for Balance Sheet Cube

KPI Calculations (by Version) for Profit and Loss Cube

KPI Calculations for Cash Flow Cube

         Financial Consolidation Procedure


         Separate Balance Sheet Report

         Separate Profit and Loss Report

         Separate Cash Flow Report

         Consolidated Balance Sheet Report

         Consolidated Profit and Loss Report

         Consolidated Cash Flow Report

Administration Reports

Cash Flow Mapping

Scope of Consolidation Report

         Consolidation Manager Report

         Data Manager Report

         Exchange Rates Report

         Financial Consolidation Posting Journal Report


Set Up

Getting Started with the Financial Consolidation Model


Balance Sheet Cube

BS Account Dimension

Transaction Type Dimension

Profit and Loss Cube

PnL Account Dimension

Cash Flow Cube

CF Account Dimension

Currency Conversion

Setting Up the Available Source Currencies

      Setting Up Transaction Currencies

Setting up the Target Currencies

Configuration of Conversion Types

Setting Up Additional Conversion Types

Conversion from Implicit Local Currency

Conversion from Explicit Source Currency

Comparison of Currency Conversions

Synchronizing Exchange Rates in Forecast and Budget Versions

Exchange Rates

Scaling Amounts in Reports


Configuring Design Elements

Version Dimension

Month_YTD Dimension

Day Dimension

Scope Dimension

Legal Entity Dimension

Partner Entity Dimension