Corporate Carbon Footprint for energy providers: What to watch for in the accounting process

The same exercise every year: For the Corporate Carbon Footprint (CCF), data from half a dozen sources is funneled into an Excel file that has grown over the years. Several colleagues contribute, and in the end, one person struggles to ensure the bottom line is a consistent figure. For many energy suppliers, this is the standard state of annual CCF preparation. And there are good reasons for it.

Because when it comes to accounting, energy suppliers are a special case. They generate energy themselves, distribute it through their grids, and sell it to customers, often in parallel across sectors such as electricity, heat, water, and public transport. This complexity makes the CCF demanding. It captures all of a company's greenhouse gas emissions and follows the internationally established Greenhouse Gas Protocol (GHG Protocol)1, the definitive standard at the corporate level.

Then there is the corporate structure. Under the umbrella of an energy supplier, there are often several companies: a grid operator, a transport company, sometimes a waste management company. Each brings its own data sources, system boundaries, and emission profiles. This makes consolidation more complex, and emissions are easily counted twice or not at all.

Where the data comes from, and why collection is rarely the problem

The data relevant to an energy supplier's CCF comes from several sources:

• own properties and vehicle fleet,
• CHP and cogeneration plants,
• grid losses and grid expansion,
• and – as the largest item – the energy sold.

Much of this is already available. Energy-based data is generated in billing and sales statistics anyway. The real difficulty lies not in obtaining the data, but in the correct classification: When is what accounted for in which scope, and how can double counting be avoided?

Grid losses from electricity illustrate this well. For an ordinary company, they fall under Scope 3 category 3, energy- and fuel-related activities. It is easily overlooked that a different rule applies to an energy supplier with its own grid: Because it must compensate for losses in its own grid through additionally purchased or generated energy, this portion does not belong in Scope 3, but in Scope 2. An energy supplier therefore accounts for the energy used to compensate for these losses differently than a pure electricity consumer. And for self-generated energy, the following also applies: do not account for it twice.

In addition, there is the Selecting emission factors. Determining which factor applies to which stage of a Life Cycle Assessment (LCA) and within which scope category is not just a formality. It is the deciding factor for the reliability of your CCF. This is particularly evident in district heating: emissions occur during production—that is, when fuels are burned—not when the heat is sold. Confusing the two shifts emissions to the wrong place.

Why Excel reaches its limits

In principle, a complete CCF can be built in Excel. It works fine at the start. The problem begins with complexity: the more multifaceted the energy provider and the more companies that need to be consolidated, the more analyses, tabs, and links the file requires. Trying to pack everything into a single workbook quickly becomes prone to errors.

Complexity grows every year. You need to map year-on-year comparisons, develop decarbonization measures, and define climate targets that align with the company's ambitions. Excel can handle this up to a point. Then, the complexity increases to the point where you lose the overview.

The second breakdown lies in the architecture itself. Excel files grow through formulas and cell references that span dozens of tabs and multiple companies. If a row is inserted, a cell is moved, or a tab is renamed, the chain of links breaks—often unnoticed, appearing only as a #REF! error or, worse, as a silent calculation error. Emission factors are also usually hard-coded into formulas rather than managed centrally. If a factor from the GHG Protocol or a national source changes, it must be manually updated everywhere—without any validation logic to detect errors or outdated values.

Even the selection of the factor itself remains a manual task. For Excel files with several thousand line items, this is a major undertaking that repeats year after year. It is also the step with the highest level of uncertainty, as the necessary in-depth expertise is often not available internally. Yet, the quality of the entire CCF depends on this classification.

The third breakdown concerns traceability. Excel has no automatic versioning or change log: it is nearly impossible to reconstruct who changed which value, when, and why. The tool does not provide a central, consistent database into which multiple companies can feed data in a structured way—every file remains an independent copy. This might be manageable for a single CCF report. However, over several years and with growing audit requirements, this becomes the limiting factor.

Why a clean CCF is worth it for energy providers right now

A properly prepared CCF is more than just a compliance exercise—it opens up opportunities. Those who have a handle on their emissions gain advantages in creditworthiness assessments, reporting under CSRD or VSME, ratings such as EcoVadis , as well as funding conditions and tenders. Mastering the CCF means doing more than just meeting these requirements. It means translating them into measurable KPIs and concrete savings, rather than viewing them as a burden. (For those who need to manage several of these frameworks in parallel, an overview can be found in our article on Multi-reporting for CSRD, EcoVadis & CDP.)

The topic is becoming particularly urgent due to the industry's capital requirements. Transforming the energy supply is extremely costly. According to BDEW calculations, over 60 billion euros must be invested in electricity distribution grids alone by 2030. A survey by VKU and PwC of 162 municipal companies estimates their investment needs at around 22.7 billion euros over ten years. On average, only about 30 percent of this can be covered by internal funds. The rest must be financed. This puts lending in the spotlight. Here, the EBA guidelines (EBA/GL/2020/06) from the European Banking Authority require banks to incorporate ESG and climate factors into creditworthiness assessments. In practice, banks are therefore increasingly asking for reliable climate data: emissions, climate targets, and transformation plans.

A CCF helps improve your financing options. A compelling climate profile strengthens your negotiating position and, especially with large credit volumes, can lead to better terms. There is no guaranteed, standardized "climate discount." The extent of the effect depends on the institution, the risk profile, and the individual case. A reliable CCF therefore pays off in real terms.

The path to a single source of truth

This is exactly where switching from spreadsheets to a dedicated system pays off. Software not only makes the CCF less prone to errors, but it also creates a shared data foundation—a single source of truth with clearly defined roles, a clean representation of complex corporate structures, a transparent history, and version control. Automation and AI-supported workflows significantly reduce manual effort, not least by automatically assigning the appropriate emission factors. This saves a massive amount of time, especially when dealing with purchased goods and services, while improving data quality and making the CCF audit-proof.

Furthermore, there are tasks that Excel can technically handle, but only with significantly more effort and less intuition: meaningful visualizations, the direct linking of the CCF to climate goals and initiatives, and the identification of hotspots. Solutions like those from Tanso address these needs. They automate recurring calculation steps and consolidate the diverse data of an energy provider into one central location. The focus shifts away from manual data collection toward the actual goal: understanding, managing, and reducing emissions.

However, even the best tool is of little use without the right expertise. Whether you use Excel or specialized software is secondary—what matters is the expertise to confidently apply the GHG Protocol or comparable standards like ISO 14064. This is the only way to create a CCF that is pragmatic, efficient, and consistently high-quality year after year, ensuring it is audit-compliant and reliable. Tools and expertise go hand in hand. This is exactly where Climate Connection comes in. Through a series of workshops and on-the-job coaching, we guide you from understanding the system, scope methodology, and GHG Protocol requirements all the way to independently creating your first Corporate Carbon Footprints and developing climate goals, reduction measures, and reporting. The result is a team that has mastered the CCF and knows how to use the software effectively.