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.
- 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.
- 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.
- 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.
- 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.
- 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.