Rent roll and operating statement analysis, explained.

From a list of tenants to a loan amount: how a building's rent decides what it can borrow

Wexley Crossing's 37 files, from the owner's package to annual review

1. The owner sends a packageWexley Crossing's owner sends 37 files: a rent roll, a T-12, two years of statements, 14 leases and amendments, 12 estoppels, bank statements, a tax notice and an insurance quote.
2. The relationship manager checks it is completeThe package arrives on a Thursday. Credit committee is a week later.
3. An analyst spreads and proves itRent roll and T-12 into the template, every suite checked against its lease, estoppel and deposits, income and expenses restated, the loan sized. This is where the $205,100 of unproven rent is found, or carried into the loan.
4. A senior underwriter reviews, credit decidesThe reviewer traces each adjustment; a credit officer approves the loan, with conditions.
5. The rent roll comes back every yearAnnual reviews and the refinance at maturity repeat the work on a new rent roll and a new T-12.

Step 3 is the subject of this guide. The people, companies and figures in this example are fictional.

Four surprises about rent rolls, T-12s and lease audits

Rent roll, T-12, estoppel certificate, net cash flow

Fourteen terms are defined in the one-page summary.

How to read a rent roll and a T-12, column by column

In shortThe rent roll is a promise: what each tenant owes from today. The T-12 is a history: what came in and went out over the last year. Lenders need both because each one misleads in its own way, and because they are prepared by the borrower's side, in the borrower's format, for the borrower's purpose.

What each column of a commercial rent roll tells a lender

Office leases are "usually leased on a gross basis", typically for "three, five, or seven years"; retail anchor leases run longer and may pay a percentage of sales.1

What a T-12 shows, and what it hides

A T-12 lists every income and expense account by month for the latest twelve months the manager has closed, so it moves forward each month. It is the nearest thing a lender has to the building's actual performance, and it carries traps.

The OCC warns that a statement "prepared on a cash basis" can "understate expenses and overstate income" when a large bill falls in a different year, and sets the goal as "an NOI that represents a stabilized estimate of income and expenses".1 One-time items sit in it too: last year's common area reconciliation booked this year, a lease buyout, an insurance payout. The CRE Finance Council's standard method says such "Non-recurring extraordinary income" should "always be adjusted out of income".3

What one refinance package holds

The rent roll and the T-12 are two files out of 37. The other 35 are how the lender proves them, which is why the size of a package depends on the number of tenants more than on the size of the loan.

The rules behind rent roll analysis, and what changed by 2026

In shortNo federal rule spells out how a bank must spread a rent roll. The OCC's handbook sets what examiners expect to find in the file, the 2023 workout statement shows how examiners read rent rolls, and the agency multifamily guides give the most explicit public rules. Since 2024 Freddie Mac has asked lenders to check audited leases against tenants' payment records, and in April 2026 the model risk guidance was replaced.

Reconciling a rent roll to leases, estoppels and bank deposits, suite by suite

In shortEach suite gets three questions. Does the lease, read with every amendment in date order, say what the rent roll says? Does the tenant's signed estoppel agree? Did the money arrive? Where all three agree, the rent counts. Where they disagree, the disagreement is the finding, and the lender underwrites the rent the evidence supports.

The three sources, and how each one fails

What the checks found at Wexley Crossing

Fictional example. A $12,000 transfer from the sponsor's own company landed on September 30, the rent roll's date. It matches no tenant, so it stays out of income.

Which base rent to believe

The T-12 looks reassuring, only about $49,000 below the rent roll. It holds only a few months of the fitness club's lower rent and of the restaurant's missed payments, and none of the gap from a tenant the roll counts but nobody can prove. Run the same three events forward for a full year and the gap is the whole $205,100. A T-12 averages a year that has already happened. The leases and deposits show the rent the building collects from today, which is the rent the loan will be paid from.

From the borrower's NOI to the bank's: every adjustment and the standard behind it

In shortStart from proven rent and recoveries, take off a vacancy allowance, then restate each expense to what the building will actually pay: taxes at the new assessment, insurance at the renewal quote, a market management fee. That is underwritten NOI. Take off reserves for capital repairs and re-leasing and you have net cash flow, the number the loan is sized on.

