Understanding Consolidation Status Report

The Consolidation Status report is an opt-in feature to view the status of the Consolidation Process for a given intersection (entity, scenario, period) within a close cycle. The Consolidation Status report offers several benefits, such as providing the necessary information to complete the close process in a timely manner. Further, consolidators can view the status by entity and time period they are responsible for. This report is available for the Consolidation Process only.

Once the necessary General Ledger data is loaded, journal entry processing and consolidation activities are completed, the behind-the-scenes log stores each action with a date and time stamp. For example, if you run the Consolidation Process, the application logs the activity and time, along with the consolidated action. All this information is available in the Consolidation Status report.

If you modify data in a previous or current period, the consolidation status for all subsequent periods will be affected, as year-to-date amounts. For example, if you modify data for July 2022, the Consolidation Status report will change for August 2022 and September 2022 as well.

How to Run and View the Consolidation Status Report?

1. Navigate to Consolidation to open the Consolidation Control Panel

2. Click Consolidation Process under Processes.

3. Under Reports, click Consolidation Status. The Consolidation Status dialog appears.

4. The Scenario is a read-only field that indicates the scenario associated with the Consolidation Process.
   
   

5. Select the Period by clicking the calendar icon.

6. Select the Entity.

7. Click GO. The report details with the Overview tab selected is displayed within the Consolidation Status dialog.
   
   

Interpret the Consolidation Status Report Results

Consolidations Status report results are spread across four different tabs —Overview, Consolidation Detailed, Standard Journals, and Validations. This section helps you understand the information on each tab. Note that all children of a parent entity display the same status as the parent.

Overview

The Overview tab provides information on the consolidation status, data load, Standard Journals, locked, and Validations. The consolidation statuses are "Consolidation successful", " Not Started", "Consolidation required", "Consolidation was never performed", "Consolidation Process was performed", "Data has changed since the last Consolidation Process", and so on. You can drill down into unprocessed consolidations for more information.

Consolidated Detailed

The Consolidated Detailed tab provides information on the location of the modified data, the modifications themselves (add, edit, etc.), the user who modified the data, and so on. For more information on modifications, click an individual process to open the pop-up message containing the most recent five modifications.

Click the more... link to download an Excel report containing the modifications across all processes for the entity. When clicking the more... link at the roll-up level, the Excel report provides information on modifications to all processes for all entities under the roll-up.

Standard Journals

The Standard Journals tab provides information on the unprocessed Standard Journals. The indicators used for the Overview and Consolidation Detailed tabs are the same. You can also drill down into unprocessed Standard Journals and export them to an Excel sheet.

Validations

The Validations tab provides information on unprocessed and failed Validations. The indicators used for the Overview and Consolidation Detailed tabs provide the same purpose on the Validations tab as well. You can also drill down into unprocessed Validations and export them to an Excel sheet.

Report Behaviour

The following is a sample Consolidation Status report that describes the behavior of each status for various processes.