Documenting expense reimbursements without double-counting NOI
A task-specific guide for sponsors to prepare a reimbursement reconciliation workpaper that separates gross rent, tenant collections, and landlord-paid operating expenses, preventing NOI inflation and clarifying debt-service coverage for lenders.
A task-specific guide for sponsors to prepare a reimbursement reconciliation workpaper that separates gross rent, tenant collections, and landlord-paid operating expenses, preventing NOI inflation and clarifying debt-service coverage for lenders.
When a property has net leases, the landlord collects rent and may also collect tenant reimbursements for expenses like taxes, insurance, and common area maintenance. If those reimbursements are added to gross income and the same expenses are deducted again, net operating income (NOI) is overstated. Lenders develop a stabilized estimate of NOI, and double-counting reimbursements would produce an inaccurate stabilized NOI [1]. This guide walks through a concrete workpaper to reconcile reimbursements and report a clean NOI.
What the workpaper shows
The workpaper is a simple spreadsheet you prepare from your rent roll and trailing twelve months (T-12) of operating statements. It has four columns: (1) gross rent per the rent roll, (2) collected income per the T-12, (3) actual operating expenses paid by the landlord, and (4) tenant reimbursements collected. The goal is to identify where reimbursements appear on both the income and expense sides and to remove the duplication.
Separating gross rent, collected income, and reimbursements
A current rent roll is a snapshot of scheduled rents. A T-12 shows twelve historical months of income and expenses, which may be reported on a cash or accrual basis. The timing difference matters: a rent roll may list scheduled rents, but the T-12 may show lower collected income due to vacancy, concessions, or late payments [1]. Record both totals and compare them. Then isolate tenant reimbursements in the T-12. If reimbursements are lumped into a single "other income" line, ask the actual lender how they prefer to see them broken out. A suggested way to prepare this is to create a sub-schedule that lists each expense category (real estate taxes, insurance, common area maintenance) and the reimbursement collected for that category.
Reconciling NOI without double-counting
Net operating income is gross income less operating expenses, excluding debt service, depreciation, and capital items [1]. Including tenant reimbursements in gross income while also deducting the full operating expense without an offset will overstate NOI. The OCC handbook permits including reimbursements in gross income if the reimbursed expenses are also included in operating expenses, but the offset must be clearly shown [1]. To avoid overstatement, subtract reimbursements from the corresponding operating expense before calculating NOI. This approach provides the lender with an accurate view of the landlord's net cash cost.
Stabilizing income and expenses
Lenders develop a stabilized estimate of NOI, not a one-year snapshot [1]. Tax returns may be prepared on a cash basis, which can understate expenses if bills were not paid in that year [1]. Compare your T-12 with your tax returns and identify any timing differences. For example, if real estate taxes were accrued in the T-12 but paid in a different period, the tax return will show a different expense amount. Adjust by using the accrual-basis T-12 for underwriting and note the cash-basis difference for the lender. A suggested way to organize this is to prepare a three-year comparison of NOI from your financial statements, tax returns, and rent rolls, and flag any significant variances, as the OCC handbook recommends examining significant variances over at least a three-year period [1].
Debt-service coverage and covenant definitions
The debt-service coverage ratio (DSCR) is NOI divided by annual debt service requirements [1]. If NOI is inflated by double-counted reimbursements, the DSCR will be overstated, potentially misrepresenting the property's ability to support debt. Loan documents often include debt-service coverage covenants, and the definitions of income and expenses in those covenants may differ from the underwriting DSCR [1]. Record the covenant definitions from your existing or proposed loan documents and compare them to your workpaper. If the covenant uses a different NOI formula, adjust your projections accordingly.
Evidence checklist for the workpaper
Prepare these items and keep them in your financing file: - Current rent roll with lease type (gross, modified gross, triple net) noted for each tenant. - T-12 operating statements with income and expenses broken out by month. - Tax returns for the last two years, with a note on whether they are cash or accrual basis. - A reconciliation schedule that shows gross rent, collected income, total operating expenses, tenant reimbursements, and net NOI after offset. - A variance analysis comparing the T-12 NOI to the tax return NOI, with explanations for differences. - A copy of any existing loan covenant definitions for income and expenses.
How this affects the financing discussion
A clean reimbursement reconciliation shows the lender that you understand the property's true cash flow. It reduces underwriting questions and can support a more accurate DSCR. The OCC handbook emphasizes that an important objective of underwriting is to develop a stabilized estimate of income and expenses [1]. By delivering a workpaper that isolates reimbursements and stabilizes NOI, you give the lender confidence in the property's ability to service debt under both normal and stressed conditions [1]. This is especially important for properties with net leases, where the distinction between landlord and tenant expenses is critical [1].
Frequently asked questions
Does including reimbursements in gross income always double-count NOI?
Only if the corresponding expense is also deducted. If you include reimbursements in gross income and deduct the full operating expense without an offset, the NOI will be overstated. The OCC handbook allows reimbursements in gross income if the reimbursed expenses are also included in operating expenses [1]. A suggested way to handle this is to show the reimbursement as a reduction to the expense line rather than as separate income.
What if my tax returns are cash basis and my T-12 is accrual basis?
Lenders typically underwrite from accrual-basis financial statements because they match the timing of income and expense recognition [1]. Prepare a reconciliation that shows the cash-basis tax return NOI and the accrual-basis T-12 NOI, and explain timing differences such as unpaid real estate taxes or delayed rent collections.
Does the workpaper replace the lender's own underwriting?
No. The workpaper is a suggested way to prepare information for the lender. The lender will perform its own underwriting and may adjust your NOI based on market comparables or stress tests [1]. Your workpaper accelerates that process by providing clear, reconciled data.
We arrange commercial real estate debt on behalf of sponsors and will help you prepare the loan request for the lenders suited to your deal.
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).