The Categories table presents the income and expenses situation.
In the Categories column, for each income and expense, the respective categories are set. In addition to the Categories column, there are columns to set:
- The Totalization groups.
For further information on the grouping system, refer to the Grouping system.
- Any cost and profit centers.
In the example there are three main groupings:
- Group 4 - Totals all the Categories that have grouping 4 in their Sum in column (total Income)
- Group 3 - Totals all the Categories that have grouping 3 in their Sum in column (total Expenses)
- Group 00 - Totals groups 3 and 4 (Total Income and Expenses), which determine the Result for the accounting period.
The columns of the Categories table
The main columns of the Categories table are listed below. The display of the columns changes according to the selected View.
You can add additional system columns as well as your own columns via Data → Columns setup.
An asterisk is inserted in the row where a title is entered, which will then be taken over in the Enhanced Statement with groups
(in our example the asterisk is inserted on the line of the title Operating result).
If other sections are provided in addition to income and expenses, such as cost and profit centers, another asterisk can be inserted in the Sections column, again on the title row. More details are available on the Sections page.
Enter an identifier (numerical or sign) identical to the one entered for each category in the Sum in column. The totals for each category belonging to the same grouping of the Sum in column will then be added up (in our example, Group 4 totals the Income Category and group 3 the Expenses category).
Enter the Category number that will identify the type of expense or income.
A description is entered to identify the income or expenses category. This description is automatically taken from the Category Description column of the Records table (if displayed).
Sum in (Gr)
Each Category has an identifier that allows the establishment of the totals for the relevant Group (in the example all Income categories, in the Sum in column, have grouping number 4, because they are totaled in Group 4, Total Income).
The column is protected and shows the balance of income transactions. The balance is updated automatically after each transaction.
The column is protected and shows the balance of outgoing expenses. After each transaction the balance is updated automatically.
The column is protected and shows the total balance between income and expenses. After each transaction the balance is updated automatically.