Cash Flow Model Overview


Return to Models Overview


The Jedox Cash Flow model enables you to closely manage your cash position. It calculates financial data for your cash flow statement and extends the Jedox Profit and Loss and Balance Sheet models. The Jedox Models for integrated financial planning use the same database and come with a customizable chart of accounts. Jedox Models are highly configurable best-practice applications. They store amounts in a source currency and convert them into one or multiple reporting currencies. Data can be either imported from source systems or entered manually.

This model requires the Profit and Loss as well as the Balance Sheet models to be installed on the same database.

Test Drive the Cash Flow Model from the Jedox Marketplace.

Technical Documentation



Cash Flow Cube

Cash Flow Mapping Cube

Cash Flow Calculation Cube

Daily Exchange Rates Cube

Exchange Rates Cube

Fact Cube Using Currency Conversion

Business Logic

Version Blending

KPI Calculations for Cash Flow Cube

Previous Year

Currency Conversion (Cash Flow Model) 

Integration of Detail-Planning Cubes (Cash Flow Cube)

Semi-Additive Measures (Cash Flow Model)


Import Exchange Rates Interfaces


Cash Flow Actual Report

Cash Flow Forecast Report

Cash Flow Mid-Term Planning Report

Cash Flow Budget Report

Cash Flow Legal Entity Breakdown Report

Cash Flow Time Series Report

Administration Reports

Legal Entity Administration Report

Exchange Rates Report

Cash Flow Mapping Report


Getting Started with the Cash Flow Model

Setting Up the Cash Flow Model


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


Configuring Design Elements

Version Dimension

Month Dimension

Day Dimension

Legal Entity Dimension