Free equipment maintenance log template for HVAC: Google Sheets, Excel and a printable PDF

Published September 5, 2026 · Record-keeping rules and warranty terms checked September 2026

• Free. The download links come by email.
• Deepsel is our product. It is free estimate, invoice and scheduling software for contractors with a service plans module on its $29 plan, and the section before the FAQ says where the log stops and it starts.
• The retention rules and warranty clauses are quoted from the source documents, with links at the bottom. They are a starting point, and a local attorney or your state board has the final word.

An equipment maintenance log template keeps one row per unit (make, model, serial, install date, refrigerant, filter size, warranty end) and one row per visit (date, tech, work done, readings, parts, refrigerant added, next due). This free one is built for HVAC service: a two-tab Google Sheet with lookups and next-due formulas, an Excel download, and a one-page printable for the truck.

Get the spreadsheet two ways: make your own copy in Google Sheets (opens in your Drive) or download the Excel version (.xlsx). The printable one-sheet-per-unit log is a separate file: PDF, Word, or a Google Docs copy if you want to add your logo before printing. Pick a format, enter your email and I'll send the links.

I built this one because the templates that rank for this search are written for factories and truck fleets. They have columns for machine hours and odometer readings and none for refrigerant type, filter size or serial number. Sockeye's is an on-ramp to a CMMS.² An HVAC shop with two trucks needs neither. It needs the sheet below, filled in for 18 months by a made-up Raleigh shop so you can see how every column gets used, then emptied and typed over.

What should an equipment maintenance log include?

An equipment maintenance log should hold two kinds of record. The first is the unit itself: where it is, what it is by model and serial, when it went in, what refrigerant and filter it takes, and when the parts warranty ends. The second is every visit to that unit: the date, who went, what they did, what they measured, what parts and refrigerant went in, and when the unit is due again. Two tabs, then, one for each.

Tab 1: Equipment, one row per unit

Tab 2: Service log, one row per visit

Three formulas do the work. Last serviced and next due on the Equipment tab look across the Service log for that unit ID and take the latest dates. Days to next due counts down, and a conditional format turns the row pink when it goes negative and yellow inside 30 days. Both tabs have a filter on the header row, so "show me Gold-tier units due in the next 30 days" is two clicks.

Why the log is one row per unit and never one row per customer

Because the unit is what you work on. Raj Patel in the sample rows has two systems on one Gold plan, an upstairs Trane and a downstairs Trane, and in February one of them needed an inducer motor under warranty. The claim needed that unit's serial and its install date, and a log kept per customer would have given the tech a choice of two serials and no way to know which furnace made the noise last time.

Techs already keep this record in whatever will hold ink. In a December 2024 r/HVAC thread about writing filter sizes on the filter door, one tech described going further: "If there's not already a sticker with it inside, I'll write the manufacturer, model, serial, and factory charge on the inside of the control panel. Always a pain when the nameplate disintegrates."³ Another keeps a phone contact per regular customer with "Client name, address, filter size and quantity, belt size and quantity. This way even if the writing fades I still have the info."³ A third answered the question with a question: "What system do you use for scheduling? Create a note for that customer on their page for filter sizes.. so you know beforehand what to bring."³

The Equipment tab is those three habits in one place the office can read. Columns F through N are the control-panel Sharpie note, typed. A tech who runs the same maintenance routine every time, "record model, serial, filter size and check filter while furnace starts, record numbers and get amperages,"⁴ is producing exactly one Equipment row and one Service log row per stop.

The payoff shows up on the next call. A veteran tech offered this to new techs in a thread on tricks of the trade: "make sure you know the service history of any equipment you diagnose before you talk to the customer. It can save you having egg on your face depending on who was out there last doing what."⁵ A former installer turned service tech said the same thing from the other side: "logging in and seeing the details of the previous tech's work, notes, and future recommendations goes a long way in properly diagnosing a unit. Sometimes I'll show up and just fix what I think is most obvious then I get call backs for another issue."⁶ The "work done / findings" column is where the previous tech's notes go, and the "open items" table on the printable version is where the future recommendations go.

