Commercial Lease Tracking: Turn Critical Dates into Owned Actions

A lease expiration date is only one part of lease control. The action that matters may be a renewal notice, a termination decision, a rent review or a document needed months earlier. A register that records the end date but does not identify the next required action leaves the manager with an incomplete picture.

A commercial lease tracking spreadsheet should connect each obligation to its source, owner and follow-up. This guide sets out an operating method; the signed documents and qualified legal review govern the interpretation of the lease.

Separate the lease record from the action record

Use one lease register for the stable facts: location ID, premises, landlord, legal tenant, commencement, expiration and document links. Keep an action register for events that require work.

One lease can create several actions. A renewal review, notice preparation and delivery confirmation should not be compressed into one cell marked “renewal.” Keeping the records separate makes it possible to assign different owners and retain evidence of each step.

Use consistent identifiers so the action list can be filtered by lease, location and responsible person.

Capture the fields that make a deadline usable

For each critical event, record:

• Lease ID and location.

• Event type, such as option notice, expiration or rent checkpoint.

• Source document, amendment and clause reference.

• Relevant date or permitted notice window.

• Verification status and reviewer.

• Internal decision date.

• Action owner and backup.

• Next action, target date and current status.

• Link to approval, correspondence or completion evidence.

Keep an “unverified” status for incomplete abstracts. A blank date and a confirmed absence of an option are different facts. Give unresolved document questions their own action owner.

Verify the complete document set

Begin with the executed lease and identify amendments, commencement agreements and other documents that may change the entry. A date copied from an old summary may no longer reflect the operative terms.

Ask the appropriate reviewer to confirm the provision, relevant conditions, required recipients and delivery requirements. Do not assume that sending an ordinary email satisfies a notice clause. Do not let a spreadsheet formula decide how a provision should be interpreted.

Record who checked the entry and when. If the document changes, review the affected dates and preserve the reason for the update.

Work backward from the external obligation

Set an internal decision date that allows time for the business review, approval and preparation of the required action. Keep that management date distinct from the contractual deadline.

For example, a team may need market information, a budget decision and counsel review before taking a renewal action. Assign those preparatory steps rather than placing a single reminder immediately before the external deadline.

Use your calendar or task system for reminders. A spreadsheet that displays an approaching date is not necessarily a notification system.

A fictional critical-date example

The following dates are entirely fictional and are not a rule for calculating lease notices.

For location O-021, the reviewed record states that the lease expires on June 30, 2028 and that the applicable notice deadline is December 31, 2027. The manager sets October 15, 2027 as an internal decision target.

The action list then separates three jobs: the real estate lead prepares the business recommendation; the authorized decision-maker records approval; the responsible reviewer confirms and coordinates the required notice process. Completion includes retaining evidence, not merely changing the spreadsheet status.

The important feature is the gap between the internal target and the confirmed external deadline. The correct dates and method must always come from the actual agreement and review.

Use statuses that describe completed work

Define statuses so different managers use them consistently. A practical sequence is:

• Needs verification: the source or interpretation is incomplete.

• Under review: the team is evaluating the required decision.

• Awaiting approval: a recommendation has been submitted.

• Action scheduled: responsibility and timing are confirmed.

• Completed with evidence: the action and supporting record have been checked.

Add a separate overdue indicator based on the relevant management target. Avoid marking a lease matter complete simply because an email was sent. A renewal decision may still require notice, documentation or a later amendment.

Review dates on a regular cadence

At the weekly review, filter for overdue actions, approaching internal targets, unresolved verification and missing owners. Discuss exceptions first.

At a longer planning review, examine future expirations and options together with business needs. A location that appears inexpensive may still require a long relocation lead time. A renewal decision should therefore be visible early enough for a meaningful choice.

The review horizon should reflect the portfolio and agreements. A 30/60/90-day view can support near-term execution, but it should not replace longer-range renewal and relocation planning.

Avoid the common spreadsheet failures

Do not mix dates stored as text with actual date values. Use a consistent date display and validate entries before relying on sorting. Preserve source references and protect calculations against accidental edits.

Do not overwrite completed events to make room for the next one. Retain history in a controlled archive or event log. Keep one approved working version and define who may change verified lease terms.

Do not use color alone to communicate urgency. Include written status labels so a printed copy or a reader with a color-vision difference can still understand the record.

Connect lease dates to the wider operation

Occupier teams need to connect lease decisions with facilities issues, location performance and planned openings or closures. The Occupier / Tenant Portfolio Operations System supports that broader location-based workflow.

Owners and property managers need a different view: tenant follow-up, property obligations, maintenance and vendor coordination. The Landlord Commercial Property Operations System is designed around that operating role.

These perspectives share lease information, but their action lists should reflect who must make the decision and carry out the work.

Build control before adding complexity

The strongest starting point is a verified register, a separate action list and a review habit that results in named responsibility. More columns will not compensate for unclear ownership.

The Commercial Lease & Critical Dates Control System provides an editable Excel structure for lease records, notice windows, options, expirations, responsibilities and follow-up. Use it as an operational management aid alongside your source documents and professional review.