Why ESG Spreadsheets Fail Internal Audit (And How Ledgers Fix the Maker/Checker Gap)

An internal audit perspective on why Excel cannot support non-financial assurance, how broken formulas create restatement risk, and how controlled ledgers establish defensibility.

The Five Questions That Break Spreadsheets

When internal audit teams evaluate sustainability spreadsheets ahead of annual external review, confidence breaks down rapidly under forensic scrutiny:

Spreadsheet Vulnerabilities in ESG Accounting

Spreadsheet Risk	Audit Failure Mode	Origin Ledger Solution
No Segregation of Duties	Single user can edit formulas and numbers undetected	Strict Maker/Checker role enforcement
Missing Source Documents	Files scattered across email threads and shared drives	Direct primary evidence attachment to each line item
Overwriting History	Prior month corrections destroy historical baseline	Immutable append-only audit trail with versioning
Formula Mutation	Unit conversion errors go unnoticed	Standardized, automated conversion engines