> ## Content Index
> Fetch the complete content index at: https://www.greeninsider.org/llms.txt
> Use this file to discover other available public pages before exploring further.

# Scope 1 and 2 for a single-site company fit in one spreadsheet
- URL: https://www.greeninsider.org/scope-1-2-spreadsheet-small-company/
- Published: 2026-11-16T13:47:01.000Z
- Updated: 2026-11-21T00:09:37.000Z
- Description: How a single-site company can calculate Scope 1 and 2 in a spreadsheet: what to include, a five-tab layout, a worked example and where the factors come from.
- Author: Veljko Plavšić
- Tags: ESG & Reporting, Fundamentals

**Short answer.** Collect twelve months of electricity, gas, fuel and refrigerant data, multiply each by a dated emission factor from a named source, and report Scope 1 and location-based Scope 2 separately. Write down the reporting period, the boundary and every factor's source before you calculate. A single-site company needs no software for this, only a spreadsheet someone owns and a method another person could repeat next year.

*Checked on 16 November 2026\. Sources and unresolved points are in the method note at the end.*

The first emissions figure a small company produces is usually requested by someone else, with a deadline. That is exactly when shortcuts get taken that make the number impossible to defend a year later.

## Key takeaways

- **Scope 1 is what you burn or leak.** Gas, fuel and refrigerants on site.
- **Scope 2 is energy you buy.** Mainly electricity, plus any purchased heat.
- **Every factor needs a source and year.** Otherwise nobody can check the result.
- **Refrigerants are the forgotten line.** Small leaks carry large warming potentials.
- **Report location-based Scope 2 first.** Most SME requests ask for it.

---

## What goes into Scope 1 and Scope 2?

Scope 1 covers direct emissions from sources you own or control. For a typical single-site company that means natural gas or heating oil burned for heat, fuel used in company vehicles, and refrigerant gas lost from air conditioning or cooling equipment.

Scope 2 covers indirect emissions from energy you buy and use, which for most small companies is grid electricity and sometimes district heat. Under the GHG Protocol, European companies report Scope 2 twice, on a location-based and a market-based method.

