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

How to reconcile a multifamily rent roll with a T-12 before financing

Lenders scrutinize the alignment between your current rent roll and trailing twelve months of operating statements. This guide explains how to prepare that evidence, identify discrepancies, and present a clean financial narrative for debt underwriting.

Source: CodexTopic: Multifamily income evidence732 wordsUpdated 2026-11-19

Lenders scrutinize the alignment between your current rent roll and trailing twelve months of operating statements. This guide explains how to prepare that evidence, identify discrepancies, and present a clean financial narrative for debt underwriting.

The core reconciliation challenge

The goal is not just to show high occupancy, but to demonstrate economic occupancy. As noted in supervisory guidance, even if a rent roll indicates high physical occupancy, actual collections must be examined to determine true economic performance [1]. Lenders need to see that the property manager is effectively collecting rents and that the income reported in the T-12 matches the contractual obligations in the rent roll.

Step one: Clean the rent roll data

Before you can reconcile anything, your rent roll must be accurate and complete. Lenders expect a detailed spreadsheet that includes every unit, tenant name, lease start and end dates, base rent, and any concessions or abatements.

Start by verifying that all vacant units are marked as such and that any tenants paying below market rate due to temporary concessions are clearly identified. If you have tenants on month-to-month leases, note that status explicitly. Lenders may view month-to-month leases as having higher turnover risk, which could affect underwriting. Ensure that all utilities, parking fees, and amenity charges are listed separately if they are part of the gross rental income. Inconsistencies here may indicate management issues, which the OCC notes can be a major cause of difficulty for multifamily loans [1].

Step two: Audit the T-12 operating statement

Identify whether the T-12 is prepared on a cash or accrual basis. Reconcile collections to reported income where necessary. Put the current rent-roll snapshot and the twelve historical months on a consistent time basis before comparison. An annualized current rent schedule is a scenario, not a substitute for actual historical results.

Lenders assess the adequacy of cash flow to meet debt service by reviewing trends in NOI, vacancy, and expenses [1]. You need to prove that the current rent roll is a realistic projection of future cash flow based on historical performance.

Step three: Identify and explain variances

Once you have both documents side-by-side, calculate the variance. If the rent roll projects higher income than the T-12 realized, you must provide a credible explanation. Are recent renovations allowing for rent increases? Is the local market experiencing a surge in demand? Or did the previous year suffer from unusual vacancies?

If the rent roll shows lower income than the T-12, the lender may ask whether the prior year included one-time gains or if current management has improved collections. Property management ability is critical; inept management is a major cause of difficulty for loans [1]. Demonstrating that you have corrected past issues strengthens your case.

Step four: Prepare the reconciliation workpaper

Create a simple spreadsheet that lists each line item from the T-12 and compares it to the corresponding figure in the rent roll. Include columns for: 1. T-12 Actual Annualized Income 2. Rent Roll Projected Annual Income 3. Variance ($) 4. Variance (%) 5. Explanation Note

This document serves as your evidence checklist. It shows the underwriter that you understand the numbers and have proactively addressed potential questions. Explain material or unresolved variances and provide a brief, factual narrative supported by the source documents; do not assume a universal variance threshold. Avoid vague explanations like "market conditions." Be specific about lease expirations, new contracts signed, or operational changes.

How do lenders treat concessions in the rent roll?

Show the face rent, concession terms, effective dates and actual collections separately. Explain the effect over the stated lease and reporting periods, and ask the lender how it treats concessions in its own analysis. Do not assume that every lender annualizes them the same way.

What if my property is self-managed?

Self-management does not disqualify you, but it requires extra diligence. Lenders will carefully evaluate the owner’s experience and time commitment. You must still provide professional-grade rent rolls and T-12s. Poor record-keeping in a self-managed property raises red flags about operational competence [1].

Can I use a pro forma instead of a T-12 for existing properties?

Provide available historical operating statements and label the pro forma as a forecast. Explain any missing history or changed business plan, support assumptions with the evidence available, and ask the actual lender what further information it requires. A projection should not silently replace or overwrite reported results.

Next steps for your financing discussion

Model this deal and request financing

Run a multifamily acquisition or value-add model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.

Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.

Open the acquisition model

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