Explaining missing expense months in a commercial property T-12
A T-12 with blank months can weaken a loan request before underwriting begins. This guide explains how to reconstruct, document, and present missing expense periods so the sponsor controls the narrative rather than defending gaps.
A T-12 with blank months can weaken a loan request before underwriting begins. This guide explains how to reconstruct, document, and present missing expense periods so the sponsor controls the narrative rather than defending gaps.
Why a T-12 gap matters to the financing discussion
A trailing twelve-month operating statement (T-12) is a historical record, not a forecast. When months are missing, the lender cannot verify whether the property’s cash flow is seasonal, interrupted by a one-time event, or simply incomplete. The OCC handbook notes that a bank’s analysis of historical income and expenses should include a comparison with industry benchmarks and an examination of significant variances [1]. A gap in the T-12 undermines that comparison and raises questions about the reliability of the net operating income (NOI) used in the debt-service coverage ratio (DSCR). The DSCR is a key underwriting metric; if the lender cannot confirm the income and expense stream, the loan request may be delayed, require more equity, or receive less favorable terms.
Identify the missing months and their cause
Start by listing each month of the trailing twelve and marking which ones are absent. Then record the reason for each gap. Common causes include a change in property management software, a transition between accounting systems, a period when the property was not yet in service, or a natural disaster that disrupted operations. Do not assume the lender will accept a vague explanation. The OCC guidance stresses that loan documents should clearly define income and expense definitions when debt-service coverage covenants are used [1]. A clear, written explanation for each missing month helps the lender understand whether the gap represents a risk or an administrative artifact.
Reconstruct the missing months with available data
If the property has prior-year statements, bank statements, or tax returns covering the gap period, use those to reconstruct the missing months. The OCC handbook points out that tax returns may be prepared on a cash basis, reflecting only income and expenses actually received or paid during the year [1]. If you use tax returns, note the reporting basis and reconcile any timing differences between the cash-basis return and the accrual-basis T-12. For example, a real estate tax expense that was not paid during the year will not appear on a cash-basis return but should be included in the T-12 as an operating expense. Attach a reconciliation worksheet that shows the source data, any adjustments, and the resulting reconstructed figures.
Distinguish the T-12 from the current rent roll
A current rent roll is a snapshot of who is in place and what they owe today. A T-12 is twelve months of historical performance. The two may not match, and that is normal. The OCC handbook defines NOI as annual gross income less operating expenses, where gross income includes all income generated through the operation of the property, including rents, parking fees, laundry, and vending [1]. When comparing the T-12 to the rent roll, identify whether the missing months contain known vacancies, rent concessions, or capital expenditures that would affect the NOI. If the T-12 shows lower income than the rent roll would suggest, explain whether the difference is due to a lease-up period, tenant improvements, or a seasonal dip.
Prepare a missing-month evidence checklist
Create a single document that lists each missing month, the reason it is missing, the source used to reconstruct it, and any reconciling adjustments. Include the following columns: - Month and year - Status (missing, partially available, reconstructed) - Source document (bank statement, tax return, prior T-12, property manager report) - Reporting basis (cash or accrual) - Adjustment applied (e.g., added accrued expense, subtracted non-recurring item) - Reconstructed total for gross income, operating expenses, and NOI
This checklist becomes part of the loan request. It shows the lender that you have identified the gap, researched the cause, and supplied a defensible estimate rather than leaving a blank.
Explain how the reconstruction affects the DSCR and NOI analysis
Once you have reconstructed the missing months, recalculate the trailing twelve-month NOI with and without the reconstructed data. Present both figures side by side. The OCC handbook warns that some capital expenditures used to calculate NOI may not appear as expenses on tax returns, such as replacement reserves for roofs, HVAC systems, and parking lots [1]. If your reconstruction added replacement reserves that were not in the original T-12, note that. If the missing months include a period when the property was not fully stabilized, the reconstructed NOI may be lower than the current run rate. That is acceptable as long as you explain the trend. The lender will stress-test the DSCR under both normal and stressed conditions, as the OCC handbook advises [1]. A clear reconstruction helps the lender apply those stress tests accurately.
Ask the actual lender about gap tolerance
Lenders differ on how many missing months they will accept and what documentation they require. Some may require a full twelve-month history for a permanent loan but accept a shorter period for a bridge loan. The OCC handbook notes that for multiple-unit loans such as lot development or condominiums, the maximum number of units financed should consider the tenor and anticipated rate of unit sales [1]. This principle illustrates how lenders consider timing in underwriting, though it is not directly about T-12 gaps. Similarly, the lender’s willingness to accept a gap may depend on the loan type, the property’s stage, and the overall strength of the sponsor’s financials. Do not assume all lenders have the same policy. Ask the lender directly: “How many missing months in the T-12 are acceptable, and what documentation do you require for reconstruction?” Record the answer in your file.
Frequently asked questions
What if the missing months are from a period before I owned the property?
You can still reconstruct them using prior owner records, tax returns, or third-party reports such as appraisals. Disclose that the data is from a prior ownership period and note any changes in operations that may affect comparability.
Should I include reconstructed months in the same spreadsheet as the actual T-12?
Yes, but clearly label each reconstructed month and provide a separate reconciliation worksheet. The lender should be able to distinguish actual data from estimates at a glance.
Does a missing month automatically disqualify the property from financing?
No, but it places a heavier burden on the sponsor to demonstrate the property’s cash flow stability. A well-documented reconstruction with a clear explanation often satisfies the lender’s underwriting requirements.
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.
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.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).