Here you can define the financial indicators, using the Statement of
financial position, Income
statement and Initial trial
balance as output data.
To set up the indicators, the following columns are filled in:
-
Code - for visual layout of the list of financial indicators
-
Name - the name of the indicator
-
Type - formula type
-
Expression - a simple expression, for example:
IIF(SFPValue['11200']=0,0,(ISValue['20000']/SFPValue['11200'])*100) -
Function - description of a function named
FinancialIndicator, which returns the result as a fraction.
For example:function FinancialIndicator: Currency; begin if ISValue['11200']=0 then result:= 0 else result:= (FPValue['20000']/ISValue['11200'])* 100; end;
-
-
Expression type:
- One for all periods - used when the formula uses data from
two or more periods - Separate for different periods - used when the formula is
one and the same in each period, i.e. only the current period's
values are used
- One for all periods - used when the formula uses data from
-
Alert - offers the option to display an alert message when the
border value is exceeded- Comparison operator - it can be ≤ or ≥
- Value - border value
-
Source - the calculation algorithm is described. For more
information on language syntax for writing sources and functions,
see Scripts FastScript. -
Description - a detailed description of the indicator's purpose
-
Alert message - the text of the alert message. If left empty,
the program will not check whether the border value is reached.
¶ Variables
Several arrays of data from different statements are available for the
description of the formulas. To open the arrays, right click within the
field where the formulas are entered to open the context
menu. The description format of the arrays is:
array ['code']
¶ Arrays
¶ Statement of financial position
- SFPValue - value of the period that the value is calculated for
- SFPCurrent - current period value
- SFPPrevious - previous period value
- SFPrePrevious - period before last value
¶ Income statement
- ISValue - value of the period that the value is calculated for
- ISCurrent - current period value
- ISPrevious - previous period value
- ISPrePrevious - period before last value
¶ Trial balance
- TBOBDr - opening balance debit
- TBOBCr - opening balance credit
- TBTODr - debit turnovers
- TBTOCr - credit turnovers
- TBCBDr - closing balance debit
- TBCBCr - closing balance credit