Can I Afford This Property?Commercial real estate financing, worked out

Reconciling lease abstracts with the commercial property rent roll

A practical guide to building a reconciliation worksheet that compares lease abstracts to the current rent roll and trailing operating statements, showing how differences affect the debt service discussion with a lender.

Source: CodexTopic: Commercial lease analysis1097 wordsUpdated 2026-11-19

A practical guide to building a reconciliation worksheet that compares lease abstracts to the current rent roll and trailing operating statements, showing how differences affect the debt service discussion with a lender.

Why this reconciliation matters to your financing request

When a lender reviews an income-producing property, the rent roll and lease abstracts are two of the first documents examined. The OCC handbook for bank examiners provides guidance that, as part of a loan file review, an examiner may assess the adequacy of cash flow to meet debt service requirements and comment on trends in net operating income, vacancy, and expenses [1]. The handbook also indicates that examiners will review current rent rolls and leases as part of their assessment [1].

If the rent roll shows one occupancy level and the lease abstracts show different terms, expiration dates, or rental rates, the lender cannot rely on either document alone. A sponsor who prepares a clear reconciliation between these two sources demonstrates that the property's income stream is understood and supportable. This guide provides a concrete worksheet you can prepare before approaching a lender.

The timing difference: rent roll snapshot versus trailing twelve months

The current rent roll is a snapshot of who is in the property and what they are paying today. A trailing twelve-month operating statement (T-12) shows historical income and expenses over the past year. These two documents serve different purposes and will rarely match exactly.

The rent roll shows gross rent per the lease terms at this moment. The T-12 reports historical income and expenses on its stated accounting basis, which may differ because of vacancies that have since been filled, tenants who paid late or not at all, concessions that reduced effective rent, or rent increases that took effect during the period. Comparing the two reveals the gap between contractual income and real collections.

How to build a lease abstract reconciliation worksheet

Create a single spreadsheet with one row per tenant. For each tenant, record the following fields from the lease abstract and the rent roll side by side:

  • Tenant name and unit identifier
  • Lease commencement and expiration date
  • Base rent per month and per square foot
  • Any rent steps or escalations scheduled
  • Expense reimbursement structure (net, modified gross, or gross)
  • Percentage rent provisions, if any
  • Co-tenancy clauses or early termination rights
  • Renewal options and notice periods

Reconciling gross rent, collected income, and net operating income

Once the rent roll and lease abstracts are aligned, compare the total gross rent from the rent roll to the actual collected income shown on the T-12. The difference is collection loss. A lender will want to understand whether that loss is temporary or persistent.

From collected income, deduct the operating expenses the landlord actually pays. The lease abstracts should tell you which expenses are the landlord's responsibility and which are reimbursed by tenants. Because terms can vary from lease to lease, each lease agreement should be reviewed to determine which expenses are the landlord's responsibility [1]. Common area maintenance, taxes, insurance, and utilities may be tenant expenses under a net lease, or landlord expenses under a gross lease.

The result after expenses is net operating income. From NOI, deduct annual debt service on the proposed loan to see whether the property generates enough cash flow to cover the loan payments. This is the debt service coverage ratio the lender will evaluate.

Identifying rent roll risks that affect loan structure

Certain lease clauses create risk that a lender will want to quantify. Co-tenancy clauses that permit a tenant to terminate or reduce rent if an anchor tenant leaves make the success of anchor tenants even more critical to the viability of the property [1]. If your property has co-tenancy provisions, identify which tenants have them and what the trigger events are.

Anchor tenants may pay percentage rent in addition to a flat rate. Percentage rents are inherently less predictable, and the flat rate should be high enough to discourage the tenant from ceasing operations while maintaining possession [1]. Record whether the flat rate alone covers debt service, or whether the loan depends on percentage rent that may not materialize.

Lease expiration concentrations are another risk. If several large tenants expire in the same year, the property faces a rollover risk that the appraisal should analyze [1]. Note the expiration dates and renewal probabilities for each tenant.

Reconciling the rent roll with the appraisal assumptions

The appraisal report should analyze and report data on current revenues, expenses, and vacancies [1]. It should also analyze the strength of the tenants, tenant rollover risk, anticipated rents, and probability of lease renewals [1]. Compare the appraisal's income assumptions to your reconciled rent roll. If the appraiser assumes higher rents or lower vacancy than the lease abstracts support, the lender will ask for an explanation.

If significant differences exist between past performance and underwriting assumptions such as lease rates, expenses, and absorption, the appraisal should include adequate explanation [1]. Your reconciliation worksheet becomes the document that either confirms the appraisal assumptions or flags where they need adjustment.

Preparing the reconciliation for your lender

Organize the reconciliation into three sections:

  1. A side-by-side comparison of the lease abstract terms and the rent roll for each tenant, with variances noted
  2. A summary showing gross rent, collected income, operating expenses, and NOI from the T-12, alongside the same figures from the rent roll projected forward
  3. A debt service coverage calculation using the reconciled NOI, deducting ground rent if applicable

If the property is ground-leased, the ground rent should be deducted as an expense when calculating debt service coverage [1]. The ground lease term should extend sufficiently beyond the amortization period to support refinancing [1].

This reconciliation is not a guarantee that the lender will approve the loan. It is a way to present the property's income stream clearly and to show that you have identified and considered the risks in the lease portfolio.

How often should I update the rent roll reconciliation?

Update the reconciliation whenever a lease is signed, renewed, or terminated, and at least quarterly to reflect rent steps, expirations, and changes in collection performance. A lender will want to see the most current version at the time of application.

Does a lease abstract need to be notarized or certified?

No. A lease abstract is your summary of the key terms from the actual lease document. The lender will request the full leases for its own review, but the abstract helps you organize the information and spot inconsistencies quickly.

What if the rent roll and T-12 show very different occupancy rates?

Run the numbers on your deal

Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.

Open the loan sizing calculator

Talk through your financing

Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. OCC Commercial Real Estate Lending handbook
  2. Wraith commercial real estate debt