Tax year 2026 closes in 52d10h13m55sStart your records now, not in March. Get all 5 templates for $59
Home / Templates / Lease & Tenant Tracker
For landlords who manage their own tenants

Know which leases end next, and who still owes rent.

Track units, leases, deposits and monthly rent in one spreadsheet. Lease status, renewal-notice dates and balances work themselves out.

$17one-time · instant download
Buy now: instant access
Excel + Google SheetsNo subscriptionSecure checkout
Best value: get this plus 4 more templates in the Landlord Toolkit for $59 (save $42) →
  • Up to 40 units and 100 leases, with status worked out for you
  • Renewal-notice dates and an 'expiring soon' list you can tune
  • A 12-month rent-collection grid with balances and late flags
  • Deposits held, occupancy and monthly rent roll on one dashboard
What's inside

A tour, tab by tab

Screenshots show the included sample data. Click any screenshot to enlarge it.

Tab · Leases

Leases

Tenants, unit, contact details, start and end dates, rent, deposits and notice days. Status (upcoming, active, expiring soon, month-to-month or ended), days left and the renewal-notice date are calculated.

Leases
Leases: status, days left and the date to send the renewal notice.
Tab · Rent Collection

Rent Collection

Each lease mirrored automatically, with 12 monthly columns for what you received. Due-to-date, received-to-date, balance and a late-this-month flag update as you type.

Rent Collection
Rent Collection: what was due, what came in and what's still owed.
Tab · Dashboard

Dashboard

Occupancy, monthly rent roll, deposits held, leases ending in 30/60/90 days and total balance owed, plus checks for overlapping leases and missing details.

Dashboard
Dashboard: occupancy, rent roll, deposits held and leases ending soon.

Start Here

Settings for the rent-collection year, the 'as-of' date (blank means today), the expiring-soon window and the day rent counts as late.

Units

Property, unit, beds, baths, square feet and market rent, plus the current tenant and whether the unit is occupied, filled in from your leases.

In your download

Everything arrives in under a minute

Lease & Tenant Tracker (Excel, with sample data)

A blank Excel copy, ready for your records

A one-click Google Sheets copy link

A Start Here tab with setup steps

Is it right for you?

Who it's for

A great fit for

  • Landlords who handle their own leases and rent
  • Small portfolios where a full property-management app is overkill
  • Anyone who wants renewal dates and deposits in one place

Not built for

  • Online rent collection, tenant screening or e-signing leases
  • More than 40 units or 100 leases
Why it's the smart buy

More built in than a free template. A fraction of a subscription.

Everything a small landlord needs for the 2026 tax year, without another monthly bill or a bank login.

Our templatesRent & TallySubscription landlord appsFree templates onlineShoebox + bank statements
One-time price, no monthly feeYesMonthly or yearly feeFreeFree
Ready for tax year 2026 (mileage rates, $2,000 1099-NEC threshold)Built inVariesRarely updatedNo
Schedule E-style expense categories13 categoriesVariesSometimesNo
Contractor totals and likely 1099-NECsYesVariesRarelyNo
Works in Excel and Google SheetsBothApp onlyUsually oneNo
No bank login neededNever askedOften asks to linkYesYes
Built-in checks catch missing dataYesVariesRarelyNo
You keep your file foreverYesTied to your planYesPaper only
Sample data and a setup guideYesUsuallySometimesNo

A general comparison of common alternatives, not of any specific product. Features of individual apps and templates vary.

Questions

Lease & Tenant Tracker FAQ

Does it collect rent or send reminders?

No. It's a tracker: you record what came in and it shows what's due, received and owed. Reminders appear as dates and flags in the sheet.

How is 'expiring soon' decided?

A lease is 'expiring soon' when its end date falls within the window you set on Start Here (60 days by default). Leases without an end date show as month-to-month.

Can I track several tenants on one lease?

Yes. Type all names in the Tenant field of one lease row.

Does it handle state deposit rules?

It records deposits held. Rules on deposits vary by state, so confirm yours locally.

Do they work in Google Sheets as well as Excel?

Yes. Every template comes as Excel files (sample and blank) plus a link that puts your own copy in Google Drive in one click. Excel 2010 or later on Windows or Mac, and Excel for the web, all work. No macros or add-ins.

Is there a subscription?

No. Each template is a one-time purchase. The file is yours to keep and use.

How do I get my files?

Right after checkout you'll see your download and Google Sheets links, and we email them to you as well.

Pairs well with

Complete your setup

Best value · save $42

The Landlord Toolkit

Five spreadsheets that run the whole landlord year: the books, the leases and rent, the contractors, the turnovers and your next purchase. One download, one price, yours to keep.

  • Rental Bookkeeping 2026$27
  • Lease & Tenant Tracker$17
  • Contractor 1099 Tracker 2026$15
  • Inspection & Maintenance Log$15
  • Rental Property Deal Analyzer$27

See everything in the Toolkit

Best value
Bought separately: $101
$59
You save $42
That's $11.80 per template, paid once.
The Toolkit price goes up to $79 on Jan 1, 2027.
Get all 5 now

Instant download · Excel + Google Sheets · One-time price

Tax year 2026 closes · Dec 31, 2026
52days
10hrs
13min
55sec

Lease & Tenant Tracker, ready in minutes

Every unit, lease and deposit in one place, with renewal reminders and a monthly rent-collection grid.

  • Instant download
  • Excel + Google Sheets
  • One-time price
  • No subscription