How to prepare a property operating expense variance schedule
A step-by-step guide to building an operating expense variance schedule that reconciles historical cash-basis records with accrual-based underwriting, helping sponsors present a credible NOI to lenders.
A step-by-step guide to building an operating expense variance schedule that reconciles historical cash-basis records with accrual-based underwriting, helping sponsors present a credible NOI to lenders.
When a lender reviews an existing property, the underwriting team builds a net operating income (NOI) that represents a stabilized estimate of income and expenses. [1] That estimate often differs from what appears on tax returns or cash-basis operating statements. A property operating expense variance schedule is the workpaper that bridges the gap. It shows the lender exactly which line items you adjusted, why, and by how much.
This guide walks through the preparation of that schedule. Each section explains what to record, how to compare it with industry or market data, and how the information affects the financing conversation.
Record the reporting basis and reconcile the periods
Start by noting the accounting method of each source document you use. Tax returns may be prepared on a cash basis, which reflects only income and expenses actually received or paid during the year. [1] An operating statement prepared on a cash basis has the same limitation. Financial statements prepared on an accrual basis record income when earned and expenses when incurred, regardless of when cash moves.
If your tax return shows real estate taxes were not paid in a given year, that return will understate expenses and overstate income compared with an accrual-based statement. [1] Identify the basis for each document you plan to use: - Tax returns (identify cash or accrual basis) - Year-to-date operating statements (identify cash or accrual basis) - Trailing twelve months (T-12) of operating statements - Current rent roll (a snapshot, not a historical record)
Next, reconcile the time periods. A current rent roll shows occupancy and rent at a single point in time. A T-12 shows twelve consecutive months of historical performance. Compare the totals from both, and note any differences caused by lease commencements, rent concessions, or vacancies that occurred during the T-12 period but have since changed.
Build the variance schedule line by line
Create a spreadsheet with the following columns: expense category, tax return or cash-basis amount, accrual-basis amount, variance, explanation, and stabilized underwriting amount. Suggested expense categories: - Real estate taxes - Property insurance - Utilities - Repairs and maintenance - Management fees - Replacement reserves - Leasing commissions - Legal and professional fees - General and administrative
For each line, enter the amount from your source document and the amount you believe represents normal, recurring operations. The variance is the difference. In the explanation column, note the reason. For example: "Real estate taxes: cash basis shows a deferred payment amount; accrual basis reflects the actual assessment." [1]
Compare expenses with market data
Lenders test the reasonableness of your numbers by comparing them with expenses incurred by comparable properties, adjusted for supported variances and lease terms. [1] Identify comparable properties in the same market and property type. Gather their reported expense ratios from appraisals, market reports, or your own portfolio data.
For each expense category in your variance schedule, add a column for the range from comparable properties. If your property's management fee is below the range observed in comparable properties, note that variance and explain why your fee is lower (for example, self-managed or below-market contract). [1]
Distinguish gross rent, collected income, NOI, capex, debt service, and equity cash flow
Lenders evaluate cash flow at several levels. Your variance schedule should support each level separately: - Gross rent: total contractual rent before any deductions - Collected income: gross rent minus vacancy, credit loss, and concessions - NOI: collected income minus operating expenses (excluding debt service, capital expenditures, and income taxes) [1] - Capital expenditures: major improvements such as roof replacement, HVAC, or parking lot resurfacing, which are not operating expenses but are captured in a replacement reserve [1] - Debt service: annual principal and interest payments as defined by the lender's loan documents - Equity cash flow: NOI minus debt service minus capital expenditures, consistent with the lender's or sponsor's definitions
Your variance schedule should show how you moved from historical cash-basis figures to a stabilized NOI that includes appropriate reserves for replacements, based on the sponsor's documented assumptions. [1]
Stress-test the NOI with normal and stressed conditions
The OCC handbook advises that each factor should be considered under both normal and stressed conditions. [1] For example, if current vacancy is below the lender's assumed vacancy rate, test the impact of higher vacancy levels. If interest rates rise, test whether the debt-service coverage ratio remains above the lender's required minimum. [1]
Add a sensitivity section to your variance schedule. Show the NOI and debt-service coverage ratio under: - Current vacancy and expense levels - Vacancy and expense levels based on the lender's or sponsor's documented assumptions - A stressed scenario reflecting higher vacancy, higher expenses, and lower income as defined by the lender or sponsor
This demonstrates to the lender that you have considered downside risk.
Ask the actual lender about covenant definitions
Loan documents may contain debt-service coverage covenants that define income and expenses differently than the underwriting analysis. [1] Debt-service coverage calculations for covenant compliance may differ from the DSCR used for underwriting and risk-rating analysis. [1] Confirm the lender's specific covenant definitions before finalizing the variance schedule.
Before you finalize the variance schedule, ask the lender for the specific definitions they will use in the loan agreement. Record those definitions and adjust your schedule if needed. This step prevents surprises after closing.
Prepare the final workpaper
Your completed property operating expense variance schedule should be a single document (spreadsheet or PDF) that includes: - A header with property name, date prepared, and preparer contact - A section noting the reporting basis of each source document - The line-by-line variance schedule with explanations - A comparison with comparable properties for each expense category - A sensitivity analysis showing NOI and DSCR under three scenarios - A reconciliation of the current rent roll and T-12 totals
Submit this schedule with your loan request. It shows the lender you have done the work to present a credible, stabilized NOI.
Frequently asked questions
Do I need to prepare a variance schedule if my property uses triple-net leases?
Yes. Even under triple-net leases, the lease itself should be analyzed to determine which expenses the landlord or tenant is responsible for, as the OCC handbook notes that terms like "triple net" lack universally agreed-upon definitions. [1] The variance schedule should separate landlord expenses from tenant expenses and include a replacement reserve for capital items.
Can I use my tax return as the sole source for expenses?
Tax returns can be helpful, but some capital expenditures used to calculate NOI may not be shown as an expense on tax returns. [1] For example, funds for recurring capital expenditures such as HVAC or roof replacement are captured in a replacement reserve, not in the tax return. Use the tax return as one input, but supplement it with accrual-based statements and market data, noting the accounting basis of each.
What if my property's expenses are consistently below market data?
A variance below market data is acceptable if you can explain the reason, such as a below-market management contract or energy-efficient improvements. [1] Document the explanation in the variance schedule. The lender will test whether the lower expenses are sustainable and whether they reflect deferred maintenance.
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).