Group Carry-Forwards New Period
Table of contents
- 1 Preface
- 2 Initiate Group Carry Forward
- 2.1 Group Carry Forward in the "Carry Forward Group Data Complete" Application (PERKTK)
- 2.2 Group Carry Forward in the KTKGES Application
- 2.3 What Will All Be Presented at the Presentation?
- 3 Repeat Carry Forward
- 4 Carry Forward of Report Header Sets for First-Time Use of IDL Konsis
- 5 Presentation of the "Capital Consolidation" Postings (KK,EK/EF,FK/FF)
- 5.1 Full Consolidation: KK Postings of the Previous Period
- 5.2 Consolidation at Equity: EK, EF Postings of the Previous Period
- 5.3 Owned Shares: FK, FF Postings of the Previous Period
- 6 Presentation of the "Other Consolidation Postings" (SK,SD,AE,MB,TA,ZU)
- 6.1 General
- 6.2 Consolidation of Debits and Credits (SK)
- 6.3 Consolidation of Debits and Credits Dividend (SD)
- 6.4 Effort and Income Elimination (AE)
- 6.5 Elimination of … Results Current Assets (ZU)
- 6.6 Elimination of … Results Fixed Assets (TA)
- 6.7 Manual Consolidation Postings (MB)
- 7 Group Transaction Types at a Glance
- 8 Equity Reconciliation
- 8.1 Company Financial Statement Capital Reconciliation
- 8.2 Group Financial Statement Equity Reconciliation
- 9 Carry Forward for Underage Deals
- 10 Presentation at Groups
1 Preface
Presentation is independent of the existence of current movement data (e.g. account balances), i.e. the carries forward can be generated directly after completion of the last annual financial statements.
A billing period must be created before a period change. For details, see the documentation on master data (Master data).
Presentation for a new period is divided into two lecture routines:
- Group Presentation (PERKTK)
- Company Presentation (PERGES)
It is recommended to start with the carry forward in the group. With the group carryforwards, for example, the consolidation group is then available for the company carryforwards as a selection criterion for the carryforwards of all companies belonging to a particular group.
2 Initiate Group Carry Forward
2.1 Group Carry Forward in the "Carry Forward Group Data Complete" Application (PERKTK)
The carry forward within the application 'PERKTK' is a global Role (symbol = world sphere) and is therefore always carried out for the whole group entered in the selection area. Therefore, no line needs to be marked for the execution of the presentation. If the carry forward has been executed, it is possible to branch to the respective application by double-clicking on the menu items provided in the overview. Alternatively, after selecting a menu item, you can use the right mouse button and display overview to branch to the respective application.
2.2 Group Carry Forward in the KTKGES Application
The group presentation can also be called up from the group monitor (KTKGES) via "Action" - "carries forward" - and the desired presentation situation can be selected here.
2.3 What Will All Be Presented at the Presentation?
Regardless of the type of menu call, the group-related "control data" and consolidation postings from the previous period (V-period) to the current period (ActPeriod) are carried forward per group/sub-group at the change in period. Lecture formation includes the following facts:
- Consolidation parameters (KTKPAR): All consolidation parameters existing in the previous period are accepted. These are then initially available unchanged for ongoing consolidation. If, for example, different threshold values are to apply in the current period, the parameters must be changed accordingly. Since the consolidation parameters are kept with period keys, the historization of the settings is ensured.
- Group/sub-groups + processing (KTKGES): The scope of consolidation of the previous period is also transferred to the current period. The changes in the scope of consolidation, e.g. the addition of new companies, changes in the type of inclusion or disposals, are to be supplemented in the CTGS. Since the consolidation groups are kept with period keys, the historization of the settings is ensured.
- Consolidation documents (KONBEL): The detailed explanation of the presentation is given in chapters 5 and 6 of this documentation.
- Consolidation postings (KONBUCH) : The detailed explanation of the presentation is given in chapters 5 and 6 of this documentation.
- Report directory (REPK) in the group: All report header sets carried with group codes from the previous period are carried forward to the current period. In the header sets, the comparison period, if specified, is increased by the same time interval.
- Product data (PRODAT): any existing product data from the previous period are transferred to the following period.
3 Repeat Carry Forward
3.1 Repeat the Whole Carry Forward
If data for consolidation parameters (KTKPAR), group/sub-group company associations (KTKGES) or report header records (REPK) already exist in the target area, i.e. in the period in which the data is to be carried forward, no new carry forward is made for these applications. A message panel will appear indicating that there is no carry forward of the respective sentences, as they already exist in the target area.
Warning: "Write data" deletes all postings of capital consolidation (document types KK_V and FF_V) that already exist in the target period and all carries forward of the other consolidation postings.
3.2 Repeat Carry Forward of Individual Consolidation Issues
If changes in the consolidation postings of the previous period were made after the initial presentation of the current period, the Capital consolidation or other consolidation postings may also be carried forward selectively.
In contrast to the presentation with the application PERKTK, which is always carried out for the entire group, the action 'carry forward Capital consolidation' and the action 'carry forward of other consolidation posting company always only has an effect on the previously marked up.
Warning: When performing the operation again, be sure to delete all carry forward voucher company that exist in the target period and whose document number starts with the marked value.
4 Carry Forward of Report Header Sets for First-Time Use of IDL Konsis
Typically, when IDL Konsis is introduced, the consolidation system reproduces the last available financial statements. Therefore, prior periods cannot be used in the year of introduction in the reporting section. In the following year, therefore, no previous period is initially available for the carry forward of the reporting header sets. If the reference period is to be used in the second reporting year, the report header sets can be supplemented by the reference period after carry forward with the mass update Role.
5 Presentation of the "Capital Consolidation" Postings (KK,EK/EF,FK/FF)
The following remarks on the formation of carryforwards apply if the previous period is an annual financial statement. The formation of a presentation from one intermediate conclusion to the next is shown in Chapter 9 of this documentation.
The carries forward of the capital consolidation transactions are run in the Hedges application under carries forward - carry forward Capital consolidation. In the case of carry forward, all capital consolidation transactions are transferred to the current period. The following document types are carried forward by the carry forward Capital consolidation action:
- Manual and Machine first consolidation (KK)
- Manual first consolidation Equity (EK)
- Update equity (EF)
- Capital consolidation deferred taxes (KK_L)
- Equity Consolidation deferred taxes (EK_L)
- Third-party shares (FK/FF)
For carry forward, the document number of the individual consolidation functions (e.g. KK) is supplemented by an additional attribute 'V' (e.g. KK_V).
5.1 Full Consolidation: KK Postings of the Previous Period
In the following period, the KK, KK_V postings, and the KK_L and KK_L_V postings of the previous period are combined for fully and proportionally consolidated companies to form a new capital-flow consolidation entry. A consolidation is carried out "gross", i.e. there is no compaction/balancing if an account is addressed several times in these postings. This means that the booking texts in the consolidation postings and thus the complete history are preserved. The posting text of the carry-forward posting contains a reference to the source posting (e.g. ‘KK 12.2019’). The posting lines are merged "horizontally", i.e. the posting is summarized per posting record number.
Postings on the previous year's depreciation, e.g. on capitalized goodwill, are carried forward within the KK_V voucher. At the same time, the depreciation of the current year is automatically set up as an asset movement and posted in the CC_V voucher.
If affecting net result constituents are present in the postings in the previous period:
- If the JÜ elimination account (from KTKPARKK) has an 'X' in the 'carry forward transfer' field in the account master, the affecting net result postings are first posted to the JÜ elimination account (from KTKPARKK) and then transferred to the group result carry-forward account. In this case, corresponding consolidation entries are created, namely for the first posting with posting keys with the usage tag 'V' for the carry forward and for transfers with posting keys with the use identifier 'UMB' for transfers.
- If the JU elimination account does not have the 'X' in the 'Transfer carry forward' field in the account master, the result effect of the previous year is immediately posted to the group result carry-forward account without creating consolidation postings.
5.2 Consolidation at Equity: EK, EF Postings of the Previous Period
- In the following period, the EC, EF, EK_V postings, and EK_L and EK_L_V postings of the previous period are combined for associated companies to form a new capital-flow consolidation entry. A consolidation is "gross" if the "consolidation" is activated in the application "KTKPAR", i.e. there is no compaction/balancing if an account is addressed several times in these postings. This means that the booking texts in the consolidation postings and the complete history are preserved. The posting text of the carry-forward posting contains a reference to the source posting (e.g. "EK 12.2011"). The posting lines are merged "horizontally", i.e. the posting is summarized per posting record number. With regard to the carry forward of depreciation and affecting net result postings of the previous period, the statements on "full consolidation" apply.
5.3 Owned Shares: FK, FF Postings of the Previous Period
- The carry forward of postings for minority interests takes place within the framework of the consolidation function 'carry forward Capital consolidation' under the document type FK_V. FK/FF postings and FK_V postings of the previous period are carried forward in a common FK_V voucher. The aggregation is "gross", if the "aggregation" is activated in the application "KTKPAR", i.e. no compaction/balancing takes place if an account is addressed several times in these postings. This means that the booking texts in the consolidation postings and the complete history are preserved.
6 Presentation of the "Other Consolidation Postings" (SK,SD,AE,MB,TA,ZU)
6.1 General
Depending on the carry forward type (see Chapter 7) the consolidation postings are transferred to the current period. For the presentation of the consolidation postings SK, SD, AE, MB, TA and ZU, a retained earnings account is used, which is defined in the respective consolidation parameters (KTKPAR). If it is not specified there, the carry forward is made to the result carry-forward account which is entered in the Capital consolidation parameters (KK).
If affecting net result constituents are present in the postings in the previous period:
- If the JÜ elimination account (from KTKPARKK) has an 'X' in the 'Transfer carry forward' field in the account master, the affecting net result postings are first posted to the JÜ elimination account (from KTKPARKK) and then transferred to the group result carry-forward account. In this case, corresponding consolidation postings are created, namely with the usage tag for the carry forward in the first posting with posting key and with the usage tag for transfers in the case of transfers with posting key.
- If the JU elimination account does not have the 'X' in the 'Transfer carry forward' field in the account master, the result effect of the previous year is immediately posted to the group profit or loss carry-forward account.
In the formation of the presentation, the respective origin voucher becomes a presentation voucher in which the origin voucher number is supplemented by a 'V', the respective tuning groups of a KVA being combined in a voucher (with the exception of MB vouchers, which can also receive differentiated presentation vouchers):
- For expense and income consolidation documents, this means: an AExx voucher becomes an AE00__V voucher.
- For consolidation of debits and credits, this means: from an SKxx voucher, a SK00__V voucher [an SDxx voucher becomes an SD00_V voucher], and an SK voucher on which deferred taxes have been calculated, from an SKxx_L voucher becomes an SK00_L_V voucher [SDxx_L-Beleg wird zu SD00_L-Beleg].
- For interim current assets, this means that a ZU voucher becomes a ZU__V voucher, and a CUM voucher on which deferred taxes have been calculated becomes a ZU_L voucher and ZU_L_V voucher
- For interim gains on fixed assets, this means that a TA voucher becomes a TA__V voucher and a TA voucher on which deferred taxes have been calculated becomes a TA_L voucher into TA_L_V voucher
- For manual postings, this means that an MBxx voucher becomes an MBxx__V voucher and an MB voucher on which deferred taxes have been calculated becomes an MBxx_L voucher into MBxx_L_V voucher
6.2 Consolidation of Debits and Credits (SK)
- In the carry forward of SK postings, it is assumed that they will be realized in the following period. Therefore, in the carry forward of the consolidation of debits and credits, the affecting net result postings with the opposite sign are transferred to the following period. The offsetting entry is made on the retained earnings account. The carry-forward transactions themselves are not carried forward to the following period. The carry-forward voucher is automatically created using the machine carry forward with the transaction type 'E'. Nevertheless, a carry forward into the following period takes place, provided that the original voucher is affecting net result.
6.3 Consolidation of Debits and Credits Dividend (SD)
- In the consolidation of debits and credits for dividends, profit and loss accounts (BilGuV number 3 or 4) are marked with the consolidation function SD in the account master record. This excludes them from the carry forward and therefore they are not booked against the retained earnings account in the following period. Why is that? In the event of a phased-out gain, the investment income of the parent is recorded in the consolidation of debits and credits directly against the equity reduction of the subsidiary. In the event of equal earnings, the investment income is equal to the difference between assets and liabilities according to the automatic consolidation of debits and credits. In the following year, claims and liabilities will face the same amount. Because the subsidiary reports the distribution in the company financial statement, the reduction in earnings of the consolidation of debits and credits is not carried forward via the consolidation postings.
6.4 Effort and Income Elimination (AE)
- The carry forward of expense and revenue consolidation vouchers ('AE00' and 'AExx') typically carries forward the postings in the earnings account and transfers them to the account for the retained earnings (specified in the 'AE' consolidation parameters) so that the carry-forward reconciliation is correct. The result shift per company can thus be represented in AE00 vouchers. NOTE: By specifying a clearing account in the respective consolidation parameters, this presentation logic can be suppressed.
6.5 Elimination of … Results Current Assets (ZU)
- Affecting net result postings from the elimination of … results in the current assets are realized analogously to the consolidation of debits and credits in the following period. Since it is possible to distinguish between currency conversion effects and non-transactions within the CU processing, the types of booking vary according to the variant: Calculation without currency conversion effect: Posting type 'WX' , Calculation with currency conversion effect: WU transaction type. The effects of the different types of lectures are explained in detail in the Elimination of … Results UV.
6.6 Elimination of … Results Fixed Assets (TA)
- Machine generated TA vouchers are created with the booking type "WU". Both original TA postings and existing carry-forward documents of the document type TA_V are carried forward to the target period. They are summarized in the formation of lectures. The original booking type, usually "WU", is retained. It should be noted that whenever a depreciation has to be generated on an IC fixed asset object, the TA processing must be triggered in the following period, even if no new IC fixed asset transactions have been maintained. Why is that? The Afa is generated automatically with the maintenance of the IC-ANLBEW. During the presentation of the company, the IC investment movements are also presented and provided that acc. AMORTIZATION CURRENT YEAR IC-ANLOBJ are still to be calculated, these are already generated during the carry forward in the IC-ANLOBJ. Make a posting However, the depreciation of current depreciation within the consolidation voucher does not occur until the elimination of … results of fixed assets in the current period has been triggered.
6.7 Manual Consolidation Postings (MB)
- In the case of manual consolidation postings (MB), the user himself can influence the lecture relevance. For this purpose, all posting types except "E" are available to him when the consolidation vouchers are created. The carry forward takes into account all vouchers of document type MBxx and the corresponding vouchers of document type "MBxx__V", which are set to recurring, i.e. are occupied with the transaction types "WU" or "WV". They are summarized in the formation of lectures. The original type of booking is retained. When using different consolidation functions MB_00 - MB_99 with the reference consolidation function MB: Vouchers that have the same company numbers in the document number are combined into a common carry-forward document of the document type "MB_xx__V" depending on the carry forward KVA deposited. Vouchers marked as one-time receipts with the booking type "EP" and "ET" are not carried forward.
7 Group Transaction Types at a Glance
The transaction type specifies how the voucher and its related postings are processed during the period carried forward. Detailed descriptions of each type of transaction can be found in the chapter KONBELE Single Set in the DOCUMENT Consolidation documents and transactions.
The consolidation functions automatically generate consolidation documents with the following types of transactions:
For the capital consolidation vouchers:
- CAPITAL CONSOLIDATION KK / FK = WU
- Carry forward Capital consolidation KK__V = WU
- Equity Update EF = WU
- Calculation of external shares on JÜ, currency conversion effect and difference amount FF = WU
- Carry forward Debt calculation FF__V = WU
For the other consolidation postings:
- Consolidation of debits and credits SKxx = WX
- Consolidation of income and expenses AExx = EU
- Intermediate result Elimination current assets ZU = WX (without price effect calculation) or WU (with price effect calculation)
- Interim result Elimination Fixed assets TA = WU
- Deferred tax vouchers always like the original document
8 Equity Reconciliation
Several approaches can be taken in the context of the capital reconciliation in the following period. A distinction should be made between equity (EK) according to the company financial statement of each company and equity in the group. In this context, equity in the group is significantly influenced by the consolidation postings.
8.1 Company Financial Statement Capital Reconciliation
The equity reconciliation of the company financial statements can be carried out with complete care of the capital transactions (KAPBEW) via the equity report. The current value of the equity accounts according to account balances (KTOSAL) is tested with the development of equity over the movement types according to KAPBEW. If the KAPBEW are well maintained in the previous period, these transactions are automatically entered into the current period via the posting key K"01" at PERGES. In addition, there are current changes in the current period, such as capital increases. If the EK Transaction development passes without error, then the EK must have been correctly continued in development. Of course, it is not possible to test the substance of the matter whether capital increases are a capital increase or some other addition.
A vote on the IDL.XLSLINK could also be added. The final values in the capital of the previous period would then be selected. If these values are compared with the currently supplied EK values, the deviations must be explained by the EK changes of the current period (e.g. capital increases, capital reductions, dividends).
8.2 Group Financial Statement Equity Reconciliation
The basic prerequisite for a successful EC reconciliation in the group is the correct control of the booking type in all EC-relevant consolidation postings in the previous period. Especially with manual consolidation postings, care must be taken to ensure that they are encrypted to recurring. If properly controlled, all postings with PO impact will be transferred to the current period via the carry forward Capital consolidation and other carry forward consolidation postings. Under this condition, the consolidated opening value for the purchase postings is correct, which is documented on the carried-forward consolidation postings in the application 'KONBUCH'. The coordination and testing of the EC postings can be done via the application 'KONBUCH'. For example, depending on the consolidation function, the purchase accounting lines can be selected there and compared with the purchase postings of the previous period.
It is highly recommended that the presentation of the accounts be coordinated before the start of the year-end work, i.e. before ongoing consolidation measures have been implemented.
9 Carry Forward for Underage Deals
IDL Konsis distinguishes between financial statements and interim financial statements by the period code according to ABR:
- J stands for financial statements,
- Q for quarterly financial statements and
- M for month end.
For inter-annual financial statements, both the most recent annual financial statements and the most recent interim financial statements may be carried forward to the current period.
However, it is recommended in the course of the subyear formation of lectures to carry forward from one intermediate conclusion to the next. For example, changes in share ownership or in KONBUCH due to changes in the scope of consolidation or of dividends are retained and do not have to be re-entered.
If the prior period is an annual financial statement (period code J according to application ABR), affecting net result postings are reclassified to the retained earnings account.
If the prior period is a monthly or quarterly financial statement (period code M or Q according to the ABR application), the postings 1:1 are carried over into the following period without any summaries, transfers or reclassifications, irrespective of the type of transaction in the document header. Exception: Vouchers with booking type 'EP' are not carried forward even during the year.
10 Presentation at Groups
A separate presentation of consolidation postings is not necessary for reporttechnic groups (group/sub-group identifier "R" in the master application "KTKDEF"). The carries forward in the consolidation postings are taken over during the copying process via the REPKTK application from the reference group (=real group). Nevertheless, the initiation of the carry forward for the reporter sub-group is useful, so that both the group structure of the reporter sub-group and any consolidation parameters used in this group are presented when the carry forward is carried out automatically.