Accounting templates / Balance templates can be used as alternative balances. This means that a balance can be wrapped via a Balance template. Formatted differently and printed via the balance generator.
For example, a Balance template can be used for a director's balance.
To make use of balance templates, create them under
Finance/Audit activities/Balance templates.
Add a balance cable
Go to
Finance/Audit activities/Balance sheet templates.
Tap [Add balance cable].
And name it. It is also possible to choose the font and set up the layout.
You could fill in with the following example:
- Name: Director Balance
- Font: Arial
- Font Size: 10
- Line spacing: 1.5
- Length of text: 40
- Length of Amount: 15
Click [Save] to save.
Back in the overview of the balance templates, click [Report lines], after which you can create the lines to be displayed in the balance sheet.
Below you can see different options you can use in your balance cable.
- Fill in the text field with the description text you want to appear in the balance.
- Line type field, select either Accounts or Calculation expression
- Accounts are used for headings, or to select which accounts to display or calculate on in the Accounts/Calculation Expression field
- Calculation expressions are used for calculations with + - * and / of either sums or entered numbers. Note: When using calculation expressions, the numbers are divided by 100 to calculate the amounts in pennies and get the most accurate result, so you must remember to multiply or divide the result by 100 to get it correct.
- The Accounts/Calculation Expression field can be left blank for a header, otherwise it must be filled with accounts or a calculation expression.
- The Save in field is used to save a result that can later be used in a calculation.
- The content of these results is used by writing Sum(number), where the number is the number the result is stored in, e.g. 10, then you write Sum(10)
| Accounts |
|
| 1010..1035 |
Here you can calculate the sum of all accounts from 1010 through 1035 |
| 1020;1021;1025;1026 |
Here the sum of accounts from 1020 + 1021 + 1025 + 1026 is calculated |
| 1020;1021;1025;1026..1310;1311 |
Here the sum of accounts from 1020 + 1021 + 1025 + (sum of all accounts from 1026 to 1310) + 1311 is calculated |
| Calculation expressions |
|
| (Sum(10)+Sum(20))*10 |
The numbers stored in Sum(10) and Sum(20) are added together and the result is multiplied by 10 |
| (Sum(10)+Sum(20)) |
The numbers stored in Sum(10) and Sum(20) are added together |
| ((Sum(10)+Sum(20)) * Sum(50)) /100 |
The numbers stored in Sum(10) and Sum(20) are added together and the result is multiplied by the result stored in Sum(50)
Note: the amounts are calculated in pennies, so remember to divide by 100 to get the correct result. |
| (Sum(70)*Sum(50)) / 100 |
The numbers stored in Sum(70) and Sum(50) are multiplied.
Note: the amounts are calculated in pennies, so remember to divide by 100 to get the correct result. |
| sum(10) + (sum(50)) |
The numbers stored in Sum(10) and Sum(50) are added together. |
| (sum(10) - sum(50)) |
The numbers stored in Sum(10) and Sum(50) are subtracted. |
| (sum(10) * sum(50)) / 100 |
The numbers stored in Sum(10) and Sum(50) are multiplied.
Note: the amounts are calculated in pennies, so remember to divide by 100 to get the correct result. |
| (sum(10) / sum(50)) * 100 |
The numbers stored in Sum(10) and Sum(50) are divided.
Note: the amounts are calculated in pennies, so remember to multiply by 100 to get the correct result. |
| Sum(50) + (10*100) |
The number stored in Sum(50) must be added with 10.
Note: When adding numbers, remember that they are converted to pennies and you need to multiply by 100. |
To use the balance sheet template, go to
Finance/Reports/Balance sheet
Select the created balance template in the
Balance template field.
Fill in the remaining fields and click [Generate] to view the balance.