When interest rates are higher and banks scrutinise cash flow more closely, rental data becomes more than administration. It documents what the portfolio actually earns, which income can be adjusted and where the risks lie.
Yet rental data is often scattered. One version in the lease. Another in Excel. Another in billing. Another in the head of the person who has “always done this”. It works fine until someone asks whether the figures will stand up to refinancing, a sale, renegotiation or a week’s holiday.
What is the rental data basis in commercial property?
The rental data basis in commercial property is the combined information explaining what a tenant should pay, why the amount is correct and how it should be followed up over time. It is not just the monthly rent. A sound rental basis links the lease, floor area, adjustment provisions, service charges, guarantees, additional services and billing.
In short: rental data is the bridge between the lease and cash flow.
If that bridge is weak, small discrepancies can quickly become difficult to explain. The area used for billing may not match the lease. CPI indexation may use the wrong date. The service charge allocation may make sense to one person but not the rest of the organisation. None looks dramatic alone. Together, they can become costly.
Why commercial property rental data matters more now
In a market with higher financing costs, the quality of rental income becomes more important. Malling’s public analysis for June 2026 highlights continued differences between commercial property segments, while Statistics Norway’s consumer price index remains a key practical source for many index-linked leases. Norges Bank has also kept interest rates and inflation high on the agenda throughout 2026.
For property companies, the practical implication is clear: roughly knowing what the portfolio rents for is not enough. You must be able to document the underlying data.
This is particularly important when you need to:
- refinance or report to a bank
- assess yield, value and cash flow
- renegotiate major leases
- monitor vacancy and the lease expiry profile
- explain differences between budget and actual billing
- ensure correct CPI indexation and service charge reconciliation
This is introductory territory, but far from fluff. Clear rental data makes the next questions easier: what income is stable? What is variable? What can be adjusted? What is uncertain? And where is the risk?
Five things a sound rental data basis should contain
1. Lease data that is actually used
Start with the fields that determine income: tenant, unit, floor area, rent, lease term, adjustment date, index basis, options and notice deadlines. These must be structured enough to support billing and reporting, rather than merely appearing as text in a PDF.
If the lease says one thing and the spreadsheet another, it is not a minor discrepancy. It is a risk to decision-making.
2. Floor areas and allocation keys
Floor area often seems simple, but it is a common source of small errors. Rent may use one area definition, service charges another and reporting a third. Unless area changes are updated consistently, errors propagate into billing, reconciliation and portfolio reporting.
For commercial buildings, you should be able to identify the areas used for fixed rent, those used for service charges and those used only for internal reporting.
3. CPI indexation and the index basis
Many commercial leases are adjusted using the consumer price index. You need to know which index month applies, whether the adjustment has a floor or cap, when notice must be given and whether the adjustment has actually been made.
Statistics Norway is the natural source for CPI figures, but the work rests with the landlord: the correct base amount, index and timing, with clear documentation. We cover the practical details in CPI rent indexation: getting it right (/en/nytt-og-nyttig/kpi-regulering-husleie-naeringseiendom).
4. Service charges and additional charges
Service charges are often where unclear supporting information creates the most friction. What is included? What are owner costs? Which allocation key applies? How are on-account payments and reconciliation handled? And how well can you explain variances to the tenant?
A sound rental basis separates fixed rent from service charges, additional services, recharged costs and special agreements. This makes it easier to give a factual answer when a tenant asks why the amount changed.
5. Links to billing and accounting
Rental data only delivers value when it reaches billing. If finance has to re-enter lease data manually, this creates duplicate work and a risk of errors.
This does not mean everything must be automated from day one. But it should be clear which system is the master for lease data, how changes are approved and how accounting receives the correct billing data.
Example: one incorrect area, three consequences
Suppose a tenant in a commercial building reduced its floor area from 1,200 to 1,080 square metres following alterations. The change was entered in a letting spreadsheet but not in the billing data. The service charge allocation was not updated either.
Three problems can quickly arise:
- The tenant is billed using the wrong floor area.
- Service charges are allocated using the old basis.
- Reported rent per square metre is misleading.
Nobody needs to have made a “major error”. Disconnected data is enough. When discrepancies are discovered late, correcting them often takes more work than the original change would have required.
How to check your rental data before summer
The period before holidays is a good time for a simple check. Not because summer is special, but because absence exposes reliance on individuals rather sharply.
Work through these questions:
- Does every active tenancy have an up-to-date rent amount, floor area and adjustment date?
- Does the billing data agree with the lease data?
- Is the next CPI adjustment visible and assigned to someone?
- Do you know which service charge items need to be recharged?
- Are guarantees, expiry dates and options linked to the correct tenant?
- Can someone other than the key person explain the figures?
If the answer to the last question is “perhaps”, you have found a useful area for improvement.
When do you need a system for rental data?
You do not need a separate system for everything. With two simple leases and few changes, a well-organised spreadsheet can work for a long time. But when the portfolio grows, or several people need to trust the same figures, the calculation changes.
Typical signs that rental data should move out of Excel:
- you have several properties, limited companies or property managers involved
- CPI indexation is manual and remembered by one person
- service charges are managed in separate spreadsheets alongside billing
- reporting to the bank, board or owners takes a disproportionate amount of time
- discrepancies are discovered only when a tenant, auditor or bank asks
The problem is not that Excel is bad. It is that Excel has been given a job it was not hired to do.
In summary
Commercial property rental data is about being able to explain and document the portfolio’s income. A sound basis shows what tenants should pay, which adjustments apply, how service charges are handled and how the figures flow into billing and reporting.
As financing costs, yields and reporting requirements receive more attention, this becomes a practical part of risk management. Not an administrative detail that can wait until “the next time we tidy up the spreadsheets”.
Want to see how Estatelab helps property companies bring leases, CPI indexation, service charges and billing data into one structured workflow? Book a demo. 30 minutes · Free · No obligation · Meet people who understand property.
Ready for more control?
Less Excel. More visibility.
Estatelab helps property companies and managers gain a better overview of leases, portfolios and financial processes.
