Projected Balance Sheet Model Overview

image_pdfimage_print

Return to Models Overview

Scope

The Jedox Projected Balance Sheet model simplifies complex integrated financial planning to support budgeting and forecasting. This Jedox Premium Model includes the same functionality as the basic Jedox Balance Sheet model plus additional content to enable projections for a forward-looking, fully integrated financial planning solution. The Premium Model integrates changes on balance sheet items from multiple PnL accounts for all planning versions. It also features the calculation of future tax liabilities as well as the projection of proceeds and payments based on payment schedules.

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 model to be installed on the same database.

Test Drive the Projected 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

Projection Configuration Cube

Business Logic

Version Blending

KPI Calculations (by Version) for Balance Sheet Cube

Previous Year

Currency Conversion (Projected Balance Sheet Model) 

Integration of Detail-Planning Cubes (Balance Sheet Cube)

Semi-Additive Measures (Projected Balance Sheet Model)

Debit Credit Shift

Actions on Journal Entries

         Posting Journal

Projection

 

Interfaces

Import Exchange Rates Interfaces

Reports

Projected Balance Sheet Actual Report

Projected Balance Sheet Forecast Report

Projected Balance Sheet Mid-Term Planning Report

Projected Balance Sheet Budget Report

Projected Balance Sheet Legal Entity Breakdown Report

Projected Balance Sheet Time Series Report

Projected Balance Sheet Posting Journal

Administration Reports

          Projected Balance Sheet Projection Configuration

Legal Entity Administration Report

Exchange Rates Report

Projected Balance Sheet Initialization Report

 

Setup

Getting Started with the Projected Balance Sheet Model

Setting Up the Projected Balance Sheet Model

Configuration

Balance Sheet Cube

BS Account Dimension

Transaction Type Dimension

Posting Journal Configuration Dimension

     Projection Configuration Cube

Batch Procedure Configuration Dimension (Projected Balance Sheet Model)

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 Dimension

Day Dimension

Legal Entity Dimension

   

 

image_pdfimage_print