Introduction
At this screen, you can view the translated financial figures which are to be consolidated in the financial statements. In addition, you can also create consolidation adjustments or elimination entries if required, and then generate the consolidated financial statements.
Note: This functionality is available only if you have the module license YA1040 – Financial consolidation and option 470.
Menu path
Financial/Reports/Financial consolidation/Consolidation worksheet
Roles & rights
- To view the consolidation worksheet, function right 42 – View consolidation worksheet is required. By default, users with the General manager and Controller have this function right.
- To view and create elimination entries, function right 31 – View elimination entries and function right 30 – Create elimination entries are required. By default, users with the General manager and Controller roles have these function rights.
- To generate the consolidated financial statements, function right 43 – Generate consolidation worksheet is required. By default, users with the General manager and Controller roles have this function right.
For more details on what you can do with function rights or levels, go to System/Setup/Security/Function rights, select the required module, and then click on the relevant ID. To find out the functions you can perform with a particular role, go to System/Setup/Security/Roles, type in the description, click Refresh, and then click the required link under the Role column.
Button
Show
Click this to display the consolidation worksheet based on the defined criteria.
Note: Once you have clicked this button, the name of the button will change to Refresh.
Refresh
Click this to update the consolidation worksheet based on the last defined criteria or recalculate the group statement based on the current/cumulative elimination entries.
Reset
Click this to clear the defined criteria.
Entry
Click this create elimination entries. For more information, see Creating and Modifying Elimination Entries.
Note: This button is available only after you have defined a reporting entity to view the consolidation worksheet for the reporting entity.
Generate
Click this to generate the consolidated financial statements. After you have clicked Generate, you will see this message "Not all periods are closed. Close period?" if you have open periods in the reporting entity or child divisions. Click “Close period?” in the message, and the system will open the configuration checking screen to allow you to adjust the closed periods prerequisite. For more information, see Checking Configuration for Financial Consolidation. After the consolidated financial statements have been successfully generated, you will see the message “Group statement: Generated”. Meanwhile, if you have already generated the consolidated financial statements for a specific financial year and period for a reporting entity and you generate again based on the same criteria, you will this message “Group statement already generated for the selected year/period. Do you want to overwrite existing data?" Click Yes to overwrite the existing consolidated statements with the newly generated statements. Otherwise, ignore the message and close the message box to not overwrite the existing consolidated statements.
In a scenario where the consolidation structure of a particular period is changed after you have generated the consolidated financial statements for that period, you should regenerate the consolidated financial statements for that particular period to reflect the latest consolidated financial statements based on the new consolidation structure.
Note: This button is available only if you leave the Show field blank, and then click Show or Refresh to view the consolidation worksheet. This function will always generate only periodic group statements based on the periodic amounts even if you select Cumulative at View.
Close
Click this to exit.
Description
Reporting entity
Type or select the reporting entity to view the consolidation worksheet for the selected reporting entity. This is mandatory.
Presentation currency / Factor
Select the presentation currency used in the financial statement reports. By default, the system will show the presentation currency of the selected reporting entity. Next, select the factor to view the financial figures in factor of 1.00, 1, 1,000 or 1,000,000. By default, the system will select 1.00. For example, if you have an amount of EUR 200 and the Factor selected is 1.00, the amount will be displayed as EUR 200.00 in the consolidation worksheet.
Year / Period
Select the financial year, and type the period of the reporting entity to view the consolidation worksheet for the defined financial year and period.
View
Select Periodical to view the periodical translated financial figures or Cumulative to view the cumulative translated financial figures. By default, the system will select Periodical.
Show
Select B/S to view the financial figures in the balance sheet or Profit & Loss to view the financial figures in the profit & loss statement. Leave the field blank to view both the financial figures in the balance sheet and profit & loss statement.
Related document