How do I set up a lease administration platform for tracking renewals, occupancy, and critical dates across multiple entities?

To set up a lease administration platform for tracking renewals, occupancy, and critical dates across multiple entities, start by designing the process and data structure first, then configure the system around it.

1) Define your scope and reporting structure

Before entering data, decide:

• Which entities will be included
• Which properties/sites each entity controls
• Which lease types you need to track
  • Office, retail, industrial, land, equipment, etc.
• What dates matter
  • Lease commencement, expiration, renewal notice, option windows, rent review dates, termination rights, insurance deadlines, reporting dates
• What occupancy means for you
  • Physical occupancy, rentable area, leased vs vacant, percent occupied, by entity/site

2) Standardize your lease data model

Create a consistent data structure so all entities can be tracked in one system.

Core master records

• Entity
  • Legal entity name, tax ID, parent/subsidiary relationship
• Property/Site
  • Address, region, asset type, square footage
• Lease
  • Lease ID, entity, landlord/tenant, status, start/end dates
• Space/Unit
  • Suite number, floor, area, occupancy status
• Critical Date
  • Date type, due date, reminder offsets, owner, status

Common fields to capture

• Lease commencement and expiration
• Renewal/extension options
• Notice periods and delivery method
• Rent escalation dates
• Termination rights
• Security deposit
• Base rent, CAM/opex, taxes, insurance
• Occupied square footage
• Vacant square footage
• Responsible department/contact

3) Set up workflows by function

A lease admin platform works best when it has clear ownership.

Typical roles

• Lease Administrator: maintains data and deadlines
• Property Manager / Facilities: occupancy and site-level updates
• Legal: lease terms, notices, option exercises
• Finance/Accounting: payment terms, accruals, reporting
• Business Owner: renewal decisions and approvals

Workflow examples

• New lease intake and approval
• Critical date review and approval
• Renewal decision workflow
• Occupancy change update
• Document upload and version control

4) Configure critical date alerts

Set reminders at multiple intervals so nothing is missed:

• 180 days before expiration
• 120 days before renewal notice deadline
• 90 days before option window
• 60/30/15 days before key dates
• Escalation if no action is taken

Use:

• Automated email alerts
• Dashboard flags
• Task assignments
• Escalation to managers

5) Build occupancy tracking

For occupancy, track both the lease and physical use of space.

Recommended occupancy fields

• Total rentable area
• Occupied area
• Vacant area
• Occupancy %
• Tenant/entity occupying the space
• Effective move-in/move-out date
• Planned vacancy date
• Space status: occupied, partially occupied, vacant, under construction

Helpful views

• Occupancy by entity
• Occupancy by property
• Vacancy aging
• Upcoming move-outs
• Space utilization trends

6) Organize renewals and expirations

Create renewal dashboards with:

• Leases expiring in 12 months
• Leases with notice due in 6 months
• Option periods currently open
• Leases under negotiation
• Auto-renewal leases
• Leases pending termination or extension

Include fields for:

• Decision owner
• Renewal probability
• Negotiation status
• Expected action date
• Final executed outcome

7) Centralize documents

Store all lease documents in one place:

• Executed lease
• Amendments
• Renewal letters
• Option notices
• Estoppels
• Correspondence
• Floor plans
• Certificates of insurance

Make sure each document is linked to:

• Entity
• Property
• Lease
• Critical dates

8) Establish data governance

This is essential when multiple entities are involved.

Governance practices

• One source of truth for lease data
• Standard naming conventions
• Role-based access control
• Audit trail for changes
• Approval required for key edits
• Monthly or quarterly data validation

9) Create dashboards and reports

Build reporting by entity, property, and portfolio.

Common dashboards

• Upcoming critical dates
• Renewals by stage
• Occupancy summary
• Vacancies and expirations
• Lease obligations by entity
• Portfolio exposure by rent and area

Useful KPIs

• % of leases with complete data
• Number of critical dates due in next 90 days
• Occupancy rate by entity
• Renewal rate
• Vacant square footage
• Average days to renewal decision

10) Integrate with other systems

If possible, connect the platform to:

• ERP/accounting system
• CMMS/facilities tools
• Document management system
• BI/reporting tools
• Calendar/email systems

This reduces duplicate entry and improves accuracy.

11) Test before rollout

Run a pilot with one entity or region:

• Load sample leases
• Validate critical date logic
• Check reporting accuracy
• Confirm alerts are working
• Train users
• Fix data issues before full deployment

12) Train users and assign ownership

Even the best platform fails without process ownership.

Train users on:

• How to enter and update leases
• How to review critical dates
• How to interpret occupancy reports
• How to handle renewals and approvals
• How to upload supporting documents

Assign a single point of accountability for:

• Data completeness
• Date accuracy
• Reminder monitoring
• Reporting quality

---

Recommended implementation structure

If you want a simple starting point, set up these modules:

1. Entity Master
2. Property Master
3. Lease Register
4. Critical Dates Calendar
5. Occupancy Tracker
6. Renewal Workflow
7. Document Repository
8. Dashboard/Reporting

---

If you’re building it in Excel, SharePoint, or software

• Excel: good for a pilot, not ideal for multiple users and audit trails
• SharePoint/Smartsheet/Airtable: good middle ground for workflow and visibility
• Dedicated lease administration software: best for scale, alerts, auditability, and multi-entity control

---

If you want, I can also give you:

1. a sample data template,
2. a recommended fields list, or
3. a step-by-step setup for Excel, SharePoint, or a lease software platform.