Cash Manager Categories table

Documentation •
In this article

The Categories table presents the Income and Expenses situation.

The Categories table

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:

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.

regrouping scheme for the Categories table

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.

Section
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.

Group
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).

Category
Enter the Category number that will identify the type of expense or income.

Description
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)
The code of a group is indicated so that the programme totals the amount of the line in the group.
The heading ‘Sum in’ has been adopted with the Banana Plus version.
The column name has remained Gr, to maintain compatibility with previous versions of the programme.
Each category has an identifier that is used to define in which group it is to be totalled (in the example, all revenue categories, in the Sum in column, have the grouping 4, because they are totalled in Group 4, Total Revenue).

Income
The column is protected and shows the balance of income transactions. The balance is updated automatically after each transaction.

Expenses
The column is protected and shows the balance of outgoing expenses. After each transaction the balance is updated automatically.

Balance
The column is protected and shows the total balance between income and expenses. After each transaction the balance is updated automatically.

Customising the Categories table

You may customise the entry and exit categories in the Categories table according to your needs. You can:

  • Change category numbers
  • Change description
  • Delete or add categories
  • Insert or delete subgroups

All category balances determine the operating result (profit or loss) and must therefore have no balance at the beginning of the year.

Adding new Categories

If you need to add new categories to an existing group, proceed as follows:

  • Insert empty rows (menu Edit > Insert Rows) before the Totalisation Group row
  • Enter the category number or abbreviation in the Category column
  • Enter a description to identify the category
  • Enter in the Sum in column , the same grouping number as the other categories, belonging to the same Totalisation Group.

Adding Subgroups

To add new subgroups, proceed as follows:

  • Insert empty rows (menu Edit > Insert rows) in the area where you wish to insert the new subgroup
  • In the last empty row enter a number or abbreviation for the totalisation in the Group column (in the example "34 - Total Optional Costs")
  • Enter a description to identify the new subgroup
  • Enter in the Sum in column  the Totalisation Group (in the example "3 - Total Costs").

Deleting categories and subgroups

To delete categories or subgroups, select the rows with the categories and subgroup to be deleted and issue the command Delete rows from the Edit menu.

help_id
cashmanager::categories
Tell us how we can help you better
If the information on this page is not what you're looking for, is not clear enough, or is not up-to-date, let us know.

Share this article: Twitter | Facebook | LinkedIn | Email