Consolidation and Status

This chapter tells you how to consolidate a group, and how to consolidate with or without the status function.

Consolidation
The consolidation routine can be run in two ways, either with the status function enabled or with the status function disabled.
Reconcile between Accounts/Opening Balances for Groups
You can use this window for reconciliation of data.
Reconcile between Accounts and Opening Balances by Automatic Journals
When you have consolidated a group, you probably want to analyze if all data corresponds, from reported values and company journals to intercompany and acquisition eliminations.
Consolidate allocations
Use this function to run allocations as a separate step in the consolidation process.
Generate Automatic Journals for Intercompany Balances
You can use this function to perform automatic elimination of the amounts that are also contained in the reconciliation report for intercompany balances.
Generate Automatic Journals for Intercompany Profits
You can use this function if you want to perform an automatic elimination of the calculated intercompany profit presented in the reconciliation report.
Perform Acquisition Calculations
Run contribution calculations
To calculate companies' contributions to the top level group, go to Group > Consolidate by steps > Automatic Journals - Contribution.
Consolidate advanced formula calculations
You can use this function to consolidate advanced formula calculations as a separate step in the consolidation process.
Consolidate User-defined business rules
You can run User-defined business rules anywhere in the consolidation process.
The Status Function
The status function can be set to disabled or enabled, which lets you reconcile values manually, or to automate the consolidation process and reconcile.
Enable and Disable the Status Function
In order to perform the consolidation process automatically for currency translation, elimination of intercompany balances, elimination of intercompany profits, elimination of acquisitions and consolidation, you need to enable the status function.
The Status Register
Reporting status keeps track of how far work has progressed for an individual company and for each submission. The status of the company or group in question changes as soon as a task is completed and acknowledged.
Perform Legal Unit Consolidation
In a manually generated management company structure there are two considerations:
Jobs and mapping tables
You must define a job to execute User-defined business rules (UDBR), allocations or advanced formula calculations, either separately in consolidation by steps or in a consolidation with status.
Define subsets
This function is used to group companies into subsets. Company subsets are currently used in User-defined business rules to define which companies to include in calculations.
The Batch Queue
In IBM® Cognos Controller, several consolidation jobs may run at the same time. The Batch Queue shows the consolidation jobs waiting for execution or in progress.
Schedule Batch Jobs
In the Schedule Job window you schedule when you want jobs in the consolidation to take place.
Generate Consolidation Reports
This section describes the various types of reports which may be useful when you are consolidating values and when you want to check and analyze the result.