Rental Property Maintenance Log: Work Orders, Vendors & Preventive Maintenance Tracker (Excel / Google Sheets)

A maintenance workbook for landlords and small property managers with 1 to 15 properties. Log every repair request as a work order, assign a vendor, and the workbook tracks what is open, what is overdue against your target response times, and what each property cost you this year.

, , ,
, , ,

A maintenance workbook for landlords and small property managers with 1 to 15 properties. Log every repair request as a work order, assign a vendor, and the workbook tracks what is open, what is overdue against your target response times, and what each property cost you this year.

What it covers: work-order log (400 rows) with dropdowns for property, category, priority, vendor and status; overdue flag against target days to close by priority; days open and days to close; tenant charge-backs and net cost by property; vendor list with job count and total paid; preventive maintenance schedule (filters, detectors, gutters, furnace service) with next-due dates and overdue / due-soon flags; dashboard with open and overdue counts, cost by category chart, cost by property, average days to close; built-in checks.

Who it is for: small landlords, house hackers and self-managing owners who want a simple repair history per property for budgeting, tenant charge-backs and year-end records.

Files: .xlsx (Excel 2016+, works in Google Sheets). No macros. Sample data is fictional. Built with AI assistance and checked for formula errors. A record-keeping tool, not legal or tax advice.

What it is used for

Keeping a dated repair history and yearly cost for each rental.

Tabs and structure

Eight tabs: Start Here, Dashboard, Settings, Properties, Vendors, Work Orders, Preventive and Checks.

What you enter

  • An as-of date (blank uses today) and target days to close by priority
  • Up to 15 properties and 30 vendors
  • Work orders: date, property, category, priority, vendor, status, cost, completion date and charge-back amount
  • Up to 60 preventive tasks with frequency and last-done date

What it calculates

  • Open and overdue flags and days open or to close per work order
  • Net cost per property; jobs and total paid per vendor
  • Next due date and status per preventive task
  • Eight dashboard figures, cost by category with a bar chart, and five checks

How to use it

Fill Settings, Properties and Vendors, delete the sample rows, then add one row per repair request. Every check should read OK.

File and limitations

One .xlsx file for Excel 2016+ and Google Sheets. No macros. Sample data is fictional. Built with AI assistance and checked for formula errors. A record-keeping tool, not tax, legal or accounting advice.

You must log in to submit a review.