Short answer: test any rent roll software on your own worst rent roll, not on the vendor's sample. A clean demo file proves the tool can read a clean file. The six checks below show whether its rent roll analysis tells you the truth about a messy one.
Written by the Titleman team with AI assistance (Claude). Reviewed by Titleman's SEO/GEO review desk (AI-assisted, not independent of Titleman) before it went live. Links checked and page updated 26 October 2026. Titleman makes a rent roll reader and describes how it handles each check; the checks apply to any tool.
Terms used below: the weighted average lease term (WALT) is the average remaining lease term across tenants, weighted by rent or area; for how leases and net rent structures differ, see the general overview of the triple net lease. Where a lender relies on a scanned document, the quality of optical character recognition on that scan is the first limit on any extraction.
This page does not rank vendors. We have not run the other tools on a common file, and a comparison we did not run would not be worth reading. What follows is the test you can run yourself on one file, and how we answer each check in our own reader.
What rent roll software does, and which kind you need
"Rent roll software" names three different jobs, and vendors often sell only one:
- Generation. Property management systems produce a rent roll from their own ledger. Useful if you operate the building.
- Extraction. Tools that read a rent roll arriving as a PDF, scan or spreadsheet and turn it into rows. Useful if you receive rolls from sellers, brokers or borrowers.
- Analysis. Tools that compute figures from the rows: occupancy, WALT, rollover, rent per square foot, loss to lease.
An acquisitions or credit team usually needs the last two, because someone else produced the roll. The checks below are about those two, since an error in extraction flows straight into every analysis figure.
What a rent roll analysis returns
A rent roll analysis turns a list of tenancies into a handful of figures a committee can read. The ones to expect:
| Figure | What it tells you | Needs from the roll |
|---|---|---|
| Occupancy | Share of area (or units) under lease | Area per suite, vacant suites listed |
| In-place rent and rent per sq ft | What the building collects today | Rent, rent period, area basis |
| WALT | How long the income stream lasts on average | Expiry dates and an as-of date |
| Rollover | Share of rent or area expiring each year | Expiry dates |
| Loss to lease | Gap between market rent and rent in place | A market rent, which the roll does not contain |
A worked example
The roll below is illustrative: six suites in an invented 60,000 sq ft building, an as-of date of 1 October 2026, annual rents on the stated area basis, and an assumed market rent of $29.00 per sq ft for every suite. It is not a real property, and the market rent is an input, not a finding.
| Suite | Area (sq ft) | Rent ($/sq ft/yr) | Annual rent ($) | Expires | Years left |
|---|---|---|---|---|---|
| 100 | 12,000 | 30.00 | 360,000 | 30 Sep 2027 | 1 |
| 110 | 9,000 | 28.00 | 252,000 | 30 Sep 2031 | 5 |
| 200 | 15,000 | 26.00 | 390,000 | 30 Sep 2029 | 3 |
| 210 | 6,000 | 32.00 | 192,000 | 30 Sep 2027 | 1 |
| 300 | 10,000 | 24.00 | 240,000 | 30 Sep 2028 | 2 |
| 310 | 8,000 | vacant | - | - | - |
The figures, with the arithmetic:
| Figure | Result | How |
|---|---|---|
| Occupancy by area | 86.7% | 52,000 leased / 60,000 total |
| In-place rent | $1,434,000 per year | Sum of the five annual rents |
| Average rent per leased sq ft | $27.58 | $1,434,000 / 52,000 |
| WALT, weighted by rent | 2.41 years | Sum of (rent x years left) = 3,462,000, divided by 1,434,000 |
| WALT, weighted by area | 2.46 years | 128,000 sq ft-years / 52,000 |
| Rollover in the next 12 months | 18,000 sq ft; $552,000 (38.5% of in-place rent) | Suites 100 and 210 |
| Loss to lease | $74,000 per year (4.9% of market rent) | 52,000 x $29.00 = $1,508,000, less $1,434,000 |
Two things the table shows. The WALT depends on the weighting, so a tool should say which one it used. And the building is 86.7% occupied but 38.5% of the rent it collects expires within a year, a fact occupancy alone hides. Loss to lease is net: suites 100 and 210 are above the assumed market, so they offset part of the gap on the others.
Pick the test file first
Background on the document itself: a rent roll summarizes the leases at a property tenant by tenant, and the figures feed the income that lenders and buyers capitalize (commercial mortgage underwriting uses them).
Use a real roll from a recent deal. The useful ones have at least three of these:
- More than one layout in one document, such as a PDF export with a summary page and a detail page.
- A rent column with no stated period, so monthly and annual figures are easy to confuse.
- Free-text notes about concessions, free rent or abatements.
- Delinquency or status flags that live in a notes column instead of a status column.
- More rows than fit on the first page.
Keep your own manual read of the same file. Every check below compares the tool's output to that read.
1. Did it read the whole roll?
Count the tenancy rows in the document and count the rows in the output. A tool that stops at the first page will still produce a tidy table.
Ask the tool to state both numbers. If it cannot tell you how many rows the document carries, you cannot tell whether its occupancy figure describes the building or the first page of it.
How we handle it. Our reader records the number of rows in the document and whether every one was transcribed. Occupancy, WALT and average rent per square foot are only computed when the whole roll was read. Otherwise the figure is left out and the reason is printed next to it.
2. Does it know the rent period?
A monthly rent treated as annual is off by a factor of twelve, and so is every per-square-foot figure built on it. Many rolls never state the period in the header.
Check what the tool does when the period is not written anywhere. Guessing from the size of the numbers is a guess, even when it is usually right.
How we handle it. The period is taken only from what the roll states, never guessed from how large the numbers look. When the roll does not state it, each suite's rent is shown as printed, but no per-square-foot rate or average rent is computed, and the report says why.
3. What happens to a cell it could not read?
Scanned PDFs lose digits. A good tool marks the cell as unreadable. A weak one fills it with a market rate, a neighbor's rate or a column average, and the gap disappears.
Blur one rent cell in your test file and see what comes back.
How we handle it. The reader's first rule is that an unreadable cell stays empty, with the reason attached: never a zero, never the row above, never a market rate or a column average. The figures are then computed only from what was read.
4. Are averages taken over the whole roll?
An average rent over eleven of twelve leased suites is not the roll's average rent. It is the average of what the tool happened to read.
Compare the tool's average to your manual one. If they differ, ask which rows were included.
How we handle it. Figures over the whole roll are all or nothing. If the roll was not transcribed whole, occupancy, rent totals and WALT are withheld, and the report says how the roll fell short.
5. Are concessions and delinquency captured or dropped?
Concessions and arrears often sit in a notes column in plain language. Tools that map only structured columns drop them silently, and the in-place rent then looks better than the cash.
Check each note in your test file against the output.
How we handle it. A note the roll carries for a suite stays with that suite. Columns the reader cannot place are listed by header with the reason, so they do not disappear. Check the full note text against your own read before you rely on it.
6. Can you trace each derived figure?
Occupancy, WALT, rollover and rent per square foot are arithmetic on figures the roll printed, as the worked example above shows. You should be able to see which figures went in.
How we handle it. The reader transcribes and does not calculate. The derived figures are computed afterwards by fixed code from the transcribed rows, so the same rows always give the same result. Market rents for a loss-to-lease comparison come from outside the roll; in an underwriting run they are tied to sources, and where none is found the gap is named, not filled.
The six checks at a glance
| Check | What to compare | Red flag |
|---|---|---|
| 1. Whole roll read | Rows in the document vs rows in the output | Tool cannot state the row count |
| 2. Rent period | Monthly vs annual treatment | Period guessed from number size |
| 3. Unreadable cell | A deliberately blurred rent cell | Cell filled with a market or neighboring figure |
| 4. Averages | Tool average vs your manual average | Average over only the rows it read |
| 5. Concessions, delinquency | Notes column vs output | Notes dropped silently |
| 6. Traceability | Inputs behind each derived figure | No way to see which figures went in |
What to do with the results
A tool that fails check 1 or 2 is not safe for underwriting, however good the demo looked. Failures on checks 3 to 6 can be managed if the tool shows them to you instead of hiding them.
Run the same file through every tool on your shortlist and keep the scores. The comparison will be specific to the rolls you actually receive.
Three more things worth putting on the test file:
- The as-of date. Every remaining-term figure is measured from it. A tool should take it from the roll, never from today's date or the file name (ours does exactly that: no stated date, no date).
- The area basis. Rentable and usable square feet are not the same number, and rent per square foot changes with the basis. Check that the tool keeps the basis the roll states.
- Merged cells and grouped layouts. Rolls grouped by floor or with merged tenant cells are where rows get dropped or shifted. Count the rows yourself on one page and compare.
What rent roll software does not replace
- The leases. A rent roll is a summary prepared by the seller or manager, and software that reads only the roll cannot see where it disagrees with the lease. See rent roll vs leases: six mismatches, and for reading the leases themselves, lease abstraction software.
- Tenant estoppels. Only the tenant confirms rent, term and defaults. See what an estoppel certificate is.
- The T-12. The roll shows what is billed on paper; the operating statement shows what was collected. Reconcile the two.
- A site visit and a licensed appraisal. Whether suites are occupied and what the building would sell for are not questions a roll answers.
FAQ
What is rent roll software?
The term covers three different jobs. Property management systems generate a rent roll from their own ledger. Extraction tools read a rent roll that arrives as a PDF or spreadsheet and turn it into rows. Analysis tools then compute occupancy, remaining lease term, rollover and rent per square foot from those rows. A deal team usually needs the second and third kind, because the roll it receives was produced by someone else.
What does a rent roll analysis include?
At minimum: occupancy by area, annual in-place rent, average rent per square foot, weighted average lease term (WALT), a rollover schedule by lease expiry year, and loss to lease, which is the gap between market rent and the rent in place. A good analysis also lists concessions, arrears and anything it could not read, so a reader can see what the figures leave out.
How do you do a rent roll analysis?
Confirm the as-of date, the rent period and the area basis the roll states. Count the tenancy rows. Compute occupancy and in-place rent from those rows, then WALT, then the share of rent expiring in each year. Compare each rent to a market rent for loss to lease. Finally check the notes column for concessions and arrears, and compare the roll to the leases.
Can AI analyze a rent roll?
Yes, but the useful question is what it does when the roll is messy. Test it on your worst real roll: it should state how many rows it read, leave an unreadable cell empty instead of filling it, and withhold whole-roll figures when the roll was not read in full.
How do I test rent roll software before choosing it?
Run it on a real roll from a recent deal that has a missing rent period, concession notes and more than one page. Compare its row count, average rent and notes to your own manual read. The six checks on this page are that comparison.
Does rent roll software replace reading the leases?
No. A rent roll is a summary prepared by the seller or manager. The leases and the tenant estoppels are what confirm it, and software that reads only the roll cannot find a mismatch between the two.