The short answer
Prepare a lender-ready rent roll by fixing the reporting date and property scope, reconciling every unit to executed leases and tenant ledgers, separating contract, scheduled, billed, collected, and market rent, disclosing concessions, vacancies, arrears, related-party or nonstandard occupancy, and linking totals to operating statements, bank records, and a dated exception schedule. Follow the lender’s actual document request.
Practical next step:
Put this workflow into practiceA 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.
Guide evidence map
Preview the answer, sections, action steps, and questions this guide actually contains. This map describes the page's structure; it is not a rating or completion measure.
Direct answer (1)
Guide sections (6)
Action steps (4)
Common questions (4)
Direct answer
1
Prepare a lender-ready rent roll by fixing the reporting date and property scope, reconciling every unit to executed leases and tenant ledgers, separating contract, scheduled, billed, collected, and market rent, disclosing concessions, vacancies, arrears, related-party or nonstandard occupancy, and linking totals to operating statements, bank records, and a dated exception schedule. Follow the lender’s actual document request.
Section connection graph
Choose a section to follow it to a key takeaway already on this page. The pairing uses repeated terms in this guide's own copy; if no terms repeat, it follows the guide's reading order.
1. Start with the lender request and exact reporting date
2. Use one supported row and stable identity per unit
3. Separate contract, scheduled, billed, collected, and market rent
4. Reconcile exceptions and collections transparently
5. Bridge the rent roll to operating statements and cash
6. Secure, certify, version, and refresh the package
Guide section
Start with the lender request and exact reporting date
Connected takeaway
A rent roll is point-in-time evidence, not a promise of future income.
The animated line only confirms the current selection; it does not indicate priority, progress, or a score.
Decision reading path
Start with the action you are making, then read the section that uses the closest wording. When there is no wording match, this follows the guide's written order.
1. Define
2. Reconcile
3. Bridge
4. Deliver
Step 1 of 4 → section 1 of 6
Your action
Define
Fix lender request, scope, cutoff, field dictionary, and delivery controls.
Read next
Section 1: Start with the lender request and exact reporting date
Connection basis: shared wording — define, lender, request, cutoff.
The line shows where the linked section appears in this guide. It is not a priority, completion, or confidence score.
Recommendation evidence trail
Rent-roll-to-lender evidence path
Each stage translates an operating record into an underwriting-ready, source-linked package without promising a lending outcome.
1. Scope and define
2. Reconcile detail
3. Bridge financials
4. Package and refresh
Scope and define
Where to look
Lender request, borrower and property entity, reporting date, unit inventory, and field dictionary
Evidence to request
Property boundary, cutoff, rent definitions, occupancy statuses, and preparer
Reject when
The package mixes properties, dates, or unlabeled rent concepts.
Reversible fallback
Freeze a new report and provide a definition sheet.
The rail marks which source-check stage you selected. It does not rate a product, estimate quality, or choose a winner.
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.
Action plan
Stage 1 of 4
Define
Fix lender request, scope, cutoff, field dictionary, and delivery controls.
Select a stage to trace the exact handoff. The rail marks the selected position in this guide's own workflow; it is not a completion score.
1
Define
Fix lender request, scope, cutoff, field dictionary, and delivery controls.
2
Reconcile
Tie every row to leases, ledgers, payment outcomes, and supported unit status.
3
Bridge
Explain scheduled, collected, concession, vacancy, and financial-statement differences.
4
Deliver
Index, secure, version, certify as appropriate, and log every subsequent update.
Key takeaways
A rent roll is point-in-time evidence, not a promise of future income.
Keep contract, scheduled, billed, collected, and market rent distinct.
Disclose concessions, arrears, vacancy, nonstandard occupancy, and unresolved exceptions.
Version every lender submission and preserve the source-linked change record.
Frequently asked
What does a lender look for on a rent roll?
Requests vary, but lenders commonly review unit status, lease dates, contract and market rent, concessions, balances, collections, vacancy, nonstandard occupancy, and consistency with leases and operating statements.
Should market rent replace contract rent on a lender rent roll?
No. Display and label them separately. Contract rent comes from executed terms; market rent is a dated estimate. The lender decides how each is used in underwriting.
How current should a refinance rent roll be?
Follow the lender’s request. State the exact reporting date, preparation date, later-event treatment, and package version rather than calling an undated report current.
Can a landlord remove delinquent units from a refinance rent roll?
No. Include every unit within scope under a consistent status definition and disclose balances and exceptions accurately. Omitting unfavorable rows makes the package unreliable.
Keep reading
All reviewed guidesEditorial ownership
Written and maintained by the Aptoria editorial team
Repository and source review completed July 29, 2026. Aptoria reviews scope, source fit, examples, limitations, links, and publication gates. This record does not claim attorney, CPA, lender, appraiser, or other independent professional sign-off.
Professional review is not claimed. Verify current law, tax treatment, loan terms, valuation inputs, and property-specific facts with the appropriate qualified professional before acting.
Let the agent help with the routine.
Aptoria helps coordinate supported routine work from this guide inside configured limits. Free for your first unit.