When you own 1-4 rental properties, most property management software is overkill. You do not need a $58/month platform built for a company managing 200 units. But you also cannot keep running your portfolio on a spreadsheet designed for tracking grocery expenses.
What you actually need is a spreadsheet built specifically for small landlords — one that tracks the right numbers without requiring an accounting degree to maintain. So I built one. It is free. Here is what is in it and how to get it.
What Most Landlord Spreadsheets Get Wrong
Most free templates you find on Reddit or Google are designed for tracking rent payments and not much else. They miss the numbers that actually matter when you are trying to evaluate whether a property is performing well or dragging down your portfolio:
- NOI (Net Operating Income) — your property earnings before mortgage payments
- Cash-on-Cash Return — how much cash you make relative to what you invested
- Vacancy tracking — empty units cost more than most landlords realize
- Expense categories — repairs vs maintenance vs capital improvements — these matter at tax time
- Mortgage balance tracking — your equity grows every month; most landlords never track it
If your current spreadsheet cannot tell you exactly how much cash you will have left if a tenant moves out next month, it is not a financial tool — it is just a digital receipt drawer.
What This Spreadsheet Includes
The spreadsheet is organized into seven tabs, each handling a different part of your portfolio:
SETUP — Enter your property addresses, purchase prices, down payments, and loan terms. This tab feeds every calculation in the spreadsheet.
MORTGAGE PAYMENTS — Track principal and interest breakdowns month by month. See exactly how much equity you are building and how much is going to the bank.
RECURRING EXPENSES — Property taxes, insurance, HOA, water, sewer, trash — anything you pay on a regular schedule. Enter it once and it populates across the year.
VARIABLE EXPENSES — Repairs, maintenance calls, capital improvements, and one-time costs. Categorized so your CPA does not have to guess at tax time.
TENANT INFORMATION — Lease dates, rent amounts, contact info, and move-in/move-out tracking. One place for everything you need when a tenant calls or a lease expires.
INCOME — Rent collected, late fees, pet fees, parking income — everything that puts money in your account. Tracks actual collections, not just what tenants owe.
DASHBOARD — The summary view. NOI, cash-on-cash return, cap rate, total expenses, and net cash flow — calculated automatically from the other tabs. This is the tab you open when you want to know how your portfolio is actually doing.
Who This Is Built For
This spreadsheet is designed for landlords who own 1-4 rental properties and self-manage. It is not for property management companies with 50 units. It is not for real estate syndicators running a fund. It is for the landlord who bought a duplex, then a 4-plex, and now needs a better way to see if the numbers actually work.
The dummy data in the spreadsheet uses properties in Dayton and Cincinnati, Ohio — because that is where I invest. But it works for any market. Replace the numbers with your own and the formulas do the rest. Most landlords finish the initial setup in 30-60 minutes.
How to Get It
The spreadsheet is a Google Sheets file. Send us an email and we will reply with the link. Make a copy, replace the dummy data with your own numbers, and you are set.
Download the Free Landlord ROI Spreadsheet
Google Sheets format. Works on any device. No account required — just make a copy to edit.
When the Spreadsheet Is Not Enough
This spreadsheet works well for 1-4 properties. Once you hit 5 or more units, the manual data entry starts to feel like a second job. That is exactly where RealAnalyticsPro picks up — automated rent collection, real-time NOI dashboards, and tenant portals that eliminate the back-and-forth. Start with the spreadsheet. Graduate to the platform when you outgrow it.
Conclusion
The best financial system is the one you will actually use. Start with this spreadsheet. Add your first property this week. Run the NOI formula once. You will have a clearer picture of your portfolio in 30 minutes than most landlords get in a year.