Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesReal Estate & PropertyRental Property ManagementLease Renewal & Expiry Tracker

SpreadsheetRental Property ManagementFree

Lease Renewal & Expiry Tracker

Lease end dates across your units, days left, proposed rent increases and where each renewal stands.

Shown with sample data

Colour

Lease Renewal & Expiry Tracker

Lease end dates across your units, days left, proposed rent increases and where each renewal stands.

Leases ending within 90 days
5
Renewed
2
Offers to send or chase
1
Extra monthly rent agreed
$140
Current rent by property
  • Harbor View$4,500
  • Maple Court$4,350
  • Elm Street$4,000
Share of current rent by property
  • Harbor View$4,50035%
  • Maple Court$4,35034%
  • Elm Street$4,00031%

How to use it

  1. 1Enter each lease’s end date and current rent.
  2. 2Send offers when the sheet says to, usually 90 days out.
  3. 3Record the outcome as soon as the tenant replies.
  4. 4Start marketing units marked Moving out immediately.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Vacancies are expensive and usually predictable. List each lease with its end date, current rent and the rent you propose; the sheet counts down to expiry, tells you when to send the renewal offer, calculates the increase and totals the extra monthly income from renewals agreed.

Who it’s for

  • Portfolios of five units or more
  • Staggering lease ends to avoid simultaneous vacancies
  • Planning rent reviews

What’s included

  • Leases sheet: One row per lease.
  • Summary by Property sheet: Current rent and Proposed rent and the number of entries for each property, calculated from the Leases sheet.

How to use it

  1. 1Enter each lease’s end date and current rent.
  2. 2Send offers when the sheet says to, usually 90 days out.
  3. 3Record the outcome as soon as the tenant replies.
  4. 4Start marketing units marked Moving out immediately.
Related searcheslease expiry trackerlease renewal trackertenancy end datesrent increase plannerlease expiration report

Details

Format
Spreadsheet
Category
Rental Property Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetRental Property ManagementFree

Lease Renewal & Expiry Tracker

Lease end dates across your units, days left, proposed rent increases and where each renewal stands.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Rental Property Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More rental property management templates

View all
Rent Roll
Task
JunJulAugSepOct
12 Oak Street
12 Oak Street
12 Oak Street
48 Elm Avenue
7 Pine Court
SpreadsheetRental Property Management

Rent Roll

Units, tenants, lease dates, rent, deposits and payment status across your portfolio.

10 min setupPreview
Tenant Rent Ledger2 sheets

Charged

$11,250

Collected

$9,300

Outstanding

$1,950

ABCD
1DateTenantTypeDescription
2Oct 1J. Alvarez - Unit 1Rent chargeOctober rent
3Oct 1M. Chen - Unit 2Rent chargeOctober rent
4Oct 1R. Okafor - Unit 3Rent chargeOctober rent
5Oct 1S. Novak - Unit 4Rent chargeOctober rent
Ledger
SpreadsheetRental Property Management

Tenant Rent Ledger

Charges, payments and late fees for every tenant, with a balance per tenant and your collection rate.

10 min setupPreview
Rental Property Income & Expenses2 sheets

Income

$7,575

Expenses

$2,577

Net cash flow

$4,998

Net cash flow by property
$3,485
$913
$600
12 Oak Street7 Pine Court48 Elm Avenue
SpreadsheetRental Property Management

Rental Property Income & Expenses

Track rent and property expenses by category for cash flow and tax time.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