Standard
When you open the view, the view below will be displayed. You can use the filters to select which data you want to see.
This tab displays the monthly financial report per ledger group. By changing the Level filter, you can also display the ledgers. On this tab, you can filter by establishment or cost center.
Column settings
The view can be configured by the administator for all users, but can also be customised for individual users. The administrator can configure the settings for all users on this tab via Column settings.
On the General (personal) tab, you can create your own personalised settings.
You can define the following on both tabs:
$stappen$
- In the Status column, you can specify whether the Actuals, Budget, Forecast or Rolling forecast is displayed.
- In the Month/YTD/Year column, you can specify the level at which you want to display the status.
- In the Relative time period column, you can specify which month, year or YTD level you want to display. If you enter 0, you indicate that you want to display the current month, YTD up to and including the current month and the current year.
- In the Version column, you can select a specific version that is displayed for the row that you defined. This enables you, for example, to compare the current situation with a version.
- In the columns with Difference, you can specify the rows between which you want to calculate a difference and whether the difference is a percentage or absolute difference.
- Tick a box in the Divider column to set a dividing line between the columns.
- Use the Title column to add a title to a column. This is only necessary if a difference is set. In other cases, the personalised title is optional, but not necessary.
$/stappen$
Based on the settings you specify, the columns can look as follows:
The view is then updated and looks as follows:
This is how you can create your own monthly report.
Moreover, you will see the comments in the column Comment which you entered under Other income and expenditure.
$note$
Booking lines
It is still possible to click through to all the amounts. If booking lines have been imported, it is also possible to click through to the booking lines:
$/note$
$note$
Budget lines
In the Forecast/Budget column, you can click through to the budget line if it was entered in the Other income and expenditure view. This is done by clicking on the amount on the ledger in the main view and then clicking on the amount in the second view that opens. This view opens as follows if there is no mapping by cost centre:
If there is a mapping by cost centre, the view opens as follows:
The above examples are at the lowest establishment level. If you click on a higher level, you will see a breakdown by budget line and establishment:
$/note$
$note$
Explanatory notes:
When a new month of actuals is imported, the explanatory notes from the previous month are automatically copied to this newly released month.
$/note$
Per establishment
On the Per establishment tab, you have the option of displaying all or several establishments beside each other. For example:
Click on Select establishments to select the establishments you want to display beside each other. There is a limitation based on the authorisation settings. You only see the establishments you are authorised to see. For example:
Ticking Automatically select underlying items also ticks the underlying establishments that are linked to a higher level.
The administrator can personalise the tab Per establishment via the Column settings. This works in the same way as described in the Column settings section. For example:
$note$
It is still possible to click through to all the amounts. If booking lines have been imported, it is also possible to click through to the booking lines. The same applies to budget lines.
$/note$
Per cost centre
On the Per cost centre tab, you have the option of displaying all or several cost centres beside each other. For example:
Click on Select cost centres to select the cost centres you want to display beside each other. You can select a maximum of 20 cost centres. Selecting more would affect the performance. For example:
Ticking Automatically select underlying items also ticks the underlying cost units that are linked to a higher level.
The administrator can personalise the Per cost centre tab as needed in the Column settings. This works in the same way as described in the Column settings section. For example:
$note$
It is still possible to click through to all the amounts. If booking lines have been imported, it is also possible to click through to the booking lines. The same applies to budget lines.
$/note$