A rent roll audit in acquisition due diligence ties every line of the seller rent roll back to the signed lease and its amendments: rent, steps, square feet, dates, recoveries, free rent and termination rights. Each difference is priced, then fixed through estoppels, a closing credit or the price. Software that extracts the leases into a source-linked rent roll turns that tie-out from days into hours.
This article is for acquisition analysts, asset managers and buyers of commercial property who have a seller rent roll, a data room of leases and a diligence period that is shorter than it should be. Our product page for this job is rent roll software built from your leases, and plans are on the pricing page.
Why the seller rent roll cannot be taken at face value
The seller rent roll is a report printed from a property system. It shows what someone entered, not what the leases say. Most of the time the two agree on the headline rent. Where they drift is in the details that never made it into the system: an amendment that granted free rent, a fixed square footage that differs from the remeasured suite, a recovery structure entered as triple net when the lease is modified gross, a termination right that has no column at all.
None of this requires a dishonest seller. A rent roll that was never tied out is simply wrong in small ways, and every small error is capitalized into the price you pay. A $10,000 annual overstatement of income at a 7 percent cap rate is about $143,000 of value. That is the arithmetic that makes the audit worth doing on every deal, not only the large ones.
How do you audit a rent roll?
Start from the documents, not the report. Extract each lease and every amendment into the same columns the seller rent roll uses, then compare the two line by line. Price each difference as recurring income, a one-time credit or a risk flag, and send the list to the seller before estoppels go out.
In practice the work has five steps:
- Collect the full lease file per tenant. Lease, every amendment, side letters, commencement date memos and any assignment. A rent roll audit done on the base lease alone misses the changes that matter most.
- Extract the rent roll fields from the documents. Suite, square feet, current rent, step schedule, commencement and expiration, recovery type and share, security deposit, free rent remaining, options and termination rights. Doing this with due diligence lease abstraction gives you each value with a link to its page.
- Compare field by field. Same tenant, same column, lease value against rent roll value. Anything that differs goes on the exception list.
- Price each exception. Recurring income differences change NOI and value. One-time items, such as free rent still to run, become a credit at closing. Risk items, such as a termination right, go into underwriting.
- Close the loop with estoppels. Ask each tenant to confirm the disputed terms in the estoppel certificate, and do not accept a seller estoppel where a tenant one is available.
A worked rent roll tie-out with dollar impact
Here is a worked example from a 14 tenant neighborhood center. The seller rent roll showed in-place base rent of $1,284,600. Extracting the fourteen leases and their amendments and comparing them with the rent roll produced five exceptions.
| Suite | Seller rent roll | What the lease file says | Impact |
|---|---|---|---|
| 104 | 2,200 SF at $36.00, $79,200 a year, no concessions | 2025 amendment grants 6 months of free base rent from January 2027 | One-time, $39,600 closing credit |
| 210 | 3,000 SF at $24.00, $72,000 a year | Lease fixes rentable area at 2,850 SF regardless of remeasurement, so $68,400 | Recurring, minus $3,600 a year |
| 300 | NNN, recoveries of $21,500 a year | Modified gross with a 2023 base year, tenant pays only increases, supporting $6,200 | Recurring, minus $15,300 a year |
| 122 | 1,600 SF at $27.00, $43,200 a year | 3 percent step on 1 September 2026 to $27.81, so $44,496 | Recurring, plus $1,296 a year |
| 118 | $96,000 a year, expires 31 December 2031 | Tenant may terminate effective 30 June 2028 on 6 months notice with a fee of 4 months rent | Risk flag, $96,000 of rent not secured past mid-2028 |
Net the recurring items and NOI is $17,604 a year lower than the seller rent roll implies (minus $3,600, minus $15,300, plus $1,296). At a 7 percent cap rate that is roughly $251,500 of value. Add the $39,600 of free rent the buyer would otherwise fund after closing, and the audit is worth about $291,000 on this deal before anyone prices the termination right in Suite 118.
Notice that one exception ran in the buyer's favor. A good audit is not a hunt for reasons to cut the price. It is a reconciliation, and an honest exception list is easier to negotiate than a one-sided one.
What should I look for in a rent roll?
Look hardest at the fields that come from amendments and the terms that have no rent roll column. The headline rent is usually right. The errors sit in free rent, rent steps, fixed square footage, recovery structure, caps, termination rights, co-tenancy and options that an amendment rewrote.
A short checklist we use on every file:
- Free rent and abatement still to run, often granted in a renewal amendment. Our rent abatement extraction pulls the dates and amounts.
- Rent steps due before closing that the system has not applied yet.
- Square footage as the lease defines it, not as the building was remeasured.
- Recovery type, share and caps, read from the lease, compared with what is billed. See CAM charges extraction.
- Termination and kick-out rights, which never appear in a rent column. See termination options.
- Security deposits and letters of credit, which transfer at closing and must match.
Do estoppel certificates replace a rent roll audit?
No. An estoppel confirms what one tenant agrees is true on a given date, and tenants often sign the landlord draft without reading it. The audit tells you which terms to put in each estoppel. Run the tie-out first, then use the estoppels to settle the exceptions it found.
The legal effect of an estoppel is that the signer cannot later contradict the facts it confirmed, a principle explained in plain terms by Cornell Law School's Legal Information Institute. That protection is only as useful as the questions you asked. If the estoppel does not mention the free rent in Suite 104, it does not protect you from it.
Rent roll audit software, an analyst or an outside firm
| Route | How it works | Where it wins | Watch out for |
|---|---|---|---|
| Analyst with a spreadsheet | Reads each lease and types the fields beside the rent roll | Very small deals, a handful of leases | Time, fatigue on long files, no link back to the page |
| Outside abstraction or diligence firm | Sends the data room out, gets a report back | Large portfolios with budget and time | Turnaround in days, quoted per lease, NDA and minimums |
| LeaseAbstracts | Extracts the rent roll fields from every lease and amendment, each linked to its clause | Diligence on a deadline, 5 to 250 leases, repeat buyers | You still review each exception and decide what it is worth |
As a sense of scale, assume an analyst needs about 90 minutes per lease file once amendments are included. Fourteen files is around 21 hours of reading before the comparison starts. Extraction takes minutes per lease, so the analyst spends the time on the exceptions instead of the typing. Plans are published: $49 a month for 15 leases, $149 for 75 and $399 for 250, which on a single acquisition is less than one hour of an outside reviewer.
How long does a rent roll audit take in due diligence?
With extraction software, a center of 10 to 20 leases can be tied out in a day, including review of every exception. By hand, plan on several days of analyst time for the same file. Start in the first week of the diligence period so estoppels can carry the questions the audit raises.
After the tie-out
Keep the extracted rent roll. It becomes the clean record you onboard into your property system on day one, and it is the document you hand your lender when you refinance. Buyers who do this once tend to use the same file for acquisition lease abstraction on the next deal too. If the plan includes leasing up vacant suites after closing, an AI marketing tool such as Aimarketer can help with the campaign while your team works the lease file.
To try it on your own deal, upload one lease and its amendments and compare the extracted row with the seller rent roll line for that tenant. If they match, you have lost two minutes. If they do not, you have found the first exception.