Supplier ESG response tracker: keep replies, evidence and coverage separate
Updated: 7 days ago
Use this editable tracker to see which supplier requests have received a reply, what evidence supports each response and whether it covers the period and boundary you asked for. Those are three separate questions. Keeping them separate helps a procurement or sustainability team decide what to clarify next.
What the workbook contains
The XLSX includes a clean 100-row request register, a separate fictional completed example and instructions with a field-by-field data dictionary. Yellow cells hold user inputs. Blue-grey cells hold formulas. Filterable columns and frozen identifiers help users follow a request across its evidence, owner and next action.
Define the request population
Enter the programme, a fixed as-of date and the reason the supplier/request subset was selected. Use one row for each supplier-topic-period request, with a stable request ID and supplier business ID. One supplier may therefore have more than one row. Record the requested reporting period and the entities, sites or products to be covered.
Keep the three reviews distinct
Request status records the stage of the exchange: planned, sent, partial response, response received, clarification requested, closed or withdrawn.
Evidence quality describes what has been supplied or reviewed. A traceable source can be located; this label does not certify that its contents are correct. A self-declaration, a response without evidence and an unresolved clarification remain separately visible.
Period/boundary coverage records whether the material matches the request, covers only part of it or addresses something different. A document can be traceable while covering the wrong year or a wider group than the supplying site. Record that distinction before using its data.
Handle unavailable data fairly
A supplier may reply that the requested aggregated data are unavailable. Record the explanation, owner and proportionate next step. The reply can count as a response while the evidence field remains No evidence supplied and coverage remains unreviewed. That is a collection gap, not proof of poor sustainability performance, misconduct or non-compliance.
Read the summary correctly
The response rate divides logged responses by active sent request rows. Planned and withdrawn rows are excluded. It is a request-row response rate, not the proportion of unique suppliers, spend, emissions or the full supply chain covered. The rate stays blank when there is no denominator or a flagged input check needs attention.
The fictional example has four active request rows across three invented suppliers. Three rows have replies, giving a 75% request response rate. One reply explains that evidence is not currently available, one covers only part of the requested period and one has a traceable source matching the request. The fourth request is awaiting a reply. All names, documents and review decisions are fictional.
Plan the next action
Record an internal owner, a specific next action and its date. Timing prompts compare that date with the fixed as-of date, which the user updates deliberately. Closing a request requires a response date, a reviewer and date, and completed evidence/coverage review fields. Active sent dates and entered review dates must not be after the as-of date. A closed review cannot predate the response. Same-day dates are allowed; response-due and next-action dates may be in the future. Closure means the record-management step has been logged; it is not a compliance judgement.
Download the supplier ESG response tracker
Limitations and data control
The tracker does not authenticate documents, calculate a supplier ESG rating or replace topic-specific technical review. It does not send emails or follow-ups. Save the file in your controlled storage and share only authorised information. Avoid unnecessary employee-level or other sensitive personal data. The workbook has no macros, external data connections or automatic transmissions.
Method source
The GHG Protocol Supplier Engagement Guidance discusses supplier data management, consistent source/period/boundary information and follow-up on data quality. This tracker uses those general workflow ideas for an original ESG request register; it does not claim that every ESG topic is governed by the GHG Protocol. Read the Supplier Engagement Guidance.
For help scoping proportionate supplier requests, organising responses and preparing reporting evidence, explore Nitium Advisory’s value-chain reporting support or discuss your project.
Workbook prepared 5 October 2026.
Choose “Customer or supplier ESG response” in the questionnaire, record your proposed scope and open evidence gaps, then review the brief before sharing it yourself. The questionnaire does not send your brief automatically.
Comments