How does the 'Periodic Balance Sheet' dashboard work?

Target Audience

• Controllers
• Management

Where in MKG?

1. Open the module My Company.
2. If the dashboard is not displayed directly: click the hamburger in the top right of the button bar and select the option 'Forms' » 'Dashboard'.
3. Click on the Views button and select Periodic Balance Sheet (8005).

Main Components

• Overview of balance sheet accounts with balances per period.
• Overview of income statement accounts with balances per period.
• Analysis at general ledger account level.
• Analysis grouped by Sub 1 and by Sub 1 and 2.
• Filter options on Sub 1 and Sub 2.

Display and Use

The selected period settings are displayed at the top. You can filter by classifications via Sub 1 and Sub 2. The dashboard contains three tabs that allow the same financial data to be viewed at the general ledger account level, at Sub 1 level, and at combined Sub 1 and Sub 2 level. Each overview shows the opening balance, period amounts, total, and closing balance.

Parameters

• PeriodFrom: start period of the analysis. Possible values: 1 to 13 and 99.
• PeriodTo: end period of the analysis. Possible values: 1 to 13.
• Period99: determines whether period 99 is included.
• ZeroBalance: determines whether general ledger accounts without a balance are suppressed.

Technical Explanation

Primary Data Source

• General Ledger Accounts (grbk)

Indirectly Consulted Data Sources

• None

Dashboard Filters

• 'Balance' overviews show only balance sheet accounts, where grbk_soort = 1 and the calculated field Show = true.
• 'Profit and Loss' overviews show only non-balance sheet accounts where the value of grbk_soort is not equal to 1 and the calculated field Show = true.

Calculated Fields

• PeriodTo: contains the selected end period.
  Calculation: uses parameter PeriodTo.
• PeriodFrom: contains the selected start period.
  Calculation: uses parameter PeriodFrom.
• ZeroBalance: shows whether general ledger accounts without a balance are suppressed.
  Calculation: provides a textual message when parameter ZeroBalance is active.
• Show: determines whether a general ledger account is visible in the dashboard.
  Calculation: checks based on parameter ZeroBalance and the values of t_beginsaldo, t_eindsaldo, t_saldo_totaal, and the period balances whether the account should be displayed.
• MKGDataDashboardTitle: contains a dashboard title.
  Calculation: contains an empty text value.
• Period99: shows whether period 99 is included.
  Calculation: translates parameter Period99 into a textual indication.