A ready spreadsheet for the value chain questions a listed customer sends under SEBI BRSR Core: company details, boundary, Scope 1 by fuel, Scope 2 from electricity, energy, water and waste, with a unit and source beside every number.
For: MSMEs that supply a listed company, and the sustainability teams who send the questions. Saves you: Suppliers answer once in the order buyers ask. Buyers get answers they can compare instead of a different format from every supplier.
Company and period
Field
Example
How to fill it
Legal name
Shree Ganesh Castings Pvt Ltd
The entity you invoice the customer from
GSTIN
27ABCDE1234F1Z5
Example format only
Reporting period
Apr 2025 to Mar 2026
Match the customer’s financial year
Boundary
Plant 1, MIDC Ahilyanagar; office excluded
Say what is left out and why
Contact for questions
Plant manager, name and email
Emissions
Field
Example
How to fill it
Scope 1: diesel
4,200 litres × 2.68 = 11.26 t CO2
One line per fuel, with quantity, unit, factor and source
Scope 1: LPG
1,900 kg × 2.98 = 5.66 t CO2
Scope 2: grid electricity
312,000 kWh × 0.710 = 221.52 t CO2
CEA grid factor, with the database version
Scope 3
Not asked
Leave blank unless the form asks; say so rather than guess
Energy, water, waste
Field
Example
How to fill it
Energy, non-renewable
1,357 GJ
Same quantities converted to GJ
Energy, renewable
0 GJ
Water withdrawal by source
Municipal 2,100 kL; borewell 900 kL
Waste by category
Foundry sand 38 t to recycler
From weighbridge slips and recycler receipts
For the buyer
Field
Example
How to fill it
Partner share of purchases
3.4%
Partners at 2% or more of purchases or sales are in scope
Coverage reached
68% of purchases
Coverage may stop at 75%; the share covered must be stated
Prior-year figures
Not requested
Voluntary in the first year of value chain reporting
How to use it
Fill the header: Legal name, GSTIN, the April to March period and the plants your figures cover.
Add one line per fuel: Quantity from your bills, the unit, the factor and its source. The sheet multiplies for you.
Add electricity: Units from your electricity bills; the sheet applies the CEA grid factor.
Check units and send: kg against tonnes is the most common slip. Offer the evidence list, not the bills, unless the contract asks.