Your Customers' ACs Are Dying and You're the Last to Know: A Free Equipment Lifecycle Tracking System for Home Service Contractors

By Ryne Bandolik · Jobs Done Labs · July 15, 2026

It's August 3rd, 96°F outside. Mrs. Patterson calls — her AC is blowing warm air. Your tech diagnoses a failed compressor on a 22-year-old R-22 unit. Replacement cost: $6,800. She's on a fixed income, and you've serviced her equipment for 8 years. You knew this was coming — the unit was 19 years old when you took over the account. But you had no system to proactively identify aging equipment across your 2,400 service agreement customers. So now you're the bearer of bad news on the hottest day of the year instead of the proactive consultant who planned a phased replacement 3 years ago.

You're sitting on a goldmine of replacement leads hiding in your own customer base. Every fall tune-up, your techs write the equipment age on a paper service ticket: "furnace: 2004 Carrier 58MVB, condition: good, CO test: passed." Those tickets go into filing cabinets. Nobody aggregates them. Nobody runs a report that says "sort by equipment age descending, flag any furnace over 18 years, any AC over 15 years, any water heater over 10 years." The data exists — it's just not actionable.

The competition isn't helping. Search "HVAC equipment age tracking spreadsheet" and every page-1 result sells you something: field service CRMs pitching their equipment tracking module as a $50/user/month add-on, manufacturer lifecycle charts designed to sell you new Trane units, and trade magazine articles that say "you should track equipment age" but provide zero tools. Nobody offers a free, purpose-built equipment lifecycle tracker for home service contractors. Until now.

Why "knowing your customers" isn't enough

Your service manager, Mike, has been with the company 14 years. He knows the equipment age intuitively for maybe 100-150 of your highest-value customers — the ones he personally visits on tough calls. But the other 2,250 are a blind spot. Every year, 30-50 of those 2,250 customers experience an equipment failure. Some call you (if your sticker is on the unit). Some call whoever answers the phone first. Every one that calls a competitor is a $6,500 replacement sale you lost — not because your price was higher, but because you never had the proactive conversation.

The replacement priority system: Red, Yellow, Green

The equipment data you already have (and aren't using)

Every tune-up ticket contains the equipment serial number. The serial number encodes the manufacture date on every major brand. Teach your techs to capture it on every visit, and you'll have manufacture dates for your entire agreement base within one seasonal cycle:

• Carrier / Bryant / Payne: First 4 digits are week and year. "1504" = 15th week of 2004.
• Trane / American Standard: Typically year and week encoded in the serial (e.g., "4123ABCD" = 41st week of 2023).
• Lennox / Armstrong / Ducane: Post-1974, digits 3-4 are the year. "5804C12345" = 2004.
• Rheem / Ruud / WeatherKing: First 4 digits after the initial letter are week and year. "W150412345" = 15th week of 2004.
• Goodman / Amana: First 4 digits are year and month. "0403123456" = March 2004.

Our free spreadsheet includes a serial number decoder tab that auto-calculates the manufacture date — your tech enters the serial number from the data plate, and the sheet does the rest.

The refrigerant reality: R-22 is your biggest replacement opportunity in decades

R-22 refrigerant was phased out January 1, 2020 — no new production or import allowed in the US. Any system manufactured before 2010 almost certainly uses R-22. These systems are now 16-35+ years old. When they develop a leak, R-22 costs $150-200/lb on the reclaimed market (vs. $15-25/lb for R-410A). A typical residential AC holds 6-12 lbs. That's $900-2,400 in refrigerant alone — before labor. The rational economic decision is replacement. But the homeowner doesn't know this. They just know "my AC stopped working."

If you have 2,400 service agreement customers, roughly 400-500 still have R-22 systems. Each one is a $6,500+ replacement opportunity that becomes MORE expensive for the customer every year the refrigerant supply shrinks. Proactive identification turns you from the "sorry, it's $2,400 just for the refrigerant" guy into the "let's plan a replacement on your timeline at today's pricing" consultant.

The equipment lifecycle tracker (the core system)

The spreadsheet has four tabs, each serving a specific function in your replacement pipeline:

Tab 1: CUSTOMERS

Customer name, address, phone, email, service agreement active (Y/N), agreement start date, total equipment count at property. This is your master list — every piece of equipment links back to a customer here.

Tab 2: EQUIPMENT

The workhorse. For every piece of equipment at every customer: equipment type (furnace / AC / heat pump / boiler / water heater / ductless mini-split), brand, model number, serial number, manufacture date (auto-calculated from serial number), installation date (if known), refrigerant type (auto-flagged RED if R-22), fuel type, capacity (BTU / tons / gallons), last tune-up date, last CO test result (PPM), last combustion analysis values (O2 / CO / stack temp / efficiency %), condition rating (1-5), estimated remaining life (years), and — most critically — REPLACEMENT PRIORITY (auto-calculated: RED / YELLOW / GREEN), replacement proposal date, proposal amount, customer response (accepted / declined / pending / follow-up), follow-up date, and notes.

Tab 3: REPLACEMENT PIPELINE DASHBOARD

Auto-aggregates from the EQUIPMENT tab: total RED count (emergency risks), total YELLOW count (this year's proactive targets), total open proposal value, proposals accepted this month/quarter/year (count and dollar value), replacement close rate by technician, and a 12-month projected replacement revenue number (YELLOW count × 25% conversion × $6,500 average). This dashboard turns the spreadsheet from a data-entry chore into a revenue management tool.

Tab 4: TECH CAPTURE FORM

A simple 10-field printable form your techs complete after each tune-up: customer name, date, equipment type, brand, serial number (critical — everything else derives from this), refrigerant type (visually identifiable from the outdoor unit data plate), CO test result (furnace only), visual condition notes (one sentence), replacement priority (tech's gut check: RED / YELLOW / GREEN). The office admin enters this into the spreadsheet — the tech never touches it. If the form takes more than 2 minutes, compliance drops to 30%. This one takes 90 seconds.

The seasonal workflow: predictable pipeline, not emergency spikes

Spring (March-April, before cooling season): Pull all YELLOW-priority AC units (12+ years old) and all RED-priority R-22 units. Send a proactive replacement letter: "Our records show your AC unit is X years old. While it's running fine today, units of this age are at increased risk of failure during peak cooling season. We'd like to offer a free in-home replacement consultation with no obligation — we'll assess your system, discuss options, and provide a firm quote valid for 90 days."

Fall (September-October, before heating season): Same process for furnaces 16+ years old and water heaters 9+ years old. This creates a predictable, year-round replacement pipeline instead of a summer/winter emergency panic.

Red flags: when the system tells you something's wrong

1. Customer with a RED-priority flag who hasn't been contacted. The system only works if you use it. Schedule a monthly 30-minute review of the RED column — every name on that list represents a conversation you need to have this month.
2. Techs who skip the serial number capture. Spot-check 10% of tune-up tickets. If the serial number is missing, it's a coaching conversation — not punitive, but clear: "This is how we identify replacement opportunities. Without the serial number, we can't help the customer plan."
3. R-22 customer who was told "we'll top off and see how it goes." Kicking the can costs the customer more every year — refrigerant gets more expensive, and the system gets less efficient. For systems over 15 years old, the economically correct answer is almost always replacement.
4. "We'll start tracking next month." Every month you delay is 30-50 more equipment failures that happen reactively instead of proactively. Start with your last 30 days of service tickets. You'll have 150-200 pieces of equipment in the tracker by Friday.