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

How to reconcile annual operating statements with a property budget

A practical guide to comparing trailing twelve-month operating statements with a property budget, including a concrete evidence checklist and explanations of how timing, reporting basis, and line-item definitions affect the financing discussion.

Source: CodexTopic: Operating expense reconciliation1094 wordsUpdated 2026-11-19

A practical guide to comparing trailing twelve-month operating statements with a property budget, including a concrete evidence checklist and explanations of how timing, reporting basis, and line-item definitions affect the financing discussion.

Why reconciliation matters in financing

When you submit a trailing twelve-month (T-12) operating statement alongside a property budget, the lender will compare them to see whether the property's actual performance matches your projections. The OCC's Commercial Real Estate Lending handbook notes that an important objective of the underwriting process is to develop a net operating income (NOI) that represents a stabilized estimate of income and expenses based on the lender's actual test or the sponsor's documented assumption [1]. A clear reconciliation shows the lender that you understand the property's cash flow and can defend any variances between what was projected and what actually occurred.

Timing differences: snapshot versus history

The first step in reconciliation is to recognize that a current rent roll is a snapshot of today's occupancy and rent, while a T-12 statement covers the prior twelve months of actual income and expenses. These two documents will almost never match. For example, if a tenant vacated two months ago, the rent roll shows no rent from that unit, but the T-12 includes the rent collected during the months the tenant was in place. To reconcile them, record the following: - The date of the rent roll snapshot. - The start and end dates of the T-12 period. - Any lease commencements, expirations, or rent changes that occurred during the T-12 period. - The monthly rent for each tenant from the T-12 and compare it to the current rent roll.

Identify any large differences and note whether they are due to a change in occupancy, a rent step-up, or a concession that has since expired. This comparison helps you explain to the lender why the T-12 income may be higher or lower than the current rent roll suggests.

Reporting basis: cash versus accrual

Operating statements can be prepared on a cash basis or an accrual basis. The OCC handbook warns that a tax return for a property where real estate taxes were not paid during that year would understate expenses and overstate income compared with financial statements prepared on an accrual basis [1]. The same risk applies to operating statements prepared on a cash basis. It is important to distinguish whether the T-12 is based on cash collections or accrual accounting, as this affects comparability with the budget. To reconcile the T-12 with the budget, you need to know the reporting basis of each document. If the T-12 is cash basis and the budget is accrual basis, you will need to adjust one to match the other. A suggested way to prepare this information is to create a simple workpaper that lists each income and expense line item, notes the reporting basis, and shows the cash-to-accrual adjustment for any items that differ. Clearly distinguish historical reporting from actual collections.

Line-item definitions: gross rent, collected income, NOI, capex, debt service, and equity cash flow

A common source of confusion is that different documents may define line items differently. The budget might show "gross potential rent," while the T-12 shows "collected income." The difference includes vacancy, concessions, and bad debt, but a rent-loss gap is not effective gross income. To reconcile, identify each line item in both documents and note its definition. Then create a bridge that shows how you move from gross rent to collected income to net operating income. The OCC handbook notes that operating expenses do not include depreciation or capital items, so capital expenditures should be separated from operating expenses when calculating NOI [1]. Debt service and equity cash flow are calculated after NOI, not within it. A clear workpaper that shows NOI, then subtracts debt service to show the lender the debt-service coverage ratio (DSCR), and then shows equity cash flow, will help the lender understand the property's ability to service its debt based on the lender's actual test or the sponsor's documented assumption [1].

A concrete evidence checklist

Prepare a single workpaper in a spreadsheet or table with the following columns: - Line item (e.g., gross rent, vacancy, collected income, operating expenses, NOI, capex, debt service, equity cash flow) - Budget amount - T-12 actual amount - Variance (budget minus actual) - Explanation for variance - Reporting basis (cash or accrual) - Adjustment needed (if any)

For each line item, record the source document and date. Then for any material variance, write a brief explanation. For example, "budget assumed a certain vacancy rate; actual vacancy was higher due to a tenant move-out during the period." This workpaper is not a mandatory lender form, but it demonstrates that you have reviewed the numbers and can discuss them.

How to present the reconciliation to a lender

When you submit the loan request, include the reconciliation workpaper along with the T-12 and the budget. In the cover note, state the reporting basis of each document and note any significant adjustments you made. The OCC handbook notes that the construction budget and project pro forma are critical elements in determining project feasibility [1]. A clean reconciliation can help the lender understand the property's operating history. It also helps the lender calculate the debt-service coverage ratio from a stabilized NOI, which is a key underwriting metric based on the lender's actual test or the sponsor's documented assumption [1].

FAQs

What if the T-12 and budget use different accounting methods?

Identify the reporting basis of each document. If the T-12 is cash basis and the budget is accrual, adjust the T-12 by adding accrued but unpaid expenses and subtracting prepaid items. Record the adjustments in your workpaper and explain them in your cover note. This is not a mandatory step, but it helps the lender understand the true economic performance.

Should I include capital expenditures in the reconciliation?

Yes, but separate them from operating expenses. Capex is not part of NOI. List capex as a separate line item below NOI, then show debt service and equity cash flow. This structure aligns with the OCC handbook's discussion of NOI, debt service, and equity cash flow [1].

How do I handle a tenant that moved in after the T-12 period ended?

The T-12 does not include that tenant's rent. The current rent roll does. In your reconciliation, note the lease start date and the monthly rent. Explain that the T-12 understates current income by that amount. The lender will incorporate this into their projection of stabilized NOI based on the lender's actual test or the sponsor's documented assumption.


Contact us through the website to get started.

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