OWNER WORKFLOW GUIDE
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.
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.
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.
- 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
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.
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.
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.
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.
USE THIS WITH ONE REAL PROPERTY
Stop rebuilding the operating record every month.
Start a 15-day trial, add one property, and bring the lease, rent, CAM, and tenant communication into the same workspace.