GUIDE for companies in 'financial statements' monitor

Table of contents

1 Companies financial statements+monitor (EA)

1.1 Symbol explanation

The Companies financial statements+monitor is the central control panel with which you can access all of the relevant applications for financial statements and in which you can be informed of their current status.

The Companies financial statements+monitor includes a tool bar, which can be activated by selecting one or several lines. The following symbols are available (from left to right):

If the information for a merger have been entered in 'GES', they will be indicated in two additional columns in the Companies financial statements+monitor (merged into / at).

By using the triangles (in each field on the right under the header line) the lines can be sorted alphanumerically up and down.

1.2 Display and selection options

The Companies financial statements+monitor has the following selection options:

Selection fieldExplanation
Group/subgroupIn conjunction with the fact or the fact group-structure this filed is used to restrict the data to be displayed. If a group is entered, only those companies are displayed which are maintained in the KTKGES for this group with this fact or fact group-structure, respectively. The fact group-structure also needs to be indicated for the balance reconciliation.

The number of status columns in the development transaction varies according to the number of defined (according to the application SPIDEF) and activated (according to the applications ABRSPI and FACSPI) development transactions. The column texts include column names and development transaction definitions. (SPIDEF)

1.3 Status display

The statuses displayed in the Companies financial statements+monitor are based on the processing control records, the so-called 'checkpoints', which are written in order to ensure that any further processing is possible with checked data. If the data is incorrect, a corresponding notification no. is written in the checkpoint records, which locks it for further processing, e.g. for currency conversion or balance transfer.

The checkpoints correspond to the balance and transaction applications as displayed in the Companies financial statements+monitor. Due to the unlimited number of development transactions, the processing control records for development transactions are not allocated permanent checkpoint IDs. They are generically made up of a fixed prefix ("SPI-" for the total development transaction, "VOR-" for the carry-forward check totals) and the development transaction key.

In the column "Creator" it can be seen which application has produced the current status.

Comments can be added to the data records for processing control, e.g. in order to explain a status. The actions “Edit comment” and “Display comment” are available in the processing controls list for this purpose. Like with the report data, it is not possible for these texts to be parallel in different languages.

The locking of a financial statement can therefore be explained with a comment by the record for the checkpoint "EALOCK". If a financial statement has already been locked, a help-text can only be recorded or amended though with special authorisation "2".

The existence of a comment is shown as in other overviews by a column ("C"/"Status of the help-text") by symbols (ticks) or coloured areas (green), provided the option "Display help-text info" has been activated in the "View" menu item.

When using individual authorisation groups without reference to the IDL standard authorisation groups it should be noted that the amendment of comments requires amendment authorisation for the respective individual record application VERARBE.

The processing control records are written automatically when the respective application is called up and can therefore not be recorded or amended by the user. It is only possible to delete processing control records, e.g. in order to cleanse the database, with special authorisation.

From the application VERARB you can to go from any written record to the respective application via the action menu 'Display list'.

The notification types in the VERARB records result in the following statuses being displayed in the Companies financial statements+monitor:

For each of the relevant applications in the financial statement there is a column in the table in which the current processing status is displayed by company. The statuses are updated automatically when the application is called up. The update can also be started directly via the action menu with “Check and refresh status information“. Statuses are only displayed for breakdown data for which the corresponding controls are set in FAC and ABR. The UBR must always be clear, i.e. an entry is essential.

The status in the Companies financial statements+monitor is displayed based on the notifications which are entered in the processing controls (VERARB list). The difference between red and yellow is based on the notification type of the notification number entered ("E"=red, "W"=yellow, "I"=white with line). The colours used for the statuses have the following meanings:

red / stop sign = incorrect, e.g.

yellow / warning triangle = warning (plausibility checks not met)

green / green tick = correct

white = no data or no validation

blue / blue ball = no data or no validation

In accordance with the EA status, the colouring of the account codes in the account balances shows the consistency of the associated breakdowns. 'Yellow' is used if the associated status in the Companies financial statements+monitor is 'yellow', particularly if the values are consistent in local currency but are different in group or parallel currency, with only a currency conversion being able to provide correct data.

2 Follow-on applications

Follow-on applications can be reached as follows:

Via the menu item "Action" or the tool bar you can reach the following applications:

