Free Rental Property Spreadsheet for Landlords

Most small landlords run their rentals from memory and a text thread. It works — right up until it doesn't. Rent arrives by Zelle one month and check the next, a tenant swears they paid on the 3rd, a lease quietly expires into month-to-month, and the same sink gets snaked twice because nobody wrote down the first visit. None of those are big failures. They're what happens when the system is your memory.

A spreadsheet fixes this for a small portfolio, and you don't need to buy one. This page is the complete blueprint: three sheets, every column explained, sample rows so you can see each sheet working, the one formula worth having, and the conditional-formatting rule that makes late rent impossible to miss. Open a blank Google Sheets or Excel file, create three tabs, and copy the headers as you read.

Prefer paper for the rent side? The printable rent ledger template is the same idea in a print-and-write format, one page per lease.

Sheet 1: Rent Payment Tracker

The sheet you'll open most. One row per unit per month, and one glance answers the only question that matters on the 5th: who hasn't paid?

• Unit — Property and unit identifier — "12 Oak St A" beats "Unit A" once you own two buildings.
• Tenant — Primary tenant name. Full roster lives in the directory sheet; this is just enough to read the row.
• Rent Due — The monthly rent amount under the lease.
• Date Due — The actual calendar date for this month (e.g., 8/1/2026), not just "the 1st" — the Days Late formula needs a real date.
• Date Paid — The day the money actually arrived. Blank means unpaid — the most important blank in the sheet.
• Amount Paid — What was received. Differs from Rent Due when a payment is partial.
• Method — Zelle, check (with number), cash, money order. Matters when a tenant says "I already paid."
• Balance — Rent Due minus Amount Paid: =C2-F2. Zero means current.
• Days Late — Formula column — see below. Turns "they're a little behind" into a number.
• Notes — Partial-payment agreements, bounced checks, anything you'd want to remember in six months.

Sample data — replace with your own units and tenants.

The Days Late formula

With Date Due in column D and Date Paid in column E, put this in the Days Late cell of row 2 and fill it down:

=IF(E2="", MAX(0, TODAY()-D2), MAX(0, E2-D2))

Read it as: if there's no payment date yet, count days from the due date to today; once a payment date exists, count due-to-paid. The MAX(0, ...) stops early payments from showing negative days. It works identically in Google Sheets and Excel. Then add one conditional-formatting rule: select the data rows and create a rule that turns the whole row red when the Days Late cell is greater than 0 (in Google Sheets, use a custom formula like =$I2>0 applied to the row range). Now unpaid rent is a red stripe you can see from across the room.

The monthly ritual: on the 1st, copy last month's rows, paste them below, clear Date Paid, Amount Paid, Method, and Notes, and update Date Due. As payments land, fill in the row the same day — a tracker updated "when I get to it" is a tracker you can't trust. When a row stays red past your grace period, that's your cue to send a receipt for what was paid and follow the steps in our guide on what to do when a tenant isn't paying rent — documented, calm, and in order.

Sheet 2: Tenant & Lease Directory

One row per tenancy. This is the sheet that ends the scroll through eleven months of texts to find a phone number, and — more importantly — the one that stops leases from expiring without you noticing.

• Unit — Same identifiers as the rent tracker, so the sheets cross-reference cleanly.
• Tenant name(s) — Every adult on the lease, not just whoever texts you.
• Phone — The number you actually reach them at.
• Email — For anything you want in writing.
• Lease Start — Move-in / lease commencement date.
• Lease End — The date that sneaks up on landlords — this column exists so it can't.
• Rent — Current monthly rent, so you never quote an old number.
• Deposit Held — Security deposit amount you are holding for this tenancy.
• Pet Deposit — Kept separate from the security deposit, because it is.
• Emergency Contact — Name and phone. You want this before the 2 a.m. call, not during it.
• Renewal Reminder Date — Lease End minus 90 days: =F2-90. The date you start the renewal conversation.

Sample data — names, numbers, and addresses are fictional.

The Renewal Reminder column earns its keep: set it to =F2-90 (Lease End minus 90 days), then put a recurring event in your phone's calendar for each date. Ninety days out is enough time to decide on a rent change, send a lease renewal letter, and — if the tenant is leaving — list the unit before it sits empty. Leases that lapse into month-to-month by accident are how landlords end up with their worst terms on their best units. If you're setting up a first lease rather than renewing one, start with the lease agreement template.

Sheet 3: Maintenance Log

One row per repair request, forever. This sheet looks optional until the second time you pay to unclog a drain that needed replacing the first time.

• Date Reported — When the tenant told you — the clock a judge or a frustrated tenant will care about.
• Unit — Same identifiers again.
• Issue — Specific enough to search later: "kitchen sink drains slowly" beats "plumbing."
• Urgency — Emergency / Soon / Whenever. Three levels is enough; ten is a system nobody maintains.
• Contractor — Who did the work — this column becomes your vetted-vendor list over time.
• Status — Reported / Scheduled / Done. Anything still "Reported" after a week is your to-do list.
• Date Completed — Closes the loop and shows how long repairs actually take.
• What It Cost — The invoice amount, logged so you can spot the same fix recurring.

Sample data — note rows 1 and 2: the same drain, twice.

The history is the point. In the sample above, the June entry only looks like a routine call-out if you can't see March — with both rows visible, it's obviously the same failing line, and the right move is a repair, not a third snaking. Memory can't do that across units and years; a searchable log can. It also protects you the other direction: when a tenant claims a problem was "reported months ago," Date Reported and Date Completed are your answer. Sort the sheet by Unit occasionally and read each property's history top to bottom — patterns you'd never notice request-by-request jump out.

Where a Spreadsheet Stops Working

Built as described, this system genuinely works — plenty of landlords run a few units on exactly this for years. But it has four limits worth knowing before you hit them, because they arrive gradually and then all at once:

• Tenants can't pay you through it. The spreadsheet records rent; it doesn't collect it. You're still juggling Zelle, checks, and cash apps — each with its own way of arriving late or getting disputed.
• You're re-typing what a payment system records itself. Every Date Paid, Amount Paid, and Method cell is you manually copying information that already exists in a bank notification. That's the whole tracker: transcription.
• Update debt compounds with units. Two units is a few minutes a month. Ten units is dozens of cells across three sheets, every month, forever — and one wrong cell (a payment logged against the wrong unit) quietly poisons your trust in the whole file.
• Nothing reminds you. The sheet knows rent is six days late and a lease ends in August. It will never tell you. Every follow-up still depends on you opening the file at the right moment.

If you're at one or two units, ignore all of this and go build your sheets. If you recognized your Saturday mornings in that list, the next section is the honest alternative.

Frequently Asked Questions

Related templates: printable rent ledger · rent receipt · lease agreement · lease renewal letter.