Playbook · Spreadsheets + AI · 29 August 2026

How to Track Home Maintenance Without Spreadsheet Chaos (2026)

You changed an HVAC filter. You did not write down the size, the date, or which unit. Three months later the house feels dusty and the furnace warranty may have lapsed. That is a home with a dozen clocks and no log — not a character flaw. Warranty math is a date problem. Dates belong in a spreadsheet.

Disclosure: Jaceal LLC publishes this site and operates Smart Files Shop on Etsy. Listing links below go to our own live Etsy listings. We earn the listing price on those sales. This page is a how-to system, not a ranking and not contractor, insurance, or tax advice. Listing IDs, titles, and prices were read from Etsy Open API list-listings active on 29 August 2026. Checkout on Etsy is the source of truth. See our affiliate disclosure.

A notebook fails at warranty end dates. A generic to-do app fails at cost totals. A purpose-built spreadsheet wins because dates calculate and totals update when you log one repair. You can build that file tonight from the schema below. If you would rather open a workbook that already has the formulas, each job maps to one live listing at its current price.

Four piles people mash into one notes app

Pile What “done” looks like Live listing (29 Aug 2026) Price
The cycle HVAC and water filters, batteries, seasonal tasks, warranty days-left, repair spend Home Maintenance Tracker 4533406672 $6.99
The facts Filter size, paint color, where the deed lives, spare keys — lookup, not a task list Home Reference Binder 4536202529 $6.99
The stuff Keep / donate / sell, and a donation-value log you can find in April Home Declutter Spreadsheet 4483586050 $6.99

Start with the pile that already cost you a weekend. You do not have to buy all three. All three listings were active at $6.99 USD on the pull that updated this page. If you also own rentals, the landlord rent-roll playbook is a different job — do not put tenant ledgers in the house file.

A 15-minute weekly habit

  • Sunday (10 minutes): glance at “due this month” and anything with warranty ending in 90 days. Schedule one overdue task or decide it waits.
  • After any repair (3 minutes): one log row — date, item, cost, who did the work, warranty used Y/N. If you skip the cost, you cannot defend a maintenance budget later.
  • Season start (one walk): gutters, detectors, outdoor shutoff, filter change. Check the box. Do not rebuild the list from memory each March.

The habit is the product. The spreadsheet is the memory. AI is optional.

Where ChatGPT belongs in a house log

Useful:

  1. A seasonal checklist for your climate and housing type (“two-story wood-frame, humid subtropical, gas furnace + central AC”). Treat it as a draft. Your house still has a specific filter size.
  2. A DATE / EDATE formula: purchase date plus warranty months → days left, with an Expired flag.
  3. A one-paragraph email to an HVAC shop: model (not serial), symptom, last service date. You type the model from the plate. You do not upload the plate photo to a chat if it shows a serial number you would not put on a postcard.

Hard rule: serial numbers, alarm codes, spare-key locations, full account numbers, and where the deed lives stay in a file you control. A consumer chat is not a house manual.

DIY schema (no purchase)

Blank Google Sheet. Four tabs. Purple sample rows until the formulas look right, then overwrite them.

Tab A — Filters & consumables

Columns: item, location/unit, size, last changed, interval (days), next due (=last + interval), status (On Track / Overdue). HVAC filter, water filter, smoke/CO batteries, humidifier pad. Size is a lookup fact. Interval is a cycle. Do not store size only in your head.

Tab B — Appliances

Columns: item, brand/model, purchase date, warranty months, warranty end (=EDATE(purchase, months)), days left, expired flag, notes. Leave serial number in a column you do not export to anyone. The 1%-of-home-value maintenance guideline some workbooks show is a planning heuristic, not an insurer rule.

Tab C — Repairs

Date, item, cost, vendor, warranty used Y/N, value-add Y/N (upgrade vs upkeep). Totals SUM the cost column. That is the whole budget.

Tab D — Who to call

Specialty, name, phone, last used. HVAC, plumber, electrician, roofer. When something fails on a Sunday you do not want to search email.

That DIY file covers the cycle. Filter size and paint color are a different pile (reference). Keep/donate/sell is a third pile. Mixing all three into one giant list is the chaos this page is trying to stop.

Job 1 — Filter due dates, warranties, spend

Home Maintenance Tracker Spreadsheet | Seasonal HVAC Warranty Repair Log Excel Google Sheets

