WorkflowCommercial Real Estate & Construction

Evaluate · proving the roll

Rent roll reconciliation: when the roll doesn't match the leases

Rent roll reconciliation is the check that every tenant, rent and date on the roll agrees with its lease, the tenant's own estoppel and the bank deposits. The rules ask lenders to audit a sample; Rent Roll & Operating Statement Analysis checks every suite, and shows the sources side by side wherever they disagree.

Updated · 13 min read

See one case, screen by screen →
Watch with transcript →

Rent roll reconciliation means proving each line of a rent roll against independent evidence: the lease and its amendments for the terms, the tenant's estoppel for what the tenant itself confirms, and the bank deposits for what was actually paid. Where the three agree, the rent can be underwritten; where they disagree, the lender has found income that is stale, overstated or not there. It matters because the rent roll comes from the borrower, research on securitised loans finds underwritten income commonly overstated, and the most explicit public rules ask for only a sample of leases to be audited. It is hard because a full reconciliation means opening every lease, every amendment in date order and three months of bank statements for every deal. Botminds' Rent Roll & Operating Statement Analysis does that on every suite: its agents read the package, compare the sources and show each difference with both passages, and the analyst decides what is underwritten.

The suite-level examples come from a fictional sample deal run through the solution: Wexley Crossing, a 21-suite office and retail building in Columbus, Ohio, refinancing $14,500,000.

How often underwritten income runs ahead of the property

29%

of CMBS loans studied overstated projected income by at least 5%

39,522

loans pooled into CMBS from 2013 to 2019, compared with their first year of actual income

$4M

of value created by $200,000 of overstated income at a 5% capitalization rate

Griffin and Priest, 'Is COVID Revealing a Virus in CMBS 2.0?', Journal of Finance 78 (2023), as summarised by the University of Texas at Austin McCombs School of Business. The sample is securitised loans, not bank portfolio loans.Source: Journal of Finance, Griffin & Priest (2023); UT Austin McCombs research summary

How do you reconcile a rent roll? Three sources, one question per suite

You reconcile a rent roll by asking, for every suite, whether the lease, the estoppel and the deposits each tell the same story as the roll. Each source catches different errors, which is why one is not enough. The lease shows what was agreed and how it has been amended. The estoppel shows what the tenant says today, including the date through which rent is paid and any defaults or rights. The deposits show what money arrived.

Four ways a rent roll goes wrong, and the source that catches each

MismatchSample suiteLease and amendmentsEstoppelDeposits
Rent cut by a later amendmentPulse Athletic Club: roll $24.00, amendment $16.50Catches it, if every amendment is read in date orderConfirms the amended rentConfirm: $17,885 a month, the amendment rate
Tenant marked current, not payingMaple & Main Kitchen: roll "current", $95,200Silent: the lease is validCatches it: paid through 30 JuneConfirm: nothing July to September
Tenant with no leaseLantern Nail Spa: roll $36,400Catches it: no lease in the packageMissingConfirm: no deposits since March
Wrong lease end dateNorthpoint Family Dental: roll 2031Catches it: ends March 2027Should confirm the dateSilent: the rent is right
Fictional sample deal Wexley Crossing in Rent Roll & Operating Statement Analysis: four mismatches among 18 leased suites, $205,100 of stated base rent removed. No single source catches all four.

The table makes the point a sampling approach tends to miss. Deposits alone would have found three of the four problems and missed the date. Leases alone would have missed the tenant who stopped paying. Estoppels alone would have missed the tenant who had never signed one. The reconciliation is the combination.

Rent roll vs leases: what a lease audit checks

A lease audit compares the terms of each lease with its line on the rent roll and then with the income the lender is about to underwrite. HUD's Multifamily Accelerated Processing Guide gives the most precise public description: "The terms of the leases must be compared to the rent roll, verifying the unit number, resident name, lease commencement date, expiration date, concessions, if any, and monthly rent. The Underwriter must confirm that this data is consistent with the assumptions used in the underwriting analysis" (HUD MAP Guide, Chapter 11).

The next sentence is the standard of proof: "Any inconsistencies or conflicts between the leases, rent roll and the underwritten revenue assumptions must be fully investigated and explained." HUD also wants the work visible: the scope and results of the audit go in the underwriter's narrative, and copies of the audited leases stay in the working papers. For a commercial lender the same list extends naturally to area, recovery terms, options and amendments, the columns where office and retail rent rolls go wrong.

How many leases should a lender audit?

HUD's MAP Guide sets a sample by project size: at least one of each unit type, plus 10% of units for projects of 50 or fewer, 10 units plus 5% of units above 50 for projects up to 250, and 15 units plus 2% of units above 250, to a maximum of 50. Typically the leases audited are those of the units inspected. The share of the property audited falls steeply as it grows.

Above 100 units, HUD's lease-audit sample shrinks as a share of the property

50 units · at least 5 audited
10%
100 units · 13 audited
13%
250 units · 20 audited
8%
500 units · 20 audited
4%
1,000 units · 30 audited
3%
2,000 units · 50 audited, the cap
2.5%
Our arithmetic on the sample rule in HUD's MAP Guide, Revision March 2021, Chapter 11, rounding partial units up and ignoring the one-of-each-unit-type minimum.Source: HUD MAP Guide, lease audit

