Refrigerant Log: Record Leak Checks and Top-Ups on Every HVAC Job With AI

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Refrigerant Log: Record Leak Checks and Top-Ups on Every HVAC Job With AI.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Refrigerant Log: Record Leak Checks and Top-Ups on Every HVAC Job With AI.

A refrigerant log should record, for each job, the equipment ID and location, refrigerant type and nameplate charge, leak check method and result, any repair and verification test, the refrigerant added or recovered (weighed), and the technician's name, certification number and signature. Technicians can dictate these as a voice note; AI structures it and the technician checks and signs.

Which of those fields the rules require depends on the equipment size, the refrigerant and where you work, and the AI cannot decide that for you. What it can do is turn a rambling dictation into labelled fields, flag the gaps and catch the arithmetic that gets skipped at 4 p.m. on a hot day. Settle coverage first. The Environmental Protection Agency's (EPA) leak repair rule for hydrofluorocarbon (HFC) refrigerants starts at a full charge of 15 lb and leaves out residential and light commercial air conditioning and heat pumps, so an 85 lb cold room in a convenience store is covered while a split system in a house is not.

Follow me on Instagram@sagnikteaches

What the rules ask you to keep, checked at the source

Three sets of rules come up most often: the EPA's Section 608 rules for ozone-depleting refrigerants, its newer leak repair rules for HFC refrigerants, and the EU F-gas Regulation. Read this as a map of where to look, drawn from the rule text as of late October 2026, not as legal advice. Thresholds, exemptions and dates change, and whether a particular unit is covered depends on its type and charge.

Connect on LinkedInSagnik Bhattacharya
RuleApplies toRecords it asks forRetention
EPA Section 608 (ozone-depleting refrigerants)Appliances holding 50 lb or more of an ozone-depleting refrigerant such as R-22Much the same per-service record as the HFC rule below: appliance, date, parts, type of work, who did it, refrigerant type and amount added, full charge and leak rate. Whoever services the unit gives the owner a record of the work, and technicians hand over their leak inspection and verification test records.At least 3 years, and full-charge records until 3 years after the appliance is retired (40 CFR 82.157)
EPA HFC leak repair, 40 CFR 84.106 (applies from 1 January 2026)Appliances with a full charge of 15 lb or more of an HFC, or a substitute with a global warming potential above 53. Residential and light commercial air conditioning and heat pumps are not covered.For each install, service, repair or disposal: appliance identity and location, date, parts and type of work, who did it, refrigerant type and amount added or removed, full charge, leak rate and method. Certified technicians must hand the owner their leak inspection and verification test records.At least 3 years, and until 3 years after the appliance is retired for the full-charge records
EU F-gas Regulation 2024/573, Article 7Equipment that must be leak-checked: 5 tonnes of CO2 equivalent or more of F-gases, or 1 kg or more of the unsaturated HFCs (HFOs such as R-1234yf) in Section 1 of Annex II. Hermetically sealed units have their own conditions.Per piece of equipment: gas type and quantity, quantities added with dates, quantity recovered, whether recycled or reclaimed and by whom, the servicing company and technician with certificate numbers, and dates and results of leak checks and repairs.At least 5 years

Under the EU rule, the leak check frequency steps up with the charge. Below 50 tonnes of CO2 equivalent it is at least every 12 months, or every 24 months with a leakage detection system. From 50 to under 500 tonnes it is every 6 months (12 with detection), and at 500 tonnes and above every 3 months (6 with detection). That is Article 5(6) of the regulation, and it is why a log that records the date of every check is more than a tidiness measure.

Subscribe on YouTube@sagnikteaches

Other places have their own refrigerant licensing and record rules. If neither regime above is yours, take the field list in the next section to your licensing body and strike or add rows. The log below was built as the union of all three, with a few practical extras, so each job fills in only what applies.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

The per-job fields, and where each one comes from

Fourteen fields cover every job type. A routine leak check fills in most of them, a top-up adds the weights, and a repair adds the verification test. The last column shows which rule asks for the field, so you can drop rows that your own rules do not need.

