ESG data collection: spreadsheets vs. a system

Almost every ESG program starts in a spreadsheet. It's the fastest way to get moving: a tab per site, a column per month, a formula at the bottom. For a first report, that's often enough. The trouble starts when the numbers have to be defended — when someone asks where a figure came from, and the answer is a workbook nobody fully trusts anymore.

Where the spreadsheet breaks down

The failure isn't the spreadsheet itself — it's what happens as an ESG program grows past one person and one reporting cycle:

• Version sprawl. “Final_v3_updated” lands in three inboxes, and no one is sure which total is the real one.
• Inconsistent factors. Each team keeps its own emission factors, so two people report two different numbers for the same activity.
• Evidence lives elsewhere. The utility bill that justifies a figure sits in an email thread, disconnected from the number it supports.
• No audit trail. When a cell changes, there's no record of who changed it, when, or why.
• Error-prone consolidation. Rolling several entities into one group total by hand is exactly where a decimal slips.

What changes with a system of record

A purpose-built ESG system doesn't just store the same numbers in a nicer grid. It changes what a number is — from a value in a cell to a record with evidence and accountability attached:

• One record per figure, with its source document attached — the bill or receipt travels with the number.
• A central library of emission factors every team calculates against, so results are consistent and comparable.
• Maker/checker approvals: the person who enters a figure isn't the only one who stands behind it, and an approved record locks.
• An immutable audit log — every entry, change and approval is recorded and can't be quietly rewritten.
• Traceability end to end, so any reported figure can be followed back to its source and its approver on demand.

The moment it matters: assurance

The difference is invisible right up until audit season, and then it's the whole game. An assuror doesn't just want the number; they want to see how it was reached. With a spreadsheet, reconstructing that costs days you don't have before the deadline. With a system of record, the chain — source document, factor applied, approver — is already intact and reviewable. The report stops being a scramble and becomes a matter of pressing a button.

When a spreadsheet is still fine

None of this means spreadsheets are the enemy. For a single entity with a handful of indicators and a one-off report, a well-kept spreadsheet is perfectly reasonable. The tipping point is scale and scrutiny: multiple entities, several teams contributing, and a disclosure that carries someone's signature and external assurance behind it. That's the point where the spreadsheet's convenience turns into risk.

Susmatic ESG is built for exactly that transition — collecting ESG data, proving it against its source, and reporting it against the frameworks GCC regulators ask for, without each team maintaining its own version of the truth.