TL;DR: A property management company in Chicago grew from 3 buildings to 12 in four years. Their equipment tracking didn't grow with them. The maintenance director was managing 340 HVAC units with a spreadsheet he'd built for 85. In October, he paid $4,200 to replace a compressor that was still under warranty. He didn't find out until December. When he audited the spreadsheet, 47 units had unknown warranty status. We built a five-stage lifecycle agent that maintains a central equipment registry, tracks manufacturer-specified maintenance schedules, monitors warranty compliance, forecasts replacements, and dashboards the whole portfolio. Eleven warranty-at-risk units caught in the first scan. One proactive warranty claim saved $3,800. Estimated first-year savings: $38,000-$52,000. Agent cost: $280/month.
The Invoice That Nagged
October. A compressor fails on a rooftop unit in Building 9. The maintenance director sends a tech. Standard replacement. $4,200. Parts ordered, installed, invoice paid, filed.
December. He's reviewing year-end expenses. The $4,200 line item catches his eye. Something about Building 9. He pulls the original equipment file. Checks the install date. Checks the warranty period.
The unit was 3 years and 7 months old. The compressor warranty was 5 years.
He calls the manufacturer. "Can we backdate a warranty claim for a replacement done two months ago?" The answer: no. Warranty claims must be filed before work is performed. Once you've paid a third-party contractor, the manufacturer won't reimburse retroactively.
$4,200. Gone. Because the spreadsheet had a column that said "Warranty: Check" and nobody had checked.
Dave closed the call and opened the spreadsheet. Three hundred and forty rows. He searched the warranty column for "Check" or blank cells. Found 47.
Forty-seven units with unknown warranty status. Some of those warranties might've already been voided by missed maintenance. Some might be active and protecting units that could fail next month. He had no way of knowing without pulling every equipment file, cross-referencing every manufacturer's terms, and checking every service record.
At 85 units, he could hold most of this in his head. At 340, he couldn't hold any of it.
The Company
Property management firm in Chicago, Illinois. Twelve commercial and residential buildings across the metro area. Three hundred and forty HVAC units: rooftop packages, split systems, boilers, chillers. Plus fire suppression systems, elevators under separate contracts, and plumbing infrastructure.
Four years ago, they managed 3 buildings with 85 units. Dave built the spreadsheet then. At 85 units, it worked. He knew most of the equipment personally. He could tell you the install date on the Building 2 chiller from memory. Then the portfolio quadrupled. The spreadsheet just got longer.
Manufacturer maintenance schedules vary by manufacturer and unit type. Some require quarterly filter changes. Some need biannual refrigerant checks. Some specify annual full inspections. Those schedules live as PDFs in a shared drive folder Dave "mostly keeps organised." At 85 units across 3 manufacturers, that's manageable. At 340 units across 8 manufacturers, it's a filing cabinet nobody opens.
The warranty trap is the part that keeps Dave up at night. Most commercial HVAC warranties run 5 to 10 years on compressors, 1 to 2 years on parts. But they're conditional. Miss a manufacturer-specified maintenance service and the warranty can void. Silently. You don't find out the warranty's voided until something breaks and the manufacturer declines the claim.
Annual HVAC maintenance and repair budget: roughly $180,000. Of that, Dave estimated $15,000 to $25,000 per year was going to repairs that could've been warranty claims or prevented entirely by timely maintenance. He couldn't prove it. He just knew, from four years of invoices that nagged at him, that the number wasn't zero.
Why Nothing Scaled
The spreadsheet was well-designed for 85 units. Dave's careful about structure. The problem was that he updated it on the last Friday of the month, which meant it was stale 26 out of 30 days. No alerts. No automatic calculations. The "next service due" column required him to manually look up each manufacturer's schedule and enter the dates. With 340 units on varying cycles, that column was a fiction. About a third of the entries were best guesses rather than actual calculated dates.
He tried Google Calendar reminders for the most critical units. At 340 units with different service intervals, the calendar became a wall of notifications he started dismissing. Too many reminders is the same as no reminders. The important ones drown in the noise.
He tried relying on contractors. "The HVAC contractor should tell us when service is due." Some do. Some forget. And none of them track warranty status. That's the property manager's responsibility. A contractor who shows up, does the work, and invoices you doesn't know or care whether that unit is still under warranty. That's not their job.
He investigated CMMS software. Computerised maintenance management systems built for exactly this problem. Starting at $500 to $1,000 per month for his portfolio size. Requires migrating all 340 unit records, training 4 techs on a new platform, and ongoing admin to keep it current. Dave's response: "I don't have time to set up the system that's supposed to save me time." He wasn't wrong. The migration alone would've taken weeks he didn't have.
Every option either didn't scale, depended on people who don't share your priorities, or required a setup project Dave couldn't resource.
The design is next. The design, the build guide, the running costs and the take-away are free to subscribers. Enter your email below and the rest of this Blueprint opens. New ones arrive every Tuesday and Friday.