FieldWhat to write (illustrative)Comes from
Job number, date, times on site4471, 14 Oct, 10:15 to 13:30EPA 84.106(l)(2); EU Article 7(1)(e) and (f)
Equipment ID and locationTag CR-2, make, model, serial, site codeEPA (l)(2)(i); EU records per piece of equipment
Refrigerant typeR-404AEPA (l)(2)(vi); EU Article 7(1)(a)
Full charge and how it was determined85 lb, from the nameplateEPA (l)(1) and (l)(2)(vii); EU Article 7(1)(a)
Reason for the visit and type of workRoom not holding temperature; leak repairEPA (l)(2)(iv)
Parts worked onEvaporator return bend, unit 2EPA (l)(2)(iii)
Leak check: methods, whether the spot was located, resultElectronic detector, then bubble solution; leak at the return bendEPA (l)(5); EU Article 7(1)(f)
Repair and verification testsBrazed joint; nitrogen test 200 psi for 30 minutes, held; follow-up check bookedEPA (l)(7); EU Article 7(1)(f)
Refrigerant added: type, weight, cylinder ID, scale before and after8.8 lb of R-404A from cylinder 417; 52.4 lb then 43.6 lbEPA (l)(2)(vi); EU Article 7(1)(b) and (d)
Refrigerant recovered and where it wentNone recovered (or the weight, the cylinder and the reclaim destination)EU Article 7(1)(c); EPA disposal records for units holding between 5 and 50 lb
Days since the last addition, and how much was added then104 days; 6.0 lbInputs for the EPA leak rate, (l)(2)(viii)
Technician, certification number, companyName; certificate number; company nameEPA (l)(2)(v), and proof of certification kept at the place of business; EU Article 7(1)(e)
Signature and time signedSigned 14:05Practice: it shows a human checked the entry
PhotosNameplate, scale display, leak locationPractice

Two details from EPA's own definitions are worth building into the form. Its definition of a leak inspection says that methods which only show a system is losing refrigerant, such as pressure decay checks, sight-glass checks or charging charts, have to be used alongside a method that finds the location. So give the form a method field that accepts more than one entry, plus a separate "leak located?" tick. And the leak rate calculation needs the days since the last addition, so ask for it as a number, or let the sheet pull it from the previous entry for that unit. A third detail concerns the full charge. EPA's definition lists the manufacturer's determination first, then a calculation from component sizes and pipework volume, then measured amounts, then an established range. When a nameplate is unreadable, the manual is the next place to look, and the tutorial on getting answers from HVAC manuals and spec sheets shows how to pull the figure out quickly. Record which method you used in the full-charge field.

Say it in the van: a voice-note script that covers every field

A technician with a cylinder in one hand and a gauge in the other will not fill in a fourteen-row form properly. They will talk. So fix the order of what they say, and the AI will know where each fact sits. Ten slots take about 45 seconds:

  1. Job number and unit tag.
  2. Refrigerant and nameplate charge.
  3. Why you were called.
  4. Leak check: method, what it found and exactly where.
  5. Repair done and the verification test: type, pressure, duration, result.
  6. Recovered: how much, into which cylinder.
  7. Added: cylinder number, scale reading before, scale reading after.
  8. Last top-up: how many days ago and how much, if known.
  9. Follow-up booked.
  10. Name and certificate number, once, at the end.

Use the keyboard's dictation button or the microphone in your chat app, or record a voice memo and paste the transcript in. Here is a dictation from the cold-room job that runs through the rest of this tutorial. It is illustrative, and it contains two deliberate traps.

"Job four four seven one, cold room two, tag C R two, convenience store. Refrigerant R four oh four A, nameplate eighty-five pounds. Call was room not holding temperature. Electronic detector picked up a leak at the evaporator return bend on unit two, confirmed with bubble solution. Brazed the joint, nitrogen pressure test held thirty minutes at two hundred psi. Recovered nothing. Added nine pounds from cylinder four one seven, scale before fifty-two point four, after forty-three point six. Last top-up a hundred and four days ago, six pounds. Follow-up leak check booked in ten days. Certificate number is on my card. Done at one-thirty."

Trap one: "nine pounds" does not match the scale readings. Trap two: the certificate number was never spoken. A good routine surfaces both before anyone signs.

The prompt that turns dictation into a checkable entry

The prompt does three jobs: it lists the fields in a fixed order, it forbids guessing, and it makes the AI raise a flag when two numbers disagree. Notice what it leaves out on purpose. It never asks the AI to decide compliance or to calculate a leak rate, because those belong to a formula and a person.

You structure a refrigerant technician's dictated notes into a log entry. You do not decide compliance and you do not invent data.

Return a table with these fields, in this order: job number; date; equipment tag; refrigerant type; nameplate charge (with unit); reason for visit; parts worked on; leak check method; leak located (yes or no) and where; repair done; verification test (type, pressure, duration, result); refrigerant recovered (amount, unit, cylinder); refrigerant added (amount, unit, cylinder ID); scale reading before; scale reading after; days since last addition; amount added last time; follow-up booked; technician name; certification number.

