A corporate real estate team is not an investor, and the portfolio question it needs answered is a different one. An investor asks what a building will return. A corporate real estate team asks what the company's own portfolio of offices, sites and leased space actually costs, when the leases expire, how much is owned versus rented, and what the ESG picture looks like across every location. So when someone on that team goes looking for a better solution for portfolio analysis, they have usually outgrown a spreadsheet and found that the obvious next step, a full facilities suite, answers a different question than the one they have.
What portfolio analysis means for a corporate team
The metrics are not the investor's NOI and IRR, or not only those. The questions a corporate real estate team actually has to answer look more like this:
- Total occupancy cost per site: rent, Nebenkosten, energy and maintenance in one number, comparable across locations.
- The lease expiry and break-option schedule, so nobody is surprised by a renewal or a notice deadline.
- The owned-versus-leased mix, and what each side costs per square metre.
- ESG and ESRS data per building, because the sustainability report now reads off the portfolio.
- The capex and fit-out pipeline against budget.
Cost still matters, but the analysis is about the estate the company runs, not a deal it might exit. That difference is what makes most of the obvious tools fit awkwardly.
The categories of tools, honestly
The spreadsheet you have now. Where most corporate portfolios are actually run, and genuinely fine at ten sites. It breaks somewhere around fifty: every site is a tab, the roll-up gets rebuilt by hand each quarter, there is no audit trail, and the version in the board pack is never quite the version on someone's laptop. The tipping point is covered in REPM vs spreadsheets.
IWMS and CAFM (Planon, Archibus, IBM TRIRIGA, Spacewell). Built for facilities: space management, work orders, room booking, maintenance across a large estate. If the problem is operating hundreds of buildings day to day, this is the category, and nothing here replaces it. The trade-off is that these are heavy to implement and priced for large estates, and their centre of gravity is operations rather than a quick, trustworthy financial and lease picture that finance and the board can rely on.
The real-estate module in your ERP (SAP RE-FX). This makes sense when the company already runs SAP and wants leases and property inside the same ledger. It is powerful and it is a consulting project, and in practice the analysis still tends to get exported somewhere else to actually be looked at.
BI dashboards (Power BI, Tableau). Excellent at showing a portfolio once the data is clean, and every option above eventually feeds one. The catch is that a dashboard is a presentation layer, not a source of truth. It reads from wherever the data lives and inherits whatever is underneath. A dashboard sitting on twelve spreadsheets is still twelve spreadsheets.
A dedicated system of record (REPM). One record per property carrying its cost, leases, ESG data and financial metrics, aggregating to a portfolio view, in your own Microsoft Dataverse tenant. Not a facilities suite. A clean place for the financial, lease and ESG truth of the portfolio to live, that a Power BI dashboard can read straight from rather than reconciling by hand.
| Category | Strongest at | Weakest at | Typical fit |
|---|---|---|---|
| Spreadsheet | Starting, tiny portfolios | Scale, audit, one version | Under ~10 stable sites |
| IWMS / CAFM | Space, maintenance, work orders | Fast financial and lease view | Large estates, heavy FM |
| ERP RE module | Leases inside the ledger | Standalone analysis, agility | Already all-in on SAP |
| BI dashboard | Visualising clean data | Being the source of truth | On top of a real system |
| System of record | Financial, lease, ESG truth | Facilities operations | Portfolio analysis, own the data |
The honest boundary
If the core need is facilities operations, space planning and work orders across a large estate, an IWMS is the category and REPM is not it. REPM does not do room booking or maintenance dispatch at facilities-management scale, and a corporate team whose real pain is those things should look at Planon or Archibus first. If the core need is a trustworthy financial, lease and ESG picture of the portfolio that finance and the board can rely on, and the team wants to own the underlying data rather than rent it inside a vendor's suite, that is a different job, and it is the one a system of record is built for.
Where REPM fits for a corporate team
REPM keeps one record per property carrying total occupancy cost (rent, Nebenkosten, energy, maintenance), the leases with indexation and break options, and the ESG and ESRS data points on the building they describe. Those figures aggregate to a portfolio the same way whether you have twenty sites or two hundred, which is the roll-up argument laid out in what asset managers need from portfolio software. The financial metrics behind it, if the team also develops or fits out space, are the standard NOI, cap rate and IRR definitions rather than anything proprietary.
The part that matters most for a corporate IT function is that it runs in your own Microsoft Dataverse tenant. Power BI, Excel and the Dataverse Web API read from it directly, the security model is your own, and the data stays yours rather than living inside an ISV's shared platform. That is the same argument the Dataverse write-up and the integrations page make in more detail. For a broader field of options beyond the corporate angle, there is also the wider portfolio-software comparison.
See it on your own portfolio. Start REPM Lite free for 30 days at app.repm.cloud, or ask for an assisted Enterprise trial set up on a slice of your real sites.
How to choose
- If the problem is operating a large estate day to day, start with an IWMS and treat everything else as secondary.
- If the company already lives in SAP and wants leases in the ledger, look at RE-FX first.
- If the need is a clean, trustworthy portfolio picture and the team wants to own the data, use a system of record and point your BI tool at it.
- If you have fewer than a dozen sites and they rarely change, a spreadsheet is honestly fine, right up until it is not.
FAQ
What is the difference between an IWMS or CAFM and a portfolio system of record?
An IWMS or CAFM is built to operate buildings: space management, maintenance, work orders and room booking across a large estate. A system of record is built to hold the financial, lease and ESG truth of the portfolio so it can be analysed and reported. They overlap little in practice, and a large corporate sometimes runs both, one for operations and one for the portfolio picture.
Isn't Power BI enough for portfolio analysis?
Power BI is excellent at showing a portfolio, but it is a presentation layer, not a source of truth. It reads from wherever the data actually lives, so it inherits whatever is underneath. A dashboard on top of a dozen spreadsheets still has a dozen spreadsheets underneath it. The value comes when the dashboard reads from a clean, single source rather than a reconciliation.
Is REPM a CAFM or facilities-management system?
No. REPM does not do space planning, room booking or maintenance dispatch at facilities-management scale. It is a system of record for the financial, lease and ESG side of a property portfolio. If facilities operations are the core need, an IWMS such as Planon or Archibus is the right category.
We lease most of our space rather than own it. Does that change the answer?
No. REPM tracks leases, Nebenkosten, indexation and break options whether or not the company owns the building, so a mostly-leased corporate portfolio is a normal case. Owning property is not a requirement for the lease and cost analysis to be useful.