Projected Balance Sheet Projection Configuration

image_pdfimage_print

Return to Projected Balance Sheet Model Overview

This report allows you to create data processing procedures that can be used to populate parts of the planned balance sheet with projected income and expense values.

Report Heading

The screenshot below points out the heading area of the Balance Sheet Projection Configuration report. The logo can be changed in Administration; see Configuring Design Elements for more on report design.

The heading area of the report displays the following fields:

Field Description 

Title

Name of the report

Point of View (PoV) Options

The content of the report can be customized using the PoV options, which can be viewed by clicking the blue arrow at the top of the report.   

 

The available options are described below: 

PoV Option

Description

 Batch Procedure Configuration  Select the projection procedure.

Version (combobox)

 Select one forecast for comparison.
Month (combobox)  Select a reporting period (can be a year, or a month in a given year).

Legal Entity (combobox)

 Select one single legal entity or any consolidated element.
Show Filter (checkbox) When clicked reveals additional filter types
Start Procedure (button)  Click to begin the procedure
 Progress Bar  Indicates when the configuration procedure is completed

Report Columns

The columns displayed in the report depend on the selections made in the PoV area. The screenshot below shows a report displaying the name of various procedures. 

Below are descriptions of the columns in the Projected Balance Sheet Projection Configuration Report. Note: the Filter columns are only visible if the “Show Filter” option in the PoV area is checked. 

Field

Description

 Level Step  Editable field that displays the step that the projection procedure belongs to.
 Enabled  Checkbox to indicate whether to enable the projection procedure.
 Name  Name of the projection procedure.
 Duplicate  Button to allow for the duplication of the projection procedure.
 Delete  Button to allow for the deletion of the projection procedure.
 Description  Editable field with a short description of the projection procedure.
 FilterVersionPattern  Editable field with the forecast pattern of the projection procedure.
 FilterMonthFrom  Editable field with the start date of the projection procedure.
 FilterMonthTo  Editable field with the end date of the projection procedure.
 FilterLegalEntityFrom  Editable field with the start date of the projection procedure was created for the legal entity.
 FilterLegalEntityTo  Editable field with the end date of the projection procedure was created for the legal entity.
Configuration Report  Link to PnL Account Configuration reports

 

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...