MKG logo
Login

How does the 'T-balance' dashboard work?

The standard dashboard 'T-balance' provides insight into the financial balance ratios of an administration. It is used to analyze debit and credit balances and to check balance and profit and loss accounts at different classification levels.

 

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?

  1. Open the module My Company.
  2. 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'.
  3. 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 ZeroBalance parameter is active, only accounts for which t_saldo deviates from 0 are displayed.
  • Dashboard filters are available via Sub 1 and Sub 1 and 2.

Calculated Fields

  • MKGDataDashboardTitle: contains a dashboard title.
    Calculation: contains an empty text value.
  • Period: contains the selected period.
    Calculation: uses the Period parameter.
  • Sub 1: determines classification at Sub 1 level.
    Calculation: removes the first character from t_grbk.
  • Sub 1 and 2: determines classification at Sub 1 and 2 level.
    Calculation: removes the first two characters from t_grbk.
  • ZeroBalance: shows the setting for suppressing accounts without a balance.
    Calculation: shows a notification when the ZeroBalance parameter is active.
  • Show: determines whether an account becomes visible.
    Calculation: when the ZeroBalance parameter is active, it checks if t_saldo deviates from 0. Only then is the account displayed.
  • Sequence: determines the internal sorting of periods.
    Calculation: converts period 14 to 99, otherwise t_num is 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'