Most RE teams still manage leases in spreadsheets. The direct cost is obvious — time spent reconciling data. The hidden cost is the decisions you can’t make because the data isn’t there when you need it.

If you manage a corporate real estate portfolio of any meaningful size, there is a near-certainty that at least part of your critical lease data lives in a spreadsheet. Maybe it started as a quick tracker during a period of rapid expansion. Maybe it was inherited from a predecessor who preferred the flexibility. Whatever the origin, the spreadsheet persists — and its cost compounds every quarter.

The direct cost is visible: hours spent reconciling tabs, chasing colleagues for updates, manually assembling board packs. Most RE directors can estimate this. What they underestimate — significantly — is the opportunity cost. The decisions that never get made because the data wasn’t available, wasn’t trusted, or wasn’t structured in a way that enables analysis.

The reconciliation tax

A typical multinational with 40–60 leased locations will maintain somewhere between three and twelve spreadsheets tracking lease data. These might be split by region, by contract type, or simply by whoever happened to create them. The reconciliation tax — the time spent making these files agree with each other and with reality — is substantial.

Consider what happens at quarter-end. Someone needs to confirm the total committed lease liability. That means pulling data from every regional tracker, converting currencies to a common base, accounting for any amendments signed since the last update, and cross-referencing with finance’s own records. In our experience, this process takes between two and five working days for a portfolio of 50 locations. That is two to five days of a senior professional’s time, repeated four times a year, producing a number that should be available instantly.

The missed break clause

Every RE professional has a version of this story. A lease break option passes unexercised because nobody flagged it in time. The financial impact is immediate and significant: you are now committed to the remaining term, which could mean hundreds of thousands in rent for space you no longer need.

Spreadsheets do not send alerts. They do not calculate the economic value of exercising a break versus staying. They do not connect to your headcount data to show that the site is now 40% underutilised. The break date is a cell in a row, and unless someone is actively reviewing that row at the right time, it passes in silence.

For a portfolio of 50 locations, each with an average of 1.5 break or option dates over a five-year period, that is 75 critical dates to track. Miss even one on a major site and the cost can exceed the entire annual RE team budget.

The benchmarking blind spot

When your lease data is scattered across files, benchmarking becomes a research project rather than a routine check. Questions that should be answerable in seconds require hours of assembly:

What is our average cost per square metre across the Nordics, and how does it compare to market?
Which five sites have the highest occupancy cost per employee?
How has our total portfolio cost changed year-over-year, adjusted for currency?
What percentage of our portfolio is on leases expiring in the next 18 months?

These are not exotic questions. They are the basic inputs to any portfolio optimisation discussion. Yet in a spreadsheet-based operation, assembling the answers is a project in itself — which means the questions get asked less often, and the portfolio drifts further from optimal.

Board reporting as a bottleneck

Board reporting is where the spreadsheet problem becomes most visible to senior stakeholders. The RE director needs to present a clear picture of portfolio performance, risk, and upcoming decisions. In a spreadsheet world, this means:

Manually pulling data from multiple sources
Building charts in PowerPoint or Google Slides
Sanity-checking numbers against last quarter’s report
Fielding questions after the meeting that require going back to the source data

The result is a reporting cycle that consumes a disproportionate amount of the team’s capacity and produces a static snapshot that is out of date the moment it is presented. Contrast this with a system where the board pack is generated from live data, where any stakeholder can drill into a metric, and where the narrative is updated automatically as the portfolio changes.

The compounding effect

The real damage from spreadsheet-based management is not any single missed date or delayed report. It is the compounding effect of operating without a clear, current, queryable picture of your portfolio. Over time, this leads to:

Reactive decision-making — acting on problems only when they become urgent, rather than identifying and addressing them early
Inconsistent strategy execution — each region or site making local decisions without visibility into the whole
Weak negotiating position — entering renewals without benchmarking data or a clear view of alternatives
Compliance risk — IFRS 16 calculations done manually from abstractions that may be incomplete or out of date

None of these show up as a line item on a cost report. They manifest as slightly worse terms on every renewal, slightly later responses to every opportunity, and a gradual erosion of the RE function’s credibility with the C-suite.

What the transition actually looks like

Moving from spreadsheets to a structured portfolio platform does not require a multi-year transformation programme. The critical path is straightforward: get lease data into a structured format, connect it to your financial and space data, and build the automated alerts, benchmarks, and reports that spreadsheets cannot provide.

The most effective approach we have seen is to start with contract abstraction — extracting the key commercial terms, dates, and obligations from your existing leases into a structured database. Once the data is structured, everything else follows: automated break-date alerts, real-time benchmarking, instant board reporting, and the ability to model scenarios across the portfolio.

The question is not whether to make this transition — the cost of not doing so is too high and too well-documented. The question is whether to do it now, while you still have time to influence the next wave of lease events, or later, after more break dates have passed and more renewal cycles have been sub-optimised.

For RE teams managing 20 or more locations, the spreadsheet phase should be over. The tools exist to do this properly. The only remaining barrier is inertia — and inertia has a cost, even if it never appears on a balance sheet.

The hidden cost of spreadsheet-based portfolio management