Sustainability reporting spreadsheets are without doubt a sensible starting point. They allow organisations to assemble an initial carbon inventory without committing to a new system. As technology evolves rapidly, it’s worth considering whether your current strategy still matches the scale and risk of the reporting process.
As datasets expand, familiar files can become difficult to govern. For example, several people may hold different versions, and evidence may be organised into separate folders. The reporting team then spends more time reconciling information than interpreting performance.
These five signs can help organisations decide whether better sustainability spreadsheet management is sufficient or whether it is time to consider environmental data software.
1. Nobody is certain which version is current
Version confusion is one of the clearest spreadsheet reporting problems. Copies may be exchanged by email, saved to personal folders or adapted by different sites. A file name containing “final” does not demonstrate that every contributor used the same assumptions.
This becomes particularly important when a reported figure is challenged because the team needs to identify the approved dataset, the underlying activity record and the calculation method used at that point in time. If that reconstruction depends on one colleague's memory, the process is fragile.
A controlled shared drive and naming convention can improve a small process. Where many contributors and reporting periods are involved, a platform with defined records, permissions and change history may provide more dependable control.
2. Supporting evidence has become separated from the data
An emissions value is more useful when its source can be found. That source might be a utility invoice, meter record, fuel statement, travel export or supplier response. If evidence is stored elsewhere without a consistent reference, review becomes slower and gaps are easier to miss.
Spreadsheets can contain links to evidence, but those links may break when folders are moved or access changes. They may also fail to show whether a document has been reviewed or which value was taken from it.
Structured software can connect the activity record, evidence and resulting calculation. This does not prove that the source is correct, but it gives reviewers a clearer trail to follow.
3. Reporting depends on repeated manual requests
Many organisations begin each reporting cycle by sending the same templates to the same departments and sites. The central team then checks formats, corrects units and follows up on blank cells. These tasks can consume a significant proportion of the reporting timetable.
Before replacing sustainability spreadsheets, organisations should examine why requests are delayed. The problem may be unclear responsibility or poor instructions rather than the file itself. Assigning named owners, deadlines and definitions can improve performance in any system.
However, where the process is recurring, workflow visibility can help. Contributors can see what they need to provide, while the central team can see what is complete, outstanding or awaiting review.
4. The calculation no longer scales across sites or categories
An initial inventory might contain a small number of Scope 1 and Scope 2 records. Adding business travel, purchased goods, logistics, waste and other Scope 3 categories can multiply both the number of rows and the range of calculation methods.
Multi-site organisations face another layer of complexity. They need consistent reporting periods, organisational boundaries, units and emission factors while retaining the ability to understand local performance. Manual consolidation can conceal omissions or double counting making carbon reporting and compliance preparation more difficult as the organisation grows.
The GHG Protocol emphasises relevance, completeness, consistency, transparency and accuracy. A spreadsheet can follow these principles, but the controls required become more demanding as the inventory grows.
5. The team cannot explain changes efficiently
Year-on-year changes do not always reflect operational progress. They may arise from updated conversion factors, improved data, organisational changes or a revised calculation method. A credible explanation requires the team to distinguish these causes.
The UK Government publishes updated greenhouse gas conversion factors annually and explains significant changes. Organisations should preserve the factor year and source used in each inventory rather than silently overwriting old calculations.
If the team cannot readily tell whether a movement came from activity or methodology, its sustainability reporting spreadsheets may not provide enough traceability.
What should you do before moving to software?
Software will not automatically repair an undefined process. Before migration, organisations should:
-
Confirm the reporting boundary and objectives
-
Identify each data source and owner
-
Review units, periods and calculation methods
-
Separate source data from calculated outputs
-
Catalogue supporting evidence
-
Decide what historical information needs to be imported
-
Test exports, access controls and change records
A pilot using one reporting period or site can expose implementation issues without disrupting the full process. It also gives users an opportunity to test whether bulk uploads work with the files they already maintain.
How should historical data be handled?
Moving every historic workbook is not always necessary. Decide which years are required for comparison, targets, reporting obligations or assurance, then preserve the approved original files alongside the migrated records.
Reconcile opening totals before relying on a new platform. Differences may arise from rounding, unit conversion, factor mapping or duplicated rows. Document each agreed adjustment rather than forcing the new system to match an unexplained legacy total. This creates a credible starting point and prevents migration from obscuring earlier methodology.
Retain a migration record showing what was imported, excluded or transformed. Ask data owners to review material balances after migration and before the new system becomes the operational source. This gives the organisation a controlled handover rather than an abrupt switch between two unexplained datasets.
The Bottom Line
Sustainability reporting spreadsheets remain appropriate for some organisations, particularly where the inventory is limited, ownership is laid out and external auditing is low. Moving to software should be a proportionate decision, not an assumption that newer technology is always better.
The warning signs are operational, for example, you may experience conflicting versions, disconnected evidence, repeated chasing, difficult consolidation and unexplained changes. When these problems become routine, structured software can reduce manual effort and create a clearer reporting process.
Tunley Environmental supports organisations in assessing their current carbon and sustainability data processes. VerdaMetric is designed to help teams organise existing information, maintain traceable records and make recurring environmental management easier to control.
Sources
GHG Protocol, Corporate Standard: https://ghgprotocol.org/corporate-standard
UK Government, Greenhouse gas reporting conversion factors 2026: https://www.gov.uk/government/publications/greenhouse-gas-reporting-conversion-factors-2026
ACCA, Sustainability reporting: the guide to preparation: https://www.accaglobal.com/gb/en/professional-insights/global-profession/sustainability-reporting/guide-to-preparation.html