View - Accounting - Journal
Templates
The amount in a journal line can either be loaded directly from an input value or may consist of a formula. With this type of formula, you can set up your own calculation operations based on one or more input values.
You use the search button to open the
formula set-up window, after selecting Formula in the Amount drop-down
list.
Entering a formula into a journal template
Select the Input value to be added in the calculation from the drop-down list. Each input value can be selected exclusive or inclusive of VAT.
Click Insert.
The input value is now displayed as a code in the formula window.
For example, <b_Invoice amount>
(b represents Gross here, which means that the Invoice amount includes
VAT)
Enter the calculations that are to be performed for the amount. You can use the four most common calculation operations, integers or decimals. Make sure you use the POINT (.) as the decimal separator.
Place MINUS in front of the whole calculation if you want to reverse your previous selection of debit or credit. The main rule is that a negative formula result is entered as a credit and a positive result as a debit.
The formula has now been entered into the journal template.
Example
- <n_Invoice amount>/3
This inserts one third of the invoice amount (which is an input value), excluding VAT (net). At the same time, the plus or minus sign is reversed, which means that the debit/credit posting is also reversed.
Read more about: