For years, Excel spreadsheets have been the default tool for managing retail lease portfolios. Whether you’re a national retailer tracking dozens of shopping centre leases or a landlord managing tenant schedules across multiple centres, chances are there’s a spreadsheet at the heart of your lease management process. And chances are, it’s causing you more problems than you realise.
The Spreadsheet Trap
Spreadsheets are familiar, flexible, and free — which is exactly why they’ve persisted for so long in lease management. But the retail leasing environment has become significantly more complex, and spreadsheets simply haven’t kept pace.
Human error is unavoidable. A single mistyped figure in a rental escalation formula can cascade through an entire portfolio analysis. When you’re dealing with CPI-linked escalations, tiered rent structures, and varying lease commencement dates across dozens of sites, the risk of a formula error going undetected is substantial. And in a lease negotiation, relying on incorrect data can cost you far more than the rent you’re disputing.
Version control is a constant battle. In most organisations, lease data passes through multiple hands — leasing managers, finance teams, legal advisors, and external consultants. When each stakeholder is working from their own version of a spreadsheet, discrepancies are inevitable. Which version has the latest rent review outcome? Did someone update the option expiry dates after last quarter’s portfolio review? These questions shouldn’t require a forensic investigation to answer.
Reporting is manual and time-consuming. Pulling together a portfolio-level view of your lease commitments — total occupancy costs, upcoming expiries, escalation profiles, or rent benchmarking across centres — requires significant manual effort in a spreadsheet environment. By the time you’ve assembled the data, it may already be outdated.
Audit readiness is compromised. With IFRS 16 now requiring most leases to appear on the balance sheet, the stakes for data accuracy have never been higher. Auditors expect a clear trail from lease terms to financial statements. Spreadsheets, with their lack of built-in version history and access controls, make this process unnecessarily difficult.
What Retail Lease Data Actually Needs
Effective retail lease management requires a system that can handle the complexity of real-world lease structures while keeping data accessible and reliable. That means a centralised source of truth that everyone works from, rather than scattered files across email inboxes and shared drives. It means the ability to filter and compare lease data across states, landlords, centre types, tenant categories, and date ranges. It means visibility into upcoming expiries and renewal deadlines, so critical dates aren’t missed. And it means downloadable datasets that can be used for further analysis without re-entering data.
These aren’t theoretical requirements — they’re the daily reality of managing a retail lease portfolio in Australia.
Moving Beyond the Spreadsheet
The shift away from spreadsheets doesn’t have to mean adopting an expensive enterprise system that takes months to implement. What it does mean is recognising that the quality of your lease data directly affects the quality of your decisions — whether you’re negotiating a rent review, evaluating a new site, or assessing your portfolio’s exposure to upcoming lease expiries.
LeaseInfo was built specifically for this purpose. Our database of over 90,000 regulated retail leases across Australian shopping centres provides the kind of comprehensive, up-to-date leasing intelligence that no spreadsheet can match. Users can search, filter, and export data across a wide range of parameters — from state and landlord to centre grade, tenant category, and MAT.
Instead of spending hours compiling and cross-referencing spreadsheet data, you can access the insights you need in minutes — and have confidence that the data is current and verified.
Book a demo here to see how Leaseinfo can support your next decision.