How do I track lease expirations across my portfolio?
Track lease expirations by turning them into live critical dates — the date-driven obligations in a lease (expirations, renewal options, rent escalations, notice deadlines) — held in one system that alerts you ahead of each deadline and stages a tenant follow-up for approval. A spreadsheet works until it drifts. A dated, alerting record does not.
The problem isn't that owner-operators don't know their leases expire. It's that the rent roll — the running list of tenants, spaces, rents, and lease terms across a property or portfolio — falls out of date the moment someone forgets to update it. This guide covers why that happens and what replaces it.
Why do lease expirations slip through the cracks?
Expirations slip because the record that holds them is a snapshot, not a system. Someone builds a spreadsheet, it's accurate for a week, then a renewal moves, a suite gets subleased, and no one re-dates the file. The date arrives before the reminder does.
Three common failure points:
- The rent roll drifts. Every manual edit is a chance to miss one. Nobody owns the update, so the file quietly goes stale.
- Critical dates live in the lease PDF, not a calendar. A renewal notice window buried on page 14 is invisible until it's blown.
- Follow-up depends on memory. The person who "just knows" the portfolio is on vacation, or gone.
What are the critical dates I actually need to track?
The critical dates that move money are renewal and expiration dates, notice deadlines, rent escalations, and option windows. On a NNN lease — triple-net, where the tenant pays taxes, insurance, and maintenance on top of base rent — you also track reconciliation and reassessment triggers. Miss the notice window and you lose leverage or a tenant.
Track these per lease:
- Lease expiration date — the hard end of the term.
- Renewal / option notice deadline — the date by which you or the tenant must act, usually months ahead of expiration.
- Rent escalation dates — when base rent steps up.
- Free rent and TI burn-off — when concessions end.
- Estoppel and reconciliation triggers — especially on NNN structures.
The expiration date alone is not enough. The notice deadline is where deals are won or lost.
What does a working system look like?
A working system holds every lease as a live record, computes the dates that matter, alerts you with enough lead time to act, and stages the tenant follow-up for you to approve. You review and send. The record updates itself; you don't re-type a spreadsheet.
At Vantrow the operating principle is propose, never commit: the system stages the action — the alert, the drafted tenant email, the flag on the rent roll — and a human approves before anything goes out. Every step lands on an audit trail. That matters when a missed notice window is a legal question, not just an oops.
What to look for:
- One system of record, not five spreadsheets. The rent roll and the critical dates are the same object, always current.
- Lead-time alerts keyed to the notice deadline, not the expiration.
- Staged follow-ups the leasing team approves, so tenant outreach actually happens.
- An audit trail showing who was told what, when.
How is this different from a calendar reminder?
A calendar reminder fires once and forgets. It doesn't know the rent roll changed, doesn't draft the tenant email, and doesn't leave a record of who acted. A critical-date system ties the alert to the live lease record, stages the next step, and logs the outcome — so a slip becomes visible, not silent.
Calendar reminders also don't scale. Ten leases, fine. A portfolio of two hundred across a dozen buildings, with staggered renewal windows and different notice terms — that's where the manual approach quietly breaks, usually right before a deadline.