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

How to reconcile utility expenses across multiple property meters

A practical guide for sponsors to prepare a utility reconciliation workpaper that aligns meter-level data with trailing twelve-month operating statements, explains variances to a lender, and strengthens the NOI discussion.

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

A practical guide for sponsors to prepare a utility reconciliation workpaper that aligns meter-level data with trailing twelve-month operating statements, explains variances to a lender, and strengthens the NOI discussion.

Identify the meters and the consumption data they cover

Start by listing every utility meter that serves the property. For each meter, record the utility type (electric, gas, water, steam), the meter number, the unit or common area it serves, and the billing period. If the property has submeters for individual tenants, separate those from master meters. This list becomes the foundation of your reconciliation workpaper.

Compare the meter list to the utility invoices the property has paid over the trailing twelve months (T-12). Any meter that appears on an invoice but not on your list, or that is listed but has no supporting invoice, is a gap to investigate. A missing meter can understate expenses in the T-12 operating statement.

Reconcile the T-12 utility totals to the meter-level consumption

Take the total utility expense from the T-12 operating statement and break it into the same categories as your meter list. For each category, calculate the total consumption (kWh, therms, gallons) from the invoices and multiply by the blended rate to confirm the dollar amount. If the T-12 shows a different total, identify which months or meters cause the variance.

Common causes of variance include: - Invoices recorded in a different period than consumption (cash basis vs. accrual basis) [1] - Late invoices that arrived after the T-12 was closed - Credits or adjustments that were netted against a later bill - A meter that serves multiple properties but was allocated differently

Record each variance in your workpaper with the dollar amount and the reason. This is your evidence that the T-12 is either complete or needs adjustment.

Compare the reconciled utility expense to the rent roll and lease terms

Utility reimbursement from tenants affects NOI directly. For each tenant on the rent roll, check whether the lease requires the tenant to pay utilities directly to the utility company, reimburse the landlord based on a pro-rata share, or pay nothing extra. [1]

If tenants reimburse the landlord, the T-12 should show both the gross utility expense and the reimbursement income. If the lease says the tenant pays the utility company directly, the landlord's T-12 should not include that consumption at all. A mismatch—for example, a lease that says direct pay but a meter that is still on the landlord's account—will create a reconciliation issue that the lender will question.

In your workpaper, list each tenant, the lease provision for utilities, and the actual billing arrangement. Flag any discrepancy.

Prepare a stabilized NOI that reflects the reconciled utility cost

Once the utility expense is reconciled to the meter-level data and tenant reimbursements, you can calculate a net utility cost that belongs in the NOI. The OCC handbook explains that an important objective of underwriting is to develop a stabilized estimate of income and expenses. [1] If the T-12 had a one-time variance—a credit for a billing error, a catch-up bill after a meter replacement—adjust the NOI to exclude that nonrecurring item and note the adjustment.

If the property has seasonal occupancy or usage, use the full twelve months rather than a shorter period. A trailing twelve months captures the full cycle of heating, cooling, and vacancy. Present the stabilized utility expense as a line item in the pro forma, with a footnote referencing your reconciliation workpaper.

Use the workpaper to answer lender questions about utility expense

A lender reviewing the operating statement may ask why utility expense appears high or low relative to comparable properties. Your workpaper gives you the answer: the consumption per square foot, the blended rate, the reimbursement structure, and any nonrecurring items. The OCC handbook notes that comparing reported expenses with expenses incurred by comparable properties, adjusted for supported variances and lease terms, is helpful in underwriting. [1]

If your utility expense is above a benchmark, you can show the lender that the difference is explained by a higher rate in your market, a larger common area, or a lease structure that passes less cost to tenants. If it is below, you can confirm that the T-12 is complete and not missing a meter.

Distinguish utility expense from other operating expenses in the T-12

Utility expense is one component of operating expenses, which the OCC handbook defines as costs incurred in the operation and normal maintenance of a property, excluding interest, principal, income taxes, depreciation, and capital items. [1] Do not include utility line items that are actually capital improvements (for example, a new HVAC unit that was billed on the same invoice as the electric consumption). Separate those into the capital reserve or capex line of the pro forma.

In your workpaper, create a column that classifies each invoice as operating expense or capital, and note the basis for the classification. This prevents a lender from double-counting or misclassifying the cost.

Suggested workpaper structure

Create a single spreadsheet or document with the following sections:

  1. Meter register: meter number, utility type, location served, billing account number.
  2. T-12 utility expense by meter: for each meter, list the monthly invoice amount from the T-12 period, the consumption, and the rate.
  3. Reconciliation to T-12 operating statement: total from section 2, compared to the T-12 total, with variance explanations.
  4. Tenant utility responsibility: tenant name, lease provision, actual billing arrangement, and any discrepancy.
  5. Adjusted stabilized utility expense: the amount you propose for the pro forma NOI, with a note on nonrecurring items.

This workpaper is not a required lender form. It is a suggested way to prepare information that supports the underwriting discussion.

Frequently asked questions

What if a tenant pays the utility company directly and I have no invoice for that meter?

If the lease requires direct payment and the meter is in the tenant's name, the landlord's T-12 should not include that consumption. Your workpaper should list the meter and note that it is tenant-direct. A lender may still ask for evidence that the tenant has been paying, such as a utility company confirmation or a copy of a paid invoice from the tenant.

How do I handle utility expenses that were recorded in a different fiscal year than the consumption?

This is a cash-basis versus accrual-basis difference. [1] In your workpaper, record the consumption period and the payment period separately. For the stabilized NOI, use the consumption period to estimate the recurring expense, and adjust the T-12 total by adding or removing the timing difference. Explain the adjustment to the lender.

Should I include utility expenses for vacant space in the NOI?

Yes. Utility expense for vacant space is an operating cost of the property. In your workpaper, identify the vacant units or common area and the associated utility cost. If the vacancy is temporary, you may adjust the stabilized expense to reflect the expected occupancy level, but you should show the actual historical cost and the basis for the adjustment.


This guide is prepared for informational purposes. All financing is subject to lender underwriting and approval. [2] To discuss a property, send the property address, business plan, and requested loan amount to contact@wraithre.com.

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