Proven rent, recoveries and other recurring income, less the vacancy allowance, is effective gross income (EGI), the base for the management fee. The OCC describes the same chain: begin "with determining the gross income that a property would generate when fully leased", apply a vacancy factor that "may be higher or lower than actual", and include expenses that "may not represent an actual or immediate cash expense, such as management fees and reserves for capital replacements".1 The replacement reserve "is imputed for underwriting purposes irrespective of whether it is actually funded".1

Where public rules put the standards

From the borrower's NOI to the bank's, one adjustment at a time

Two of the adjustments are judgment, and both are common. The owner's affiliate charges a 2.0% management fee. A buyer of the building, or a lender that takes it back, would pay a market fee, which is why the OCC and the CREFC method both start at 3%. And the vacancy allowance applies to a building that is fully proven, so a 5% floor is a policy choice the credit policy should state.

How to size a CRE loan on coverage, loan-to-value and debt yield

In shortCompute the largest loan each test allows and lend the smallest. Coverage asks whether net cash flow pays the debt with room to spare; loan-to-value asks whether the building's value covers the loan; debt yield asks what the cash flow is worth as a share of the loan, whatever the rate. The test that gives the smallest loan sets the limit; at Wexley Crossing that is coverage.

The loan constant is the year's payments per dollar borrowed: 8.028% for a 6.40% rate on a 25-year schedule. The OCC notes that an appropriate coverage "should consider the loan amortization period and the expected volatility of the cash flow", and that debt yield "provides a measurement of risk that is independent of the interest rate, amortization period, and capitalization rate".1 The Federal Reserve's stress-test documentation says lenders "generally require a minimum DSCR between 1.2 and 1.5 to qualify for a loan".16

The same request, three ways

Fictional example. Debt service on $14.5 million at 6.40% over 25 years is $1,164,011 a year. Loan-to-value does not move with the cash flow, which is why a value-only check passes a loan the cash flow cannot carry.

Debt yield passes or fails with the income you divide

Debt yield conventions are market practice: one valuation firm writes that "Most lenders set a minimum debt yield somewhere between 8% and 10% for stabilized commercial properties", and calls these "market conventions rather than fixed rules".17

The ceiling the regulators set

Tenant rollover risk: reading the lease-expiry calendar against the loan's maturity

In shortBuild a schedule of the verified rent that expires each year and mark the year the loan matures. If a large share expires in that year, or just before it, the loan may not refinance. Then compute coverage as if those tenants leave, and write a condition: a renewal deadline, a reserve, or both.

The anchor tenant, a freight company, holds floors 4 to 7 under one lease: 42,000 square feet, 37.3% of the building, $546,000 a year to June 30, 2031. That is 38.2% of the bank's NOI, and the lease ends six months before the loan does. Two smaller tenants also end in 2031, a child-care center and a restaurant, for $715,000 of rent in all.

How examiners read rollover

The 2023 workout statement includes an office loan restructured at maturity on interest-only terms that the lender graded pass. The examiner read the rent roll: "A review of the rent roll, which was available to the lender at the time of the restructuring, reflects the majority of tenants have short-term leases, with three leases expected to expire within the next three months." The loan was classified substandard, the grade for a loan with a well-defined weakness, partly because "there is lease rollover risk because three of the leases are expiring soon".5

The Federal Reserve's stress-test model builds maturity in: for income-producing loans "that approach maturity with DSCR below 1.2 (a typical minimum underwriting threshold)", the projected probability of default is "adjusted upwards by a factor of four".16

Tools for a rollover year

Twelve rent roll and T-12 errors that make a building look stronger than it is

In shortMost errors overstate income. The rent roll is stale or wrong, the T-12 carries one-time money, or the expenses are last year's. They are hard to spot because each one looks normal on the spreadsheet. The fix is a check against an independent source for every suite and every adjusted line.

How often underwritten income runs ahead of the building