Rules:
- Use only what is in the note. If a field is missing, write NOT STATED. Never guess numbers, cylinder IDs or certificate numbers.
- Keep units exactly as spoken. Write refrigerant names in standard form (for example R-404A, R-410A, R-32).
- Where two numbers in the note disagree (for example an amount said aloud and the scale readings), do not choose. Add a line under the table headed CHECK and show both.
- After the table, list any questions for the technician, one line each.
- Do not calculate leak rates or say whether any threshold is exceeded.

NOTE:
[paste the transcript here]

This is the kind of output the cold-room dictation produces (illustrative), with the technician's review beside it. Only the rows that needed attention are shown.

FieldWhat the AI wroteWhat happened at review
Reason for visitLow refrigerantChanged back to "room not holding temperature". The AI inferred a cause that nobody had stated.
Leak checkElectronic detector, confirmed with bubble solution; located at the evaporator return bend, unit 2Correct. Both methods and the location are recorded.
Verification testNitrogen pressure test, 200 psi, 30 minutes, heldCorrect. Recorded as the initial test, with the follow-up due in 10 days.
Refrigerant added9 lb, cylinder 417CHECK line raised: the scale readings give 8.8 lb. The technician confirmed the scale and corrected the entry to 8.8 lb.
Certification numberNOT STATEDThe technician added it from the card before signing.
Days since last addition; amount then104 days; 6 lbCorrect.

The CHECK line is what makes the routine worth using. The weighed difference, 52.4 minus 43.6, is 8.8 lb. The technician had said nine out of habit, and a log that carries "9" would quietly overstate the top-up and distort every calculation built on it. The weighed figure wins every time, because the scale is the evidence and the sentence is a memory.

Let a formula do the leak rate, not the AI

For HFC appliances of 15 lb or more that EPA's leak repair rules cover, the owner has to work out a leak rate each time refrigerant is added. The rule allows two methods. The annualising method divides the pounds added by the full charge, then divides that by the shorter of 365 days or the days since the last addition, expressed as a fraction of 365, and multiplies by 100. The rolling average method adds up the pounds added over the previous 365 days and divides by the full charge. A facility has to use one method for all its appliances.

For the cold room: 8.8 lb added, 85 lb full charge, 104 days since the last top-up. Step one is 8.8 divided by 85, which is 0.1035. Step two is 104 divided by 365, which is 0.2849. Divide the first by the second and you get 0.3633, or a leak rate of 36.3%. The threshold for commercial refrigeration under that rule is 20%, so this unit has crossed it, and the rule then calls for a leak inspection and repair within 30 days of adding refrigerant, with initial and follow-up verification tests. In a sheet with the full charge in E2, the pounds added in F2 and the days since the last addition in G2, one cell does it:

=(F2/E2)/(MIN(365,G2)/365)

Format the cell as a percentage, then add a second cell that compares the result with the threshold for the equipment class (under the EPA rule, 20% for commercial refrigeration, 30% for industrial process refrigeration and 10% for comfort cooling and most other appliances) and turns the row amber. The sheet raises the flag and a person decides what follows. Whether the unit is covered at all is a classification question that neither the formula nor the AI answers, so settle it once per unit and write it in the equipment register.

Where the entries live, and how long they stay

Pick one place and make it hard to skip. A form that writes to a spreadsheet works well: drop-down lists for refrigerant types and equipment tags, one row per refrigerant event rather than one per day, photos attached by link. Job software with a custom form does the same job if it can export the rows. The routine is short. The technician pastes the reviewed table into the form, the office clears any rows still carrying a CHECK or NOT STATED, and the signed rows are locked. The tutorial on HVAC service reports from technician notes shows how the same dictation can also feed the customer's report.

Retention is the part people forget until an audit. The EPA rule asks for at least three years, and for the full-charge records until three years after the appliance is retired. The EU rule asks for at least five. Keep to the longest period that applies to you, and keep the equipment register for as long as the unit is on your books. If your reminders for periodic checks live in a separate system, the tutorial on AI service plan reminders for heating and cooling customers shows how to tie each leak check date to a recurring visit.

Keep customer details out of the AI step. The unit tag and site code identify the equipment; names, phone numbers and door codes add nothing to a refrigerant record. Treat the audio and the transcript as working material, deleted under a written rule once the signed entry exists. Cylinders are stock as well as records, so the tutorial on van stock for HVAC and electrical vans is worth a read when you decide where cylinder IDs and tare weights are stored.

Five checks the AI cannot do

  1. Weighing. Only the scale proves how much went in. The AI can compare the readings with what was said, but it cannot weigh anything.
  2. Certification. Whether the person signing holds the certificate the work needs, and whether the number on the entry is real, is a human check against the card.
  3. Coverage. Whether a unit falls inside a rule depends on its type, its charge and its refrigerant. Decide it once per unit and note the reasoning.
  4. Thresholds and deadlines. The formula flags a leak rate. A person decides whether the 30-day repair clock has started and what the next step is.
  5. Missing data. Backfilling a blank from memory the next morning turns an honest gap into a doubtful record. NOT STATED is acceptable. A confident guess is not.

