Accounts
The amounts displayed in charts are derived from records of movements on accounts in the accounting journal. In the chart settings, you can choose whether turnovers or balances for the selected period should be summed into the resulting amounts. Directly in the chart, you can then select how the period is divided into shorter intervals (days, months, quarters, etc.).
The method for calculating the amounts displayed in each interval is determined by so-called expressions. An expression describes a group of account movements that are summed into the resulting amount, as well as which type of amount from each corresponding movement should be included in the result.
Expressions are entered in the chart settings in the Accounts field. Each expression is applied to every interval in the chart to calculate one resulting amount for that interval.
Expressions
Each expression consists of several parts, which are described below. An expression must begin with an account number; all other tags are optional, are written in lowercase, and must appear in the order listed in this documentation.
Account number
The account number can be entered exactly (a specific analytical account), or, if movements across multiple accounts are to be included in the resulting amount, the leading digits shared by all such accounts can be used (an account group or synthetic account). Only one account number may appear in an expression, and the expression must begin with it.
For example:
An expression for a single specific account number is "342001".
The expression "342" corresponds to the sum of movements across all analytical sub-accounts "342001", "342002", "342003", etc.
Calculating the difference in turnovers and account balances
If no further specification of the debit or credit side follows the account number (see below), the resulting amount to be displayed is calculated according to the account type as follows:
account type | turnover difference | account balance |
asset, revenue | debit turnover – credit turnover | debit balance – credit balance |
liability, expense | credit turnover – debit turnover | credit balance – debit balance |
asset/liability by balance (debit balance > credit balance) | debit turnover – credit turnover | debit balance – credit balance |
asset/liability by balance (debit balance < credit balance) | credit turnover – debit turnover | credit balance – debit balance |
Filtering by account type
If you want to include in the resulting amount only movements on accounts with a specific account type, use one of the following tags in the expression:
meaning | tag | English |
asset | "a" | active |
liability | "p" | passive |
revenue | "e" | revenue |
expense | "o" | cost |
Only one tag from this group may be used in a single expression.
For example: "33a", "50o".
Filtering by specific amounts from account movements
Debit and Credit sides
If you want to include in the resulting amount only amounts from a specific side of the account, use one of the following tags in the expression:
meaning | tag | English |
debit | "d" | debit |
credit | "c" | credit |
Only one tag from this group may be used in a single expression.
For example: "343d", "082c".
Positive and negative amounts
If you want to include in the resulting amount only positive or negative amounts, use one of the following tags in the expression:
meaning | tag |
positive amounts (greater than 0) | ">" |
negative amounts (less than 0) | "<" |
Only one tag from this group may be used in a single expression.
For example: "324>" – means that only a positive balance of synthetic account 324 will be included; if the balance is negative, it will not be included (0 is used instead).
Combining expressions
Expressions can be combined into more complex expressions using the "+" and "-" operators. In this case, each individual expression is evaluated separately for each interval, and the results are then added or subtracted.
For example: "082d-082c" – means the difference between the debit turnover and the credit turnover of synthetic account 082 (in this case regardless of the account type setting).
Displaying resulting amounts in the chart
The following conventions apply to the display of resulting amounts in the chart:
Positive amounts derived from asset and revenue accounts are displayed as positive values (above the axis). (Negative amounts are analogously displayed as negative.)
Positive amounts derived from liability and expense accounts are displayed as negative values – below the chart axis (their sign is reversed). (Negative amounts are analogously displayed as positive.)
If an expression contains multiple terms connected by "+" or "-" operators, the type of each individual term is determined. If all terms are of the same type, the same convention described above applies. If the terms are of different types, a positive result is displayed as positive (and a negative result as negative).
The practical consequence of this convention is that when revenues and expenses (or assets and liabilities) are displayed together in a single chart, non-negative revenues (assets) appear above the chart axis and expenses (liabilities) appear below it.
Expression examples
The following applies to all examples below:
Account "343019" has its account type set to "asset/liability (by result)".
The balance of the account is:
account | period | opening debit | opening credit | debit turnover | credit turnover | debit balance | credit balance |
343019 | February 2016 | 2 000 | 15 000 | 10 000 | 55 000 | 12 000 | 70 000 |
343019 | March 2016 | 12 000 | 70 000 | 80 000 | 1 000 | 92 000 | 71 000 |
Consider a case where the chart displays account turnovers (this is determined by the chart settings and cannot be influenced by expressions).
Expression "343p"
Because in February the credit balance is greater than the debit balance, the account is treated as a liability account in that period; in March it is treated as an asset account. If the expression "343p" is used in a chart displaying turnovers, its value for the interval February 2016 will be 45,000 (the tag "p" means liability; the account is treated as a liability and the debit turnover is subtracted from the credit turnover for this interval), while for March the value will be 0 (the account is treated as an asset and therefore does not match the expression).
Expression "343019d"
If the expression "343019d" is used in a chart displaying turnovers, the value of the expression for the interval February 2016 will be 10,000 (the tag "d" means debit turnover), and for March it will be 80,000.
Expression "343019>"
Because in February the credit balance is greater than the debit balance, the account is treated as a liability account in that period; in March it is treated as an asset account. If the expression "343019>" is used in a chart displaying turnovers, its value for the interval February 2016 will be 45,000 (the account is treated as a liability, so the debit turnover is subtracted from the credit turnover for this interval), and for March it will be 79,000 (the account is treated as an asset, so the credit turnover is subtracted from the debit turnover for this interval).
Expression "343pd>"
This expression combines the suffixes from all the previous examples. In a chart displaying turnovers, the value of this expression for the interval February 2016 will be 10,000 and for March it will be 0.
Expression "343019d-343019c"
The expressions "343019d" and "343019c" are first evaluated separately, and the results are then subtracted from each other. If the expression "343019d-343019c" is used in a chart displaying turnovers, its value for the interval February 2016 will be -45,000 and for March it will be 79,000. In this case, the account type has no effect on the result.