General Information on Table Maintenance 
The following tables are available for entering activity data for the consolidation of investments:
You can enter the data into these tables in the Consolidation menu in the step Indiv.Fin.Stmts
® Data transfer.The data is stored by year, period and version.
You can maintain the data at any time, regardless of when the individual financial data is entered. You must set the block indicator in Data Entry Form Definition for the respective table. Also see
Entering Data in Financial Reporting Tables.Changes in Investments table
The data for the investments of the parent companies in subsidiaries, joint venture companies and associated companies must be entered here.
Alternative percentage rates for voting, non-voting and retained equity can be entered in addition to the overall share in equity.
The percentage rates for overall, voting and non-voting equity can be calculated by the system using the function Calculate Shares on the Deviating Shares detail screen. For this, the system requires the following entries in the Changes in Investee Equity and Changes in Investment tables:

Investment of company A in company B
Local currency company A: DEM
Local currency company B: CHF
Group currency: USD
Investment A |
Par value |
LC |
GC |
60 % Overall |
150 DEM |
100 USD | |
100 % Voting |
100 CHF |
||
20 % Non-voting |
20 CHF |
||
80 % Retained |
Equity B |
LC |
GC |
Voting |
100 CHF |
80 USD |
Non-Voting |
100 CHF |
80 USD |
On the basis of the entries of the values in Swiss Francs, the system calculates the investment percentage rates of 60%, 100% and 20%. The percentage of ownership in retained equity can not be calculated; it has to be manually entered by the user.
Once they have been calculated, the group shares are displayed in Subgroup Maintenance, on the detail screen for maintaining the consolidated entity.
The consolidation of investments program only uses the percentage rates for ownership in overall equity and retained equity. The percentage of ownership in retained equity is used for processing the entries in the Changes in Investee Equity table with the indicator F.
When making entries in the investments table, you can set the database indicator instead of entering values. This way, the consolidation program knows that it must copy the current values from the totals table.
You can also automatically load the values into the database under Indiv.Fin.Stmts
Changes in Investee Equity table
The equity values which are included in the consolidation of investments must be entered here for all companies of the subgroup. For the highest parent company, equity values are generally also entered for analysis purposes.
You do not need to enter the item "Subscribed capital stock".
If the appropriation of retained earnings is stated on the balance sheet, ensure that the respective appropriation items are entered with a reversed sign.

Increase in appropriations by 500 monetary units in the current year.
You should record an increase in the value of the assets items "Deficit not covered by equity" and "Non-subscribed capital stock" in the table with a negative (minus) sign, since this leads to a decrease in equity. Conversely, record a decrease with a positive (plus) sign in the table.
If appropriations are stated on the balance sheet, note the following when making entries to the equity item "Unappropriated retained earnings":
The item’s balance results from carrying forward from the previous year the items Annual net income, "Unappropriated retained earnings", "Transfers to/Deductions from appropriations", and "Distributions". Therefore, in general, you should not enter a value for the equity item "Unappropriated retained earnings" in the Changes in Investee Equity table. You should merely post the differential whenever the individual financial statement data produces a different value for the item.
Example 1:
Item |
Table values 1995 |
Reported for 1996 |
Table entries |
Annual net income |
300 + |
500 + |
500 + |
Profit carried fwd |
500 + |
700 + |
0 |
Transfers to appr. |
100 - |
200 - |
200 - |
The values for 1995 result in "Profit carried forward" of 700 monetary units. This corresponds to the value reported for 1996. This is why no value is posted to the Changes in Investee Equity table for "Profit carried forward" in 1996.
Example 2:
Item |
Table values 1995 |
Reported for 1996 |
Table entries |
Annual net income |
300 + |
500 + |
500 + |
Profit carried fwd |
500 + |
800 + |
100 + |
Transfers to appr. |
100 - |
200 - |
200 - |
The values for 1995 result in "Profit carried forward" of 700 monetary units(MU). This does NOT correspond to the value reported for 1996. Therefore, the difference of 100 MU is entered for 1996 in the Changes of Investee Equity table.
Equity Holdings Adjustments table
The values for the net profit achieved, the distributions of dividends as well as any currency differences are stored in this table.
Hidden Reserves table
You can assign any hidden reserves (fair value adjustments) to assets in this table.
The entries in Hidden Reserves table therefore show the absolute value, and not changes.
Eliminated Hidden Reserves table
The system computes the elimination of hidden reserves and records it in the table. It also calculates the amortization of the eliminated hidden reserves. The data of the Hidden Reserves table and the specifications for the elimination in the definition of the C/I methods are the basis.
You can manually adjust the default value that is set for the amortization of each period that follows.
One could basically state that hidden reserves must be dealt with exactly the same way as the assets disclosed in individual financial statements. If because of this, the following activities must be taken into consideration, you must manually enter them in the table.:
Goodwill resulting from consolidation of investments is also recorded in the table by the system, assuming it is not directly cleared against a stockholders’ equity item. It is posted against the FS item that has been specified as the APC item in C/I Method Definition, with the account assignment "GOOD". The system calculates the amortization of goodwill and records it in the table. Manual adjustments can be made.