Group Companies and Monitor
Table of contents
- 1 Brief Description
- 2 Action Menu or Context Menu
- 2.1 Overview Submenu
- 2.2 Carries Forward Submenu
- 2.3 Consolidation Functions Submenu
- 2.4 Next Processing Submenu
- 3 Single Set Processing (KTKGESE)
- 4 Other Notes
1 Brief Description
The KTKGES group companies + monitor is the central launch application for all consolidation functions. After entering the desired selection parameters (group, period, fact), the application first displays all group companies assigned to the group/Tk. The next versions also refer to the Report Technical sub-group (REPKTK).
1.1 Selection Area
The ability to sort allows 4 different view variants to be displayed.
In this way, different sorts can be called up within the tree structure. Thus, both an alphabetical sorting by company number and a sorting by investment level can be set. The startup data of the sort option can be set in the user-specific startup data (VOR).
If not all companies from the subordinate sub-groups (ledger TKs) are assigned to the current group companies, a faulty group structure is displayed as far as possible in the tree structure, so that a correction is possible without changing the sort option. The missing companies appear in the message window.
The consolidation method selection box allows you to filter companies by consolidation method ( V, Q, E or K ). By default, the setting is '<> K', which means that companies that are not being consolidated are hidden.
1.2 Toolbar in the Table
The title line of the table displays icons that allow you to perform certain actions without having to go through the actions menu. Use the Tool Tip Role to find out what you are doing behind the icon.
Re-create data: New companies can be inserted into the group structure via the single set KTKGESE.
Group structure (diagram): There is a branching into the application KTKGRAPH. This Role allows the group structure to be displayed graphically. It offers two alternative representations of "group structure" and "Share Ownership", which can be switched between by means of an action menu.
- "Group structure" is based on KTKGES and shows the group as a node with all the associated group companies. Sub-groups that are entered as book-tk represent child nodes. Double-clicking on a sub-group node branches into the corresponding detailed view. The representation of the arrows visualizes the consolidation method of each daughter. The arrows are labeled with the direct participation percentage.
- "Shareholders" are based on GESGES and show the respective mothers' shares in their subsidiaries with percentages on the arrows also for minority interests. That is, each parent company constitutes a node.
Check/update equity values: The percentage sign is used to manually initiate the participation determination for the group.
Check/update Group company status values: This starts the status value check for the whole group.
Lock group financial statement: The lock icon can be used to lock the group financial statement. Editing is no longer possible. The following data is blocked:
- The group you entered.
- All child groups.
- All company financial statements of the companies contained in the group on the group data type
Unlock group financial statement: The lock symbol can be used to unlock the group lock. Processing of the data is again possible. When the lock is released, it is released only for the group you entered. The release of the company financial statements concerned will not take place in this case. A child sub-group cannot be unlocked unless its parent group is unlocked.
The lock is displayed in column 'E' when displayed with colors in the group row (lock/ green= lock locked, lock open/ yellow= lock unlocked for lock).
Next icons: The next icons support handling in the table.
1.3 Table Summary Columns
General meaning of columns:
The exact description of the abbreviated headings shown in the overview table can be displayed by using the "Tool Tip Role" when the mouse pointer remains on the corresponding cell. Each column represents the state of that consolidation function.
Explanation of individual columns of the table:
- Overall Status Column (Heading S): The overall status represents the 'worst' of all detail states, i.e. is 'red', for example, if at least one detail state is also 'red'. For example, you can filter this column to select all companies whose overall status is not yet 'green'. Double-clicking on the overall status column will also allow you to quickly branch to the 'KVERARB' summary (group Processing control). The application KVERARB provides detailed information about the respective state per company (who, when, with which release, which fact and which prior period performed the respective consolidation function). The 'Manual release' action allows you to manually set the state to 'green' or 'processed'. This may be necessary, for example, if certain facts have been booked differently from the system at the request of the user/auditor, or if consolidation documents were not created by machine but recorded manually.
- Participation additive %: Participation percentage additive. (Total direct participations according to GESGES application)
- Participation multiple %: Participation percentage multiplicative. Calculation: ((GES1 percentage of participation * GES2 percentage of participation )/100) This field can be manually entry. This overrides the calculated value. The manual entry is carried out via the single set (KTKGESE), or via the application KTKDEF. In the KTKGES overview, the manual input is visualized (the field is highlighted in yellow and an additional column with a hand symbol (icons) or green with an M (colors) is displayed)
- Participation Voice %: Participation percentage, voting rights (according to GESGES application)
- Participation Result %: Percentage of profit participation (as per GESGES application)
1.4 State Indicator
There are 2 ways to display the processing status:
- Color rendering
- Icon Appearance
The setting is determined from the options menu 'Options'-'Appearance'- 'Icons instead of colors'
Meaning of colors/symbols:
- 'blank' means that no consolidation function has been started or status check has been performed.
- ' - ' means that no data is available for this consolidation function company at this time, e.g. no IC balances (ICKTOSAL) at a 'SK'/'AE' or no shareholding transactions (GESGES) for a Capital consolidation
- 'green ' or 'Hook' means that this consolidation function has been successfully (plausibly) completed by machine or manually.
- 'red' or 'STOP' means that this consolidation function has been terminated incorrectly or is still in progress.
- 'Yellow' or 'Exclamation mark' means that the consolidation function can only be terminated successfully by manual intervention (e.g. by correcting entries or distributing a difference amount)
- 'Green field with an M or a hook with a hand' means that this processing has been manually set to 'Manual release' via the 'KVERARB' application. (manual entry of multiple %sets see above)
- 'T' means that this consolidation function must be carried out at sub-group level. The corresponding consolidation postings are taken over from there. 'T' does not indicate whether the sub-group has already been processed.
2 Action Menu or Context Menu
Various actions can be initiated or branched into applications via the Action menu (tool icon) or the context menu.
Some Roles are limited to serving from the context menu bar. Company The corresponding icons are highlighted in light gray, if none of the buttons have been selected.
Edit data: Company By triggering this action, you can insert or modify an option in the single sentence 'KTKGESE'.
Delete: Deletes all previously selected companies from the group companies.
Mass copy: The mass copy action copies all previously selected companies of the group companies in one step to other keys (group, period, and/or fact). Note: Since when calling the application 'KTKGES' for easier editing all companies with KonsArt = K (no consolidation) are hidden by default, to copy the complete group companies the selection must be removed ('K' in the second input field remove on consolidation method). If this overall selection is omitted, the corresponding companies are missing in the new "KTKGES".
Detail view: This action can only be performed when the parent company of a sub-group is marked and allows direct branching into the subgroup overview. Alternatively, double-click on the green field in the 'E' (investment level) column with entry 1 to branch directly into the sub-group.
Check/update Group company status values: This allows the status value check of previously selected companies to be started.
2.1 Overview Submenu
General:
- Meaning 'whole world' before an action: no prior company mark is required. When this action is called, all data from the group is selected for the selected action.
- Meaning 'Half-world' before an action: these applications can be executed for all company (no previous mark of an item) as well as for selected company (previous mark of an item)
- You can branch to only those applications that are black in the view. Applications shown in gray are only possible after one or more companies have been marked.
In principle, the user can branch into all group-relevant overview applications.
2.2 Carries Forward Submenu
The carries forward submenu summarizes the lecture functions "carry forward consolidated data complete", "carry forward consolidated data complete with sub-group", "carry forward Capital consolidation", "carry forward other consolidation" and the "reconciliation carry forward".
Depending on whether the carry forward is to be carried out completely for the group, optionally with or without a sub-group (no prior marking of the companies necessary, globe function!) or only for one company (black is stored as soon as one or more companies are marked), the group presentation can be started here from the group monitor.
The difference from the presentation with the application 'PERKTK' is that the carry forward can also be carried out here for individual companies. For detailed information on the Group's presentation, see Creating Group Presentation.
2.3 Consolidation Functions Submenu
If the company has been marked beforehand and one of the listed consolidation functions has subsequently been called up, the processing is carried out if the respective conditions are met.
The result of the determination is then displayed in the monitor by the identification of the field already explained at the beginning. Please refer to the following documentation for each consolidation function required to perform it correctly:
- For Capital consolidation see Capital Consolidation, At Equity Consolidation, Clearing Difference Amount.
- For consolidation of debits and credits (SK), see Consolidation of debits and credits.
- For income and expense consolidation (AE), see Consolidation of Income and Expense.
- For elimination of … results in fixed assets (TA), see Elimination of … results in fixed assets.
- For elimination of … results in current assets (ZU), see Elimination of … results in current assets.
- For the calculation of deferred taxes (LT), see Deferred Taxes.
- For the update of the minority interests (FF), see Minority interests.
- For deconsolidation/upstream merger, see Deconsolidation and Upstream merger.
2.4 Next Processing Submenu
All processing operations referred to in this point should always be carried out after all consolidation functions have been completed. The actions with the globe, apply again to the whole group and are thus executed for all companies of the group. Actions without a globe (or half globe) can only be performed on the previously selected companies.
Consolidation currency conversion: When this action is performed, all companies of the group consolidation posting/TC are converted from group currency to parallel currency. After performing the action, a status column 'WUM' appears. This display is only displayed on the group line. For detailed information on the currency conversion, see Currency conversion parallel currency conversion.
Currency conversion with sub-group: When this action is executed, all companies of the group/TC including all sub-group consolidation postings are converted from the group currency to the parallel currency.
Make a posting Quantitative equalization values for (QU): When this action is executed, the compensation of rounding differences in the annual profit or loss is controlled by the quotient conversion. It shall also ensure that changes in the percentage shares in quota companies from one period to the other are reflected in the Transaction developments correctly. You can find detailed information about this in the Final processing quot. Balancing values (QU).
Transfer automatic transaction development area (FU): This calculation is used to allocate carries forward and current changes correctly for automatically generated Transaction developments for group level Cashflow statement. The consolidation function "Transfer of Automatic Transaction developments" (FU) thus ensures that items posted at group level that lead to a change in company financial statement balances are carried forward to the following period and ensures that the correct movement data can be evaluated within the Cashflow statement in the following period. Detailed information can be found in the Finalization Processors- Transfer of Automatic Transaction developments (FU).
Calculate test rule result: Performing this action calculates the group check rule results. For detailed information, please refer to the Audit Rule Definition.
Generate datamart tables for all group companies: This action creates the complete OLAP data tables for all group companies regardless of the current selection.
3 Single Set Processing (KTKGESE)
Company The single-set application (KTKGESE) can be accessed by pressing 'Action' - 'Edit Data' (pen), or by double-clicking on an option or by clicking on an icon (asterisk) from the toolbar. The startup data can then be overwritten or applied.
Warning: With the default startup data 'consolidation method company' <>K', it is possible that an item to be added to the group companies has already been assigned to the group companies with consolidation method 'K'. Then a corresponding error message is sent.
Explanation of each attribute:
Mother.: Indicates whether the selected company should have the property 'Parent company of the group/sub-group' ('X'). Only one company of a group/sub-group may receive this attribute, otherwise there will be an error in determining the ownership structure. If the company is not a parent company, the field shall be blank. It is also possible to define 'G' parent companies (groups with several equal parent companies). 'G' may be specified for multiple companies. For the calculation of the ownership ratios, the participations are calculated on the basis of all companies marked with 'G'. A mixture of the symbols 'X' and 'G' is not permitted. Company If only one 'G' is marked, it will look just like an 'X'.
Account receipt: Enter an access date here. The date to be entered here must be the same as the access date in the GESGES application. This also applies to unconsolidated companies. The date is then to be adjusted when the consolidation method is changed.
KonsType: The type of consolidation; the allowable versions can be obtained via the combo box. The consolidation method specified here affects the allowed consolidation functions. IDL Konsis has 4 different consolidation methods:
- E = At consolidation at equity
- K = no inclusion / shareholding only
- Q = QUOTA-CONSOLIDATION
- V = FULL CONSOLIDATION
NettoAnl.: If the field 'Net Fixed Assets Incorporation' is set to 'X' and the Capital consolidation is then performed or the calculation 'Cost mirror posting' is re-initiated, the carries forward of the depreciation are shown as cost. (For example, see Finishing Processes - KK development reposting)
BetAdd%: You can only enter a quotal percentage value in a quotal company (consolidation method = Q). Company If the parent company of a sub-group is a pro-ratale état, the sub-subsidiaries should also be included in the financial statements on a pro-rata basis. For these cases, a different quota percentage can be entered here, which is used to calculate quota values instead of the additive percentage in other applications.
KonsBuchTk: The company is the parent company of the subsidiary sub-group specified here. Then, for the sub-group entered here, all consolidation postings are transferred to the next higher sub-group or group, i.e. all clearing transactions that have already taken place are transferred directly, for example from the consolidation of debits and credits, without having to perform the individual operations again for the companies belonging to this sub-group.
AbgangKons: The date to be entered here must be the same as the movement date in the shareholding transactions 'GESGES' application, if it has maintained an outgoing movement with BSL03. If the date does not match, the deconsolidation will display an error message and the operation will be canceled. After the deconsolidation company for this period has been run and moved to the next period, this issue date causes the consolidation method to change to 'K' for no inclusion in the next period.
WechselKon: Company If the inclusion type of an inclusion changes from 'K' (no inclusion) to E, Q or V, an indicator NZL (non-liquidity addition) must be entered here. Labeling leads to Capital consolidation. Company If the inclusion type of an option changes from 'E, Q or V' to 'K' (no inclusion), an indicator NZA (non-liquidity disposal) must be entered here. Labeling results in deconsolidation.
Modif.FF: By marking the field company with 'X', it can be indicated that no indirect foreign share calculation should take place for this determination. You can find detailed information in the Minority interests.
BetMultM%: You can manually entry the multiple percentage here. This overrides the calculated value. In the KTKGES overview, the manual input is visualized (the field is highlighted in yellow and an additional column with a hand symbol (icons) or green with an M (colors) is displayed).
4 Other Notes
Manually initiating the status determination in the Group Monitor when individual financial statements data are subsequently changed
With regard to the status determination in the company financial statement and group circuit monitor, it should be noted that there is no uniform status determination. In the group, the status determination by the respective consolidation function takes place automatically. However, there is no automatic update when underlying individual financial statements data change. The status determination must be initiated manually in such cases.