How does the 'General Ledger Account Comparison' dashboard work?

Target Audience

• Controllers
• Management

Where in MKG?

1. Open the My Company module.
2. If the dashboard is not displayed immediately: click on the hamburger in the top right corner of the button bar and select the 'Forms' » 'Dashboard' option.
3. Click on the Views button and select General Ledger Account Comparison (8011).

Main Components

• Comparison of realized result with budget.
• Comparison of realized result with the previous fiscal year.
• Analysis per general ledger account.
• Analysis grouped by Sub 1.
• Analysis grouped by Sub 1 and Sub 2.
• Percentage deviations from budget and previous fiscal year.

Display and Use

The selected fiscal year and period range are displayed at the top. Additionally, you can filter by categorizations through the tree structure. The dashboard contains 3 tabs that allow the same data to be viewed per general ledger account, per Sub 1, and per combination of Sub 1 and Sub 2. Each overview shows realized results, budgets, differences, and percentage deviations.

Parameters

• PeriodFrom: start period of the analysis. Possible values: 1 through 13 and 99. Default value: 1.
• PeriodTo: end period of the analysis. Possible values: 1 through 13. Default value: 12.
• Period99: determines whether period 99 is included. Default value: false.
• NoBalance: determines whether general ledger accounts without balance and budget are suppressed. Default value: false.

Technical Explanation

Primary Data Source

• General Ledger Accounts (grbk)

Indirectly Queried Data Sources

• Fiscal Years (adbj)

Data Source Filtering

• The primary data source is filtered on profit and loss accounts via grbk_soort = 2.
• The tree structure and all overviews show only records for which the calculated field Show = true.
• When the NoBalance parameter is active, only general ledger accounts for which t_budget, t_dc, or t_dc_vorig_jaar deviates from 0 are displayed.
• Dashboard filters are available via Sub 1 (grbk_sub1) and Sub 1 and 2 (grbk_sub2).

Calculated Fields

• PeriodFrom: contains the selected start period.
  Calculation: uses parameter PeriodFrom.
• PeriodTo: contains the selected end period.
  Calculation: uses parameter PeriodTo.
• Sub: forms a categorization for the tree structure.
  Calculation: combines fixed text with grbk_sub1.
• Spacer: used as a separator field in the overviews.
  Calculation: contains an empty value.
• LastFiscalYear: determines the previous fiscal year.
  Calculation: decreases adbj_boekjaar by 1.
• NoBalance: shows the setting for suppressing accounts without balance and budget.
  Calculation: displays a message when the NoBalance parameter is active.
• Show: determines whether a general ledger account is visible.
  Calculation: when the NoBalance parameter is active, it checks whether t_budget, t_dc, or t_dc_vorig_jaar 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 period 99.
  Calculation: translates parameter Period99 to a textual indication incl. or excl. period 99.