Skip to main content

Report Preparation Workflow of the Report & Analysis Execution System

The Report Preparation Workflow within the Report & Analysis Execution System (RAES) plays a vital role in executing Standard Operating Procedures (SOPs) for due diligence based on the type of report requested by the Client User. It sets in motion a series of execution steps, each triggering the necessary Analysis Workflows to compile and generate the requisite data points and insights.

Key Execution Steps​

The workflow comprises a set of predefined steps tailored to cater to a wide array of report types. These steps can be broadly categorized into preparatory, execution, and output generation stages.

Preparatory Steps​

The preparatory steps form the foundation of the report preparation workflow. They are designed to gather, process, and prepare the necessary data before the actual report generation commences. These steps help streamline and automate manual processes, reducing the potential for human error and increasing overall efficiency.

1. First Level CP Identification​

This step involves the identification of first-level Connected Parties (CPs) of the target entity. Connected Parties include entities such as shareholder companies, group companies, and associates. By identifying these parties, the system provides a broader context to the analysis and assists the analyst in determining additional entities for which Ministry of Corporate Affairs (MCA) filings might need to be procured.

2. Populate MCA Docs from Order IDs​

Upon procurement of MCA documents, the system allows analysts to input their respective order IDs in the report configuration. Once the order IDs are provided, this step auto-loads all necessary MCA documents along with their associated metadata into the system. This functionality removes the necessity for analysts to manually load each document, significantly reducing the time and effort required.

3. Preprocess Input Files​

During this phase, the system preprocesses the uploaded MCA documents to extract essential information. These files are typically extensive and unstructured, making manual information extraction laborious and prone to error. The preprocessing step involves automating the extraction of basic information to identify and populate data such as which party the documents belong to, ensuring an accurate data foundation for the subsequent steps of the workflow.

4. Connected Party Estimation​

Some reports, such as those following Section 29A guidelines, necessitate an estimate of the size of the connected party network before billing the customer. This is because these reports' costs depend on the number of CPs being checked along with the target. This step calculates the connected party network's size and provides a list of related entities without necessitating the generation of the full report. This approach allows for more accurate billing estimates and helps manage the customer's expectations.

Execution Steps​

Execution steps are crucial in the report preparation workflow as they trigger the required analysis workflows and data generation. They primarily focus on executing the full report analysis.

Full Report Generation​

This is the core execution step, which triggers all required analysis workflows as per the report configuration.

Key activities in this step include:

  1. Target Overview Analysis: This generates information about the target entity, including basic details, corporate structure, business overview, and connected parties.

  2. Financial Analysis: Provides insights into the financial health of the target company, including key financial metrics, valuation parameters, and potential forensic signals.

  3. Media Analysis: This covers analysis of media mentions and categorizes them based on the type of events detected.

  4. Filing Analysis: This checks for GST, EPF, and TDS filings, and investigates any delays or defaults.

  5. Regulator Checks Analysis: Conducts litigation checks, standard regulatory checks, Section 29A checks (IBC), standard sanctions checks, anti-money laundering (AML) checks, and related party checks.

  6. Risk Scorecard Generation: Generates a risk scorecard across various risk dimensions based on the data and insights generated from the aforementioned analyses.

  7. Continuous Monitoring Signal Generation: Detects updates as part of continuous monitoring across various data points in other analyses compared to earlier assessments.

The output of the full report generation is a detailed analysis result in the form of JSON for easy visualization and further processing. Additionally, outputs in other formats like DOCX or Excel are also generated for certain types of reports.

Note: Risk scorecard and signal generation will not run at this stage as they require the output of this step for their data generation.

Output Generation Steps​

This phase of the workflow is focused on assembling the final deliverables. It encompasses the steps of generating scorecards, monitoring signals, creating order output files, and generating the final report document. Each of these steps is described in more detail below:

Generate Scorecard​

This is the first step in the output generation phase. Once all required analyses are completed, the scorecard analysis is triggered based on the generated data. This involves computing risk scores across various risk dimensions, taking into account the insights derived from the previous analyses. Alongside this, an Excel version of the scorecard is prepared for verification and validation. This file allows Analyst Users to have an at-a-glance view of the risk scores for each dimension, enabling them to spot outliers and focus on high-risk areas.

Signal Generation​

This step triggers the continuous monitoring's signal generation analysis. This feature is key to the objective of continuous risk monitoring. Based on the data generated from the previous analyses, it detects updates and changes in various data points (attributes) in comparison to earlier assessments. Depending on the type of update and what it might imply, signals are generated for the Client Users to review or act upon. This provides a proactive approach to risk management, allowing for swift action when potential risks are detected.

Create Order Output Files​

This utility step aids in the creation of order output files for all litigation cases present in a report. It automates the process of downloading all relevant order files, extracting text from these documents, and consolidating them into an Excel file. This Excel file is designed for easy user searchability, facilitating quick access to pertinent information when needed.

Create Report Doc Output File​

The final step in the workflow is the generation of the Word DOCX version of the report. This document includes all the sections of the report, including the scorecard and the various analyses. It's designed for easy sharing and exporting, serving as a comprehensive document of the due diligence conducted, the insights derived, and the risk assessment.

Benefits of the Report Preparation Workflow​

This structured approach to report generation facilitates efficiency, accuracy, and consistency. It automates tedious manual tasks, reducing the possibility of human error and ensuring standardized outputs. Furthermore, the modular nature of the workflow allows for flexibility, customization, and scalability to cater to a wide range of reporting needs.