February 16, 2026 · 9 min read

Free Landlord Spreadsheet Templates (and Why You'll Outgrow Them)

Every landlord starts with a spreadsheet. Most landlords eventually hate it. Here's what to put in yours — and how to know when it's time to move on.

If you just bought your first rental property, congratulations. Your second purchase will be a spreadsheet template. Maybe a Google Sheets rent roll. Maybe an Excel expense tracker someone shared on Reddit. Maybe something you cobble together at 11 PM the night before you need to file taxes.

Spreadsheets are the duct tape of property management. They work. They're free. And they'll hold everything together — until they don't.

This guide gives you actual templates you can copy today, explains what each one should track, and — honestly — tells you when a spreadsheet stops being "good enough" and starts costing you money.

Why Every Landlord Starts with a Spreadsheet

It makes sense. You have one property, maybe two. You're collecting rent from a few tenants. Why would you pay for software when Google Sheets is free and you already know how to use it?

This is a sentiment echoed constantly in landlord communities:

"Inherited a building with 6 apartments and 2 businesses downstairs... previous family member who held the property was very hands-off when it came to keeping records. Basically learning everything from scratch and trial by fire." — r/realestateinvesting

That post got dozens of replies, and almost every one recommended... another spreadsheet. Because when you're starting out, a spreadsheet is the right answer. The problem comes later.

The 4 Spreadsheets Every Landlord Needs

Whether you use one mega-spreadsheet with tabs or four separate files, here's what you need to track:

1. Rent Roll (Who Owes What, and Did They Pay?)

This is the big one. A rent roll tracks every tenant, their monthly rent amount, and payment status for each month.

Unit	Tenant	Rent	Jan	Feb	Mar
101	Jake M.	$950	✅ 1/2	✅ 2/1	⏳
102	Sarah K.	$1,100	✅ 1/3	✅ 2/5	⏳
103A	Chris D.	$625	✅ 1/1	⚠️ Late	⏳

Key columns: Unit, tenant name, lease start/end, monthly rent, payment date for each month, notes (partial payments, late fees applied, etc.)

Pro tip: Color-code aggressively. Green for paid, yellow for partial, red for late, gray for vacant. You should be able to glance at the sheet and know your situation in 3 seconds.

2. Expense Tracker

Every dollar you spend on a property needs to be logged — not just for budgeting, but for taxes. The IRS lets you deduct repairs, maintenance, insurance, property management fees, and dozens of other expenses on Schedule E. But only if you can prove them.

Key columns: Date, property, category (repair, maintenance, insurance, utilities, legal, etc.), vendor/payee, amount, receipt (link to photo or file), notes.

At tax time, you filter by property and category, sum it up, and hand it to your accountant. Without this, you're digging through bank statements and shoe boxes of receipts.

3. Tenant Contact Sheet

Simple but critical: every tenant's name, phone, email, emergency contact, lease dates, rent amount, security deposit amount, and move-in condition notes. When someone's toilet explodes at 2 AM, you don't want to be searching your email for their phone number.

4. Maintenance Log

Track every maintenance request: date reported, unit, description, vendor assigned, date completed, cost. This protects you legally (you can prove you addressed issues promptly) and helps you budget for recurring problems.

"I'd like to see some examples if possible? Trying to make a spreadsheet via Google Sheets to track my income and expenses of my house hack." — r/Landlord

The fact that this question gets asked every week on r/Landlord tells you something: there's no universally agreed-upon template. Everyone builds their own. And that's part of the problem.

Where to Find Free Templates

You don't need to build from scratch. Here are legitimate free sources:

• Google Sheets template gallery — Search "rental property" in the template gallery. Basic but functional.
• Landlord Studio — Offers a free downloadable spreadsheet template with income and expense tracking. Frequently recommended on Reddit.
• Stessa — Has a free rental property financial tracking tool (not a spreadsheet, but free and spreadsheet-like).
• Vertex42 — Excel-focused templates including rental income trackers and property management sheets.
• BiggerPockets forums — Members share custom spreadsheets regularly. Search the forums for "rent roll template" or "expense tracker."

Download one, customize it, and start using it today. Seriously — even a bad spreadsheet is better than tracking rent payments in your head or in a text thread.

The 5 Ways Spreadsheets Break Down

Spreadsheets are great tools with a hard ceiling. Here's when you'll hit it:

1. Roommate Rentals

If you rent a 4-bedroom house to 4 individual tenants, your rent roll suddenly needs to track 4 people per unit, each paying different amounts at different times via different methods. Spreadsheet formulas weren't built for "Chris paid $400 of his $625 via Zelle on the 3rd, then sent the rest from his mom's account on the 7th."

This is the exact chaos we wrote about in How to Collect Rent from Roommates Without Losing Your Mind.

2. Payment Matching

You get a Zelle notification: "$950 from J. Martinez." Great — is that Jake in unit 101 or his dad sending rent on his behalf? Is it January rent or a late December payment? Your spreadsheet doesn't know. You open your bank app, cross-reference, and update manually. Every. Single. Month.

3. Late Fee Calculations

You can build a late fee formula in Excel. It'll work until someone pays 3 days late, you waive the fee, they pay partial next month, and now your formula is producing numbers that make no sense. Late fees with edge cases require logic that spreadsheets handle poorly.

4. Tax Time

Your accountant asks for a Schedule E breakdown by property. You have 3 properties across 2 spreadsheets and a folder of receipt photos. You spend an entire weekend reconciling numbers that don't match your bank statements because you forgot to log a $200 plumber visit in August.

5. Scaling Past 5-10 Units

One spreadsheet for 2 units? Easy. A spreadsheet system for 10 units with 25 tenants, maintenance requests, lease renewals, and expense tracking? You're now maintaining a homegrown property management system. Except it has no backup, no mobile access, no automation, and it breaks every time you accidentally sort column B without selecting the whole row.

"I've been trying to build my own 'Mega Excel' for years now, tried hundreds of Templates... never found exactly what I need." — r/uklandlords

This is the spreadsheet trap. You keep adding tabs, formulas, and conditional formatting — trying to build software out of a tool that was designed for simple calculations. At some point, you're spending more time maintaining the spreadsheet than managing the property.

When to Upgrade from a Spreadsheet

There's no magic number, but here are the signs:

• You're spending 30+ minutes per month on data entry and reconciliation
• You've missed a late fee because you didn't notice a payment was short
• Tax prep takes more than a day of sorting through your spreadsheet
• You manage roommate rentals where multiple tenants pay different amounts per unit
• You've had a "spreadsheet disaster" — accidental deletion, formula corruption, or version confusion
• You're past 3-4 units and the tabs are multiplying

If two or more of those apply, it's time to look at actual property management software. The good news: you don't need to jump to enterprise tools like Buildium or AppFolio. There are options built specifically for small landlords. (We compared the best ones in our 2026 property management software guide.)

What to Look for in a Spreadsheet Replacement

When you do upgrade, don't just pick the first tool with good marketing. Look for:

• Per-tenant tracking — especially if you have roommates or shared housing
• Bank connection — automatic transaction import so you're not doing manual data entry
• Expense categorization — aligned with Schedule E categories for tax time
• Late fee automation — configurable rules that handle edge cases
• E-signatures — so you're not printing, scanning, and mailing leases
• A free tier — because the whole point is you started with a free spreadsheet; you shouldn't need to spend $50/month to manage 3 units

Rentlane was built for exactly this transition. The free plan gives you manual rent tracking and e-signatures — basically replacing your rent roll spreadsheet and your DocuSign subscription in one shot. Upgrade to Pro ($5/month) when you want AI-powered payment matching that automatically connects Zelle transactions to the right tenant.

Your tenants don't need to create accounts or change how they pay. They keep Zelle-ing you. Rentlane just makes sure you actually know who paid.

The Spreadsheet Is a Starting Point, Not a Destination

There's no shame in using a spreadsheet. Every landlord with 50+ units started with one. The mistake isn't starting with a spreadsheet — it's staying with one long after it's costing you time, money, and sanity.

Grab a template. Use it. Learn what you actually need to track. And when the spreadsheet starts fighting you instead of helping you, take that as the sign it is.