ESG data traceability: how to prepare evidence for assurance

Table of contents

ESG data traceability for sustainability assurance allows companies to reconstruct the path of each figure or statement: from the definition of the indicator and its source to its calculation, review, and publication. To prepare this traceability, the company must assign responsibilities, retain evidence, document reconciliations and adjustments, control versions, and organize a file for each indicator.

What does ESG data traceability mean for assurance?

A traceable piece of data is not just a number on a spreadsheet, but a documented chain that links the result to its source, the transformations performed and the validations applied, allowing verification of the process without relying on informal explanations.

To reconstruct it, it is necessary to specify what the indicator measures, its period and scope, the source, the calculations performed, who reviewed the result, and which version was published. In qualitative statements, supporting documents and the management aspects they cover must also be identified.

This practice improves the quality of non-financial information, facilitates tracing the origin of data, identifies changes, and explains discrepancies between records and published figures. Simply compiling files is not enough: each document must be linked to a verifiable indicator, period, and result.

Before organizing the documentation, it is advisable to identify the report's indicators and claims. To expand the context, consult What is a sustainability report? and the comparative analysis of sustainability reports. The evidence required will depend on the selected indicators and the criteria and scope of the assurance.

How to design a chain of evidence by indicator

Traceability is best built during data preparation, not when the report is being finalized. A simple sequence helps anticipate what information to retain and who is responsible for each stage.

  1. Define the inventory and scope. Identify the indicators, claims, time period, and processes included. Record any exclusions, their justification, and changes in scope between periods, indicating how they affect the information presented.
    1. Create a dictionary of indicators. Prepare a form with the code, name, definition, unit, formula, period, scope, source, frequency, responsible party, reviewer, controls, and location of the evidence. For qualitative claims, include supporting documents and their scope.
    2. Map the data flow. Document the path from the original record to the reported result, including extraction, review, transformation, consolidation, and approval. Identify manual processes, conversions, and estimates, maintaining references to the original sources, even when using spreadsheets.
    3. Assign responsibilities. Identify who provides the data, calculates the indicator, and verifies the result. Record all reviews and resolved observations. If one person performs multiple roles, document this and establish additional controls based on risk, such as a second review or reconciliation.
    4. Establish rules for changes and exceptions. Define how to document missing data, corrections, methodological or source changes, and estimates. Record the reason, the method applied, approval, and the effect on the result, when it can be determined.

For reference, the chain can be expressed as follows: original source → extraction → controls and transformations → calculation or consolidation → review → approved value → report. The dictionary and the flow map serve complementary functions: one defines the indicator and the other shows how the data that is ultimately reported was generated.

ESG data controls to protect the quality of information

ESG data controls must address how each indicator is generated. Automated validation may be suitable for structured calculations, while manual recording may require coverage and consistency checks. There is no single check for all metrics; the key is that controls help detect errors, omissions, or unexplained changes.

Integrity and cut-off date

Verify that the dataset corresponds to the reported period and defined scope. When a list of expected sources, units, or records exists, compare it with what was received and identify any missing or late additions. Note how these cases were handled to avoid making a total appear complete when coverage has not been confirmed.

Accuracy and reproducibility

Retain the input data and calculation rule so that the result can be reconstructed. Review, as applicable, units, conversions, duplicates, formulas, rounding, and values outside of expected ranges. If an error is corrected, retain the explanation of the adjustment and prevent the previous version from disappearing without a record.

Reconciliations with the sources

Compare the consolidated result with the records from which it is derived and document any differences. If the indicator also relates to information from another process or system, explain how the bases are reconciled and why variations may exist. Not all ESG indicators have a direct counterpart in financial records; in such cases, the data sheet should describe the source and relevant controls without forcing a reconciliation that is not appropriate.

Consistency between periods

Use consistent definitions and methods when relevant to comparing results. If you change the source, formula, scope, or method of data collection, record the date and reason for the change, along with its effect on the comparison. This allows anyone reviewing the report to distinguish a change in the indicator itself from a change in how it is measured.

Exceptions and estimates