Listing 4533406672 · $6.99 · state active (Etsy Open API, 29 August 2026). Instant download. Nothing ships.

Listing copy: a 12-tab Excel and Google Sheets workbook plus a browser dashboard. Tabs include Start Here, Dashboard (tasks due this month, overdue, YTD spend, appliances under warranty), Seasonal Schedule (spring/summer/fall/winter with overdue highlight), Task Log, Appliance & Systems Inventory with days-left on warranty and an Expired flag, Service Providers, Repair & Improvement Log, Filters & Consumables with next-due formulas, Home Budget, Paint & Materials. Compatible with Microsoft Excel (2016+) and Google Sheets (import the .xlsx). No macros required for core function.

It is for the homeowner tracking that from memory — not an inspection, not a filed insurance claim, and not a claim that the 1%-of-home-value budget is an insurer rule.

Open the live Home Maintenance listing — $6.99

Job 2 — Filter size, paint, where the papers are

If the maintenance tracker answers “when,” the reference binder answers “what size is the filter” and “what paint is in the hallway.” Those are lookup facts. They do not belong on a due-date dashboard.

Home Reference Binder Printable | House Manual Warranty Filter Log PDF

Listing 4536202529 · $6.99 · active. A 29-page fillable binder plus companion spreadsheet: house facts, paint swatches, filter / bulb sizes, a document locator (where the deed lives — not account numbers), renewals, spare keys. Listing copy is explicit: nothing here asks for an SSN, full account numbers, or passwords. It is a lookup binder, not a task tracker, and it does not duplicate the maintenance tracker above.

Open the live Home Reference listing — $6.99

Job 3 — Keep / donate / sell

The donate pile in the garage is not a maintenance schedule. If you need a donation-value log in April, that value has to be written down when the bag leaves the house — not reconstructed from memory.

Home Declutter Spreadsheet | Keep Donate Sell Donation Tax Log Excel Google Sheets

Listing 4483586050 · $6.99 · active. A 14-tab Excel and Google Sheets workbook plus a browser dashboard. Listing copy: Room-by-Room status, Declutter Log with Keep / Donate / Sell / Toss, Donation Tracker (fair-market value by date and organization — a paper trail you fill in, not tax advice and not a Schedule A form), plus inventory, cleaning schedule, and a storage map. Consult a tax professional before you treat any donation log as a deduction.

Open the live Home Declutter listing — $6.99

Common mistakes

  • Tracking tasks but not warranty end dates.
  • Logging repairs without cost — you cannot defend a maintenance budget later.
  • One giant list instead of cycle + facts + stuff.
  • Paying for property-management software when you have 1–4 units. If you are a small landlord, use a rent roll — see the landlord playbook — not a house-filter tracker.
  • Pasting serial numbers and spare-key locations into ChatGPT because “it will remember.” It will not remember safely.

Love Guarantee and custom work

Every listing on this page carries the same 14-day Love Guarantee from live listing copy: message Smart Files Shop if the file is not right — free fix, free small customization, or refund.

Free small customizations (typical): rename a column, add a header, change a filter or appliance label, swap a room name.

Paid customs are quoted before any extra charge. Individual listings may quote lower for tweaks already in scope. The shop does not inspect houses, file insurance claims, or prepare tax returns.

Start here

Maintenance tracker for the cycle. Reference binder for the facts.

ChatGPT for a climate-specific seasonal draft. Serial numbers stay in your file.

Maintenance Tracker $6.99

FAQ

What should a home maintenance spreadsheet track?

Seasonal tasks, appliance identity with purchase date and warranty end, repair spend, and who to call. Size and paint color are lookup facts — a different pile.

Can I use ChatGPT to remember HVAC filter sizes?

Ask it for a seasonal checklist. Store the actual size in a sheet or binder you control. Do not paste serial numbers or alarm codes into a consumer chat.

Is the 1%-of-home-value budget a rule?

No. Some workbooks show it as a planning guideline against actual task-log and repair-log spend. It is not an insurer rule and not tax advice.

What is the live price of the home maintenance tracker?

$6.99 USD on listing 4533406672, state active, as of the 29 August 2026 Etsy Open API pull. Checkout on Etsy is the source of truth if the price changes.

Related playbooks

Last updated 29 August 2026 against a live Etsy list-listings active pull (94 actives). AI-assisted draft; human-reviewed against listing copy. Not deployed from this edit until quality prints APPROVED.