Lease Renewal Tracker
Upcoming lease end dates, proposed rent bumps, 30/60/90-day windows and a Monday pipeline.
Never miss a lease end date.
Track every unit with lease end, current rent, proposed rent, status and notice-sent date.
Calculated for you
- days until lease end
- window: Past due, 0–30, 31–60, 61–90, 90+ days
- rent bump $ and %
- a suggested action for each row
Dashboard counts open renewals, past-due and near-term windows, offers in flight, and average proposed bump %.
Pipeline tab (SAMPLE) is a Monday view of open renewals sorted soonest-first.
Includes a blank workbook, a SAMPLE with 8 leases, and a PDF guide.
Works in Excel 2010+, Google Sheets and LibreOffice. No macros.
Tested: every calculated cell in the SAMPLE was recalculated in LibreOffice and matched an independent Python model.
Not legal advice. Renewal notice periods vary by state and lease.
Built with AI assistance and tested by running it end to end (details in the guide).
Refunds: 30-day refund if it doesn't work as described (refund policy).
Learn the method (free)
- Lease Renewal Tracker Spreadsheet: Lease Expiration Alerts, Notice Deadlines and Rent Increases (Excel & Google Sheets)
Build a landlord spreadsheet that flags leases expiring in 30, 60 and 90 days, works out the last day to send a renewal or rent-increase notice, and calculates each proposed rent bump. Exact formulas, tested by recalculating a sample workbook.
Related free tools
- Free Rental Property Calculator: Cash Flow, Cap Rate, Cash-on-Cash, DSCR
Instant rental deal math in your browser: monthly cash flow, NOI, cap rate, cash-on-cash return, DSCR, GRM, 1% rule and break-even occupancy.
Checkout, delivery, receipts and sales tax are handled by Gumroad. Questions after purchase: reply to your Gumroad receipt email. Not tax, legal or financial advice.