AuditDesktop
Page tree
Skip to end of metadata
Go to start of metadata

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
  • 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
  • No labels