How to prepare an expense evidence index for a commercial lender
An expense evidence index helps a sponsor reconcile reported operating expenses with the net operating income a lender will use for underwriting. This guide explains how to build one, what each supporting document shows, and how to present the information so a lender can compare it to market benchmarks and identify stabilized cash flow.
An expense evidence index helps a sponsor reconcile reported operating expenses with the net operating income a lender will use for underwriting. This guide explains how to build one, what each supporting document shows, and how to present the information so a lender can compare it to market benchmarks and identify stabilized cash flow.
A lender underwriting a permanent or bridge loan needs to form a view of the property's net operating income (NOI) that it can rely on through the loan term. The NOI used for underwriting is not simply the number on a tax return or a trailing twelve-month (T-12) operating statement. The lender may compare reported expenses with expenses incurred by comparable properties, adjusted for supported variances and lease terms, as part of developing a stabilized estimate of income and expenses [1].
An expense evidence index is a workpaper that organizes the supporting documents for each operating expense line item so the lender can see what was actually paid, what was accrued, and what is a reasonable forward-looking assumption. It turns a stack of invoices, tax bills, and service contracts into a structured file that answers underwriting questions before they are asked.
What an expense evidence index contains
The index is a single document, typically a spreadsheet, that lists every operating expense category a lender will consider. For each category, the index identifies the source document that supports the amount, the period the document covers, and whether the expense was paid or accrued. The lender can then trace any line item in the T-12 or tax return back to a specific invoice, statement, or contract.
Common expense categories include real estate taxes, insurance, utilities, management fees, maintenance and repairs, janitorial, landscaping, snow removal, trash removal, security, professional fees, and replacement reserves. The index should also capture expenses that may not appear on a cash-basis tax return, such as a reserve for recurring capital expenditures including heating, ventilation, and air conditioning systems, roofs, and parking lots [1].
Reconciling the reporting basis
It is helpful to know whether the operating statements are prepared on an accrual basis or a cash basis, as the OCC handbook notes that cash-basis statements may understate or overstate expenses compared to accrual-basis statements [1]. A cash-basis tax return reflects only income and expenses that were actually received or paid during the year. For example, a tax return for a property for which 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 can be true for operating statements prepared on a cash basis [1].
The expense evidence index should include a reconciliation note for each line item where the cash-basis amount differs from the accrual-basis amount. If real estate taxes were billed but not paid in a given year, the index should show the invoice and the payment record, and the reconciliation should explain the timing difference. The lender can then decide whether to use the actual paid amount or the accrued amount in its stabilized NOI.
Separating gross rent, collected income, and net operating income
A rent roll is a snapshot of the current leases in place. A T-12 is a historical report of twelve consecutive months of income and expenses. The two may not match because the T-12 includes periods when units were vacant or rents were not collected. The expense evidence index should not combine these into a single total without explaining the timing difference [1].
The index should distinguish gross rent (the total contractual rent from all leases), collected income (what was actually received), and net operating income (gross income less operating expenses). It should also separate operating expenses from capital expenditures, debt service, and equity cash flow. The lender will use NOI to calculate the debt-service coverage ratio (DSCR), which divides NOI by annual debt service requirements [1].
Documenting each expense category
For each expense category, the index should list the following:
- The source document (invoice, statement, contract, or tax bill)
- The period the document covers
- The amount shown on the document
- Whether the amount was paid or accrued
- Any variance from the prior year or from the budget
- A brief explanation of the variance
If the property uses a management company, the index should include the management agreement and the most recent management fee statement. The lender will want to confirm that the management fee is consistent with the agreement and that it is included in operating expenses.
Comparing expenses to market benchmarks
The lender may compare the property's expenses to those of comparable properties, adjusted for supported variances and lease terms [1]. The expense evidence index should include a column for the lender's reference that shows the expense per square foot or per unit, so the lender can make that comparison directly.
If the property has net leases, the index should note which expenses the tenant pays directly and which the landlord pays. Net leases may be referred to as net, double net (NN), triple net (NNN), or absolute net, but these terms lack universally agreed-upon definitions, so the lease itself should always be analyzed to determine the expenses a landlord or tenant is responsible for rather than relying on these terms [1]. This determination is critical to developing an accurate estimate of cash flow and NOI for the property [1].
Including a replacement reserve
The OCC handbook notes that replacement reserves are captured in NOI analysis, so including a line item for a replacement reserve in your expense evidence index can help align with underwriting expectations [1]. The reserve captures funds for recurring capital expenditures such as replacing heating, ventilation, and air conditioning systems, roofs, and parking lots. The index can show the amount the lender has required in similar properties and the basis for that amount, such as the age and condition of the major building systems.
Preparing the index for the lender
The expense evidence index should be delivered as a single spreadsheet with the supporting documents organized in a corresponding folder. Each supporting document should be labeled with the same category name used in the index. The lender can then open the index, find the category, and open the corresponding document without searching through a stack of paper.
The index should also include a summary page that lists the total operating expenses from the T-12, the total from the tax return, and the total from the index itself, with a reconciliation of any differences. This summary gives the lender a starting point for developing a stabilized estimate of income and expenses [1].
How the index affects the financing discussion
A well-prepared expense evidence index signals to the lender that the sponsor has reviewed the property's financial history and understands the difference between reported expenses and stabilized expenses. It can reduce the number of underwriting questions and shorten the time from application to term sheet. It also helps the sponsor negotiate the definition of income and expenses in the loan documents, particularly the debt-service coverage covenant, which may differ from the DSCR used for underwriting and risk-rating analysis [1].
If the index reveals a one-time expense that will not recur, the sponsor can point to it and ask the lender to exclude it from the stabilized NOI. If the index shows that a particular expense has been consistently understated on a cash basis, the sponsor can address that before the lender discovers it and adjusts the NOI downward without explanation.
Suggested task: Build an expense evidence index
As a concrete exercise, prepare an expense evidence index for one property you own or manage. List every operating expense category from the most recent T-12. For each category, locate the supporting document and record the source, period, and amount. Note whether the amount was paid or accrued. Reconcile the total from the index to the total from the T-12 and the tax return. Identify any variances and write a brief explanation for each. This workpaper can be shared with a lender or used as a starting point for a financing discussion.
Frequently asked questions
Can I use a cash-basis tax return as the only expense evidence?
A cash-basis tax return may understate or overstate expenses compared with an accrual-basis financial statement [1]. Lenders typically prefer accrual-basis operating statements. If you only have cash-basis reports, the expense evidence index should include a reconciliation that shows the timing differences for each major expense category.
Does the index need to include every single invoice?
The index should include the most representative supporting document for each expense category. For recurring expenses such as utilities, a full year of statements is typical. For one-time expenses, the invoice or contract is sufficient. The goal is to give the lender enough information to verify the trend, not to audit every transaction.
What if a property has no replacement reserve?
If the property has not funded a replacement reserve, the index should still include a line item for it. The index can note that the reserve is proposed rather than actual, and include a basis for the amount, such as a capital needs assessment or the age of the major building systems. Including this line item can help align with underwriting expectations [1].
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).