Put a sign-off line at the foot of every entry so that a person, not a tool, owns what the record says:

"I confirm that these entries are accurate to the best of my knowledge, that the refrigerant weights come from the scale readings shown, and that I carried out or supervised the work. [Name], [certificate number], [date and time]."

Have the wording checked by whoever advises you on compliance, since the right form of declaration depends on the rules that apply to your equipment.

The signed entry for job 4471, as it goes in the log

After the technician's review, the cold-room entry looked like this. It is the filled-in version of the fields table, and it is what an auditor or the owner would see.

FieldEntry (illustrative)
Job and date4471, 14 October, on site 10:15 to 13:30
EquipmentCold room 2, tag CR-2, convenience store site code
Refrigerant and full chargeR-404A, 85 lb (nameplate)
Reason for visitRoom not holding temperature
Leak checkElectronic detector, confirmed with bubble solution. Leak located at the evaporator return bend, unit 2.
Repair and testJoint brazed. Nitrogen pressure test at 200 psi for 30 minutes, held. Follow-up leak check booked for 10 days later.
Refrigerant recoveredNone
Refrigerant added8.8 lb R-404A from cylinder 417 (scale 52.4 lb before, 43.6 lb after)
Last addition104 days earlier, 6.0 lb
Leak rate (sheet formula)36.3%, above the 20% threshold entered for commercial refrigeration. Row flagged amber for the office.
Technician and certificateName and number entered from the card
Signed14:05, with the sign-off line

A four-week rollout that does not need a software project

Week one: agree the field list against your own rules, then build the form or sheet with its drop-down lists. Week two: have two technicians dictate ten real jobs each and compare the AI's tables with how they would have written the entry by hand. Count the CHECK lines and NOT STATED fields, because they show where the script or the form needs tightening. Week three: add the leak rate formula and the amber flag, and set the threshold cells per equipment class. Week four: pull twenty signed entries at random and audit them against the scale photos and the certificate list.

Measure two things and nothing more: minutes per entry from the end of the job to a signed record, and the share of entries that needed correction at review. If entries are still taking longer than a couple of minutes, the usual cause is the form, not the AI. If corrections stay high after week three, the voice-note order is being ignored, and the fix is a laminated card in the van rather than a cleverer prompt. A sample of twenty a month keeps the routine honest, and the equipment register can grow one unit at a time as you go. A unit that needs topping up twice in a season is a callback pattern as well as a compliance matter, so the tutorial on logging the cause of HVAC callbacks pairs well with this log.

Questions technicians and office managers ask about refrigerant records

Does a visit with no refrigerant added still need a log entry?

Yes. A leak inspection, a repair or a verification test is a record in its own right: the EPA's HFC rule asks owners to keep leak inspection and verification test records, and the EU rule asks for the dates and results of every leak check. Write 0 lb in the added field rather than leaving it blank, so nobody later wonders whether a top-up went unrecorded.

What goes in 'days since last addition' when there is no earlier record?

Write NOT STATED rather than a guess, and ask the owner, who keeps the earlier records. One exception helps: under the EPA's HFC rule, the first time an owner works out a unit's leak rate with the annualising method after 1 January 2026, the rule says to use 365 days. Note that in the entry so the row is not mistaken for a gap.

Does a refrigerant log replace the customer's service report?

No. The log is the equipment-level record of gas, leaks and tests, written for audits and leak-rate sums. The service report tells the customer what was done and why. Many firms produce both from the same dictated notes, but they have different readers and should stay separate documents.

How should the log handle pounds, ounces and kilograms?

Use one unit per column and put it in the column header. Scales often read pounds and ounces while some rules use kilograms, so convert once, by formula, and show both if customers or regulators use different units. Tell the AI to keep the unit the technician said and to flag any conversion rather than do it silently.

Further reads

Sources: 40 CFR 84.102 and 84.106 on the eCFR (current to 29 October 2026); EPA pages on recordkeeping and reporting for stationary refrigeration and on Section 608 regulatory updates; EPA's January 2026 fact sheet on HFC leak repair; Regulation (EU) 2024/573, Articles 5 and 7, Official Journal text.

Want a refrigerant log your technicians will use?

On a 1:1 call we'll look at how your technicians record jobs today, choose the fields and capture method that fit your equipment and rules, and set up the AI step with a human sign-off.

Book a 1:1 call with me