Find Expiring Leases Without Signed Renewals | Jolene.pro
One lease ends next month. Another ends in 70 days. The second one may need your attention first if its notice deadline is Friday and the renewal is still unsigned.
To build a useful follow-up list, compare your lease register with your renewal tracker. The lease register tells you when the current term ends. The renewal tracker tells you how far the conversation has actually gone.
Start with your lease register and renewal tracker
If you work in Excel, keep the property, unit or suite, lease ID, lease end date, recorded notice deadline, and current annual base rent in the lease register. In the renewal tracker, keep the lease ID, renewal status, and date signed, where available.
If you use property software, start with the upcoming expirations report your team already uses, such as Buildium’s Leases Ending report. Commercial teams can use the upcoming renewals they track in VTS. Bring the available spreadsheet export and the tracker your team uses to confirm signatures. Buildium’s Leases Ending report · VTS Lease
Sort by the deadline that needs action
- Find leases ending in the next 90 days. Match the renewal tracker to the current lease ID so an older renewal doesn’t get attached to the wrong term.
- Separate signed renewals from open ones. Keep “offer sent,” “verbally agreed,” and “signed” as distinct statuses. Flag missing or conflicting records for review.
- Sort the open renewals by notice deadline. Put overdue deadlines first, then upcoming ones. Keep missing deadlines in a separate group so someone can check the lease record.
In a sample portfolio, Cedar’s lease ends in 70 days, its renewal is unsigned, and notice is due Friday. Harbor’s lease ends in 30 days, but the renewal is already signed. Cedar gets the first call. Its current annual base rent is $96,000, which gives the leasing team a sense of what’s tied to that decision.
What to ask Jolene.pro
Add the lease register and renewal tracker, then ask:
Which leases expire in the next 90 days without a signed renewal? Sort by recorded notice deadline, flag missing dates, and show the suite, current annual base rent, and source rows.
Use the list in your weekly leasing meeting. Give each open renewal an owner and a next action. For Cedar, that means confirming the notice date and calling the tenant before Friday.