Rent Roll for Commercial Property: What It Should Show

A refinancing is three weeks from close. The lender's analyst sends back the rent roll with eleven comments. Four tenants show a different passing rent than the signed amendments. Two expiry dates are the original term, not the exercised option. One unit is listed as occupied but has been dark since the operator stopped trading in the spring. None of this is fraud. It is what happens when a rent roll is a spreadsheet maintained by whoever had time that month, and it costs real money: a wider margin, a lower loan-to-value, or a buyer who re-trades the price on the day of exchange.

Most owners know a rent roll should list tenants, units and rents. The question for asset managers and finance teams is what else it has to show for the document to survive scrutiny from a lender, a valuer, an auditor or a bidder's due diligence team, and how it stays correct between those moments.

The columns a lender actually reads first

Experienced underwriters do not start at tenant name. They go to the expiry and break columns, then to passing rent against estimated rental value, then to the arrears column if one exists. A rent roll that forces them to request three further schedules to answer those questions has already signalled weak asset management. At minimum, each line should carry:

• Unit reference, lettable area and the measurement basis used, so area totals reconcile to the measured survey.
• Legal tenant entity and trading name, because the covenant being assessed is the entity, not the fascia.
• Lease start, expiry, break dates with notice periods, and whether a break is tenant-only, landlord-only or mutual.
• Passing rent, the next review or indexation date, the mechanism, and any cap or collar.
• Turnover rent provisions: base rent, percentage, threshold and the reporting frequency the tenant is contractually bound to.
• Service charge and insurance recoveries, with any caps or exclusions that leave cost with the landlord.
• Rent-free periods, stepped rents and capital contributions still being amortised.
• Deposit or guarantee held, and its expiry.
• Current arrears, aged by 30, 60 and 90 days.
• Status: occupied and trading, occupied and not trading, vacant, under offer, or in solicitors' hands.

That last distinction matters more than many owners realise. A unit where the tenant still pays but has stopped trading is technically income-producing and practically a problem. Valuers discount for it when they can see it, and discount harder when they discover it on the inspection you did not warn them about.

Where rent rolls go wrong between valuations

The errors that appear at refinancing are rarely dramatic. They accumulate. A side letter grants a six-month rent concession and the finance system is updated but the roll is not. An option to renew is exercised by letter to the property manager and the expiry date stays at the original term for two years. A tenant assigns the lease and the roll still names the assignor. Each is small. Together they produce a document that disagrees with the ledger, the lease files and reality in different ways.

The root cause is almost always that the rent roll is a report produced from memory rather than a report generated from the leases themselves. When lease terms, amendments, critical dates and billing live in one lease administration software system, the roll is an output, not a separate artefact somebody has to remember to edit. That is the structural difference between a rent roll that is right on the day it was last checked and one that is right on any day you export it.

A practitioner's note on the first month

Anyone who has moved a portfolio into commercial lease management software will tell you the same thing: the migration finds the problems before the lender does. Abstracting every lease, amendment and side letter into structured fields surfaces the forgotten concession, the unexercised option that is now past its notice window, and the deposit nobody can locate. Budget for this. A portfolio of a hundred leases typically yields a handful of discrepancies that change passing rent or expiry, and it is far cheaper to find them in an internal reconciliation than in a buyer's due diligence report with a price chip attached. VemLease is built around exactly this abstraction and critical-date tracking, which is why the first month of use is often the most valuable one.

What a retail rent roll should show that an office roll does not

For shopping centres, retail parks and high-street holdings, a rent roll that stops at contractual rent understates both the risk and the opportunity. Two further columns separate a competent retail roll from a strong one.

The first is occupancy cost ratio: total occupancy cost as a percentage of reported tenant sales. A unit paying rent on time at a 25 percent ratio is a renewal risk; the same unit at 9 percent is under-rented and a reversion opportunity at the next review. Neither is visible from rent alone. Owners using VemTenant collect tenant sales reporting directly, so the ratio can be calculated per unit rather than estimated from sector averages, and turnover rent can be reconciled against actual certified figures instead of chased by email each quarter.

The second is footfall context. Rent per square metre means something different in a mall zone receiving a quarter of the scheme's visitors than in a dead-end corridor. Pairing lease data with VemCount visitor traffic lets an asset manager show a lender or bidder that a vacancy sits in a low-traffic zone with a known remerchandising plan, rather than leaving them to assume the worst. Counting accuracy is contractually a minimum of 96 percent and typically 98 to 99 percent where lighting, layout and visitor behaviour allow, which is precise enough to support zone-level rental arguments at review.

Reading the roll as a portfolio, not a list

Finance teams and leasing directors look at the same rent roll for different reasons, and a good one serves both. The summaries that should fall out of it without manual work are:

• Weighted average unexpired lease term, both to expiry and to earliest break, because lenders will calculate both and query the gap.
• Expiry concentration by year and by income share, so a single year carrying 30 percent of rent is flagged early enough to stagger renewals.
• Top-ten tenant income exposure and the covenant quality behind it.
• Vacancy by area and by rental value, since 5 percent of floorspace vacant can be 2 percent or 12 percent of income depending on where it sits.
• Reversionary potential: passing rent against ERV, aggregated and per unit.

When these are produced by the lease management software rather than rebuilt in a spreadsheet each quarter, they also become management tools. A leasing director who sees the 2027 expiry cluster in 2025 has two years to re-gear selectively. One who sees it in the lender's comments has two weeks to explain it.

A simple test before the next valuation

Pick five leases at random. Compare the rent roll line to the signed documents, the latest amendment, the rent ledger and a site walk. If all five agree, the process is working. If two disagree, assume the problem is proportional across the portfolio and fix the process, not the five lines. Lenders and buyers run exactly this test; owners who run it first keep control of the conversation.

Frequently asked questions

What is a rent roll in commercial real estate? A rent roll is the schedule of every lettable unit in a property, showing the tenant, lease dates, passing rent, review and break terms, recoveries, arrears and occupancy status. Lenders, valuers and buyers use it as the primary evidence of contracted income, so its accuracy directly affects loan terms and sale price. Generated from a lease administration system rather than maintained by hand, it stays reconciled to the underlying leases.

If your rent roll currently lives in a spreadsheet and the next refinancing, valuation or disposal is on the horizon, it is worth seeing how VemLease generates it directly from abstracted lease data, with VemTenant sales and VemCount traffic alongside each unit. Contact Vemco Group to walk through a sample rent roll from your own portfolio and find the discrepancies before a lender does.