A reporting platform that made sustainability data usable
Consolidating emissions data from fourteen sites into a single reporting tool that finance and operations both trust.
The challenge
Verdant had emissions data spread across fourteen sites, three spreadsheet templates and a legacy database nobody wanted to touch. Producing a quarterly report took two people the better part of a fortnight, and by the time it was finished the numbers were already out of date. Worse, finance and operations kept arriving at different totals from the same source data, which meant every board meeting started with an argument about whose figures were right.
Our approach
Start with the disagreement, not the dashboard
Before designing anything we sat with both teams and traced a single quarter’s numbers end to end. The discrepancy turned out to be a definitional one — operations counted a site from the day it opened, finance from the day it was acquired. No amount of visualisation would have fixed that. We wrote the definitions down, got both teams to sign off, and only then started building.
One ingestion path, many formats
Rather than force fourteen sites onto a new process overnight, we built an ingestion layer that accepted the spreadsheets they already produced, validated them on upload, and told the submitter exactly what was wrong in plain language. Adoption was near-total within a month because nobody had to change how they worked on day one.
Reports as a product, not an export
The quarterly report became a living view rather than a generated PDF. Filters persist in the URL, every figure links back to its source rows, and the board pack exports from the same data everyone else is looking at.
The outcome
Reporting time dropped from roughly two weeks to under a day, and the reconciliation meetings stopped entirely. The definitional work turned out to matter more than the software — but the software is what kept the definitions honest.
“The part we did not expect was how much of the work was getting our own teams to agree on definitions. They pushed us on that early and it saved the project.”
More work
View all case studiesRebuilding a retail storefront without losing a season
Migrating a decade-old storefront to a modern stack, incrementally, through the busiest trading quarter of the year.
Read case studyA booking experience patients could finish on the first try
Redesigning an appointment flow where two thirds of patients were abandoning before confirmation.
Read case studyLet’s Build Something Together
