✅ Purpose of the Document

The ESG KPI Tracking document is a centralized reporting dashboard designed to aggregate all sustainability metrics across your organization and its subsidiaries.
Its primary goal is to provide a single "source of truth" for your ESG data, enabling you to track progress in real-time, monitor the effectiveness of your CSR policies, and provide the quantitative evidence required for EcoVadis and other sustainability frameworks. By consolidating data from all services (HR, Operations, Procurement, etc.), you ensure transparency and audit-readiness.

🏗️ Expected Structure & Key Elements

The template is organized to mirror the EcoVadis assessment pillars. Below are the core components you should manage within the tracking tool:
General Information: Mapping of all operational sites and legal entities, including headcount per site to ensure reporting scope is 100%.Environmental Data: Metrics on Energy & GHG (Scopes 1, 2, & 3), Water consumption, Waste management, Biodiversity impacts, and Product end-of-life.Social & Human Rights: Indicators for Employee Health & Safety (accident rates), Working Conditions, Social Dialogue, Diversity (gender pay gap), and Training hours.Business Ethics: Tracking of ethics training coverage, corruption risk mapping updates, and counts of data security incidents or whistleblower alerts.Sustainable Procurement: Monitoring supplier signatures of the Code of Conduct, the percentage of suppliers assessed on CSR, and buyers trained in sustainable sourcing.

📚 Acceptance Criteria per Framework

EcoVadis

EcoVadis doesn't just want to see your goals; they want to see the results of your actions. To ensure your "Reporting" section scores maximum points:

Relevance: Do not track everything. Filter the template to keep only the KPIs relevant to your industry and operational reality.
Completeness: Data should ideally cover the last 2-3 reporting years to show trends (improvement or decline).
Standardized Units: Use consistent units (e.g., metric tons for CO₂, kWh for energy). The auditor will penalize inconsistent or non-standard reporting.
Avoid Blank Cells: Never leave a cell empty. Use "0" if the value is zero, or "N/A" if the data is currently unavailable, to show the indicator was not overlooked.
Scope Alignment: Ensure the data covers all entities listed in your assessment scope. If data only covers one branch, it must be clearly stated.

📌 Include:

Brand Customization: Update the document with your company logo and brand colors.
Historical Data: Include at least the last completed calendar year. You will get more points if you can have data for at least the three past year
Source Notes: For internal use, keep a note of where each data point came from (e.g., "Electricity bill" or "HR Portal").
Planned KPIs: If you aren't tracking a specific EcoVadis-relevant KPI yet, keep the row and mark it as "Planned for 202X."

📎 Typical Attachments & Supporting Proofs

The Excel/CSV Tracker: The primary file used to consolidate data before it is formatted into an annual report.
Utility Bills & Invoices: Samples of energy or water bills to verify the consumption data entered.
HR Reports: Anonymized exports from payroll or HRIS systems for headcount and training data.
External Audit Reports: If your carbon footprint or social data was audited by a third party (e.g., ISO 14064 or social audits).

❌ Common Mistakes to Avoid

Tracking Irrelevant Data: Including KPIs that don't apply to your business (e.g., "Wastewater from production" if you only have offices) creates noise for the auditor.
Changing Units Mid-Year: Reporting energy in MWh one year and kWh the next without a clear conversion will lead to data rejection.
Siloed Reporting: Only reporting on HQ while ignoring the environmental or social impact of regional sites.

🔄 How Often to Update

Recommended Update Frequency per Framework:

EcoVadis: Annual. Reporting must be from the most recent 12-24 month period.Internal Management: Quarterly to allow for course correction if targets are being missed.

🖋️ Example of an ESG KPI Tracking

This template is your foundation. It contains a comprehensive list of indicators mapped to EcoVadis criteria.
How to use it: 1.Identity: Fill in the "Introduction" and "General Information" tabs.
2. Filter: Review the Social, Environment, Ethic, and Procurement tabs. Delete rows that are not material to your business.
3. Populate: Enter your data for the relevant years.
4. Enhance: Add any industry-specific KPIs that are unique to your company's strategy.

Brand: Apply your company's visual identity to the document before sharing it with stakeholders or auditors.

FAQs

Should I upload the entire raw Excel file to EcoVadis?

It is usually better to export a "Clean" version (PDF or formatted Excel) that only shows the relevant KPIs and the last 2-3 years of data, rather than a working document with internal notes.

What if we don't have data for a specific EcoVadis KPI?

If it is a key KPI for your industry, start a "Data Collection Plan." Note in your tracker that this KPI will be monitored starting next year. This shows a commitment to transparency.