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

Reconciling a property tax bill with the operating statement

Learn how to reconcile a property tax bill with the operating statement to present a clear, accurate NOI to lenders. This guide provides a concrete evidence checklist and explains how the information affects the financing discussion.

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

Learn how to reconcile a property tax bill with the operating statement to present a clear, accurate NOI to lenders. This guide provides a concrete evidence checklist and explains how the information affects the financing discussion.

Why reconcile property taxes

Property taxes represent a significant operating expense that can fluctuate due to changes in assessments, appeals, and payment timing. When submitting an operating statement to a lender, discrepancies between the tax bill and the reported expense can raise concerns about the accuracy of the financial information. Reconciling these documents demonstrates a clear understanding of the property's actual expense burden and the ability to explain any differences, which enhances credibility during underwriting.

Documents needed for reconciliation

To perform a property tax reconciliation, gather the following:

  • The most recent property tax bill or assessment notice for the property.
  • The trailing twelve months (T-12) operating statements, specifying whether they are prepared on a cash or accrual basis.
  • The current rent roll reflecting occupancy and rents as of a recent date.
  • A prior year’s tax return for the property, if available, to compare cash versus accrual reporting.

A useful approach is to create a spreadsheet with columns for each month in the T-12 period. Enter actual property tax payments made each month (from bank statements or payment records) in one column and the property tax expense accrued each month per the operating statement in another. Calculate monthly and cumulative differences to identify timing or reporting variances, noting whether differences arise from cash versus accrual accounting or payment timing.

Comparing the tax bill and operating statement

Begin by noting the total annual property tax amount from the latest bill. Then, sum the property tax expense reported on the T-12 operating statement. If these totals align closely, the reconciliation is straightforward. If not, investigate common causes such as:

  • The operating statement may be prepared on a cash basis, showing only taxes paid during the period rather than the full amount owed. [1]
  • A tax appeal settled during the period could result in refunds or reduced assessments not yet reflected in the operating statement.
  • The tax bill may cover a different time frame than the T-12 (for example, calendar year versus fiscal year).
  • The operating statement might include estimated or budgeted tax amounts instead of actual payments.

Aligning timing differences

The rent roll provides a snapshot of current occupancy and rents, while the T-12 operating statement reflects income and expenses over the past twelve months. Property tax bills are typically annual. To compare accurately, ensure the tax bill period matches the T-12 period. For example, if the T-12 covers a twelve-month period, use the tax bill for that same period or prorate the tax amount accordingly if the bill covers a different timeframe.

Impact on lender analysis

Lenders rely on net operating income (NOI) to assess loan metrics such as the debt-service coverage ratio (DSCR) and debt yield. [1] If the operating statement is prepared on a cash basis and property taxes were not paid during the year, expenses may be understated and NOI overstated, potentially making the DSCR appear higher than it would be on an accrual basis. [1] Conversely, a large tax payment concentrated in one month can cause that month’s NOI to appear lower. Lenders prefer a stabilized estimate of income and expenses to evaluate the property’s ongoing performance. [1] Reconciling the tax bill with the operating statement helps present this stabilized NOI.

Presenting the reconciliation to lenders

Include the reconciliation workpaper with the loan submission, alongside the operating statement and tax bill. In the property narrative, explain any differences clearly. For example: "The operating statement is prepared on a cash basis and shows property tax expense for the twelve months ended June 2024 that differs from the actual tax bills for that period. The difference results from a payment deferral that was subsequently resolved. The pro forma has been adjusted to reflect the annual tax expense per the tax bills." Providing this level of detail demonstrates thoroughness and transparency.

Questions to ask your lender

Lenders may have specific preferences regarding property tax treatment in underwriting. Before submitting an application, clarify:

  • Do you require operating statements on an accrual basis, or do you accept cash basis with adjustments?
  • How do you handle tax appeals or refunds in NOI calculations?
  • Is a current tax bill or assessment notice required as part of due diligence?

Understanding these requirements helps tailor your submission to the lender’s expectations and can prevent delays.

FAQs

How can I tell if my operating statement is on a cash or accrual basis?

Check the statement’s header or notes for labels such as "cash basis" or "accrual basis." If unclear, ask the property accountant or manager. Cash basis statements reflect income received and expenses paid during the period, while accrual basis statements record income earned and expenses incurred regardless of cash flow timing. [1]

What if the tax bill and operating statement still don’t match after reconciliation?

Document the discrepancy and explain it in your underwriting narrative. Possible reasons include tax prorations at ownership transfer, assessment changes not yet reflected in payments, or one-time refunds. As long as you identify the correct annual tax expense, lenders can adjust their analysis accordingly.

Does reconciling property taxes guarantee loan approval?

No. Reconciliation is one part of preparing a complete and accurate loan request. Lenders consider many factors, including property cash flow, borrower financial strength, and market conditions. [1] A thorough reconciliation supports your credibility but does not replace comprehensive underwriting.

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