The study covered securitized loans; bank portfolio loans were outside it. Its lesson carries over: income written by the side that wants the loan tends to run high. The McCombs summary gives the arithmetic: a building valued at a 5% capitalization rate (income divided by value) gains $4 million of value from $200,000 of overstated income.19

What a wrong rent roll risks: forged leases, classified loans and losses

In shortRent rolls are a known fraud document. Federal cases show fake tenants, forged leases and staged proof of payment getting past inspectors and lenders. Even an honest rent roll that is stale can send a loan to classification at its next review. And bank CRE delinquencies, still low, have more than doubled since 2022.

The Hartford case shows why proof has to come from a source the borrower does not control. Inspectors were shown furnished, empty apartments. As proof of payment, the scheme then emailed the lender pictures of money orders and checks from the invented tenants, bought by its own people.20 In the Massachusetts case, prosecutors charged forged leases, forged tenant signatures and inflated rents.22 A pattern of deposits from named tenants into the property's own account, over several months, is much harder to stage than any one document.

Bank CRE loans that stop paying

Office vacancy reached 14.0% at the end of 2025, the highest of the major property types, and the FDIC notes that net operating income growth "continued to slow, reflecting elevated vacancy rates, higher property operating costs, and tepid rent growth".25 In that market, a rent roll made a year ago, or a T-12 that averages better months, overstates the building.

The CRE lending market in 2026: $875 billion of maturities and a return to easing

In shortUS commercial banks hold more than $3.1 trillion of CRE loans. $875 billion of commercial and multifamily mortgages matures in 2026, $396 billion of it at banks and thrifts. Lenders have turned from tightening to easing. More refinances, on looser terms, means more rent rolls to prove, each one carrying more weight.

Each of those maturities needs a fresh rent roll, a fresh T-12 and a new sizing at today's rates. The OCC put it plainly in spring 2026: "A substantial volume of CRE loans originated in a lower-interest environment will mature in the next several years and will need to be refinanced at prevailing rates."9 The MBA counts $652 billion more in 2027.27

AI rent roll analysis: what software can prove, and what the 2026 guidance leaves to your bank

In shortSoftware can read rent rolls and T-12s in any format, map them into the template, read every lease and estoppel, match deposits to tenants and recompute the sizing in seconds. Reading and mapping save keying time. Checking every suite against independent evidence, with each figure traceable to its page, is what makes the spread reliable. Under SR 26-2 the arithmetic falls outside the model definition and generative AI outside the guidance, so your own controls carry the weight.

Three levels of rent roll software, from typing to proof

The April 17, 2026 guidance, issued jointly as Federal Reserve SR 26-2, OCC Bulletin 2026-13 and FDIC FIL-15-2026, replaced SR 11-7.7,12,8 It defines a model as "a complex quantitative method, system, or approach that applies statistical, economic, or financial theories to process input data into quantitative estimates".7

The definition excludes "simple arithmetic calculations, such as those found within spreadsheets, as well as deterministic rule-based processes".7 Its footnote puts generative AI, and AI that acts on its own, outside its scope, while saying a bank's own risk management "should guide the determination of appropriate governance and controls" for such tools.7,12

The third-party guidance keeps the responsibility for an outsourced activity with the bank.31 NIST's framework gives a structure for the bank's own testing: govern, map, measure, manage.33 For business credit, Regulation B's notice rules still apply to a declined request.34

Market rent, renewal odds and forged documents stay with people

• Market rent, renewal odds and the cost to re-let a floor are judgments.
• A missing lease still has to come from the borrower.
• An estoppel or a deposit can be forged; a disagreement between sources is a question for a person.
• The credit decision, and the signature on the spread, stay with the bank.

How CRE credit teams spread and prove a rent roll today, and where the hours go

In shortA relationship manager gathers the package, an analyst keys and checks it, a senior underwriter reviews and a credit officer decides. Most of the analyst's hours go to reading the operating statements and checking leases, estoppels and deposits, which is also the part most often cut short.

Who spreads and proves a rent roll: RM, analyst, underwriter, credit

Four people a refinance package passes before committee

