CSRD reporting starts with one exercise: deciding which sustainability matters are material to your company from both directions, your impact on the world and the world's financial impact on you. Get it wrong and you either over-report or fail assurance. This workbook runs it to the ESRS 1 method.
IRO Register for up to 60 impacts, risks and opportunities across all ten ESRS topical standards, E1 to G1, with dropdowns for topic, type, value-chain position and time horizon.
Impact materiality scored on scale, scope and irremediability, likelihood-weighted for potential impacts, as ESRS 1 section 3.4 sets out. Financial materiality on magnitude and likelihood, per section 3.5.
Editable thresholds on a dedicated sheet, with the scoring scales written out so the method is documentable for the assurance provider.
Topic summary tells you, per standard, whether it is material and what that means for reporting, including the rule that E1 Climate cannot be omitted without a detailed explanation.
Materiality matrix chart plots every IRO on impact versus financial axes.
Stakeholder, evidence and owner columns so the audit trail is built as you go.
Basis: Commission Delegated Regulation (EU) 2023/2772 (the ESRS), sections cited in the Guide. A working tool, not legal advice. No macros, no locked cells.
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 are preparing a CSRD sustainability statement and need a defensible, documented materiality assessment.
Not suited if: You need the full sustainability statement drafted; this decides what goes in it.
Contents: 1 Excel workbook (.xlsx), sheets: Guide, IRO Register, Topic summary, Materiality matrix, Thresholds. 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 ESG, Compliance Excel: CSRD Double Materiality Assessment 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. |