CDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
6
 XBRL Excel Utility
7
1.Overview
8
2.Before you begin
9
3.Index
10
4.Steps for Filing Corporate Governance Report
11
5.Fill up the data in excel utility
12
13
14
1. Overview
15
The excel utility can be used for creating the XBRL/XML file for efiling of Integrated Governance Report.
16
17
18
 2. Before you begin
19
1. The version of Microsoft Excel in your system should be Microsoft Office Excel 2007 and above.
20
2. The system should have a file compression software to unzip excel utility file.
21
3. Make sure that you have downloaded the latest Excel Utility from BSE Website to your local system.
22
4. Make sure that you have downloaded the Chrome Browser to view report generated from Excel utility.
23
5. Please enable the Macros (if disabled) as per instructions given in manual, so that all the functionalities of Excel Utility works fine. Please first go through Enable Macro - Manual attached with zip file.
24
6. Kindly use this file in local system instead of OneDrive/shared drive.
Because it may gives an error "Run-time error '52' : Bad file name or number" While clicking on textblock button if files saved on OneDrive/shared drive.
25
26
27
3. Index
28
1Details of general information about companyGeneral Info
29
2Composition of BODAnnexure I - Composition of BOD
30
3Composition of CommitteeAnnexure I - Composition of Committee
31
4Meeting of BODAnnexure I - Meeting of BOD
32
5Meeting of CommitteesAnnexure I - Meeting of Committees
33
6Affirmation Annexure I - Affirmation
34
7WebsiteAnnexure II - Website
35
8Annual AffirmationAnnexure II - Annual Affirmation
36
9Annual Affirmation ContinueAnnexure II -Annual Affirmation Continue
37
10Annexure III AffirmationsHalf yearly Affirmations
38
11Additional Half yearly DisclosureAdditional Half Yearly Disc
39
12Details of Cyber security incidenceCyber security incidence
40
13Signatory DetailsSignatory Details
41
14Investor Grievance ReportInvestor Grievance Report
42
15Acquisition of Shares or VotingAcquisition of Shares or Voting
43
16Imposition of Fine or PenaltyImposition of Fine or Penalty
44
17Ongoing TaxLitigations_DisputesOngoing TaxLitigations_Disputes
45
46
47
5. Steps for Filing Integrated Governance Report
48
I. Fill up the data: Navigate to each field of every section in the sheet to provide applicable data in correct format. (Formats will get reflected while filling data.)
- Use paste special command to paste data from other sheet.
49
II. Validating Sheets: Click on the ''Validate" button to ensure that the sheet has been properly filled and also data has been furnished in proper format. If there are some errors on the sheet, excel utility will prompt you about the same.
50
III. Validate All Sheets: Click on the ''Home" button. And then click on "Validate All Sheet" button to ensure that all sheets has been properly filled and validated successfully. If there are some errors on the sheet, excel utility will prompt you about the same and stop validation at the same time. After correction, once again follow the same procedure to validate all sheets.
51
Excel Utility will not allow you to generate XBRL/XML until you rectify all errors.
52
IV. Generate XML : Excel Utility will not allow you to generate XBRL/XML unless successful validation of all sheet is completed. Now click on 'Generate XML'' to generate XBRL/XML file.
- Save the XBRL/XML file in your desired folder in local system.
53
V. Generate Report : Excel Utility will allow you to generate Report. Now click on 'Generate Report'' to generate html report.
- Save the HTML Report file in your desired folder in local system.
- To view HTML Report open "Chrome Web Browser" .
- To print report in PDF Format, Click on print button and save as PDF.
54
VI. Upload XML file to BSE Listing Center: For uploading the XBRL/XML file generated through Utility, login to BSE Listing Center and upload generated xml file. On Upload screen provide the required information and browse to select XML file and submit the XML.
55
56
57
6. Fill up the data in excel utility
58
1. Cells with red fonts indicate mandatory fields.
59
2. If mandatory field is left empty, then Utility will not allow you to proceed further for generating XML.
60
3. You are not allowed to enter data in the Grey Cells.
61
4. If fields are not applicable to your company then leave it blank. Do not insert Zero unless it is a mandatory field.
62
5. Data provided must be in correct format, otherwise Utility will not allow you to proceed further for generating XML.
63
6. Select data from "Dropdown list" wherever applicable.
64
7. Adding Notes: Click on "Add Notes" button to add notes.
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100