Rental Property Maintenance Spreadsheet Template (Free Download) — and When to Move On
A free Google Sheets template for tracking rental property maintenance. Plus: how to know when a spreadsheet stops working and what to use instead.
A spreadsheet is how most landlords start tracking maintenance. It works. Until it doesn't.
This post gives you a free Google Sheets template structure you can build in 15 minutes, explains how to set it up for multiple properties, and then tells you honestly where spreadsheets break down — and what to do when that happens.
The Template Structure
The template uses one tab per property. Within each tab, you track tasks in rows with the following columns:
Column Structure
Setting Up the Next Due Column
Use a simple formula. If Last Completed is in column D and you want Next Due in column E:
For monthly tasks: =IF(D2="","",D2+30)
For quarterly tasks: =IF(D2="","",D2+91)
For annual tasks: =IF(D2="","",D2+365)
Setting Up the Status Column
A conditional formula that checks today's date against Next Due:
=IF(E2="","No date set",IF(TODAY()>E2,"OVERDUE",IF(TODAY()>=E2-14,"DUE SOON","Upcoming")))
Apply conditional formatting: red for OVERDUE, yellow for DUE SOON, green for Upcoming.
Summary Tab
Add a summary tab that pulls from each property tab using COUNTIF formulas:
- Total overdue tasks across all properties
- Total due in next 30 days
- Estimated maintenance costs this quarter
This gives you a single view when you have 2-4 properties.
Populating Your Task List
Start with these tasks across four categories. Add or remove based on your property type.
Safety (Monthly)
- Smoke detector test
- CO detector test
- Fire extinguisher check
HVAC (Variable)
- Air filter replacement (Monthly or every 3 months depending on filter type)
- HVAC service (Annual)
- Duct cleaning (Every 3-5 years)
Plumbing (Variable)
- Water heater flush (Annual)
- Check under-sink areas for leaks (Quarterly)
- Test shut-off valves (Annual)
Exterior (Seasonal)
- Gutter cleaning (Spring and Fall)
- Roof inspection (Annual)
- Exterior paint and caulking check (Annual)
- Driveway/walkway inspection (Annual)
Appliances (Annual)
- Dryer vent cleaning
- Refrigerator coil cleaning
- Dishwasher filter cleaning
This gives you 15-20 tasks per property to start. A 4-unit property might have 60-80 rows across tabs, which is still manageable in a spreadsheet.
What the Spreadsheet Does Well
Be honest about the strengths before moving on:
Low barrier to entry. You can have a working tracker in 20 minutes with no new tools, no accounts, no learning curve.
Fully customizable. Add columns for contractor phone numbers, warranty expiration, permit numbers. No tool tells you how to organize it.
Free. Google Sheets costs nothing. If you are managing one property and doing all the work yourself, this is a reasonable choice.
Shareable. Give a co-owner or property manager read access in two clicks.
Where Spreadsheets Break Down
Here is the honest part. Spreadsheets work until one or more of these things happen:
No Reminders
A spreadsheet does not notify you. You have to open it and check the status column. If you open it monthly, you catch things monthly. If you get busy and go six weeks without looking, tasks go overdue and you do not know.
For one property with 15 tasks, this is manageable. For three properties with 60 tasks, it is not. The spreadsheet becomes accurate documentation of what you missed.
You Stop Opening It
This is the most common failure mode. A spreadsheet is passive. There is no alert, no notification, no push on your phone. Life gets busy. The spreadsheet sits unchanged for months. You discover in November that the water heater flush was due in April.
No Mobile Access (In Practice)
Google Sheets is technically available on mobile. But opening Sheets, navigating to the right tab, scrolling to the right row, and updating a date while standing in a utility room is friction. Enough friction that you do not do it in the moment — you tell yourself you will update it later, and then you do not.
Sharing and Sync Problems
If you have a property manager or co-owner, spreadsheet sharing creates version problems. Who has edit access? What if two people update the same row? A shared sheet works for viewing but breaks quickly as a collaborative operational tool.
No History
When you update "Last Completed" to today, the previous date is gone. You lose your maintenance history. After two years, you cannot tell when you last replaced the anode rod on the water heater. You have one date, not a timeline.
Scaling Past 3-4 Properties
At 5+ properties, spreadsheet complexity grows fast. Multiple tabs, multiple summary formulas, cross-tab lookups. The spreadsheet that worked well at 1-2 properties becomes unwieldy at 5. This is where landlords often abandon it entirely and switch to nothing, which is worse.
When to Move On
The signal is simple: if you have missed tasks because you forgot to check the spreadsheet, the spreadsheet is not working.
A tool that requires you to remember to use it is not a maintenance system. It is a static record. There is a difference.
The next step up is a tool that:
1. Sends you reminders when tasks are due (or overdue)
2. Works on mobile without friction
3. Keeps a history of every completed task
4. Scales across multiple properties without getting complicated
That is exactly what FixReminder is built for. It is not property management software with a maintenance module bolted on. It is a maintenance-first tool that does one thing well: schedules recurring tasks and reminds you before they are due.
Free tier covers one property and ten tasks. That is enough for most landlords to start and see whether it fits.
See also: FixReminder vs. Spreadsheet for a direct comparison, and Google Calendar for Rental Property Maintenance if you are considering the calendar approach before committing to a dedicated tool.
Frequently Asked Questions
Is the spreadsheet template really free?
Yes. The structure described in this post is yours to build in Google Sheets or Excel at no cost. There is nothing to download — set up a new sheet, create the columns described above, and you are done in 15-20 minutes. Google Sheets is free to use with a Google account.
How many properties can I track in one spreadsheet?
Practically, 1-4 properties before the spreadsheet becomes hard to manage. Beyond that, the cross-tab formulas, scrolling, and manual update process creates enough friction that most landlords either stop maintaining it or miss tasks. At 5+ properties, a dedicated tool is worth the switch.
Can I share the spreadsheet with my property manager?
Yes. Google Sheets allows view or edit sharing via link or email. The limitation is collaborative editing — if two people update the same row simultaneously, you can get conflicts. For view-only access (manager checks status, landlord updates), it works fine. For active collaborative use, it breaks down quickly.
What is the difference between this spreadsheet and FixReminder?
The spreadsheet is passive — you have to open it to know what is due. FixReminder is active — it sends you reminders before tasks are due. The spreadsheet has no mobile-friendly update flow. FixReminder works on mobile. The spreadsheet overwrites history on every update. FixReminder keeps a log. For one property and one landlord who checks the spreadsheet religiously, the spreadsheet is fine. For most landlords, a tool that reminds you is more reliable than one that waits for you.
Should I migrate my spreadsheet data to a new tool?
If you switch to FixReminder, you do not need to migrate historical data. Set up your properties and tasks with current dates and go forward. The most important thing is getting reminders set up so you do not miss upcoming tasks — not preserving historical records from the spreadsheet.