ESG Reporting: Why Spreadsheets Create Audit Gridlock

Executive Summary

---

When the spreadsheet approach stops working

I've seen this happen at quite a few businesses that are growing and trying to do the right thing. You likely started with good intentions, tracking energy use, travel emissions, and supplier details in a few spreadsheets. For a time, that was probably fine. It was enough to put together an annual impact report and show you were making progress.

Then things tend to get more serious. The board might ask for quarterly ESG updates. Investors start their due diligence and want to see auditable data. Regulators begin to shift from voluntary frameworks to required disclosures. All of a sudden, that collection of spreadsheets feels less like an asset and more like a liability.

You've reached a common sticking point. The tools that helped you get started are now what's holding you back. This isn't a reflection on your team; it's what happens when a system not built for this level of scrutiny is put under pressure.

Why manual data processes are difficult to audit

To be direct, the current process is often not just inefficient, it's very difficult to defend under scrutiny. You may have a modern data warehouse, like Snowflake, and a good engineering team. But without changing the underlying process, you might just be moving a messy system from one place to another, only faster. Automating a flawed process tends to produce flawed data, just more quickly.

From my experience, an auditor can find the weaknesses in a report built on Excel very quickly. They'll pick a number in your carbon report and ask for its source. The question is, can you trace it from the final report, back through all the calculations, to the original PDF invoice from your energy supplier, and show that no manual changes were made along the way? If you can't, you'll have a problem with the audit.

The main issues I see are usually:

No clear version control: Which is the definitive 'Master Emissions Sheet'? The one on SharePoint, or the copy on someone's desktop?

No audit trail: When a number is changed, there's often no record of who changed it, why, or when. It's a black box, which can make people uneasy.

Human error: Mistakes from copying and pasting, errors in formulas, or inconsistent units (like kWh versus MWh) are not just possible, they're pretty much inevitable when you're dealing with a lot of data.

Scattered data: The information is there, but it's often stuck in unstructured formats. This isn't really a reporting problem, it's an issue with Data Integration.

I worked with a company recently where a key emissions tracking process was run from a single 'Master Google Sheet'. We didn't just ban the sheet, as that would have slowed things down. Instead, we built a reliable pipeline to bring that data into a governed system where it could be properly managed and audited.

A three-step approach to building an auditable system

Getting this right isn't usually about buying a new, expensive ESG software platform. That can be like building a new roof when the foundations are shaky. The problem isn't the final report, it's the process that creates it. The fix, in my view, is to treat your data with the same rigour you'd apply to a production line.

So we don't just patch the report, we look at the whole process. This usually involves a practical, three-step approach.

Design and build: First, we get a handle on the current situation. We look at every source of ESG data, from PDF invoices to supplier websites. Then we design a central data model to hold all this information in one place. The aim is to build one set of dashboards for the sustainability team, so they don't have to keep asking for custom reports.

Govern and document: This is probably the most important step. We put a sensible Data Governance framework in place. This isn't about writing a hundred-page document that no one reads, it's about light-touch rules, often built into the code. We define every metric, like 'Scope 2 Emissions', in a central place. This means that when anyone in the business asks for that number, they get the same figure, calculated in the same way, every time. It's this consistency that helps with Audit Anxiety, because it makes your numbers much easier to defend.

Train and enable the team: Finally, we create a self-service area with documentation and training. This allows the sustainability team to explore the data and answer their own questions within the new, governed system. It usually means they rely less on the central data team for day-to-day queries.

The challenge is often organisational, not technical

It's worth being honest: putting a single source of truth in place for ESG data can be difficult. It might mean telling the Head of Operations that their team's spreadsheet is no longer the official record. It could mean asking the Finance department to line up their energy cost reports with the sustainability team's consumption data. You should probably expect a bit of resistance.

What I've found is that you often have to accept moving a bit more slowly for a quarter to build a system that will let you move faster and more reliably for years to come. The goal is to change the Head of Sustainability's job from being a 'data janitor', always chasing and cleaning numbers, to being a strategic leader who can use reliable data to make a real difference.