A 14-hour spread, more than half on statements and lease checks

Few analysts get fourteen quiet hours. Spread over calls and other deals, one package can take most of a week, and the step most easily cut is the one in the middle: opening every lease and every bank statement. That is the step that finds the money.

A spreading workbook, an outsourced spreading service or verification software

Wexley Crossing's refinance: four mismatches, a rent cut by amendment in Suite 201, and 2031's rollover

In shortThis is the example from the top of the page, inside the product. Six agents read the 37 files, write the rent roll and the operating statement into the bank's template, check every leased suite against its lease, estoppel and deposits, apply the bank's standards and size the loan. Priya Raghunandan, the CRE credit analyst, works the four mismatches, reads the rollover and signs. Owen Halvorsen, the senior underwriter, reviews; Denise Okafor, the credit officer, decides.

1

The deal opens as its building

Priya opens Wexley Crossing and sees it drawn from the rent roll: seven floors and two outparcels, every suite a block sized by its area and shaded by the year its lease ends. One tenant, a freight company, fills floors 4 to 7. The badge under the title says what everything on screen is: "Stated · not checked". As stated, $1,998,200 of base rent on 93.9% occupancy.

Under the plan, a strip shows the share of rent that expires each year, with the loan's maturity marked.

2

Six agents spread the package in 92 seconds

Priya presses "Start spreading". The package reader sorts the 37 files in five formats. The rent roll normalizer writes 21 suites into the bank's template and drops four summary rows. The operating statement spreader maps 36 accounts, 33 to the template and 3 below the line, and finds a one-time $41,800 reconciliation. The lease and estoppel checker reads 14 leases and 12 estoppels; the deposit matcher matches three months of deposits.

The borrower's NOI of $1,803,118 becomes the bank's $1,428,503. At the $14.5 million request, coverage is 1.11x against a 1.25x minimum.

3

Suite 201: the rent an amendment cut

Priya opens the fitness club's suite. The rent roll bills $24.00 a square foot, $24,010 a month with recoveries. Amendment 2, section 3, signed March 18, 2026, cut the rent to $16.50 for eighteen months from April 1. July, August and September deposits of $17,885 match the amendment rate plus recoveries.

The checker quotes the clause and links to it. The underwriting note says the step back to $24.00 in October 2027 is not counted.

4

Four mismatches, each with its three sources

The mismatches screen puts the rent roll, the lease and estoppel, and the deposits side by side for each suite that disagrees: the fitness club at the amendment rate (−$73,500), the restaurant with no deposits since June underwritten as vacant (−$95,200), the nail salon with no lease excluded (−$36,400), and the dental office whose lease ends in March 2027, rent kept and rollover reserved.

Beside them, the six operating statement adjustments, each with its standard, and the requests sent to the sponsor.

5

2031: floors 4 to 7 light up together

Back on the plan, now verified, Priya presses "The year the loan matures". The anchor, a child-care center and a restaurant turn orange: $715,000, 39.9% of verified rent, ends in 2031. The anchor alone is 38% of the bank's NOI and its lease ends six months before the loan does.

The readout says what that means: if none of the three renews, net cash flow falls to $578,503 and coverage on the recommended loan to 0.56x.

6

Signed, reviewed, and sent to credit

On the send-to-credit screen, the NOI bridge runs from the borrower's figure to the bank's, step by step. Five conditions travel with the spread, among them the anchor's renewal by June 30, 2030, or excess cash swept to a $1,470,000 rollover reserve. Priya signs with her password and the meaning of her signature. Owen reviews, and it goes to Denise for Thursday's committee at $12,850,000.

The solution's design target is 100% of leased suites checked against lease, estoppel and deposits on every deal. Our estimate is about one hour of analyst time from a complete package to a signed spread. Measure both on your own packages.

The spreading queue, deposit matching, an anchor's lease abstract and the plan recolored by proven rent

In shortOne deal is the story. These screens show the rest: the queue, the package as received, the rent roll and operating statement in the bank's template, the deposit match, loan sizing, the plan recolored by what is proven, an anchor's lease abstract, the bank's standards and the list of every change with its reason.