The refrigerant column is a legal record on big equipment

On any appliance holding 50 pounds or more of an ozone-depleting refrigerant, the log is a federal requirement, and the columns in this template are the ones the rule names. Under 40 CFR 82.157(l), the owner or operator must keep a record of each time such an appliance is "maintained, serviced, repaired, or disposed of," and if someone else does the work, "that person must provide a record." The record lists the identity and location of the appliance, the date, the parts worked on, the type of service, "the name of the person performing the maintenance," and "the amount and type of refrigerant added."⁷ Those are columns B, A, G, E, F, J and K on the Service log. The same regulation says the records "must be kept for at least three years."⁷

The companion section, 82.166, puts the duty on the contractor in plainer words: "Persons servicing appliances normally containing 50 or more pounds of refrigerant must provide the owner/operator of such appliances with an invoice or other documentation, which indicates the amount of refrigerant added to the appliance," and the owner "must keep servicing records documenting the date and type of service, as well as the quantity of refrigerant added."⁸ A 7.5-ton rooftop unit holding 14 pounds is well under the line. A chiller or a large commercial rack is over it. If your shop touches anything over 50 pounds, the Service log row for that unit is the record the EPA will ask to see.

The refrigerant type column matters on the small stuff too, starting this year. Under the EPA's technology transitions rule, new residential and light commercial systems moved to lower-GWP refrigerants, with a carve-out for equipment built or imported before January 1, 2025: it "may continue to be installed" with no deadline, since EPA's May 26, 2026 rule removed the January 1, 2026 cutoff (New York kept it).⁹ So for the next decade your fleet is mixed: R-410A units installed while pre-2025 stock lasts next to R-454B and R-32 units from 2025 on. The sample rows include one of each. An A2L system needs different recovery gear and a different bottle on the truck, and column K is how the dispatcher knows before the tech leaves the yard.

How long do you have to keep HVAC maintenance records?

Long enough to satisfy the longest rule that applies to you. Three years covers the EPA refrigerant records above and the IRS in the ordinary case. Five covers California's contractor board. The life of the unit covers a manufacturer warranty.

The warranty clause is the one shops underrate. Lennox's equipment limited warranty opens with "Failure to maintain equipment will void this limited warranty," and its claim section says the owner must provide and the service provider must collect the model and serial, the owner's name and the equipment location, and "the date of original Equipment installation," with the note that proof of prior maintenance may be required.¹² Trane's extended warranty terms make the customer promise to "maintain the Equipment in accordance with Trane literature and instructions" and to "make records of said maintenance available to Trane upon request."¹³ Goodman's claim form has the contractor sign "I hereby certify the service shown has been performed and purchase date verified."¹⁴ Every one of those fields is on the Equipment tab. Standby generator makers ask for the same proof, and the generator maintenance checklist quotes Generac, Kohler and Cummins on it.

In practice the distributor rarely asks. A tech answering a homeowner on r/hvacadvice put it at "more than 95% of warranty claims are made through a wholesaler with no questions asked," adding that "the manufacturer is allowed to ask for service records" and that a $30,000 compressor gets a different look than a $200 gas valve.¹⁵ A homeowner in the same thread reported the other outcome: "Lennox basically told me that if I can provide proof that an annual maintenance has been done by a specialised HVAC tech, that is all that is required in order to keep my warranty."¹⁵ You will not know in advance which claim gets questioned. The log costs one row per visit either way. The owner's side of the same file, with the current Carrier, Trane, Lennox and Goodman residential warranties quoted, is the records to keep for the warranty, send it to the customer who asks what to hold on to.

How to use the log

Three passes, and only the first one happens in the field.

At the visit: the tech fills the row

The tech starts from the unit ID and lets the customer and model fill themselves. Service type, a plain-words description, the readings, the parts, refrigerant weighed in, hours, and the job number from your invoicing app. The readings column is the one that pays for the whole exercise. "Cap 40/5 reads 38.4/4.9 (ok, watch)" in May is a capacitor you replace in the fall tune-up instead of on a 96-degree emergency call. A subcooling or superheat entry means more beside its target, and the HVAC cheat sheet lists superheat and subcooling targets from current manufacturer manuals. The printable version rides in the truck for shops that don't want a phone out in the attic, and someone types it in at the office the same week.

