Financials

Context

Financial data for an entity is editable through the financial plan and the workbook. This document describes how to configure the financial plan

A financial plan page can be created by opening the Contact Area library on the dashboard page and selecting Financial Plan Table

The following settings are available for the financial plan. They can be accessed by clicking on the pencil icon.

Descriptors are displayed in the first column and are configured in the Financial Summary Lines process template
In the Process Template Editor you can change the field prompt and validation to better suit your business. However the token must never be changed.
You can configure which financial line fields are required via the Field Status Map.
To control which descriptors are displayed in the financial plan, use the setting 'Descriptor Format'. The following tokens are available:
1. [P.TYPE]
2. [P.CATEGORY]
3. [P.EXPENSE_TYPE]
4. [P.UD_1]
5. [P.UD_2]
6. [P.UD_3]
7. [P.UD_4]
8. [P.UD_5]

It is possible to configure which totals columns should be displayed in the financial plan

The relevant settings for these are: Totals Columns and Totals Columns Functions.
The setting 'Totals Columns' should list the column headers for the totals columns. For example: "Total Plan", " Total Actual"
The setting 'Totals Columns Function' should list the functions for each column. The function order should match the column ordering in 'Totals Columns'. For example: financial_editor.getRowTotalPlan, financial_editor.getRowTotalActual
The following standard functions are available:

Custom javascript code can also be entered into the 'Totals Columns Functions' field.

The financial plan shows a Red/Amber/Green status at the top of each column. These indicate the proximity of the actual value to the planned value
The thresholds for these are configurable using the settings 'Heat Tolerance (Amber)' and 'Heat Tolerance (Red)'.
In these fields a multiplier is at which the status is shown. For example, a multiplier of 1.1 for the Amber threshold would mean a planned amount of 100 would turn Amber once the Actual value is greater than 110.

A benefits plan can be set up using the same content area as the financial plan. However the following differences should be noted:

Descriptors: Descriptor fields are configured via the Financial Summary Lines (Benefits) process template.
Available Tokens:
1. [P.CATEGORY]
2. [P.TYPE]
3. [P.UD_1]
4. [P.UD_2]
5. [P.UD_3]
6. [P.UD_4]
7. [P.UD_5]
Heat Tolerance: Calculations are reversed. If the planned benefits are lower than the actuals by a certain threshold amount then the heatmap will change colour.
Financial Type: Should be set to Benefits

Whenever the financial rollup is triggered, a special datasource is activated which will replace form values with the results of the query.

The special datasource is named: Portfolio Entity Form Field Roll Up
The SQL query in this datasource can be written to return values, just like a standard datasource. Instructions are provided at the top of the datasource query.
If the datasource token mapping matches that of the form field's token, the data in that form field will be replaced with the datasource query result.
It is possible to control if the query result should replace the form field's hidden value, visible value, or both.
If the datasource token mapping is prefixed with a P_ it will only replace the hidden value.
If the datasource token mapping is prefixed with a VP_ it will only replace the visible value.
If there is no prefix for the datasource token mapping, both the hidden and visible value will be replaced.

When a Financial Plan table is created for an entity, certain properties are applied to that table, depending on the entity type. The default settings for these properties are controlled by the CORE - Fin Table Properties validation.
If a user has the Edit Financial Table Properties grant, they will have access to update the properties on a given financial table by clicking the cog icon on the financial table.

Google Sites

Report abuse