Due Diligence Report Engine
AI & Auditing

Due Diligence Report Engine

Author : CA Naveen Agarwal

Watch on Youtube
  1. Problem Statement –

The purpose of this use case is to draft a comprehensive Due Diligence Report supported by detailed analysis. The Problem is taking long time to collect and present data from Multiple Government Portals. It involves downloading historical data from the Registrar of Companies and evaluating changes in corporate structure and shareholding patterns. Additionally, collecting public compliance data from different portals relating to GST, Income Tax, ESI, and PF compliances need to be extracted and summarized for meaningful insights. The process also covers fetching and analysing details of Income Tax Cases, GST Cases cased filed by company or against the company and other civil or criminal cases from various court portals. All findings are then required to be consolidated into clear, presentable Dashboard supplemented with charts for effective decision-making that Investment should be made or not by the Private Investor Group or Venture Capitalist.


  1. Targeted Audience –


  1. Chartered Accountant in Practice for Making Due Diligence Report.
  2. Chartered Accountant in Industry working with Different Investment Groups or VC.
  3. Investment Groups or Angel Networks.
  4. Private Investors


  1. Technology Solution –


  1. Use of Probe42 login and search the required company and unlock all the related data from its dashboard to get automatically downloaded Data from MCA, Income Tax, GST, ESI PF Portal, Civil Cases Search, Tax Litigations Portals at one place.
  2. Use of Probe42 for Downloading in a summarized Report at One Place in PDF or Excel as per Requirement. Save the file into .xlsx format to get readable further by Claude properly.
  3. Use of Claude to Draft a Due Diligence Report Dashboard with valuation report, SWOT Analysis and suggestions on decision From The Input Data
  4. Make Due Diligence Report Tool as per User Type by using Claude.


  1. Prompt Used -


  1. Prompt for Getting Due Diligence Report Dashboard


Assume you are a strategic advisor to a venture capitalist who want to Invest 50 Crore for 1% Equity in the Company Data Attached as Source Data.xlsx. Make a Due Diligence Report highlighting all the relevant parameters of investment making SWOT Analysis making a Dashboard and also suggest correct valuation based on financial statement given in attached excel.


  1. Prompt for Making Custom Due Diligence Report Generation Engine –

Make an web app which can read data from attached template and make due diligence report from venture capitalist and making all graphical presentation to make him easy presentation and highlight all strength weakness threat and opportunities. It also show all green flag and red flag factors. Also give a summary valuation report. Also add Input field to consider in valuation report. One Filed to Ask offer Value and another filed to ask percentage of equity offered. Remove and repair any possible error in tool and keep the currency calculation in Indian rupees instead of dollars mention the proper approximation in Lakh or crore rupees as per requirement.


Conclusion –

 

PROBE 42 serves as a comprehensive tool for collecting and downloading MCA-related filed data while automatically identifying compliance gaps across GST, Income Tax, ESI, PF, and credit ratings. It provides all reference documents in a structured input report format (Excel/PDF), which can be seamlessly converted into a detailed due diligence report.


Additionally, tools like CLAUDE significantly reduce time and effort by automating data presentation Dashboard and making Valuation Report with decision making. Claude also help to make the Web app for the same as a tool which can generate reports for multiple company only on upload of source data excel file generated from Probe42. It removes the requirement of entering prompt every time. The combined utility of these tools extends to multiple professional applications, including audit observations, drafting of red herring prospectus, and preparation of project finance reports.