A sample is a reasonable design for multifamily, where hundreds of similar leases carry similar rents and an error in one unit moves income by a fraction of a percent. It is a weak design for an office or retail building, where a handful of leases carry most of the rent and each is negotiated separately.

Why a sample misses the mismatch that matters in commercial property

In a commercial building, a sample can miss everything. Wexley Crossing has 18 leased suites and four of them are wrong. Audit a random two, roughly the 10% HUD's rule would give a small multifamily property, and the chance of missing all four is about 59%. The four mismatches are worth $205,100 of rent, 10.3% of what the roll states.

Concentration makes it worse. One tenant, Hollis Freight Group, pays 30.5% of the building's verified rent from four floors. A sample that happens to include it proves a third of the income; one that does not proves a few percent. Commercial lenders sometimes respond by auditing the largest tenants by rent, which catches concentration but by design skips the small suites where, at this building, three of the four problems sat.

Sampling the leases versus checking every suite

A sample lease auditEvery suite against lease, estoppel and deposits
Coverage

A sample lease audit: A share of units or the largest tenants by rent.

Every suite against lease, estoppel and deposits: All leased suites; vacant suites confirmed vacant.

What it proves

A sample lease audit: That the sampled leases agree with the roll.

Every suite against lease, estoppel and deposits: That each rent underwritten is in force, confirmed and paid.

Errors it misses

A sample lease audit: Anything outside the sample: here, up to all four mismatches.

Every suite against lease, estoppel and deposits: Errors in documents the package does not contain, which become requests to the borrower.

Effort by hand

A sample lease audit: Hours per deal, which is why it is a sample.

Every suite against lease, estoppel and deposits: Many hours per deal by hand; minutes with agents reading the package.

What the analyst does

A sample lease audit: Opens leases and ticks rows.

Every suite against lease, estoppel and deposits: Reviews the differences, with both passages shown, and decides.

Our comparison. The sample design is HUD's MAP rule for multifamily; the every-suite design is how Rent Roll & Operating Statement Analysis works, with a 100% check of leased suites as its design target.

Can deposits prove a rent roll?

Deposits prove that money arrived, not that it was rent, and not that it will keep arriving. Matched to tenants by payer and amount over three months, they are still the strongest single test of a rent roll, because a stale term or a tenant who has stopped paying shows up as a missing or different deposit.

The discipline is in what does not count. An unmatched deposit is not rent. At the sample deal a $12,000 transfer from the sponsor's property-management company landed on 30 September, the rent roll's date; it matches no tenant and stays out of income. A borrower that wants a building to look occupied can make deposits appear, which is exactly what happened in a federal mortgage fraud case covered in who certifies a rent roll, and what that proves. Matching by payer, against a named tenant with a signed lease, is what makes deposits hard to fake.

Rent Roll & Operating Statement Analysis: one suite's evidence, side by side

Suite 201 panel for Pulse Athletic Club, 9,800 square feet: the rent roll says lease term March 2022 to February 2032, base rent $24.00 per square foot or $235,200, recoveries $4,410 a month, flagged rent cut by amendment; the source says Amendment 2 section 3, signed 18 March 2026, sets annual base rent at $16.50 per rentable square foot, $161,700, for eighteen months from 1 April 2026; deposits show $24,010 billed a month against $17,885 received in July, August and September; underwriting at $161,700, minus $73,500, with the step back to $24.00 in October 2027 not counted.
The fictional sample deal's suite 201: what the roll says, the amendment's own words, and three deposits that settle which one is in force.

What are rent roll fraud red flags?

Most mismatches are not fraud: a property manager forgets to update a rent after an amendment, or carries a tenant as current out of optimism. But the same checks find both, and a handful of patterns deserve a harder look whatever their cause.

Rent roll red flags worth a second look

  1. Occupancy far above comparable buildings, with no lease-up history

    A building that went from half empty to full in a quarter should show the leases and the deposits.

  2. Round-number rents, or identical rents per foot across different space

    Real leases are negotiated one by one.

  3. Tenants on the roll with no lease, or leases signed just before the application

    Recent paper is not yet proven by payment.

  4. Deposits from the sponsor, its affiliates or the manager

    Money moving inside the borrower group is not tenant rent.

  5. Rent paid by money order, cash or a third party

    Harder to tie to the tenant named in the lease.

  6. Estoppels that are missing, unsigned or returned by the landlord

    An estoppel is only evidence if the tenant signs it.

  7. A T-12 that rises sharply in the last three months

    The history should support the rent roll, not catch up with it.

  8. Inspection access refused to occupied units or suites

    An inspector should see what the roll describes.

Our checklist. Each item is a reason to widen the reconciliation, not a finding in itself.

What if the rent roll doesn't match the leases? Underwriting each mismatch

When the rent roll does not match, underwrite what the evidence supports, write down why, and turn whatever is missing into a request or a condition. Each mismatch at the sample deal ends in one of four treatments.

