A corporate greenhouse gas inventory to the GHG Protocol Corporate Standard: Scope 1 (fuel you burn), Scope 2 (electricity and heat you buy), and the Scope 3 categories most organisations report first. It is the inventory ESRS E1 asks for under CSRD, and what large customers now ask their suppliers for.
35 emission factors copied from the UK Government GHG Conversion Factors 2025 (DESNZ), each with its official ID, so every number in your inventory traces to a public source. Add rows for your own country's grid factor with a citation.
Scope 1, 2 and 3 activity sheets: pick the factor from a dropdown, enter the quantity, the emissions compute. Evidence and data-quality columns build the audit trail as you go.
Organisation sheet: reporting year, consolidation approach, sites, FTE and revenue.
Summary: totals by scope, shares, intensity per FTE and per million revenue, Scope 3 by category, market-based Scope 2 alongside location-based, and a chart.
Flight factors include radiative forcing. Well-to-tank and T&D losses covered.
Pairs with the Bindler CSRD Double Materiality Assessment: run the materiality first, then this inventory feeds E1. Live formulas, no macros, no locked cells. Excel and Google Sheets.
Who it is for: sustainability and finance teams producing their first audited inventory, and consultants who need a factor trail their client's assurance provider can follow. Each activity row multiplies your quantity by a factor whose DESNZ identifier sits beside it.
How to work with it. Open the workbook in Excel or Google Sheets. Yellow cells are inputs, blue cells are formulas. Start with the Guide sheet, which walks through the sheets in the order they are meant to be used, then replace the example values with your own data. Every figure traces through live formulas to the inputs and to the cited source, so an auditor, lender or client can follow the working.
Use it if: You need the Scope 1, 2 and 3 inventory ESRS E1 or IFRS S2 asks for, with an audit trail.
Not suited if: You need country-specific grid factors for many countries; one UK grid factor ships, others you add with a source.
Contents: 1 Excel workbook (.xlsx), sheets: Guide, Organisation, Summary, Factor Register, Scope 1, Scope 2, Scope 3. No macros, no locked cells, no hidden sheets. Built and verified by Bindler.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Sustainability, ESG Excel: GHG Protocol Scope 1, 2 and 3 Inventory Workbook Excel (XLSX) Spreadsheet, Bindler
|
Download our FREE Organization, Change, & Culture, Templates
Download our free compilation of 50+ slides and templates on Organizational Design, Change Management, and Corporate Culture. Methodologies include ADKAR, Burke-Litwin Change Model, McKinsey 7-S, Competing Values Framework, etc. |