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

How to present rent collections that differ from bank deposits

A practical guide for multifamily sponsors on reconciling rent roll collections with bank deposits, including an evidence checklist and explanations of how this affects lender underwriting.

Source: CodexTopic: Multifamily income evidence1035 wordsUpdated 2026-11-19

A practical guide for multifamily sponsors on reconciling rent roll collections with bank deposits, including an evidence checklist and explanations of how this affects lender underwriting.

When a rent roll shows collected rent that does not match bank deposit records, lenders may question the accuracy of income reporting or suspect undisclosed vacancies or concessions. This guide explains how to prepare a clear reconciliation, what documents to assemble, and how to present the information so the lender can underwrite with confidence.

Identify the timing difference between a rent roll and a T-12

A current rent roll is a snapshot of the property on a single date. It shows which units are occupied, the contracted rent per unit, and any concessions or delinquencies as of that day. A trailing twelve-month (T-12) operating statement is a historical record of income and expenses over the past twelve months. The two will rarely match because the rent roll captures a point in time while the T-12 covers a period. Before comparing totals, record the date of the rent roll and the months covered by the T-12. Explain that a unit listed as occupied on the rent roll may have been vacant for part of the T-12 period, and a tenant who paid late in month 11 may appear as current on the rent roll but as delinquent in the T-12. [1] supervisory guidance recommends verifying that tenants and vacancies have been accurately reported in the rent roll, so a clear reconciliation shows the lender you have done that work.

Distinguish gross rent, collected income, and net operating income

Lenders evaluate cash flow available for debt service, not just contractual rent. Prepare a simple table that shows:

  • Gross potential rent: the total rent if every unit were occupied at market rate.
  • Gross collected rent: the actual cash received from tenants, net of concessions and write-offs.
  • Net operating income (NOI): gross collected rent minus operating expenses, before debt service.
  • Debt service: the scheduled principal and interest payments on the loan.
  • Equity cash flow: NOI minus debt service.

If collected income on the rent roll differs from bank deposits, identify the source of the gap. Common reasons include security deposits held in a separate account, utility reimbursements paid directly to the utility company, or management fees deducted before deposit. For each difference, note whether it is a timing issue (deposit lag) or a structural one (expense paid before deposit). [2] explains that lenders base their underwriting on the information provided, so a clear reconciliation helps the lender assess risk accurately.

Prepare a rent roll reconciliation worksheet

Create a single-page worksheet that compares the rent roll collected income to the bank deposits for the same period. Include:

  • The date of the rent roll.
  • Total collected rent per the rent roll.
  • Total bank deposits for the same period (attach bank statements).
  • Each difference itemized (e.g., late deposits, security deposit transfers, utility reimbursements).
  • A net adjustment that explains why the two totals differ.

This worksheet is not a lender requirement but a suggested way to organize information. It demonstrates that you have identified and explained each variance. [1] supervisory guidance highlights the importance of monitoring real estate lending market conditions to ensure lending policies remain appropriate, and a clear reconciliation supports that monitoring.

Collect supporting documents for each variance

For each item on the reconciliation worksheet, attach the supporting document. Examples include:

  • Bank statements showing deposit dates and amounts.
  • Tenant ledgers showing payment dates and amounts.
  • Copies of security deposit receipts or transfer records.
  • Management company reports showing deductions before deposit.
  • Utility reimbursement invoices and payment records.

If a variance is due to a tenant paying late, note the tenant name, unit, and the date the payment was actually deposited. If the variance is due to a concession (e.g., one month free), show the concession schedule. [1] supervisory guidance recommends periodic property inspections to verify that tenants and vacancies have been accurately reported, and the same principle applies to income verification.

Explain how the reconciliation affects debt service coverage

Lenders calculate debt service coverage by dividing NOI by total debt service. If collected income is lower than bank deposits suggest, coverage may be overstated. If collected income is higher, coverage may be understated. Show the lender both scenarios: the coverage ratio using the rent roll collected income and the coverage ratio using the bank deposits. Then show the coverage ratio after your reconciliation adjustments. This demonstrates your understanding of the impact on underwriting. [2] notes that loan terms depend on the property, the sponsor, the lender, and market conditions, so a clear reconciliation helps the lender evaluate risk accurately.

Ask the actual lender about their preferred format

Lenders may have specific requirements for how income evidence is presented. Before finalizing your reconciliation, ask the lender:

  • Do you prefer a rent roll that shows collected income or gross potential rent?
  • Should the T-12 be prepared on a cash or accrual basis?
  • Do you require a separate reconciliation for each property in a portfolio?
  • What is your tolerance for variances between the rent roll and bank deposits?

The lender’s underwriting team will ultimately decide what format they accept. [2] explains that lenders differ on more than interest rates; covenants and reserves can be as important to a business plan.

Frequently asked questions

What if the rent roll and bank deposits never match exactly?

It is common for the two to differ due to timing, concessions, or expense deductions. The key is to explain each variance with supporting documents. Lenders expect a reconciliation, not a perfect match.

Do I need to prepare a reconciliation for every month?

No. Prepare one reconciliation for the most recent trailing twelve-month period. If the lender requests additional months, you can expand the worksheet. Focus on the period that the lender will underwrite.

Can I use software to generate the reconciliation?

Yes, but the lender will still need to see the supporting documents. Software can produce the worksheet, but attach the bank statements and tenant ledgers manually. The reconciliation is only as reliable as the evidence behind it.


To move forward, send us the property, the business plan, and the capital you need. We will tell you how we would approach it.

Model this deal and request financing

Run a multifamily acquisition or value-add model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.

Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.

Open the acquisition model

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