[Check refresh status information]:
the set statuses are updated, respectively new set.
[Display comment]:
display a comment, if one is available. The existence of a comment is shown by the book symbol in the column with the heading 'C'.
[Edit comment]:
an explanatory text (comment) for the “financial statements” application can be recorded directly in the application Companies financial statements+monitor (EA).For this purpose it is not necessary that the financial statement was locked beforehand.The help-text can only be created or changed with special authorisation if the financial statement has already been locked.
[Lock...]:
If a financial statement should be locked against transactions for a period, this can be done the action "Lock company financial statement" in the "Lock …" menu. Depending on the setting the status is shown with the following symbols: green tick or closed padlock with a green tick.If the lock is lifted, the status is “yellow” or has an open padlock with a yellow triangle. By locking a group financial statement in KTKGES all of the financial statements of the companies in the group are automatically locked. The locking of a financial statement is no longer linked to the updating of a status, so a financial statement can be approved without stating the business unit. A lock on a financial statement cannot be lifted if the higher-level group is locked.

Via the menu item "Action" or the right mouse button you can reach the following applications:

[Lists]
[Company financial statements + monitor for entry]
in this menu item you can open the application 'Company financial statements + mmonitor for entry.Then via the menu item 'Action' or the right mouse button and the menu item 'Entry company financial statements' you can reach the following apllications:
[Import]
with this application you can import Data from your financial accounting or from extern sources (f.e. IDl.XLSLINK) into the IDl.KONSIS.FORECAST system.
[Delete functions...]
The deletion of data already recorded for one or more companies can be time-consuming if you have to go to each individual application. Therefore in the Companies financial statements+monitor there are also a few delete functions which can be run simultaneously for several companies and which combine several applications. For example, account balances, IC and controlling balances can be deleted at the same time as assets, capital, provisions and development transactions. When deleting account balances the existing proof of origin is also deleted as the proof of origin is no longer of significance without the result. When the transactions are deleted the carry-forward transactions are not deleted and would where applicable also have to be deleted manually.
[Carry forward into new period]
[Transition to new fact]
[Currency conversion]
[IC reconciliation]
With the Companies financial statements+monitor a simulation of the debt (b/s) and cost/income consolidation (p/l) can be created without generating consolidation postings. This makes it easier to check IC balances easier as this check can be made before the actual consolidation starts.With the field ‘Fact group-structure‘ (set in the application 'FAC' or in the application ‘VOR‘), which should include the consolidation fact, the consolidation group and the b/s+p/l parameters are determined. An implicit currency conversion also takes place, with all of the IC balances converted uniformly at the exchange rate on the reporting date. Users who would like to use the check to correctly forecast the effect on results should set and run the currency conversion for the lower fact. The IC balance reconciliation is also possible for the consolidation fact, provided the corresponding consolidation (debt consolidation (b/s) or cost/income consolidation (p/l)) has not yet taken place. This condition concerns not only the company (companies) selected, but also the other (IC) companies of the consolidated group. In the Financial Statement Monitor only the status of an IC-b/s and IC-p/l reconciliation is displayed, not though the status of a genuine consolidation. The balance reconciliation does not generate any consolidation postings; this also means that the IC balances here have not yet been “stamped” with the data relevant for the residual value analysis such as the voucher no. and group/subgroup. Only an IC-clearing list is created, based on the differences which are recognisable. The IC balance reconciliation includes the postings (at the same level) to inter-company accounts. This also includes the currency conversion, provided the values of the postings are only in local currency. Please note that this control always takes place and cannot be switched off. The IC clearing list displays the contributions of the postings to the overall difference in their own columns and allows you to branch off to the posting list (BUCH).
Via the action menu item "Lock intercompany account balances" you can also selectively lock the IC balances, for example if the IC balances have already been reconciled and are to be protected against further transactions, or lift existing locks if they are to be subsequently changed. The status display functions the same as the locking of the financial statement.
Due to the inclusion of postings in the IC balance reconciliation, the locking of the IC balances (action " Lock intercompany account balances") also effects the changes to postings to IC accounts, including the deletion of vouchers which include such postings.
[Deferred taxes]
[More functions...]
Letzte Änderung: WERNER 23.12.2016 15:28