How does the 'Trial Balance Sheet' dashboard work?
General Function
The Trial Balance Sheet dashboard provides an overview of the balances of all ledger accounts, divided into balance sheet and profit and loss. The ledger classifications can also be consulted in a condensed form up to 2 levels.
Target Audience
- Controllers
- Management
Where in MKG?
- Open the module My Company.
- If the dashboard is not displayed directly: click on the hamburger in the top right corner of the button bar and select the option 'Forms' » 'Dashboard'.
- Click the Views button and select Trial Balance Sheet (8007).
Main Components
- Overview of balance sheet accounts with opening, mutation, and closing balances.
- Overview of profit and loss accounts with opening, mutation, and closing balances.
- Analysis at ledger account level.
- Analysis grouped by Sub 1.
- Analysis grouped by Sub 1 and Sub 2.
- Filter options on classifications.
Display and Use
The selected period settings are displayed at the top. You can filter by Sub 1 and Sub 1 and 2. The dashboard contains 3 tabs that display the same financial data at different levels: per ledger account, per Sub 1, and per combination of Sub 1 and Sub 2. Each overview shows opening balance, debit, credit, balance progression, and closing balance.
Parameters
PeriodFrom: start period of the analysis. Possible values: 1 to 13. Default value: 1.PeriodTo: end period of the analysis. Possible values: 1 to 13. Default value: 12.Period99: determines whether period 99 is included in the calculation. Default value: false.ZeroBalance: determines whether ledger accounts with no balance are suppressed. Default value: false.
Technical Explanation
Primary Data Source
- Ledger Accounts (
grbk)
Indirectly Consulted Data Sources
- None
Dashboard Filters
- Filter on Sub 1 via field
grbk_sub1. - Filter on Sub 1 and 2 via field
grbk_sub2. - The 'Balance' overviews show only records for which
grbk_soort= 1 and the calculated fieldShow= true. - The 'Profit and Loss' overviews show only records for which
grbk_soort= 2 and the calculated fieldShow= true. - When parameter
ZeroBalanceis active, only ledger accounts for whichgrbk_beginsaldo,t_debet,t_credit,t_dcort_eindsaldodeviates from 0 are displayed.
Calculated Fields
PeriodFrom: contains the selected start period.
Calculation: uses parameterPeriodFrom.PeriodTo: contains the selected end period.
Calculation: uses parameterPeriodTo.ZeroBalance: shows the setting for suppressing accounts with no balance.
Calculation: shows a notification when parameterZeroBalanceis enabled.Show: determines whether a ledger account is visible.
Calculation: when parameterZeroBalanceis active, it checks whethergrbk_beginsaldo,t_debet,t_credit,t_dcort_eindsaldodeviates from 0. Only then is the account displayed.MKGDataDashboardTitle: contains a dashboard title.
Calculation: contains an empty text value.Period99: shows the setting for including period 99.
Calculation: translates parameterPeriod99into a textual indication including or excluding period 99.
Add to 'My Dashboards'
Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Homepage. This way, you create your own cockpit from the data in your database. How to add dashboards can be read in How to set up 'My Dashboards'
- Published:27 Oct 2026 08:26
- Latest update:27 Oct 2026 09:26
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar