HonestFix

Free Landlord Maintenance Tracking Spreadsheet Template (+ Better Alternative)

Last updated: January 2026 | 5 min read

If you manage rental properties, you need to track maintenance requests somewhere. Many landlords start with spreadsheets, and honestly, spreadsheets work well enough for small portfolios with low request volume.

This guide gives you a ready-to-use spreadsheet template, explains when spreadsheets make sense, and covers when it is time to upgrade to something better.

Table of Contents

  1. The Spreadsheet Template
  2. How to Use This Template
  3. When Spreadsheets Work Well
  4. When Spreadsheets Break Down
  5. The Better Alternative

The Spreadsheet Template

Here is a maintenance tracking spreadsheet structure you can copy directly into Google Sheets, Excel, or your preferred tool.

Main Tracking Sheet

Create a sheet called "Requests" with these columns:

| Column | What It Tracks | Example | |--------|----------------|---------| | A: Request ID | Unique identifier | MR-001 | | B: Date Reported | When tenant reported | 2026-01-15 | | C: Property | Which property | 123 Oak Street | | D: Unit | Which unit | Unit 2B | | E: Tenant Name | Who reported | Sarah Johnson | | F: Issue Description | What is broken | Garbage disposal not turning on | | G: Category | Type of issue | Appliance | | H: Priority | How urgent | Normal / Urgent / Emergency | | I: Status | Current state | New / In Progress / Scheduled / Completed | | J: Assigned To | Who is handling | Self / Contractor name | | K: Date Scheduled | When work scheduled | 2026-01-18 | | L: Date Completed | When resolved | 2026-01-18 | | M: Cost | What you spent | $150 | | N: Notes | Additional details | Needed new disposal unit | | O: Photo Link | Link to photos | [Drive link] |

Category Options

Use these standard categories (data validation dropdown):

  • Plumbing
  • Electrical
  • HVAC
  • Appliance
  • Structural
  • Exterior
  • Pest Control
  • Cosmetic
  • Safety
  • Other

Priority Levels

  • Emergency: Health/safety risk, no heat, major water leak, gas smell
  • Urgent: Affects habitability but not immediately dangerous
  • Normal: Should be fixed but can wait a few days

Status Options

  • New: Just received, not yet reviewed
  • In Progress: Being worked on
  • Scheduled: Contractor appointment set
  • Completed: Work finished
  • Canceled: Request withdrawn or invalid

How to Use This Template

Step 1: Set Up Your Spreadsheet

  1. Open Google Sheets or Excel
  2. Create a new spreadsheet called "Maintenance Tracking"
  3. Copy the column headers from the table above
  4. Set up data validation dropdowns for Category, Priority, and Status columns

Step 2: Create Data Validation

For Google Sheets:

  1. Select the entire Category column (Column G)
  2. Go to Data > Data validation
  3. Choose "Dropdown" and add your category options
  4. Repeat for Priority (Column H) and Status (Column I)

Step 3: Set Up Conditional Formatting

Make urgent items stand out:

  1. Select the entire sheet
  2. Go to Format > Conditional formatting
  3. Create rules:
    • If Priority = "Emergency" -> Red background
    • If Priority = "Urgent" -> Yellow background
    • If Status = "Completed" -> Gray text

Step 4: Create a Dashboard View (Optional)

Add a summary tab that shows:

  • Open requests by property
  • Requests by priority
  • Monthly spending totals
  • Average days to resolution

Use COUNTIF and SUMIF formulas:

=COUNTIF(Requests!I:I, "New")  // Count open requests
=SUMIF(Requests!I:I, "Completed", Requests!M:M)  // Sum completed costs

Step 5: Establish Your Workflow

When a request comes in:

  1. Add a new row with today's date
  2. Generate a Request ID (increment from last one)
  3. Fill in property, unit, tenant, and description
  4. Set initial status to "New"
  5. Determine priority and category
  6. Update status as you work the request

When Spreadsheets Work Well

Spreadsheets are a reasonable solution when:

You Have 1-2 Properties

With low request volume (maybe 1-3 requests per month), a spreadsheet provides sufficient tracking without monthly software costs.

Requests Come Through You Anyway

If tenants call or email you directly and you are entering information manually regardless, a spreadsheet centralizes that information just as well as software.

You Want Zero Cost

Spreadsheets are free. If you are cash-constrained or just starting out, a spreadsheet lets you build good habits without monthly fees.

Your Primary Need Is Documentation

If you mainly want a record for tax purposes or dispute resolution, and tenant communication is not a pain point, spreadsheets handle documentation well.

You Are Tech-Comfortable

If you enjoy building spreadsheet systems and want full customization control, spreadsheets let you design exactly what you need.

When Spreadsheets Break Down

Spreadsheets work until they do not. Here are the warning signs that you have outgrown spreadsheet-based tracking:

You Are Manually Copying Information Constantly

When tenants email you a request and you have to:

  1. Copy their description into the spreadsheet
  2. Download their photo and upload to Drive
  3. Send them a confirmation email
  4. Later send them a status update email

...you are doing a lot of manual work that software automates.

Tenants Keep Asking for Status Updates

If you find yourself fielding multiple "What is the status?" messages per request, you need automatic status notifications. Spreadsheets do not send emails.

You Are Missing Requests

If requests slip through the cracks because they are in email and you forgot to add them to the spreadsheet, you have a system problem. Software eliminates this failure mode.

You Have More Than 3 Properties

As request volume grows, spreadsheet maintenance becomes its own time sink. When you spend more time updating the spreadsheet than managing actual repairs, something is wrong.

You Need Contractor Coordination

Spreadsheets have no way to notify contractors of new jobs. You are copying and pasting information into emails manually. Software handles this with one tap.

You Want Tenant Self-Service

If you wish tenants could check status themselves instead of contacting you, spreadsheets cannot help. You need a tenant-facing status page.

The Spreadsheet vs Software Decision

Here is a simple framework:

| Factor | Stick with Spreadsheet | Consider Software | |--------|------------------------|-------------------| | Properties | 1-2 | 3+ | | Monthly Requests | Under 5 | 5+ | | Time Spent Managing | Under 1 hour/mo | Over 2 hours/mo | | Tenant Status Questions | Rare | Frequent | | Contractor Coordination | Minimal | Regular | | Budget | Very constrained | $19-40/mo available |

If you are on the fence, ask yourself: Would I pay $19/month to save 3 hours?

At $19/month, maintenance software costs about $6 per request processed if you have 3 requests per month. If the software saves you 20 minutes per request, you are paying roughly $18/hour for your time back.

Most landlords find that math favorable once they have more than 2-3 properties.

The Better Alternative

If you have identified that spreadsheets are not enough, dedicated maintenance software offers significant advantages:

What Software Adds Over Spreadsheets

Tenant Submission Links

Instead of tenants emailing or texting you, they submit through a dedicated link. Information goes directly into the system with photos, no manual copying required.

Automatic Status Notifications

When you update a request status, tenants receive email notifications automatically. No more "What is the status?" messages.

Tenant Status Pages

Tenants can check request status anytime via a unique link. They see exactly where things stand without contacting you.

Contractor Assignment

One tap assigns a contractor and sends them an email with all job details: address, access instructions, photos, tenant contact info.

Emergency SMS Alerts

When a tenant flags a request as emergency, you receive an immediate SMS. No more discovering water leaks 8 hours after the email.

Per-Request Expense Tracking

Log costs against specific requests with receipts. Export for taxes with actual data, not spreadsheet estimates.

Searchable History

Find any request instantly. When was the last time Unit 2B reported a plumbing issue? One search, instant answer.

HonestFix: Built for Small Landlords

HonestFix is maintenance software designed specifically for landlords with 1-30 units. It solves the exact problems spreadsheets create:

| Spreadsheet Pain Point | HonestFix Solution | |------------------------|-------------------| | Manually entering requests | Tenant submission links | | Sending status update emails | Automatic notifications | | "What's the status?" questions | Tenant status pages | | Forwarding info to contractors | One-tap assignment | | Missing urgent requests | Emergency SMS alerts | | Scattered photos | Photos stored with requests |

Pricing:

  • Starter: $19/month (up to 5 units)
  • Growth: $39/month (up to 15 units)
  • Scale: $99/month (up to 30 units)

All plans include unlimited requests, SMS alerts, and full features.

21-day free trial, no credit card required.

If you have been managing maintenance with a spreadsheet and are feeling the pain, HonestFix is the logical next step.

Join the Founder-Led Beta

Summary

Spreadsheets work for maintenance tracking when:

  • You have 1-2 properties
  • Request volume is low (under 5/month)
  • You do not mind manual data entry
  • Tenant communication is not a pain point

Spreadsheets break down when:

  • You are spending significant time on data entry
  • Tenants keep asking for status updates
  • Requests slip through the cracks
  • Contractor coordination becomes tedious

The spreadsheet template above will serve you well if you are in the first category. If you are in the second, dedicated software like HonestFix pays for itself in time savings.

The best approach: start with a spreadsheet, track your time honestly, and switch to software when the math makes sense. For most landlords, that point arrives somewhere between 2 and 5 properties.

Try HonestFix Free - Upgrade When You Are Ready

Related Articles: