Financial Report Formulas
Financial Report Formulas
Financial Report
Formulas
Use any mathematical and logical operations, as described in the
topic on formulas, in calculating data for
financial reports.
The following values are available for use in formulas:
General ledger accounts
|
Using formulas for calculating lines in
financial reports you can directly reference the general ledger accounts.
Enter code of account between # (hash) signs. Reference individual account
code or, for that matter,classes, groups, and any analytical lever… Here you
can of course use wildcard characters,
most often the % sign.
Nadalje se lahko sklicujemo na :
- D – debit transactions on account in a given period
- K – credit transactions on account in a given period
- S – absolute value of account balance in a given period =
|D - C|
- P - credit – debit (credit balance in a given period) = C
- D
- O – debit – credit (debit balance in a given period) = D -
C
Below You Can See Examples of Correct Entry:
- #S1200# = balance of account 1200 in a given period (absolute
balance)
- #D12%# = debit transactions on accounts of group12 in a given
period
- #K0%# = kreditni promet kontov razreda 0 v danem obdobju
- #O02%# = debit – credit on accounts of group 02 in a given
period
(debit balance) = #D02%#-#K02%#
- #P90%# = credit – debit on accounts of group 90 in a given
period
(credit balance) = #K90%#-#D90%#
|
Cells of financial reports
|
In formulas you can reference data calculated in individual
line and column in financial report. First, enter the column number and then
line number. Enter expression between # (hash) signs.
Below You Can See Examples of Correct Entry:
- #A1# - value of line 1 from column A (Formula 1)
- #B14# - value of line 14 from column B (Formula 2)
YOU CANNOT simplify referencing cells in financial report by using
wildcard caharacters.
|
Constants
|
Here is meant any number. Example of usage:
number of months of company operation in statistical profit and loss account.
|
| Other variables |
#StDel# - average number of employees in individual
year.
Use: It calculates the average number of employees to be displayed in
income statement according to the year from Period Date from
field.
Podatke za izračun najdemo v kadrovski
evidenci.
|
 |
Use wildcard characters when ceating financial report formulas (see
Wildcard Characters topic).
You can use it only in formulas referencing general ledger accounts, and not in
formulas referencing cells in financial report.
|
Example:
See above for examples of usage.
1. Sign %
It replaces any given character thus enabling easy referencing for example
| class and all child records
(groups, control and subsidiary accounts) |
4%
|
| group and all child records (subsidiary accounts, control
accounts) |
41%
|
| subsidiary account and all child
records (control accounts) |
410%
|
2. Square Brackets
By using square brackets accounts are specified in a more user-friendly and
transparent way.
Let us for eample take line number 109 of financial report for AJPES, that
is, income statement:
| expression where subsidiary accounts
are summed up |
shorter form of expression by using
square brackets
|
| #D403%#+#D404%#+#D405%#+#D406%#+#D407%#+#D408%# |
#D40[3,4,5,6,7,8]%#
|
3. Sign _
Character _ can replace individual characters in expression. Thus enabling
simple referencing for example
| all account groups of class 4 |
4_
|
| only control accounts of class 4 |
4__
|
| only four-digit subsidiary accounts of class 4 |
4___
|
|