Lease Tracker

Track every lease across your properties — tenants, rent, deposits and terms — with expiry countdowns so renewals never sneak up on you.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Trackers

Tables

Leases, Properties

Fields

24

Views

grid, timeline, calendar, kanban, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Leases

17 fields · 5 sample rows

  • All leases (Grid)
  • Lease timeline (Timeline)
  • Expiries (Calendar)
  • By status (Kanban)
  • Portfolio (Dashboard)
LeaseTextPropertyLink to another tableUnitTextTenantTextTenant emailEmailTenant phonePhoneStart dateDateEnd dateDateTerm (months)FormulaDays to expiryFormulaMonthly rentCurrencySecurity depositCurrencyAnnual escalationPercentRent due dayNumberStatusSingle selectLease agreementAttachmentNotesLong text
Skyline 1202 – KapoorSkyline Residency1202Ankit & Ritu Kapoor[email protected]+91 98200 1123424 Dec 202524 Dec 20261235₹55,000₹1,65,0005.0%5Renewal due
Skyline 804 – FernandesSkyline Residency804Clara Fernandes[email protected]22 Jul 202621 Jul 202823610₹48,000₹1,44,0005.0%1Active
Green Park Shop 3 – Chai PointGreen Park ArcadeShop 3Chai Point Retail Pvt Ltd[email protected]19 Dec 202419 Dec 202736395₹1,20,000₹7,20,0007.0%7Active
Green Park Office 2F – NimbusGreen Park Arcade2nd floorNimbus Analytics[email protected]5 Dec 202314 Nov 202635-5₹2,10,000₹12,60,0006.0%Notice givenVacating; deposit refund after inspection.
Lakeview Villa 7 – JohnsonLakeview VillasVilla 7Mark & Sue Johnson[email protected]3 May 20263 May 202712165₹95,000₹2,85,0005.0%1Active
Field details
Lease · Text
Property · Link to another table
Links to Properties
Unit · Text
Tenant · Text
Tenant email · Email
Tenant phone · Phone
Start date · Date
End date · Date
Term (months) · Formula
IF(AND({Start date}, {End date}), DATETIME_DIFF({End date}, {Start date}, 'months'), BLANK())
Days to expiry · Formula
IF({End date}, DATETIME_DIFF({End date}, TODAY(), 'days'), BLANK())
Monthly rent · Currency
INR
Security deposit · Currency
INR
Annual escalation · Percent
Rent due day · Number
Status · Single select
Active, Renewal due, Notice given, Expired, Renewed
Lease agreement · Attachment
Notes · Long text

Properties

7 fields · 3 sample rows

  • Properties (Grid)
PropertyTextAddressAddressTypeSingle selectUnitsNumberLeasesLink to another tableLeases on fileCountRent rollRollup
Skyline ResidencyHiranandani Gardens, Mumbai, Maharashtra, 400076, IndiaResidential2Skyline 1202 – Kapoor, Skyline 804 – Fernandes2₹1,03,000
Green Park ArcadeAurobindo Marg, Green Park, New Delhi, Delhi, 110016, IndiaCommercial6Green Park Shop 3 – Chai Point, Green Park Office 2F – Nimbus2₹3,30,000
Lakeview VillasWhitefield, Bengaluru, Karnataka, 560066, IndiaResidential12Lakeview Villa 7 – Johnson1₹95,000
Field details
Property · Text
Address · Address
Type · Single select
Residential, Commercial, Mixed use
Units · Number
Leases · Link to another table
Links to Leases
Leases on file · Count
Rent roll · Rollup
sum of Monthly rent via Leases

Lease Tracker: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates