Balance Sheet Model Overview

image_pdfimage_print

Return to Models Overview

Scope

The Jedox Balance Sheet model lets you calculate opening and closing balances for a period and create a balance sheet financial statement. Integrate retained earnings for actuals from the P&L in your Jedox Profit and Loss model and link to the Jedox Cash Flow model. Jedox Models are highly configurable best-practice applications that easily integrate with each other. 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.

Test Drive the Balance Sheet Model from the Jedox Marketplace.

Technical Documentation

Tasks

Database

Balance Sheet Cube

Daily Exchange Rates Cube

Exchange Rates Cube

Fact Cube Using Currency Conversion

Business Logic

Version Blending

KPI Calculations (by Version) for Balance Sheet Cube

Previous Year

Currency Conversion (Balance Sheet Model) 

Integration of Detail-Planning Cubes (Balance Sheet Cube)

Semi-Additive Measures (Balance Sheet Model)

Debit Credit Shift

Interfaces

Import Exchange Rates Interfaces

Reports

Balance Sheet Actual Report

Balance Sheet Forecast Report

Balance Sheet Mid-Term Planning Report

Balance Sheet Budget Report

Balance Sheet Legal Entity Breakdown Report

Administration Reports

Legal Entity Administration Report

Exchange Rates Report

         Balance Sheet Initialization Report

Import Exchange Rates Report

Setup

Getting Started with the Balance Sheet Model

Setting Up the Balance Sheet Model

Configuration

Balance Sheet Cube

BS Account Dimension

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

Other

Configuring Design Elements

Version Dimension

Month Dimension

Day Dimension

Legal Entity Dimension

 

image_pdfimage_print