How does the 'T-balance' dashboard work?
General Function
With the T-balance dashboard, the ratio between equity and liabilities can be quickly and easily assessed, and the financial health of your company is visualized. The dashboard helps identify any financial issues and determines liquidity and solvency.
Target Audience
- Controllers
- Financial staff
Where in MKG?
- Open the module My Company.
- If the dashboard is not displayed immediately: click on the hamburger icon in the top right of the toolbar and select the option 'Forms' » 'Dashboard'.
- Click the Views button and select T-balance (8020).
Main Components
- T-balance at general ledger account level.
- T-balance grouped on Sub 1.
- T-balance grouped on Sub 1 and 2.
- Overviews of balance and profit and loss accounts.
- Total cards for debit, credit, and result.
- Filters on classifications.
Display and Use
The selected period and settings are displayed at the top. Additionally, you can filter on Sub 1 and Sub 1 and 2. The dashboard contains 3 tabs that allow the same financial data to be viewed at the general ledger account level, at Sub 1 level, and at Sub 1 and 2 level. Within each tab, debit and credit sides are displayed separately, supplemented with a result overview.
Parameters
Period: period up to and including which the T-balance is prepared. Possible values: 1 to 13 and 99. Default value: 99.ZeroBalance: determines whether general ledger accounts without a balance are suppressed. Default value: false.
Technical Explanation
Primary Data Source
t_periodes
Indirectly Consulted Data Sources
- General ledger accounts (
grbk)
Data Source Filtering
- Debit and credit overviews are filtered on the selected period via
Sequence = ?Period. - Balance overviews show only general ledger accounts for which
grbk_soort= 1. - Profit and loss accounts show only general ledger accounts for which
grbk_soort<> 1. - Debit sides show only accounts for which
grbk_presentatie_type= true. - Credit sides show only accounts for which
grbk_presentatie_type= false. - When the
ZeroBalanceparameter is active, only accounts for whicht_saldodeviates from 0 are displayed. - Dashboard filters are available via
Sub 1andSub 1 and 2.
Calculated Fields
MKGDataDashboardTitle: contains a dashboard title.
Calculation: contains an empty text value.Period: contains the selected period.
Calculation: uses thePeriodparameter.Sub 1: determines classification at Sub 1 level.
Calculation: removes the first character fromt_grbk.Sub 1 and 2: determines classification at Sub 1 and 2 level.
Calculation: removes the first two characters fromt_grbk.ZeroBalance: shows the setting for suppressing accounts without a balance.
Calculation: shows a notification when theZeroBalanceparameter is active.Show: determines whether an account becomes visible.
Calculation: when theZeroBalanceparameter is active, it checks ift_saldodeviates from 0. Only then is the account displayed.Sequence: determines the internal sorting of periods.
Calculation: converts period 14 to 99, otherwiset_numis used.
Add to 'My Dashboards'
Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Homepage. In 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:30 Oct 2026 11:03
- Latest update:30 Oct 2026 12:03
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar