Skip to content
CRE Agents LogoCRE Agents
All Posts
Asset Management

Build a clean rent roll straight from your leases

Skip the manual build and get a one-sheet Excel rent roll with totals and a usable summary.

VicVic
February 1, 20263 min read
Build a clean rent roll straight from your leases

You know the drill. Someone asks for a current rent roll and all you have are PDFs, a few old versions, and notes that do not quite line up. You start keying in suites, rents, dates, and hope nothing slips.

That hour goes fast, and the result still needs a second pass. Small mistakes creep in, especially around escalations and term dates, and those are the ones that come back later.

Asset Management
~10 min to run
Build a Commercial Rent Roll from Leases
Vic prompt
Use Vic to build a commercial rent roll from my leases.
Purpose
A clean rent roll supports accurate NOI tracking, rollover analysis, and valuation work. The task reduces the time to compile this data from 60 minutes to about 10 minutes.
Inputs
Commercial LeasesRequired
As Of DateOptional
Building Sf Or Suite MapOptional
Outputs
A single Excel worksheet with one row per suite or tenant, a bold totals row, and a summary block. Every figure traces back to the source leases.
Time saved
Turns roughly an hour of manual work into about ten minutes.

How it works

Give Vic the lease documents. Add an as of date if timing matters, and a building SF or suite map if you want occupancy metrics tied to a specific layout. Then run: "Use Vic to build a commercial rent roll from my leases."

Vic reads each lease and outputs a single Excel worksheet with one row per suite or tenant. The sheet includes leased square footage, term start and end dates, base rent, expense responsibility, escalations, renewal options, and security deposits. Every figure ties back to the source leases, so you can trace anything that looks off.

At the bottom, there is a bold totals row. On the same sheet, a summary block pulls together occupancy, in place rent, WALT, and an expiration schedule by year. You do not have to stitch together a second tab or build your own formulas. It is ready to review or share.

The value here is consistency. Rent rolls are simple until they are not. One lease uses annual rent, another quotes monthly. One has stepped rent, another has fixed bumps. Expense structures vary. When you assemble this by hand, you make judgment calls line by line. Vic applies a consistent structure across all leases so the output reads like one document, not a collage.

For asset management, that means faster NOI checks and cleaner variance analysis. You can line up in place rent against budget without wondering if a number was transcribed or interpreted. For acquisitions, you get to a usable view of cash flow and rollover without building a model first. You can see concentration, near term expirations, and how much rent is tied to upcoming renewals.

The same sheet holds up in conversations. When a broker or lender asks for detail behind a number, you can point to the row and trace it back to the lease. It sounds small, but it removes friction. People trust a rent roll they can follow.

This task does not guess beyond what is in the leases. If something is not stated, it stays blank rather than filled with assumptions. That keeps the output clean and forces the right follow ups, instead of burying gaps under made up numbers.

In practice, the time savings is obvious. What used to take about an hour of reading, typing, and checking drops to roughly ten minutes to run and review. More important, you spend that time reviewing instead of building, which is where your judgment matters.

Vic

Written by

Vic

Vic is the seasoned CRE pro behind CRE Agents. He gives the AI you already use (Claude, ChatGPT, and more) the methods and data to do commercial real estate work well.