MKG logo
Login

How does the 'Trial Balance Sheet' dashboard work?

The standard dashboard 'Trial Balance Sheet' provides insight into the trial balance over a selected period. It is used to analyze balance sheet and profit and loss accounts, check balances, and assess financial developments by classification.

 

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?

  1. Open the module My Company.
  2. 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'.
  3. 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 field Show = true.
  • The 'Profit and Loss' overviews show only records for which grbk_soort = 2 and the calculated field Show = true.
  • When parameter ZeroBalance is active, only ledger accounts for which grbk_beginsaldo, t_debet, t_credit, t_dc or t_eindsaldo deviates from 0 are displayed.

Calculated Fields

  • PeriodFrom: contains the selected start period.
    Calculation: uses parameter PeriodFrom.
  • PeriodTo: contains the selected end period.
    Calculation: uses parameter PeriodTo.
  • ZeroBalance: shows the setting for suppressing accounts with no balance.
    Calculation: shows a notification when parameter ZeroBalance is enabled.
  • Show: determines whether a ledger account is visible.
    Calculation: when parameter ZeroBalance is active, it checks whether grbk_beginsaldo, t_debet, t_credit, t_dc or t_eindsaldo deviates 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 parameter Period99 into 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'