# Refrigerant Leak Rate and Repair Log Worksheet

> Source: https://netray.co/tools/refrigerant-leak-rate-and-repair-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Calculate each appliance's annual leak rate from charge and top-up amounts, and the CO2e of refrigerant lost for your emissions inventory.

## Category

ehs-workforce

## Industry

Manufacturing

## Audience

- EHS manager
- Facilities manager
- Sustainability lead

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Appliance

**Key:** unit

**Type:** text

#### Refrigerant

**Key:** refrigerant

**Type:** select

**Options:**

- R-410A
- R-134a
- R-404A
- R-407C
- R-32
- R-22

#### Full charge (kg)

**Key:** charge

**Type:** number

#### Added in year (kg)

**Key:** added

**Type:** number

#### Annual leak rate (%)

**Key:** leakpct

**Type:** number

**Expr:** added / charge * 100

**Format:** percent

#### GWP (100 yr, AR4)

**Key:** gwp

**Type:** number

**Help:** R-410A 2088, R-134a 1430, R-404A 3922, R-407C 1774, R-32 675, R-22 1810

#### Lost CO2e (t)

**Key:** co2e

**Type:** number

**Expr:** added * gwp / 1000

**Format:** decimal

#### Repair done

**Key:** repair

**Type:** date

#### Technician

**Key:** tech

**Type:** text

**Rows:**

**Unit:** Roof chiller 1

**Refrigerant:** R-410A

**Charge:** 38

**Added:** 4.5

**Gwp:** 2088

**Repair:** 2026-06-12

**Tech:** CoolServ

**Unit:** Cleanroom AHU

**Refrigerant:** R-407C

**Charge:** 22

**Added:** 1.2

**Gwp:** 1774

**Repair:** 2026-04-03

**Tech:** CoolServ

**Unit:** Cold store rack

**Refrigerant:** R-404A

**Charge:** 65

**Added:** 12

**Gwp:** 3922

**Repair:** 2026-08-21

**Tech:** FreezeTech

**Unit:** Server room split

**Refrigerant:** R-32

**Charge:** 3.2

**Added:** 0

**Gwp:** 675

**Unit:** Old office split

**Refrigerant:** R-22

**Charge:** 6

**Added:** 0.9

**Gwp:** 1810

**Repair:** 2026-09-02

**Tech:** FreezeTech

**Totals:**

#### Total refrigerant added (kg)

**Key:** added

**Agg:** sum

**Format:** decimal

#### Total lost CO2e (t)

**Key:** co2e

**Agg:** sum

**Format:** decimal

#### Highest leak rate

**Key:** leakpct

**Agg:** max

**Format:** percent

**Notes:** GWP values shown are IPCC AR4 100 year figures, widely used in inventories. Use the AR set your reporting scheme requires. Leak rate thresholds that trigger repair vary by regulation and appliance type, so check your local rule.

## Content

**Intro:** Refrigerant top-ups are one of the most overlooked sources of scope 1 emissions, and some regulations require leak checks and repair records. This worksheet turns service records into a leak rate and tonnes of CO2e per appliance.

**Sections:**

#### How to use the worksheet

**Body:** List each appliance with its refrigerant type and nameplate charge. After each year, or after each service visit, enter the kilograms of refrigerant added. The annual leak rate divides the amount added by the full charge. The CO2e column multiplies kilograms added by the global warming potential and divides by 1,000 to give tonnes. Record the repair date and the technician so you can show follow-up on any leak.

**Bullets:**

- Use the mass added to restore full charge, not the mass bought
- Count recovered refrigerant separately
- Keep technician certificates on file
- Track appliances with no top-ups too, as they show good control

#### The method

**Body:** The simplest approach in the GHG Protocol is a mass balance: refrigerant purchased or added, minus returned or recovered, adjusted for inventory change. Where only service top-up is known, it is treated as the loss for the year. Multiply the mass of each gas by its GWP to get CO2e. Fugitive refrigerant is reported under scope 1.

#### Reading the results

**Body:** Rank appliances by leak rate and by CO2e. A small unit with a high percentage may be cheap to fix, while a large rack with a modest percentage can dominate the emissions. Older gases such as R-22 and R-404A have high GWP or phase-out status, so replacement planning belongs in your capital review.

#### Common mistakes

**Body:** Mixing refrigerant blends with single components, using a GWP from the wrong assessment report, and ignoring appliances that were topped up by a contractor without a record. Ask contractors for a service report each visit.

**Cta:** If maintenance work orders in your ERP already record refrigerant top-ups, we can help extract them for scope 1 reporting.

**Faq:**

#### Is refrigerant a scope 1 emission?

**Answer:** Yes. Leakage from owned or controlled cooling equipment is a fugitive emission and belongs in scope 1 under the GHG Protocol. Equipment you do not control, such as a landlord's chiller, may be scope 3 or excluded, depending on your boundary.

#### Which GWP values should I use?

**Answer:** Use the values required by your reporting framework. Many programmes still use IPCC AR4 or AR5 values, while others have moved to AR6. State the source in your report and keep the same set from year to year for comparability.

#### How do I handle blends like R-410A?

**Answer:** Use the published GWP for the blend, which is already weighted for its components. For example, R-410A is a blend of R-32 and R-125. Do not add the two components again.

#### Do I need to repair every leak?

**Answer:** That depends on local rules. Many regulations set leak rate thresholds that trigger repair and re-test for larger systems, and some require leak detection. Check your jurisdiction, and keep a record of each repair attempt either way.

## Search terms

refrigerant leak rate calculator excel, refrigerant leak log template, refrigerant repair log, refrigerant top up CO2e, HVAC refrigerant tracking spreadsheet, fugitive emissions refrigerant worksheet, refrigerant GWP table

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json