How to build a commercial rent roll from scratch
A step-by-step process for building your first real rent roll, from gathering lease documents to a rent roll a lender or buyer would actually trust.
Building a rent roll for the first time is less about spreadsheet skill and more about a clean process: gather the real source documents first, extract the same fields consistently, and be honest about what you don't actually know yet.
SKIP THE BLANK SPREADSHEET
Build the rent roll in your browser, then export it.
Occupancy, rent per square foot, weighted average lease term, and upcoming expirations are calculated as you type. No account, nothing uploaded.
01 / 05
Start by collecting every lease document, not the spreadsheet
Before entering a single number, gather the executed lease and every amendment, extension, or modification for each tenant. A rent roll built from memory, an old email, or someone's verbal recollection of “what the rent is now” is exactly how a rent roll drifts from the actual lease terms in the first place.
02 / 05
Extract the same fields, lease by lease
Work through each lease and pull the same fields every time, in the same order, so nothing gets skipped for one tenant and not another.
Key points
- Suite, tenant legal name, and square footage
- Lease start and end dates
- Current base rent and any scheduled future steps
- CAM or NNN method and current monthly charge
- Security deposit and any renewal option terms
03 / 05
Handle the gaps honestly
Some leases will be missing a clean signed copy, or won't clearly state square footage, or reference an amendment nobody can locate. Flag it—don't estimate a number and enter it as if it were verified. A rent roll with an honest “needs verification” note is more trustworthy than one that looks complete but silently guessed at a few fields.
04 / 05
Total it and sanity-check it
Once every lease is entered, total the expected monthly and annual rent, then compare it against what's actually landing in the bank account. A meaningful gap between the rent roll's total and real deposits usually means either a missed rent step, an error in a lease's extracted terms, or a tenant who's genuinely behind—worth knowing which, before treating the rent roll as final.
05 / 05
Keep it current, not just built once
The harder problem was never the first build—it's staying current as rent steps land, renewals get exercised, and a new tenant moves in. A rent roll that's accurate on the day it's built and stale three months later isn't meaningfully better than not having one. Start with our free rent roll template for the field set, then decide whether ongoing upkeep should stay manual or move into a system that updates it automatically from the lease record.
FAQ
Frequently asked questions
How often should a rent roll be updated?
Whenever something on it actually changes—a rent step lands, a renewal is signed, a tenant moves in or out—rather than on a fixed schedule that can leave it stale between updates.
What if a lease was never reduced to a clean written document?
Reconstruct what you can from whatever documentation exists (a signed term sheet, email confirmations, payment history), flag the entry as unverified, and prioritize getting it formalized in writing going forward.
Free template
Get the rent roll template and tenant file checklists
The rent roll spreadsheet, the tenant information checklist, and a COI tracker for the insurance certificates every tenant owes you.
- Commercial rent roll templateSpreadsheet template
- Commercial Tenant Information ChecklistPrintable checklist
- Tenant insurance certificate (COI) trackerSpreadsheet template
Put it into practice
TenantPoint handles this workflow in Commercial property record management and Commercial property management software. See all TenantPoint solutions or how it compares with other software.
This educational material is not legal, accounting, tax, or investment advice. Review controlling lease language and consult qualified professionals when appropriate.
Back to resources