Rental Property Maintenance Log Spreadsheet: What to Log, and Why Undocumented Repairs Cost Money

Most landlords remember a repair happened. Fewer can tell you, six months later, exactly what it cost, which contractor did it, or whether it was the second time that same pipe had leaked. That gap isn't a memory problem — it's a records problem, and it's an expensive one. A maintenance log fixes it with one sheet: one row per job, a handful of columns that actually matter, and two numbers on a dashboard that tell you what's been spent versus what's merely been scheduled.

Why undocumented repairs cost money

An untracked repair costs you in three separate ways, and none of them show up until you go looking. First, repair costs on a rental property are frequently tax-deductible, and a deduction you can't back up with a date, an amount, and a description is a deduction you're less likely to claim with any confidence when tax season arrives. Second, patterns hide in memory. A single mental note of "we fixed the water heater" doesn't tell you that it's the third time in a year — a logged record does, the moment you filter by property and category. Third, a scheduled job that never gets marked done is easy to lose track of entirely: a tenant reports a dripping faucet, you call a plumber, and if nothing records that call past your own memory, a busy month is all it takes for the job to quietly fall through.

What to log for every job

Keep the maintenance log to one row per job, with eight columns:

The nine categories worth tracking

Category is what turns a flat list of repairs into a picture of where your maintenance money actually goes. Nine categories cover the ground most rental properties need: Plumbing, Electrical, HVAC / Heating & Cooling, Appliance, Structural / Roofing, Pest Control, Landscaping / Exterior, Cleaning / Turnover, and Other. Each one is editable from a settings list, and each rolls up into its own line on the Dashboard's Spend by Category table — so instead of a gut feeling that "plumbing seems expensive lately," you get an actual number to compare against HVAC, appliances, and everything else.

Open vs Completed: tracking a job through to done

Status runs through four stages — Reported, Scheduled, In Progress, Completed — and that one column is what separates money you've spent from money you've merely committed to spending. The Dashboard tracks both sides: Open Items counts everything at Reported, Scheduled, or In Progress, and Completed Items counts everything marked Completed. Below that, Total Maintenance Spend adds the Cost column across every row regardless of status, while Total Completed Spend adds it only for rows marked Completed. The difference between those two totals is real money — it's what's been quoted or scheduled but not yet actually paid out.

Here's how that plays out with six logged jobs across a couple of properties:

Total Maintenance Spend adds all six: $185 + $350 + $210 + $95 + $60 + $420 = $1,320. Total Completed Spend only adds the three marked Completed — plumbing, appliance, and structural: $185 + $210 + $420 = $815. Open Items reads 3 (the HVAC, electrical, and pest control jobs), and Completed Items also reads 3. The $505 gap between $1,320 and $815 is the part of your maintenance budget that's already committed — quoted, scheduled, or underway — but hasn't actually left your account yet, which is exactly the number you want when you're checking what's left of a maintenance budget for the year rather than what you've logged as a possibility.

Spend by category and by property

Beyond the two headline totals, the Dashboard builds two rollups automatically: Spend by Category, which sums Cost against each of the nine categories, and Spend by Property, which sums Cost against each address in your Properties settings list. Both use the same underlying formula pattern — add up Cost everywhere Category (or Property) matches, everywhere in the log — and both update the moment you add a new row, with no separate report to build. Together they answer two different questions: which type of repair is actually costing the most, and which property is quietly costing more than the others to keep running.

What this log doesn't do

Worth being direct about the edges. The Maintenance Log itself has no date-based or status-based conditional formatting — no color that appears because a Reported job has sat untouched for three weeks, no highlight tied to how long something has been open. The Open Items count on the Dashboard is the closest thing to a flag: it's a number that goes up as jobs pile up unresolved, and it's on you to open the log and see which ones. The sheet also doesn't schedule contractors, send anyone a reminder, generate an invoice, or process a payment — it's a record and a set of rollups, not a work-order system.

For most landlords running a handful of properties, that record is exactly what's needed: complete enough for tax time, detailed enough to catch a pattern, and simple enough to actually keep current. If you want to check whether a property's underlying numbers justify what you paid for it, the rental property ROI calculator runs cap rate and cash-on-cash return from your figures. For the fuller monthly routine this maintenance log sits inside — alongside rent and tenant tracking — see the rental property expense tracker guide, and if you're weighing long-term leasing against furnishing a unit for short-term rental, the Airbnb vs long-term rental calculator compares both on the same property.