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

Documenting the dates behind a multifamily occupancy snapshot

A practical guide to preparing the occupancy history and collection evidence lenders review when underwriting a multifamily loan, with a concrete document checklist and instructions for reconciling rent-roll dates with trailing twelve-month operating statements.

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

A practical guide to preparing the occupancy history and collection evidence lenders review when underwriting a multifamily loan, with a concrete document checklist and instructions for reconciling rent-roll dates with trailing twelve-month operating statements.

When you submit a multifamily loan request, the lender will compare two documents that describe the same property from different time perspectives: a current rent roll and a trailing twelve months (T-12) of operating statements. The rent roll is a snapshot of who is in place and what they owe as of a specific date. The T-12 is a historical record of rent scheduled and rent collected over the past twelve months. Lenders use the two together to measure the gap between scheduled rent and cash collected, and to evaluate whether management can sustain that gap. This guide explains how to prepare the date-stamped evidence lenders expect, how to reconcile the two documents, and how the information affects the financing discussion.

Occupancy history as a lending risk indicator

The OCC Commercial Real Estate Lending handbook states that property-specific considerations for multifamily loans include occupancy history, collection losses, rents as compared with competitive properties, and management quality [1]. A lender reviews occupancy history not as a single number but as a trend: whether occupancy has been stable, declining, or recovering over time. A current rent roll showing high occupancy may look strong, but if the T-12 shows that occupancy was significantly lower several months ago, the lender will want to understand what changed and whether the improvement is sustainable. Prepare a simple table listing month-end occupancy percentages for each of the past twelve months, and note any events that affected occupancy, such as a major renovation, a change in property management, or a local economic shift.

Collection losses versus rent-roll occupancy

The OCC handbook warns that even though a review of the rent roll might indicate a high rate of occupancy, actual collections should be examined to determine the true economic occupancy and evaluate the competency of property management and the effectiveness of its collection efforts [1]. A rent roll may show every unit as rented, but if several tenants are not paying, the economic occupancy is lower than the physical occupancy. To document this, prepare a rent-roll snapshot dated as of the last day of the most recent month. The snapshot should list each unit, the tenant name, the monthly rent, any concessions or rent-free periods, and the current balance due. Then, on the T-12, identify the total gross rent scheduled each month and the total rent actually collected. The difference is collection loss. Lenders will evaluate this loss according to their underwriting criteria and may ask about eviction history or payment plans.

Reconciling the rent-roll date with the T-12 period

The rent roll is a point-in-time document, while the T-12 covers a twelve-month historical period. A common mistake is to compare the current rent roll directly to the T-12 without accounting for timing differences. For example, if the rent roll is dated at the end of a month and the T-12 covers the prior twelve months, payments such as prorated rent may appear differently in each. To reconcile, create a simple workpaper that lists each month in the T-12, the gross rent scheduled for that month, the rent collected, and the variance. Then note how the current rent roll compares to the most recent month's scheduled rent. This workpaper helps the lender see whether the rent roll is consistent with recent collection performance.

Distinguishing gross rent, collected income, NOI, and debt service

Lenders underwrite multifamily loans based on net operating income (NOI), not gross rent. The OCC handbook explains that lenders analyze NOI to understand a property's income-generating capacity, which is central to underwriting [1]. To prepare your file, start with gross rent from the rent roll, then subtract collection losses to get collected income. From collected income, subtract operating expenses such as management fees, utilities, insurance, property taxes, repairs, and a replacement reserve. The result is NOI. Then compare NOI to the proposed debt service, which includes principal and interest payments on the loan, tested according to the lender's underwriting standards. Lenders typically want NOI to exceed debt service by a margin, often expressed as a debt service coverage ratio. Prepare a simple pro forma that shows each of these line items and the resulting coverage ratio as calculated by the lender. A cap rate converts NOI to value, while a debt constant measures the annual debt service as a percentage of the loan amount; they measure different things.

Evidence checklist for the occupancy and collection file

Prepare the following documents and workpapers before submitting a loan request. Each item should be labeled with the property name, the date prepared, and the period covered.

  • Rent-roll snapshot dated as of the last day of the most recent month, listing each unit, tenant, monthly rent, concessions, and current balance due.
  • Trailing twelve months of operating statements (T-12), showing monthly gross rent scheduled, rent collected, operating expenses, and NOI.
  • Occupancy history table showing month-end occupancy percentages for each of the past twelve months, with notes on any events affecting occupancy.
  • Collection loss workpaper reconciling the rent roll to the T-12, showing the variance between scheduled rent and collected income for each month.
  • NOI pro forma showing gross rent, collection losses, collected income, operating expenses, replacement reserve, and NOI, compared to proposed debt service.
  • Property management resume or summary of management experience, including years of experience, number of units managed, and any third-party management agreements.
  • Schedule of any rent-control or stabilization programs that apply to the property, with a summary of how they affect rent increases and vacancy.

Three common questions about occupancy documentation

How far back should occupancy history go?

Lenders typically ask for at least twelve months of occupancy history, but if the property has experienced significant changes, such as a renovation or a change in management, include additional years if available. The OCC handbook notes that occupancy history is a property-specific consideration [1], and a longer history helps the lender see the trend.

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

This is common because the documents cover different time periods. The rent roll shows who is in place today, while The T-12 reports historical income and expenses on its stated accounting basis over the past year. Reconcile the two by preparing the workpaper described above, and explain any material differences in a brief note. For example, if a large block of units turned over in the past month, the rent roll may show new tenants while the T-12 still reflects the vacancy period.

Does the lender require a third-party management company?

The OCC handbook states that property management ability is critical to the success of multifamily properties and that inept or inexperienced management is a major cause of difficulty for loans financing multifamily dwellings [1]. Whether management is self-managed or third-party, the lender will evaluate the manager's experience and track record. If you self-manage, prepare a resume or summary of your management experience, including the number of units you have managed and your collection rate history.

Suggested way to prepare the information

As a practical step, create a single folder or digital file labeled with the property name and the date. Inside, place the rent roll, the T-12, the occupancy history table, the collection loss workpaper, the NOI pro forma, and the management summary. Label each document clearly and include a cover sheet that lists the documents and the dates they cover. This organization helps the lender review the file efficiently and reduces follow-up questions. Remember that lenders quote on what they are given, and a complete, well-organized file supports a more informed quote [2].

How the information affects the financing discussion

The occupancy and collection evidence directly affects leverage, pricing, and covenants. A property with stable occupancy and low collection losses may qualify for higher loan-to-value ratios and more favorable terms, while a property with volatile occupancy or high collection losses may require additional equity, higher pricing, or reserves. The OCC handbook notes that banks establish internal loan-to-value limits and supervisory limits for improved commercial and multifamily property [1]. A lender may offer less than those limits if the occupancy or collection history is weak. Preparing the evidence in advance allows you to present the property's story on your terms and to address any concerns before the lender raises them.

When you are ready to discuss financing

If you would like to discuss your property, send us the property address, a brief description of the business plan, the amount of capital you need, and the timing of the transaction. We will tell you how we would approach it. Submission is a preliminary request, not an engagement or lender submission.

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