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

Naming property financial files so a lender can identify the reporting period

A practical guide to naming and organizing rent rolls, operating statements, and other property financial files so that the reporting period is immediately clear to a lender, including a worksheet to track key underwriting metrics and distinguish temporary timing differences from actual performance changes.

Source: CodexTopic: Financing process and document control1299 wordsUpdated 2026-11-19

A practical guide to naming and organizing rent rolls, operating statements, and other property financial files so that the reporting period is immediately clear to a lender, including a worksheet to track key underwriting metrics and distinguish temporary timing differences from actual performance changes.

When a lender opens a file named "rent roll" or "operating statement," the first question is always: What period does this cover? An undated file forces the lender to guess, to ask clarifying questions, or to set the file aside until the borrower responds. Each of those delays slows the financing process and risks a weaker first impression. This guide explains how to name files so the reporting period is obvious, how to organize the supporting information a lender will compare across periods, and how to prepare a simple evidence checklist that connects the numbers to the underwriting discussion.

Name each file with the property name, document type, and ending date of the period

A file name should tell the lender what the document is and what time it covers without opening the file. For a rent roll, use a format such as "Rent Roll – 123 Main – Dec 31 2025." For an operating statement, use "Operating Statement – 123 Main – 12 months ending Dec 31 2025." For a trailing twelve-month (T-12) statement, the ending date is the last month of the twelve-month period. For a current rent roll, the date is the snapshot date, typically the last day of the most recent month. This naming convention lets the lender immediately sort documents by property and by period, and it avoids confusion between a current rent roll and a T-12 that ends on the same date.

Label each rent roll as a snapshot and each T-12 as a historical twelve-month period

A current rent roll is a single point in time. It shows who is in place, what they pay, what concessions remain, and what security deposits are held. A T-12 operating statement is a historical report covering the trailing twelve consecutive months. The two serve different underwriting purposes. The rent roll tells the lender the current income position. The T-12 tells the lender how the property has performed over the past year, including seasonal patterns, vacancy changes, and operating expense trends. When you compare the two, remember that the rent roll is a snapshot and the T-12 is a historical summary. A difference between the rent roll's gross potential rent and the T-12's actual collected income does not necessarily mean a problem; it may reflect lease-up, concessions, or timing of move-ins. You can note the reason in a brief comment attached to the file or in a separate cover note. [1] The OCC handbook describes underwriting as a comprehensive process that includes project feasibility and collateral valuation, and the lender will use both the snapshot and the historical period to evaluate the property's income stability.

Distinguish gross rent, collected income, net operating income, capital expenditures, debt service, and equity cash flow

A lender will want to see each of these line items clearly labeled and supported by the rent roll and operating statements. Gross rent is the total contractual rent before any vacancy or collection loss. Collected income is what the property actually received after vacancy, concessions, and bad debt. Net operating income (NOI) is collected income minus operating expenses, before debt service and capital expenditures. Capital expenditures (capex) are major improvements that are not routine repairs. Debt service is the principal and interest payments on the loan. Equity cash flow is what remains after all operating expenses, capex, and debt service are paid. Each of these numbers affects the underwriting analysis differently. For example, a lender may calculate a debt service coverage ratio using NOI before capex, or after a capex reserve. [1] The OCC handbook lists DSCR and debt yield as common financial covenants for income-producing CRE loans, and the lender will need the correct NOI figure to test those covenants.

Record the reporting basis and reconcile periods before comparing totals

Not all operating statements use the same accounting basis. Some are prepared on a cash basis, some on an accrual basis, and some on a modified cash basis. The lender needs to know which basis was used for each period. If you are comparing a T-12 on a cash basis to a rent roll on an accrual basis, the totals will not match. You can reconcile the difference by listing the accrual adjustments, such as unpaid rent accrued but not yet collected, or prepaid rent collected but not yet earned. Similarly, if the T-12 covers a different twelve-month period than the rent roll's snapshot date, note the difference. For example, if the rent roll is dated December 31, 2025, and the T-12 covers January 1, 2025, through December 31, 2025, they align. If the T-12 covers October 1, 2024, through September 30, 2025, they do not align, and the lender will need to compare the rent roll to the most recent three months of the T-12 separately.

Prepare a one-page evidence checklist that connects the file information to the underwriting discussion

Create a single-page document that lists each key underwriting metric, the file that supports it, the period covered, and the reporting basis. A suggested format is a simple table with four columns: Metric, Supporting Document, Period, Reporting Basis. For example: Gross potential rent / Rent roll / Dec 31 2025 / Accrual. Actual collected income / T-12 operating statement / 12 months ending Dec 31 2025 / Cash. NOI / T-12 operating statement / 12 months ending Dec 31 2025 / Cash. Capex summary / Capex schedule / Jan 1 2020 – Dec 31 2025 / Actual cost. This checklist is not a lender form; it is a suggested way to prepare information so you can answer the lender's questions quickly. [1] The OCC handbook notes that loan documents typically include covenants requiring periodic submission of financial information, and the lender will compare the submitted information to the covenants. Your checklist helps the lender verify that the information is complete and consistent.

Ask the actual lender which period and basis they want for each document

Every lender has a preferred format for financial submissions. Some want a trailing twelve-month statement that ends with the most recent quarter. Others want a calendar-year statement plus a current rent roll. Some want all statements on an accrual basis; others want cash basis. The best way to know is to ask the lender directly. You can ask at the initial conversation or when you receive the term sheet. The answer will save you from preparing documents that the lender will ask you to redo.

FAQs

Why does the lender need both a current rent roll and a trailing twelve-month operating statement?

The rent roll shows the current income position, which helps the lender evaluate the property's present cash flow. The T-12 shows historical performance over the past year, including seasonal patterns, vacancy changes, and operating expense trends. Together they give the lender a complete picture of the property's income stability and the sponsor's management track record.

What if my rent roll and T-12 use different accounting bases?

That is common. You can note the difference in a cover note or on the evidence checklist. The lender will reconcile the two by adjusting for accrual items such as unpaid rent or prepaid rent. You can save time by providing the reconciliation yourself.

How should I name files for a property with multiple buildings or phases?

Include the building or phase identifier in the file name, such as "Rent Roll – 123 Main Bldg A – Dec 31 2025." If the property has a single legal description but multiple rent rolls, label each roll clearly. The lender will sort by property, then by building, then by period.


Include the amount and timing. Submission is a preliminary request, not an engagement or lender submission.

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