Excel workbook previewGHG Protocol carbon accounting
Scope 2 Emissions Calculator (Location-Based and Market-Based)
3 free downloads per account. Just your email and a 6-digit code.
About this template
Scope 2 covers emissions from the electricity, steam, heat and cooling an organisation purchases. Since the GHG Protocol Scope 2 Guidance, companies operating in markets with certificates and green tariffs report two figures: location-based, using the grid average, and market-based, using what they contracted for. Finance teams often hold the evidence, such as certificate invoices and supplier disclosures, and are asked to produce both numbers.
This calculator builds both results site by site. Location-based factors come from the EPA GHG Emission Factors Hub 2025 (eGRID2023), the UK DESNZ 2025 factors and the AIB 2025 production mix for the Netherlands. Market-based results count only instruments that pass all eight Scope 2 Quality Criteria, with Green-e residual mix rates for uncovered US consumption. The summary then writes the disclosure lines for both methods from the numbers.
Who it is for
The controller asked to report electricity emissions both ways, with renewable certificates and green tariffs that someone bought but nobody documented.
What is inside
- Sites sheet with 8 worked sites in the US, UK and Netherlands plus 16 blank rows
- Location-based and market-based results and the difference per site
- Instruments sheet for RECs, REGOs, GO certificates, PPAs and tariffs, 4 worked and 12 blank rows
- Quality Criteria sheet testing all 8 Scope 2 Quality Criteria, with one failing example
- 15 factors: 7 eGRID2023 rates, DESNZ 2025, AIB 2025, EPA steam and 4 Green-e residual mix rates
- Summary with share of electricity covered, failing instruments count and disclosure lines
- Disclosure sentences that update from the numbers
How to use it
Enter each site's annual kWh on the Sites sheet and pick its grid factor ID.
Files
- XLSXscope-2-emissions-calculator.xlsx22 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
Can I use renewable energy certificates from another country?
Not in the market-based result. One Scope 2 Quality Criterion is that the instrument comes from the same market as the consumption it is applied to. Certificates bought in one grid market and applied to consumption in another fail that test, so the consumption falls back to the supplier rate or the residual mix.
What is a residual mix and when do I use it?
A residual mix is the grid emission rate after the renewable and low-carbon attributes claimed by others have been removed. It is used in the market-based method for electricity not covered by your own certificates, contracts or a disclosed supplier rate. Without it, renewable claims would be double counted.
Should eGRID non-baseload rates be used for Scope 2?
No. The EPA notes that total output emission rates are the default for inventories and carbon footprints. Non-baseload rates estimate the effect of changing electricity use on the grid and are not meant for an inventory. Grid loss percentages also stay out of Scope 2 and belong in Scope 3 category 3.




