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

Reconciling cash-basis and accrual-basis property statements for financing

Learn how to reconcile cash-basis and accrual-basis property statements for commercial real estate financing, with a concrete evidence checklist and practical steps to prepare your loan request.

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

Learn how to reconcile cash-basis and accrual-basis property statements for commercial real estate financing, with a concrete evidence checklist and practical steps to prepare your loan request.

When you prepare operating statements for a lender, the difference between cash-basis and accrual-basis reporting can change the story your numbers tell. A tax return or operating statement prepared on a cash basis only reflects income actually received and expenses actually paid during the year. An accrual-basis statement records income when earned and expenses when incurred, regardless of when cash moves. Lenders need to see both to develop a stabilized estimate of net operating income (NOI). This guide walks through how to reconcile the two, what to prepare, and how the information affects the financing discussion.

Understand the timing difference between cash-basis and accrual-basis statements

A cash-basis statement records income when it is received and expenses when they are paid. An accrual-basis statement records income when it is earned and expenses when they are incurred. [1] For example, a tax return for a property where 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 happen with operating statements prepared on a cash basis. [1] When you compare the two, look for timing differences in rent collections, property taxes, insurance premiums, and management fees. A rent roll is a snapshot of current tenants and rents. A trailing twelve-month (T-12) operating statement shows twelve historical months of income and expenses. The T-12 is historical; the rent roll is current. Do not compare them as if they cover the same period.

Distinguish gross rent, collected income, NOI, capex, debt service, and equity cash flow

Gross rent is the total rent billed. Collected income is what was actually received. NOI is collected income minus operating expenses. Capital expenditures (capex) are improvements that extend the property's life, not routine repairs. Debt service is the total of principal and interest payments. Equity cash flow is what remains after all operating expenses, capex, and debt service are paid. A lender evaluates whether the borrower demonstrates the capacity to meet a realistic repayment plan from available cash flow and liquidity. [1] Cash flow from the underlying property is evaluated to determine whether, and to what extent, the borrower can adequately service interest and principal on a prospective loan. [1] Do not equate a cap rate with a debt constant. A cap rate is a valuation metric; a debt constant is a loan payment factor. They measure different things.

Prepare a reconciliation workpaper: cash-basis to accrual-basis

Create a simple spreadsheet or document with three columns: line item, cash-basis amount, and accrual-basis amount. List each income and expense category from the trailing twelve-month statement. For each item, note whether it was recorded on a cash or accrual basis. Then adjust the cash-basis figure to an accrual-basis figure by adding income earned but not yet collected and subtracting income collected but not yet earned. Do the same for expenses: add expenses incurred but not yet paid and subtract expenses paid but not yet incurred. The result is an accrual-basis NOI. [1] The objective is to develop an NOI that represents a stabilized estimate of income and expenses. [1] This reconciliation workpaper becomes part of your loan request. It shows the lender you understand the difference and have adjusted for it.

Compare reported expenses to comparable properties

After you reconcile, compare your adjusted expenses to expenses incurred by comparable properties. [1] Adjust for supported variances and lease terms. [1] For example, if your property pays its own utilities and a comparable property passes them through to tenants, your expenses will be higher. Note the reason for the difference. If your property has above-market management fees, flag that. Lenders look for stabilized, recurring cash flows. [1] Unusual or non-recurring expenses should be identified and explained. This comparison helps the lender see whether your property's operating performance is in line with market expectations.

Identify the reporting basis and reconcile periods

Do not assume financial statements are on a cash basis. Identify the reporting basis explicitly. If the statement is on a cash basis, note that. If it is on an accrual basis, note that as well. Then reconcile the periods. A trailing twelve-month statement covers twelve consecutive months. A rent roll is a single point in time. If you are comparing trailing twelve-month data to a rent roll, adjust for lease start dates, rent concessions, and vacancy changes during the twelve months. The trailing twelve-month statement shows what happened; the rent roll shows what is supposed to happen now. Both are useful, but they are not interchangeable.

Prepare a debt-service coverage ratio analysis

The debt-service coverage ratio (DSCR) is calculated by dividing NOI by annual debt service requirements. [1] The determination of an appropriate DSCR should consider the loan amortization period and the expected volatility of the cash flow. [1] Use your reconciled accrual-basis NOI for this calculation. Then run a second calculation using your cash-basis NOI. Compare the two. If the cash-basis DSCR is lower, it may indicate timing issues with rent collections or expense payments. Explain why. A lower DSCR may be acceptable for properties with stable and certain cash flows, such as those with long-term net leases to highly creditworthy tenants. [1] The lender uses this ratio to measure your ability to service the debt.

Ask the actual lender about their preferred format

Lenders differ on what they want to see. Some prefer accrual-basis statements; others accept cash-basis statements with a reconciliation. Ask the lender directly. Do not assume. The OCC handbook notes that loan documents typically include covenants requiring the periodic submission of financial information that allows the bank to adequately monitor the borrower's and guarantor's overall financial soundness and capacity to support the credit. [1] Your job is to provide the information in a format that the lender can use. If you are unsure, prepare both and include the reconciliation workpaper. This shows thoroughness and helps the lender underwrite the loan.

Frequently asked questions

What is the difference between a rent roll and a trailing twelve-month operating statement? A rent roll is a snapshot of current tenants, rents, and occupancy at a single point in time. A trailing twelve-month (T-12) operating statement shows twelve historical months of income and expenses. They cover different periods and serve different purposes. Compare them with care.

Should I use cash-basis or accrual-basis numbers for the debt-service coverage ratio? Use accrual-basis NOI for the primary DSCR calculation, as it reflects income when earned and expenses when incurred. Then run a second calculation using cash-basis NOI to show timing differences. Explain any material variances.

What if my property has non-recurring expenses in the trailing twelve-month period? Identify and flag non-recurring expenses. Adjust them out of your stabilized NOI projection. Lenders look for recurring, predictable cash flows. Non-recurring items can distort the picture if left in.

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