Budget Scheme Matrix

The budget schema matrix serves three different purposes:

•Create budget: manual input and calculated values like social security contributions

•Create forecast: Calculated values

•Assessments: for example, target/actual comparison

 

You will see the following fields in the upper area:

Category name | Field name

Description / Example

Budget structure name

You can select here the budget structure you want to edit or rather assess.

Column layout name

You can select a previously configured column layout here.

Version name

You can select here the version you want to edit or assess. Note: Version 1 is created automatically for each budget structure.

Show by

You can determine here the period unit you want to summarize the values for.

Date filter

You can determine here the period you want to summarize the values for.

Note: If you enter an annual budget and want to enter monthly values (e.g., monthly wage), make sure that you enter January of the budget year in this field (also see Chapter Changing Column Layout, field "Write Budget").

 

The “Start” and “Actions” tabs in the “Budget scheme matrix” ribbon have the following functions:

Category name | Field name

Description / Example

Previous column

If multiple columns have been created and not all columns can be displayed, you can switch to the previous column here.

Next column

If multiple columns have been created and not all columns can be displayed, you can switch to the next column here.

Previous period

You can switch to the previous period here. The values in the matrix are then up-dated to the new selected period.

Subsequent period

You can switch to the subsequent period here. The values in the matrix are then updated to the new selected period.

Settle budget

You can settle the budget here. For more information on this topic see Chapter Creating a Budget

Export to Excel

You can export the budget in an Excel file. You will see the following fields on the request page:

•“Create workbook” option:

a new Excel file will be created

•“Update workbook” option:

You can use the Assist button under “Workbook file name” to select the Excel file to be updated. In addition, you can use the Assist button under “Table name” to select the worksheet of the Excel file to update.

•Details:

If you check this box, all details will be transferred to the Excel file.

If you do not check this box, “only” the sums will be transferred to the Excel file.

Edit structure

You can directly open the budget structure here that you have selected in the budget scheme matrix.

Delete budget items

This action allows you to delete budget items. The visible budget items are deleted.

•If ‘month’ is selected in “Show by” and the date filter is set to e.g. 01.07.18..31.07.18, the budget items of July 2018 will be deleted.

•If ‘year’ is selected in “Show by” and the date filter is set to e.g. 01.01.18..31.12.18, the budget items of the year 2018 will be deleted.