Financial Consolidation Model Overview

Return to Models Overview

Jedox Financial Consolidation significantly reduces the resources and time companies spent 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 pre-built 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

Tasks

Database

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

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

Administration Reports

Cash Flow Mapping

Scope of Consolidation Report

 

Configuration

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 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

Other

Configuring Design Elements

Version Dimension

Month_YTD Dimension

Day Dimension

Scope Dimension

Legal Entity Dimension

Partner Entity Dimension