The voluntary SME standard, now EU law, asks in its basic module for energy use in MWh, Scope 1 and location-based Scope 2\. That makes these two scopes the core of almost every request you will receive, as set out in our guide to the [VSME basic module](https://www.greeninsider.org/vsme-basic-module-data-checklist/).

---

## What should you decide before calculating anything?

Four things, written on the first tab of the file. Skipping them is the main reason a second-year figure cannot be compared with the first.

1. **Reporting period.** Calendar year or financial year, matched to your accounts where possible.
2. **Boundary.** Operational control is the usual choice for small companies, meaning you include what you run day to day.
3. **Factor sources.** One named source per factor, with its publication year, kept the same unless you note a change.
4. **Global warming potentials.** Which IPCC assessment report you use for refrigerants, since values differ between them.

---

## How should the spreadsheet be laid out?

Five tabs are enough, and keeping inputs separate from calculations is what makes the file auditable. Anyone opening it should be able to trace a total back to an invoice without asking you.

| Tab                    | What goes in it                                                                               | Source documents                              | Typical owner                |
| ---------------------- | --------------------------------------------------------------------------------------------- | --------------------------------------------- | ---------------------------- |
| Settings               | Period, boundary, method, GWP source, preparer, date                                          | Your decisions, written once                  | Whoever signs off the figure |
| Activity data          | Monthly kWh of electricity and gas, litres of fuel, kg of refrigerant added                   | Utility invoices, fuel cards, service records | Finance or office management |
| Factors                | Each factor with unit, source, publication year and the date you copied it                    | Official national or government factor sets   | Preparer                     |
| Calculations           | Activity multiplied by factor, by line, with formulas visible                                 | The two tabs above, never typed numbers       | Preparer                     |
| Summary and change log | Scope 1, Scope 2 location-based and market-based, intensity, and every change since last year | Calculations tab                              | Whoever signs off the figure |

A five-tab structure for a single-site Scope 1 and 2 inventory. Green Insider, November 2026.

The rule that matters most is in the calculations row. No number is typed there, so a corrected invoice or a new factor flows through automatically and leaves a trace.

---

## What does a worked example look like?

Here is a single site with an office and a small workshop, using illustrative factors. Replace every factor with the current value from your chosen source before using any of this.

| Source                     | Scope              | Annual activity | Illustrative factor | Emissions, tCO2e |
| -------------------------- | ------------------ | --------------- | ------------------- | ---------------- |
| Natural gas for heating    | 1                  | 80,000 kWh      | 0.18 kg per kWh     | 14.4             |
| Diesel in two company vans | 1                  | 6,000 litres    | 2.5 kg per litre    | 15.0             |
| Refrigerant R-410A top-up  | 1                  | 2 kg            | GWP 2,088           | 4.2              |
| Grid electricity           | 2 (location-based) | 120,000 kWh     | 0.30 kg per kWh     | 36.0             |
| **Total**                  |                    |                 |                     | **69.6**         |

Worked example for a single site. Factors are illustrative placeholders; the R-410A value is the IPCC Fourth Assessment Report GWP. Green Insider, November 2026.

Scope 1 comes to 33.6 tonnes and location-based Scope 2 to 36.0 tonnes. With turnover of 4 million euro, the intensity is about 17.4 tonnes per million euro, which is the ratio many questionnaires ask for alongside the totals.

Look at the refrigerant line. Two kilograms of gas, a routine service top-up, adds more than four tonnes, which is why leaving it out is the most common error in first inventories.

---

## Where do the factors come from?

From an official, dated factor set, used consistently. The UK government's conversion factors are a common choice even outside the UK for fuels, and the 2026 set was published in June 2026; it cut the UK electricity factor by around 26 percent, a reminder that factors change from year to year.

For electricity, use the location-based factor for the country where your site sits, from your national authority or another recognised source. For the market-based figure, use the residual mix: the Association of Issuing Bodies published the 2025 European residual mixes on 28 May 2026, averaging 435 grams of CO2 per kWh.

A green tariff changes only the market-based number, and only when certificates are cancelled for your consumption. Our [green tariff piece](https://www.greeninsider.org/green-tariff-rego-scope-2-market-based/) explains what evidence you need before reporting zero.

---

## When does a spreadsheet stop being enough?

When the structure above no longer fits on five tabs. That usually happens with several legal entities or sites, recurring Scope 3 requests that need supplier-level data, or an external assurance engagement where an auditor must trace every figure.

Until then, a spreadsheet built this way is not a compromise. It is the same logic any software applies, made visible, and the cost of software is rarely justified by one site and two scopes.

Once you have the total, our guide to [Scope 3 questions](https://www.greeninsider.org/supplier-questionnaire-scope-3-questions/) shows how to allocate it to one customer.

---

## Method note

Scope definitions, dual Scope 2 reporting and the operational control approach follow the GHG Protocol Corporate Standard and Scope 2 Guidance. The basic module requirement for energy use, Scope 1 and location-based Scope 2 follows Delegated Regulation (EU) 2026/1560.

The publication of the UK 2026 conversion factors and the 26 percent change in the electricity factor reflect reporting on the June 2026 release. The residual mix date and average are taken from the Association of Issuing Bodies' 2025 residual mix publication. The R-410A value is the IPCC Fourth Assessment Report figure; later reports give different values, so state which you use.

The worked example uses illustrative factors chosen to show the arithmetic, not official values. All sources read on 16 November 2026\. This article is not legal or financial advice.

---

## What to do this week

1. Write the period, boundary, factor sources and GWP report on a Settings tab.
2. Collect twelve months of electricity and gas invoices and fuel card statements.
3. Ask your cooling or air conditioning contractor for refrigerant top-ups by gas type.
4. Copy current factors into a Factors tab with source, year and date copied.
5. Build the calculations with formulas only, then report Scope 1 and both Scope 2 figures.

---

## Frequently asked questions

### Do I need software to calculate Scope 1 and 2?

Not for one site. A spreadsheet with documented inputs, factors and formulas is enough until you have several entities, Scope 3 requests or an assurance requirement, and the [real software cost](https://www.greeninsider.org/carbon-accounting-software-true-cost/) is rarely just the licence.

### Which emission factors should I use?

A recognised, dated source for each factor, used consistently year to year. Record the source, unit and publication year next to every value.

### Are refrigerants really part of Scope 1?

Yes. Refrigerant gas lost from equipment you control is a direct emission, and its global warming potential makes even small leaks significant.

### Which Scope 2 figure should I report?

Both, labelled. Location-based is the one the voluntary SME standard asks for; market-based reflects any certificates cancelled for your consumption.

### How do I handle gas bills in cubic metres?

Convert them to kWh using the calorific value on the bill, and make sure the factor you apply matches that basis, since gross and net calorific values give different results.

---

*Green Insider is independent. No vendor, provider or consultancy paid for a mention in this article, and none was given advance sight of it.*