The checklist tells the tech what to measure. This site has a free printable set, one per equipment type and season: the HVAC maintenance checklist, the AC maintenance checklist, the furnace maintenance checklist, the heat pump maintenance checklist and the commercial HVAC maintenance checklist for rooftop units on a quarterly contract. The findings from an HVAC inspection checklist belong on the Equipment tab: a cracked heat exchanger or a 20-year-old condenser is a fact about the unit, so it goes in the notes column and in the open-items table, and every later visit starts from it. The whole set is listed on the checklists page.

Weekly at the office: next due and open items

Once a week, someone in the office sorts the Service log by date, reads the new rows, and makes sure each planned visit has a next-due date. That date is what drives the Equipment tab. Open items go to whoever sells: a recommended repair that nobody quoted is money the tech found and the office lost. On a commercial contract this weekly pass is what Standard 180 means by documentation. The standard requires that "execution of the task shall be documented and archived for future reference," and its minimum documentation package is a listing of the systems, the tasks and how they're tracked, and "sufficient record detail and verification (written or electronic) to demonstrate implementation of the maintenance plan."¹⁶ Two tabs of this sheet, kept current, are that package for a small building.

Monthly: the due list and the age list

Filter the Equipment tab on days to next due, ascending. Pink rows are overdue and get booked first. Yellow rows inside 30 days get the reminder text. Then sort once by install date. ENERGY STAR's rule of thumb is that a heat pump or air conditioner "more than 10 years old" and a furnace "more than 15 years old" are candidates for replacement,¹⁷ and the install column shows you which customers are due that conversation before the unit decides for them.

Log, checklist, tracker: three documents that get confused

Shops ask for a "maintenance spreadsheet" and mean three different things. They live in three different files on purpose.

The log and the tracker overlap on one column, and that overlap is the seam between the two halves of a maintenance program. Column O on the Service log, "agreement visit?", says whether a visit was one the customer had already paid for. The tracker holds the other side of that same fact: two visits owed, one delivered, one still owed. If the shop's office manager keeps both files by hand, that column is the join, and it's the first place the two drift apart.

The log is the unit record. In Deepsel it is the equipment record.

The log is a history. It tells you what happened to the Anderson furnace and when. What it cannot be is the record the office works from: column B exists so the name matches your invoicing app, column N exists so the visit row can find its invoice, and the serial, filter size and last readings sit in a file the tech in the attic does not have open. In Deepsel, our free estimate, invoice and scheduling software for contractors that replaces Jobber or Housecall Pro, the Equipment tab is the equipment record: one record per unit with the model, serial, year, filter size, tonnage and refrigerant, the nameplate captured from the tech's phone. The Service log only half fits: the unit lists the visits it was part of, with the date and the tech's notes, while each visit's readings sit on the checklist the tech fills in on the phone, kept on the job with the photos. Deepsel doesn't line those readings up by unit yet. The invoice is built from the job and paid by card from the phone. All of that is on the Free plan: scheduling and dispatch, quotes, invoicing, card payments, and customer and equipment records, with 30 estimates and 30 invoices a month for your whole team.

If you sell plans, the visits column O marks as "agreement visit?" are what Pro's service plans module counts: it keeps visits owed against delivered per unit, charges the renewal to the card on file or sends a scheduled invoice, and sends the booking reminders by email when a visit comes due.

Step one costs nothing. Run the shop on Deepsel Free, no card to start, and keep the agreement book beside it in the free maintenance agreement tracking spreadsheet: one row per agreement, visits owed versus delivered, days to renewal. The contract that creates each of those rows is the free HVAC maintenance agreement template, and its equipment schedule uses the same model, serial and filter-size fields as the Equipment tab here, so the two documents describe the same units. The reasoning behind each column is in how to track HVAC maintenance agreements. A sheet holds a small book fine. You outgrow the pair when the shop sends more than 30 estimates or 30 invoices a month, or the sheet's hand-work (reminders, renewals, visits owed) starts eating the office's week. Then Pro, $29 a month for unlimited estimates and invoices, adds the service plans module: the sheet's customers import in one upload, and each plan is set up once in it.

