How to Manage 20, 50 or 100+ Leased Locations

A growing leased portfolio creates a particular management problem: the information exists, but it is scattered across leases, emails, work orders and individual spreadsheets. The manager needs to know what requires a decision, who owns the next action and which location is at risk of being overlooked.

Managing 20, 50 or 100+ leased locations starts with a consistent operating process. A spreadsheet can support that process when ownership, access and review routines are clear. The number of locations alone does not determine whether enterprise software is necessary.

Start with one location register

Give each location a permanent identifier. Use that identifier in the lease register, facilities log, landlord correspondence and project list. A street address can change format; a location ID should remain stable.

Record the trading or operating name, address, property type, occupancy status, responsible manager and link to the controlled document folder. Separate the location from the legal tenant entity and lease record. One location may have an original lease, amendments, a commencement agreement and a separate storage arrangement.

For a mixed portfolio, distinguish retail stores, offices and industrial premises. Their operating priorities differ, but the shared register should still answer the same basic questions: where is it, who occupies it, what agreement governs it and who is responsible?

Build five connected operating views

1. Lease obligations and critical dates

Track expiration, renewal and termination provisions, notice windows, rent changes and outstanding document questions. Keep the source document and clause reference beside each material entry. An unverified date should be visibly marked for review rather than presented as confirmed.

Separate the contractual deadline from the earlier internal decision date. Time is needed to evaluate the location, obtain approvals and prepare any required notice. For the detailed workflow, see the Commercial Lease & Critical Dates Control System.

2. Landlord matters

Record the issue, relevant correspondence, responsibility under review, last response and next follow-up. Distinguish a request sent from a matter resolved. An email asking for a repair does not establish that the repair is scheduled or complete.

3. Facilities issues

Capture the location, observed problem, operating impact, priority, owner, vendor, next action and target date. Use your established emergency procedures for urgent hazards; a spreadsheet entry is not an emergency response.

Avoid treating every open ticket as equally important. A loss of usable space requires a different management response from a minor cosmetic defect.

4. Openings, relocations and closures

Maintain a milestone list for each project, with dependencies and approvals. Track possession, readiness, utilities, IT, access, signage and handover as separate actions where relevant. A signed lease is a transaction milestone, not evidence that a location is operational.

5. Management decisions

Keep a short decision queue: renew or relocate, approve a repair scope, resolve a responsibility question, or authorize a project step. Each item needs a decision-maker, recommendation, required date and supporting documents.

What the weekly dashboard should show

A useful dashboard puts exceptions ahead of decorative charts. It should help the reviewer identify:

• Contractual deadlines approaching, plus the earlier internal decisions needed.

• Overdue actions and items with no assigned owner.

• Facilities issues affecting trading, access or usable space.

• Landlord matters awaiting a response.

• Openings, relocations and closures with delayed dependencies.

• Records not updated within the team's agreed review period.

Show an “as of” date and define every status. “On track” should mean the next milestone remains achievable, not merely that nobody has reported a problem. If costs appear, identify their period, source and whether they are actual, budgeted or estimated.

A fictional portfolio review

Consider a fictional operator, Cedarbridge Services, with 24 leased locations: 12 offices, eight retail service sites and four industrial support units. These figures illustrate a process, not a customer result or product screenshot.

The weekly review finds three different actions. Office O-014 needs an internal renewal decision before its confirmed notice deadline. Retail R-006 has a recurring entrance-door fault with a vendor visit awaiting confirmation. Industrial I-003 has a relocation milestone blocked by an unresolved access arrangement.

The meeting should end with three named owners and three dated next actions. It should not end with a general instruction to “follow up on the portfolio.”

Run a repeatable weekly review

Before the meeting, location owners update their records and flag changed circumstances. The portfolio manager checks approaching deadlines, unassigned work and stale records.

During the meeting, review urgent operating issues first, then contractual decisions, project dependencies and overdue follow-up. Record the decision and next action in the relevant register while the discussion is still clear.

Afterward, circulate the action list and escalate unresolved decisions to the appropriate approver. Archive completed actions with supporting evidence. Retain enough history to explain why a status changed.

When Excel can be sufficient

Excel can be a practical operating layer when a small accountable team maintains one controlled version, input rules are consistent and the update workload is manageable. Protect formulas, restrict access appropriately, retain version history and establish a backup owner.

Use calendar reminders as a separate control for time-sensitive actions. Do not assume a workbook sends automatic notifications or replaces document management, work-order software or lease accounting.

At 20 locations, the work may fit one weekly review. At 50, regional ownership and standardized inputs become more useful. At 100+, workload, access requirements and integration needs deserve particular scrutiny. These are planning examples, not software capacity guarantees.

When to evaluate enterprise software

Evaluate a dedicated platform when concurrent editing creates recurring conflicts, permissions need to differ by role or location, integrations are essential, or formal audit trails and automated escalation are required. The same applies when the team spends more time reconciling versions than acting on the information.

Do not wait for a fixed location count. Compare the cost of administration and control failures with the implementation effort of a new system. A clean register and defined workflow will also make a future migration easier.

Put the process into operation

Start with a reliable location register, verify the highest-priority dates and assign ownership to every open action. Expand the dashboard only when the underlying records can support it.

The Occupier / Tenant Portfolio Operations System is an editable Excel tool for connecting location and lease records, critical dates, landlord matters, facilities follow-up and portfolio actions. It offers a structured starting point for teams that need operating discipline without immediately implementing a complex platform. You can also explore the Commercial Property Operations tools.