How to prepare a rent roll for a refinance lender
Package current leases, charges, concessions, balances, collections, vacancy, and supporting records so lender underwriting starts from a reconciled report rather than a promotional spreadsheet.
14 min read
Updated July 2026
A rent roll used for weekly operations is not automatically an underwriting package. A lender needs definitions, reporting date, lease support, vacancy and concession treatment, collections evidence, and a bridge to financial statements. Hiding an arrearage or substituting projected market rent for current contract rent makes the package less reliable and can derail diligence later. This guide owns lender packaging; the review guide owns operational accuracy and the close guide owns source-to-bank reconciliation. Build the package as an indexed evidence trail, not a cleaned spreadsheet detached from source systems. Underwriting questions should resolve to a lease, amendment, ledger entry, payment outcome, unit-status record, or explicit exception. That structure makes honest corrections easier: the borrower can issue a controlled update, explain the cause, and show the effect on totals without silently altering an earlier submission.
Start with the lender request and exact reporting date
Obtain the lender’s document checklist and definitions for current rent roll, trailing operating statement, leases, borrower, occupancy, concessions, delinquency, market rent, security deposits, and certifications. Requirements differ by property and program. Fannie Mae small-loan and underwriting materials illustrate why current rent roll and income definitions matter, but they do not define every lender’s request.
State borrower or property entity, included parcels and units, report date and time zone, preparation date, source systems, preparer, and contact. Freeze the cutoff and log later activity separately. Do not update a row after submission without versioning the package.
Use one supported row and stable identity per unit
Include property and unit IDs, status, resident or lease identifier appropriate for controlled sharing, lease start and end, contract rent, recurring charges, concessions, billed amount, payments, open balance, paid-through date, deposit reference, renewal or notice status, and relevant notes. Keep personally sensitive data out unless specifically required and securely requested.
Tie each occupied row to an executed lease and amendments and each financial field to the tenant ledger. Confirm vacant, employee, model, owner-occupied, offline, down, pending move-in, and pending move-out statuses under written definitions. Do not classify a unit as occupied solely because a name remains in software.
Separate contract, scheduled, billed, collected, and market rent
Contract rent is the signed lease amount; scheduled rent is what the system expects for the period; billed rent is what was charged; collected rent is settled cash applied; market rent is an estimate under stated evidence. Display and define each rather than collapsing them into “rent.” Explain partial periods, step rents, renewals, and changes not yet effective.
List concessions with type, amount, covered period, and lease support. Distinguish abatement, credit, bad debt, write-off, refund, and collection timing. Annualizing current scheduled rent does not prove historical collected income or future performance.
Reconcile exceptions and collections transparently
Prepare an exception schedule for lease-to-ledger rate mismatch, missing document, aged balance, credit, returned payment, payment plan, disputed amount, vacancy transition, nonstandard occupancy, related party, month-to-month status, and data gap. Show amount or field, source, owner, next step, and expected resolution without editorial concealment.
Reconcile initiated, settled, returned, refunded, and disputed payments to tenant ledgers and bank evidence. A positive balance is not automatically collectible delinquency, and a zero balance can result from a waiver or missing charge. State the composition of each material balance.
Bridge the rent roll to operating statements and cash
Build a bridge from gross potential or scheduled rent through vacancy, concessions, abatements, credits, bad debt, timing, and other adjustments to rental income reported for the same period. Then tie collected cash to bank and processor records with deposits in transit and returns identified. Keep security deposits and other liabilities outside rental income.
Explain differences between rent-roll reporting date and trailing financial periods. A point-in-time rent roll cannot by itself prove twelve months of operations. Provide source reports and accountant-reviewed statements as requested rather than constructing synthetic net income in the rent roll.
Secure, certify, version, and refresh the package
Create an index with report, definition sheet, lease schedule, exception schedule, financial bridge, requested leases, statements, bank support, and certifications. Use secure delivery and access controls. Record exactly what was sent, by whom, to whom, when, and under which version.
Answer lender questions through a change log linked to source evidence. If a new month, lease, payment, vacancy, or correction changes the package, issue a dated replacement or supplement and preserve the earlier version. Do not promise approval, value, or underwriting treatment; the lender makes its own decision.