Frequently asked questions

Is there an Excel version of the equipment maintenance log?

Yes. Download the .xlsx above, or open your Google Sheets copy and use File, Download, Microsoft Excel. The lookups, the last-serviced and next-due formulas, the dropdowns and the overdue highlighting all come with it. The formulas use MAXIFS, so you need Excel 2019, Excel 2021 or Microsoft 365. Older Excel shows a #NAME? error in those three columns and everything else still works.

What is the difference between a maintenance log and a maintenance schedule?

The schedule is the plan: which task, on which unit, how often. The log is the record: what was actually done, by whom, on what date, with what readings. You need both. A schedule with no log cannot prove anything happened, and a log with no schedule cannot tell you what is due next. The free preventive maintenance schedule template on this site is the planning half; this page is the record half.

Can I use this log for a commercial building or a facility?

Yes. The sample rows include a dental office with two rooftop units on a quarterly contract, and the columns hold what Standard 180 asks a maintenance program to document: the equipment inventory, the task performed, and enough record detail to show the plan was carried out. Facility managers with more than about 40 units usually outgrow a spreadsheet and move to a CMMS, and the columns here match what those systems import.

How do I record refrigerant for the EPA in this log?

Every Service log row has a refrigerant-added column in pounds and a refrigerant-type column pulled from the Equipment tab. For appliances holding 50 pounds or more, 40 CFR 82.157 requires a record of the date, the part serviced, the type of service, the name of the technician and the amount and type of refrigerant added, kept for three years. For a residential split system under 50 pounds the federal rule does not apply, and I still fill the column, because the pounds you added last April is the first thing you want when the same unit is low again in July.

Do I need a maintenance log for a manufacturer warranty claim?

Usually the distributor processes the claim on the serial number and the install date without asking for service history. The warranties themselves reserve the right to ask: Lennox's says failure to maintain equipment voids the warranty and proof of prior maintenance may be required, and Trane's extended terms say the customer shall make records of maintenance available on request. The log gives you the install date, the serial and the dated visits in one place when a large claim gets questioned.

Sources

