Building a CO2 reporting tool on ERP data
A CO2 reporting tool was developed in Microsoft 365, combining ERP data and a separate database into one automated reporting flow. The result supports both EU requirements and internal ESG reporting.
Domain
ESG reporting
Tooling
Microsoft 365
Approach
Build and handover
Johnson Controls operates globally in building management and climate technology, in a context where sustainability reporting requirements are becoming more demanding. At the same time, the data needed for CO2 reporting was spread across different systems, making consistent reporting difficult to organise.
The practical issue was clear. Information from an ERP system and a separate database had to come together in one workable reporting setup, without creating ongoing dependence on external support.
The challenge
There was no automated solution yet for combining CO2 data from both sources and turning it into reports that met EU and internal ESG requirements. What was needed was not just a prototype, but a tool the internal team could actually use and manage itself.
Blackbear's role
Blackbear helped define the scope clearly at the start. Phase one was limited to the CO2 reporting tool itself, while packaging material reporting and broader automation stayed outside scope. That kept the project realistic and focused. From there, the work moved through requirements gathering, data integration, report setup, testing and final handover within one clearly defined delivery block.
Result
Johnson Controls now has a working CO2 reporting tool in Microsoft 365 that automatically combines data from the ERP system and the separate database. Reports can be generated in line with EU and internal ESG requirements, and the internal team can continue working with the tool independently.
