Verifiable sustainability data: why Excel lets you down with auditors (and customers)
A spreadsheet with plausible numbers is often enough to write a report. It is rarely enough to withstand an audit. The difference…
strait
Date
Category
Insights
Reading time
4 min
A table with plausible numbers is often enough to write a report. It is rarely enough to withstand an audit. The difference between "reported" and "auditable" is precisely where many SME reports fail in practice.
What "auditable" means in practice
Auditable data is not just correct data – it is data whose origin is traceable. An auditor or buyer does not just want to see the number, but also where it comes from: Which meter, which period, which calculation method. An Excel cell with "12,400 kWh" without proof of origin is an assertion, not proof.
Where Excel spreadsheets typically fail
No version history. Was the number corrected after the fact? Excel usually does not show it.
Manual transcription errors. Copy-paste errors between worksheets are one of the most common reasons for inconsistencies during audits.
Lack of source traceability. Where does the value come from – meter reading, estimate, invoice? Without clear documentation, it is often impossible to reconstruct this after the fact.
Outdated values. Data collected annually is often already months old at the time of the audit.
Why this is more than a compliance detail
Auditability does not only affect formal audits. A major customer reading your EcoVadis assessment or your supplier questionnaire also implicitly evaluates how robust your information appears. Unsupported rounded values ("approx. 10% less than last year") raise more suspicion than a traceable, even if incomplete, data situation.
Three levels of documentation quality
Level | Characteristic | How an auditor reacts |
|---|---|---|
Unproven assertion | Number without recognizable source | Inquiry, in the worst case loss of trust |
Plausible estimate, labeled | Clearly marked as an estimate, method explained | Usually accepted, noted as potential for improvement if necessary |
Auditable measurement | Origin, time, method documented | Robust, lowest inquiry rate |
The leap from Level 1 to Level 2 often only costs an honest labeling – no additional collection effort. The leap from Level 2 to Level 3, on the other hand, requires a structural change in data collection, usually towards automation.
What auditable documentation should contain in practice
Source: Meter, invoice, estimation method – clearly named
Period: Exact collection period, not just "last year"
Calculation path: Traceable formula or conversion, no black box
Responsible person: Who recorded or approved the value?
Version history: Was the value corrected after the fact – and why?
A simple internal documentation process
Auditability does not result from a one-time effort, but from an ongoing process. Three elements are enough to get started:
A fixed, responsible person for data maintenance – even in small businesses it should be clear who can provide information in case of doubt.
A unified storage location for evidence (invoices, meter logs, certificates), instead of scattered files on different computers.
A short note for every correction – why was a value changed after the fact? This alone prevents most inquiries during a later audit.
Why manual processes fail in the long run
Even a well-intentioned manual process often only works as long as the responsible person actively thinks about it. Staff turnover, vacation times, or simply time pressure in daily business regularly lead to a decline in documentation discipline in practice – usually unnoticed until an audit or a critical customer inquiry makes the gaps visible. Automated collection is therefore not only more convenient, but structurally more robust against precisely this type of creeping quality loss.
A typical scenario
A business reports electricity consumption of 240,000 kWh for the year in its report. When asked by an auditor or EcoVadis analyst how this value is composed, it turns out: The number comes from an estimate based on the previous year's value, adjusted by a flat surcharge – not from actual meter readings. The value may even be realistic. The problem is not the number itself, but that it cannot be proven. Exactly this leads in practice to inquiries, delays, or a worse rating, even though the actual performance of the business would have been unremarkable.
The pragmatic way out: Capture data at the source
The most reliable way to achieve auditability is not better spreadsheet maintenance, but data that does not have to be manually transferred in the first place. When consumption data is captured directly at the source – meter, sensor, system – and automatically documented, the most error-prone step is completely eliminated: manual transcription.
How strait establishes auditability
strait records energy and operational data directly via IoT sensors, with seamless documentation of source, time, and calculation path. The result is a database that does not just look plausible, but can be traced back to the original measurement in case of doubt – during an audit, an EcoVadis inquiry, or a critical customer meeting.
How robust is your current data situation? Book a demo and we will show you how auditable data differs in practice from Excel estimates.
See what auditable data looks like in practice
[→ Book a demo]
Blog and articles