1. MapTrack, "Free equipment maintenance log template" - download form reads "Enter your email to download the equipment maintenance log as a free PDF." maptrack.com, updated August 10, 2026, read September 5, 2026.
2. Sockeye, "Free Equipment Maintenance Log Template in Excel and Google Sheets" - "it's best to keep your maintenance log in digital form, preferably in your CMMS." getsockeye.com, October 31, 2025, read September 5, 2026.
3. r/HVAC, "what do we say about writing filter sizes on the filter door" - comments: "I'll write the manufacturer, model, serial, and factory charge on the inside of the control panel. Always a pain when the nameplate disintegrates"; "Client name, address, filter size and quantity, belt size and quantity"; "Create a note for that customer on their page for filter sizes.. so you know beforehand what to bring." reddit.com, December 3, 2024, read September 5, 2026.
4. r/HVAC, "Boss says I need to spend at least an hour at maintenances" - a tech's furnace routine: "record model, serial, filter size and check filter while furnace starts, record numbers and get amperages." reddit.com, June 4, 2025, read September 5, 2026.
5. r/HVAC, "Best tips and tricks from experienced techs" - "make sure you know the service history of any equipment you diagnose before you talk to the customer. It can save you having egg on your face depending on who was out there last doing what." reddit.com, December 19, 2024, read September 5, 2026.
6. r/HVAC, "What's a skill, routine, or task you always perform on every job" - "logging in and seeing the details of the previous tech's work, notes, and future recommendations goes a long way in properly diagnosing a unit." reddit.com, November 17, 2023, read September 5, 2026.
7. 40 CFR 82.157, "Appliance maintenance and leak repair," paragraph (l) Recordkeeping - records for appliances of 50 or more pounds must include the date, parts, type of service, "the name of the person performing the maintenance," and "the amount and type of refrigerant added"; "All records identified in this paragraph must be kept for at least three years." law.cornell.edu, current e-CFR, read September 5, 2026.
8. 40 CFR 82.166, "Reporting and recordkeeping requirements," paragraphs (j), (k) and (m) - "Persons servicing appliances normally containing 50 or more pounds of refrigerant must provide the owner/operator of such appliances with an invoice or other documentation, which indicates the amount of refrigerant added"; owners "must keep servicing records documenting the date and type of service, as well as the quantity of refrigerant added"; "a minimum of three years unless otherwise indicated." law.cornell.edu, current e-CFR, read September 5, 2026.
9. U.S. EPA, final rule, 91 FR 31284 (FR Doc. 2026-10387, RIN 2060-AW39), May 26, 2026 - revised 40 CFR 84.54(c)(1): new residential and light commercial air-conditioning and heat pump systems at 700 GWP or more "may continue to be installed where all specified components of that system are manufactured or imported prior to January 1, 2025"; the summary says the rule "Removes the installation deadline"; "This final rule is effective on July 27, 2026." govinfo.gov, read September 24, 2026. Reported by the National Association of Home Builders, "EPA Finalizes Refrigerant Rule Update to Allow Older HVAC Unit Installation," nahb.org, May 26, 2026, read September 24, 2026. New York: NYSDEC, Part 494 FAQ, May 2026 - "USEPA later extended the prohibition one additional year to January 1, 2026 … Part 494 adopted the later date for all products and systems." dec.ny.gov, read September 24, 2026.
10. California Business and Professions Code 7111(a) - records must be available for inspection "for a period of not less than five years after completion of any construction project or operation to which the records refer." leginfo.legislature.ca.gov, read September 5, 2026.
11. Internal Revenue Service, "How long should I keep records?" - "Keep records for 3 years if situations (4), (5), and (6) below do not apply to you"; "Keep records for 7 years if you file a claim for a loss from worthless securities or bad debt deduction"; "Keep employment tax records for at least 4 years." irs.gov, read September 5, 2026.
12. Lennox, "Lennox Quality Care Program Equipment Limited Warranty" (commercial packaged units) - "Failure to maintain equipment will void this limited warranty"; claim requirements list the model and serial, owner's name and equipment location, and "the date of original Equipment installation"; "NOTE - Proof of prior maintenance and purchase may also be required." lennox.com (PDF), read September 5, 2026.
13. Trane, "Extended Warranty Terms and Conditions" (form 1-27.98) - the customer shall "maintain the Equipment in accordance with Trane literature and instructions and shall make records of said maintenance available to Trane upon request." trane.com (PDF), May 20, 2021, read September 5, 2026.
14. Goodman, "Warranty Claim Form, Air Conditioning & Heating" - contractor signature line: "I hereby certify the service shown has been performed and purchase date verified." apps.goodmanmfg.com (PDF), read September 5, 2026.
15. r/hvacadvice, "Annual service required to maintain HVAC manufacturer warranty?" - a tech: "The manufacturer is allowed to ask for service records... more than 95% of warranty claims are made through a wholesaler with no questions asked"; a homeowner: "Lennox basically told me that if I can provide proof that an annual maintenance has been done by a specialised HVAC tech, that is all that is required in order to keep my warranty." reddit.com, November 2, 2023 and July 13, 2024, read September 5, 2026.
16. ANSI/ASHRAE/ACCA Standard 180-2012, "Standard Practice for Inspection and Maintenance of Commercial Building HVAC Systems," sections 4.2.2.e and 4.3 - documentation package includes "sufficient record detail and verification (written or electronic) to demonstrate implementation of the maintenance plan"; "execution of the task shall be documented and archived for future reference." philcoaircontrol.com (PDF copy of the 2012 edition; the current edition is 180-2018), read September 5, 2026.
17. ENERGY STAR, "When is it time to replace?" - "Your heat pump or air conditioner is more than 10 years old"; "Your furnace or boiler is more than 15 years old." energystar.gov, read September 5, 2026.