Select any screen to open it larger. The bank, building, tenants, people and figures are fictional.

Agents key and match; the credit analyst signs each spread, a senior underwriter reviews it, the credit officer decides

In shortEach agent has one job and written limits. None of them signs a spread, changes a standard, overrides a signed estoppel or counts an unmatched deposit as rent. The credit analyst signs every spread, a senior underwriter reviews it before credit, and the credit officer decides the loan.

Six agents, from package reader to underwriting and sizing

People decide; every number is traced

The template and standards change only by a versioned rule approved by the chief credit officer. Signatures, adjustments and their sources are written to the audit trail and cannot be changed afterwards. Roles are separate: the person who prepares a spread does not review it.

Priya Raghunandan's six to nine packages a week and her reviewers

Rent rolls in any format become a traced spread, a mismatch list, a loan sized three ways and conditions for credit

In shortIt reads the files borrowers already send, writes into your template under your standards, and leaves a spread where every number is traced, a list of mismatches with their sources, the loan sized three ways, the rollover read against maturity, and conditions for credit. Your systems of record stay where they are.

Origination, borrower portal and lease files a spread reads

For each, check whether it has an API, a file feed or only screens, and who owns it.

Your spreading template and vacancy floors, kept line for line

Rent counts when proven, each adjustment named, people sign

What an unproven rent roll costs you: analyst hours, loan dollars and classified credits

In shortStart from your own numbers, because nobody publishes the hours a bank spends on a rent roll or how often its spreads overstate income. A few published figures frame them: how much CRE debt is coming up for refinance, how often securitized loans overstated income, and how far each dollar of overstated cash flow inflates the loan.

Timing five spreads and re-checking every suite on closed deals

The stale anchor amendment, the forged estoppel, the lease-expiry cliff

Analyst hours moved from keying to checking: what a pre-spread, pre-matched package returns

In shortPut in your own numbers. The calculator asks how many packages you spread a year, the hours each takes now and after automation, your loaded hourly cost and what the tool and your testing cost. Every default is an assumption to replace; nothing here is a measured result.

Analyst hours, every suite checked, loans sized on proven rent

Your analyst hours back on every rent roll and T-12 you spread

A team that spreads 200 multi-tenant packages and 100 annual reviews a year clears the 142-package line. A team that lends mostly on single-tenant net-leased buildings saves fewer hours a package and should run the numbers before buying anything.

Your spreading template, written standards and how you verify rent today: a readiness score

In shortPick the answer closest to your team today. Eight questions score 0 to 2; the last is for reflection. The meter adds your score as you go, and each question says why it matters and what a strong answer sounds like.

Explore, replay 30 to 50 past packages, or prove every deal

Rent roll formats, proof against leases and deposits, your standards: what to ask rent roll software vendors

In shortAsk every vendor the same questions, us included. The answers show what the tool reads, what it proves and how, whose standards it applies, what evidence you keep, and how you would measure it on your own packages.

We found no published independent test of any rent roll tool's accuracy on bank CRE packages, as of October 2026. A test on your own closed files is the fairest comparison, and it measures your current process too.

Thirty closed packages, ten with planted errors, then live deals: a ten-week rent roll trial

In shortMeasure first, test on closed packages where you already know the answer, run in parallel on live deals, then decide on three numbers. None of these steps commits you to a vendor.

1. Time five packages by step, one single-tenant and four multi-tenant. That is your baseline.
2. Pull 30 closed packages with their signed spreads, and copy ten with planted problems: a stale amendment, a tenant with no deposits, a wrong end date, a one-time item.
3. Load your template and standards by property type, and your sign-off roles.
4. Run in parallel on live packages for four weeks, with your analysts signing every spread.
5. Decide with three numbers: planted problems found by type, false alarms on clean files, and analyst hours to a signed spread.

Planted rent roll errors found, false alarms and figures traced

Rent rolls, T-12s, estoppels, underwritten NOI and vacancy: answers CRE analysts search for

In shortThe questions CRE credit teams and buyers search for most, each answered on its own.