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

Preparing a borrower response when two financial documents conflict

A practical guide to reconciling conflicting rent rolls and operating statements before submitting a loan request, with a concrete evidence checklist for the sponsor.

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

A practical guide to reconciling conflicting rent rolls and operating statements before submitting a loan request, with a concrete evidence checklist for the sponsor.

When two financial documents for the same commercial property show different numbers, the loan request can stall unless the sponsor prepares a clear, documented explanation. Lenders and arrangers rely on consistent financial information to assess repayment capacity and project feasibility. This guide explains how to identify, document, and present a reasoned reconciliation of conflicting documents, distinguishing what is known from what is assumed, and provides a worksheet to organize the evidence.

Identify the conflicting documents and their timing

Start by naming the two documents that conflict. A possible pair is a current rent roll and a trailing twelve-month (T-12) operating statement. A rent roll is a snapshot of current tenant occupancy, lease terms, and rent due. A T-12 shows actual income and expenses for each of the past twelve months. The difference in timing is the first thing to check. A rent roll might be dated the first of the month, while the T-12 covers the prior twelve months ending on that same date. If the rent roll shows higher gross rent than the T-12 average, the property may have added tenants or increased rents recently. If the rent roll shows lower gross rent, the property may have lost tenants or granted concessions. Record the date of each document and the period each covers. This timing difference is a possible source of apparent conflict and often explains the gap without further investigation. [1] discusses how cash flows should be assessed on a global basis and the importance of integrating financial information from multiple sources, which reinforces the need to reconcile timing differences before drawing conclusions.

Compare gross rent, collected income, and net operating income

A rent roll records scheduled rent and occupancy at a particular date. A T-12 reports twelve historical months on its stated accounting basis. Do not compare one month of scheduled rent with an annual historical total without reconciling periods. Show vacancy, concessions, collection losses and timing adjustments separately. Keep operating income, operating expenses, recurring capital spending and debt service on distinct lines. [1]

Reconcile operating expenses between documents

Operating expenses on a T-12 may include items that are not on a rent roll, such as property management fees, utilities, insurance, repairs, and property taxes. A rent roll rarely shows expenses. If the T-12 shows expenses that seem high relative to the rent roll gross rent, check whether the property is self-managed or professionally managed, whether any expenses are seasonal, and whether capital expenditures are included. Capital expenditures (roof replacement, HVAC upgrades) should be separated from operating expenses. Record the total operating expenses from the T-12 and note any capital items. If the rent roll includes an expense estimate, compare it to the T-12 actuals. [1] notes that realistic projections of such expenses as property and income taxes should be considered, and that cash flows should be assessed on a global basis. A discrepancy in expenses can affect NOI and, therefore, debt service coverage.

Prepare a reconciliation worksheet

Create a reconciliation with a separate row for each disputed figure. Record the source filename, reporting period, accounting basis, units and date; show the other document's figure alongside it. Explain any supported adjustment, identify the evidence used, and leave unresolved differences visible. A rent roll generally does not contain the operating expenses or debt schedule, so those figures need their own sources rather than invented rent-roll counterparts.

Distinguish known facts from assumptions

Separate observed source facts from projections. Lease terms and recorded transactions can be traced to dated documents; future growth, expense changes and renewals remain assumptions until supported by the appropriate evidence. Do not treat a current rent roll as a forecast. If a discrepancy remains, record the missing evidence and the person responsible for obtaining it. Avoid changing an actual result merely to make a proposed model reconcile. [1]

Ask the actual lender for guidance on specific conflicts

If the reconciliation reveals a material conflict that cannot be resolved with available information, ask the lender or arranger how they prefer to handle it. Some lenders may accept a written explanation; others may require updated financial statements or a third-party report. Do not assume that all lenders require the same approach. [1] states that each bank should monitor compliance with its real estate lending policy and individually report exception loans of a significant size to its board of directors. This means lenders have internal policies for handling exceptions, and the sponsor should ask what documentation is needed.

Frequently asked questions

What if the rent roll and T-12 conflict on vacancy rate? Record both vacancy rates and the periods they cover. Explain whether the difference is due to timing (a recent lease-up) or a data error. If a data error is suspected, obtain a corrected rent roll or T-12 from the property manager.

Should I include a pro forma that assumes a different NOI than the T-12 shows? Yes, but label the pro forma as projected and compare it to the T-12 actuals. Show the reconciliation between historical NOI and projected NOI, and support the projection with lease-up assumptions or capital improvement plans.

What if the sponsor's personal financial statements conflict with the property financials? [1] requires global cash-flow analysis that integrates cash flows from business financial statements, tax returns, and Schedule K-1 forms. Prepare a global cash-flow schedule that reconciles personal and property cash flows, noting any transfers or guarantees.

Send us the property, the business plan, the amount and timing of capital needed. We will tell you how we would approach it. 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