Clearly identify estimated data, gaps, and corrections. Document the basis used, relevant assumptions, the decision-maker, and known limitations. Keeping this information visible facilitates data evaluation and prevents presenting an estimate as if it were a directly observed record.

Revision and versions

Record who reviewed the information, when they did so, and how the observations were resolved. Maintain version control to distinguish between source files, working files, and approved results. Limit modifications to those who need to make them and keep the version linked to the final report data.

Sustainability evidence checklist by indicator

Adequate sustainability evidence varies depending on the indicator, source, and scope of the report. The following matrix provides examples of possible supporting evidence, not a universal list of requirements. It should be adapted to the data actually used and the criteria defined for each review process.

Examples of support and checks by data type

Type of data or statement Possible supports Practical verification
Quantitative data of an operation Source record, reading, invoice or system extract, depending on the source used, along with the period and scope covered. Confirm the unit and period, and that the record can be linked to the consolidated value.
Calculated or consolidated indicator Input data, formula or method, calculation file, transformations, and evidence of review. Verify that the calculation can be reconstructed and that any conversions, exclusions, or missing items are documented.
Data collected manually Capture form or record, definition used, data received, and evidence of review. Verify that the capture criteria were applied consistently and that the information coverage is explained.
Qualitative or managerial statement Policy, procedure, minutes or other document that supports the claim, with its date and version. Confirm that the disclosed text does not exceed what the document demonstrates and that its scope is clear.
External, estimated or corrected data Documentation of the source, method and assumptions of estimation, record of the adjustment and evidence of approval, as applicable. Identify the period and scope, known limitations, and how the data was treated before reporting.

Quick checklist

  • The sheet includes the definition, unit, period, and scope of the indicator.
  • The original source is preserved or located; there is not just a copied figure in the report.
  • The formulas, transformations, and consolidations can be tracked from the input data.
  • The reconciliations carried out and the differences found have an explanation.
  • The estimates, exclusions, and corrections are identified and justified.
  • It records who prepared and reviewed the information, as well as the date and the approved version.
  • The final value of the report is linked to the corresponding support files.
  • Qualitative claims relate to documents that support their content and scope.

How to organize the document archive before the review

An effective record links each result to its supporting documentation. To do this, maintain a master index with the definition, source, period, calculation, responsible party, review status, and value of each indicator.

Organize documents by period and code, identifying source, date, and version. Separate original records, working files, and approved versions, ensuring their location, change control, and secure access.

Record outstanding items, indicating the affected indicator, the issue to be resolved, the responsible party, the status, and evidence of closure. This will allow you to identify corrected errors and remaining limitations.

Before submitting the information, verify that the results match the original sources, that the time periods and scopes are consistent, and that the calculations are reproducible. The assurance conclusion will depend on the scope, criteria, and evidence evaluated. Amézquita offers services in ESG/ASG assurance.

Frequently Asked Questions

What should the traceability sheet of an ESG indicator include?

At a minimum, it is advisable to record its definition, unit or method, period, scope, source, responsible party, calculation rule if applicable, controls, location of supporting documentation, and revised version. If the indicator is qualitative, the form should indicate which documents support the statement and their scope.

Is a source file sufficient as evidence?

It can support the initial data, but it doesn't always explain how the published value was obtained. If there was extraction, conversion, calculation, consolidation, or exclusions, those steps and the relationship between the source file and the result must also be documented.

How are estimated or missing data documented?

Identify the data as estimated or missing and document the methodology, assumptions, source consulted, approval, and known limitations. If a subsequent correction was made, retain the reason for it and its effect on the reported value.

How often should the records be updated?

Update them when preparing each reporting period and whenever the definition, source, system, calculation method, or scope of the indicator changes. The specific frequency may vary depending on the data flow and the criteria applicable to the report and the engagement.

Does traceability guarantee a favorable assurance conclusion?

No. A documented chain of custody facilitates reviewing the origin and processing of data, but it does not guarantee a result. The conclusion depends on the scope and agreed-upon criteria, the available evidence, and the evaluation performed during the process.

This article has been verified by
Humberto González,
Public accountant

Search