Where an amendment has changed the rent, underwrite the rent in force: Pulse Athletic Club at $161,700, with the later step back to $24.00 not counted. Where a tenant has stopped paying, underwrite the suite as vacant until it cures: Maple & Main Kitchen, $95,200 out, and a default notice, cure or re-letting plan as a condition. Where a tenant has no lease, exclude it until the lease, a signed estoppel and a first deposit arrive: Lantern Nail Spa, $36,400 out, with a request to the sponsor that, if met, lifts the supportable loan from $12,850,000 to $13,200,000. Where only a date is wrong, correct the date and test what it means: Northpoint Family Dental's March 2027 expiry becomes a condition for a renewal or letter of intent.

Rent Roll & Operating Statement Analysis shows every mismatch with its three sources

Mismatches screen: 4 mismatches, minus $205,100 of rent taken out, 10.3% of stated base rent, 6 operating statement adjustments, 2 requests to the borrower. Each mismatch shows the rent roll, the lease and estoppel and the deposits side by side with links to the amendment, estoppel paragraph and deposits, and the underwriting decision; a panel lists operating statement adjustments each tied to a bank standard, and requests sent to the borrower for a certified rent roll and the status of Maple and Main Kitchen.
The fictional sample deal: each mismatch with the rent roll, the lease and estoppel, and the deposits in three columns, the decision beside it, and what was asked of the borrower.

What a rent roll reconciliation should leave in the credit file

A reconciliation is only as useful as what it leaves behind for the reviewer and the examiner. For each suite that means the rent roll's line, the lease clause, the estoppel paragraph and the deposits relied on, the decision taken and who took it; for each gap, what was requested, of whom and when, and the answer when it came.

HUD asks the same of its multifamily lenders: the scope and results of the lease audit go in the underwriter's narrative, and the leases reviewed stay in the working papers, "which may be subject to audit." A bank's commercial file benefits from the same discipline, because the examiner's file review begins with the rent roll and the leases.

At the sample deal the file shows four mismatches, none of them accepted into the underwriting as stated, two requests sent to the sponsor's manager on 12 October, and five conditions on the spread. Every verified rent links to the file, page and passage it came from. The test of the file is simple: someone who never saw the deal should be able to open it and reach the same rent for every suite.

Every suite instead of a sample: what changes for the credit file

Checking every suite changes what the analyst's signature can mean. Under a sample, the analyst can certify that the leases audited agree with the roll. Under a full reconciliation, the analyst can certify that every rent in the spread is in force, confirmed and paid, or excluded with a reason, which is what an examiner reading the same leases will look for.

It also changes where time goes. The reading, matching and comparing are mechanical, and agents do them in the time a person takes to open the first lease. What is left for the analyst is judgement on the four suites that disagree, which is where the credit work was always meant to be. Reconciling the rent roll with the T-12 is the next step, and Rent Roll & Operating Statement Analysis shows both on one deal.

The building recoloured by what is proven

Stacking plan of Wexley Crossing coloured by checks: 14 of 18 leased suites shown in green where lease, estoppel and deposits agree, lighter green for small suites proven by deposits, amber for Northpoint Family Dental where rent holds but dates do not, red for Pulse Athletic Club, Maple and Main Kitchen and Lantern Nail Spa where rent is not proven, grey for vacant suites; a banner summarises the four mismatches and $205,100 of rent taken out.
The fictional sample deal: 14 of 18 leased suites hold up; four do not, and the rent taken out is shown on the plan.

Questions people ask

What is a rent roll audit?

A rent roll audit is a check of the rent roll against the leases, and often the tenants and the payments, to confirm that the rents, dates and occupancy it states are real. Lenders call the lease part a lease audit; HUD's MAP Guide requires one on a sample of units, compared field by field with the rent roll.

Who performs the lease audit on a multifamily loan?

Under HUD's MAP Guide, the lender's approved underwriter, or an analyst or trainee acting under the underwriter's direction who does not report to the loan originator. The person who inspected has to be named in the underwriter's narrative, and the audited leases stay in the working papers.

Does every tenant need an estoppel for the reconciliation?

Not usually. Lenders set a size threshold, because chasing estoppels from small tenants costs more than it proves. The sample bank requires them from tenants of 2,500 square feet and above and proves smaller suites by their leases and deposits.

How many months of deposits should a lender check?

Three months is a common minimum, long enough to show a pattern and short enough to obtain. The sample bank checks three. Fannie Mae's multifamily rules also ask for three months of vacancy history and an aged receivables report at 30, 60 and 90 days.

What if a tenant's estoppel disagrees with the lease?

Investigate before underwriting either version. A signed estoppel binds the tenant to what it states, so a lower rent, a default or a right the lease does not show is a serious finding. The solution's agents never override a signed estoppel; they report the difference with both passages for the analyst to resolve.

Rent Roll & Operating Statement Analysis.
See it on your own files.

An agentic solution from Botminds. Any rent roll or operating statement, in any format, turned into the bank's template and checked against the leases. Book a demo, or explore how it works.