The short answer
Review a rental rent roll by reconciling tenant, unit, lease, charge, payment, credit, and balance information; then investigate exceptions before using the report for an owner, lending, or portfolio decision.
Practical next step:
Put this workflow into practiceReview a rental rent roll by reconciling tenant, unit, lease, charge, payment, credit, and balance information; then investigate exceptions before using the report for an owner, lending, or portfolio decision.
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 (3)
Common questions (4)
Direct answer
1
Review a rental rent roll by reconciling tenant, unit, lease, charge, payment, credit, and balance information; then investigate exceptions before using the report for an owner, lending, or portfolio decision.
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. Read the rent roll as a control report, not a sales sheet
2. Work the exception queue in a fixed order
3. Example: find the difference before it becomes an owner surprise
4. Use the completed review to make a decision
5. Prove completeness before trusting the total
6. Package the rent roll for the decision it supports
Guide section
Read the rent roll as a control report, not a sales sheet
Connected takeaway
Set a reporting date; rent rolls are point-in-time control reports.
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. Freeze the reporting date
2. Prove every exception
3. Publish the next action
Step 1 of 3 → section 1 of 6
Your action
Freeze the reporting date
Run the report for a stated date, then avoid mixing later payments or lease edits into the review.
Read next
Section 1: Read the rent roll as a control report, not a sales sheet
Connection basis: shared wording — reporting, date, report, payments.
The line shows where the linked section appears in this guide. It is not a priority, completion, or confidence score.
Read the rent roll as a control report, not a sales sheet
A rent roll is a point-in-time inventory of who occupies each unit, what the lease says is due, and what the tenant ledger says remains open. It becomes misleading when it is treated as a promise of income rather than a record that needs to agree with leases and payments. Put a reporting date at the top before you begin.
For every occupied unit, compare the tenant name, unit, lease start and end, current monthly charge, recurring concessions, deposit reference, and balance. For every vacant unit, confirm that the status is actually vacant rather than a pending move-in, an expired lease, or a unit with an unresolved turnover.
A zero balance is not proof that rent was collected: it can also reflect a credit, waiver, or a charge that was never posted.
A positive balance is not automatically delinquency: identify whether it is current-period rent, a disputed charge, a payment in transit, or an old error.
A lease end date is a decision trigger, not merely a data field: mark renewals, notices, and unsigned documents separately.
Work the exception queue in a fixed order
Start with exceptions that can change the economic picture quickly: vacant units, balances that predate the current period, charges that differ from the signed lease, and credits without a documented reason. Then inspect upcoming events, including leases ending soon and agreed rent changes that are not yet reflected in the ledger.
A useful review does not merely highlight a red cell. It records the source of truth and the corrective next step. If Unit 2 shows a $300 credit, the reviewer should be able to point to the approved concession, ledger entry, and effective date—or flag it as unresolved.
Vacancy: confirm the last paid-through date, make-ready status, listed date, and next leasing action.
Balance: identify the oldest open charge, last tenant contact, payment plan if any, and the next follow-up date.
Rate mismatch: compare lease amendment, notice, and ledger charge before changing a number.
Data gap: assign the missing document to a person rather than guessing the field.
Example: find the difference before it becomes an owner surprise
Suppose a three-unit rent roll reports $5,400 in scheduled monthly rent and $5,050 collected. The right question is not simply “why is $350 missing?” Unit A may have an approved $150 renewal concession, Unit B may show a $200 current balance due tomorrow, and Unit C may have paid in full. Those facts produce different actions: preserve the concession record, monitor the current balance, and do not call a fully paid tenant.
If the same $200 is still open after the due and grace periods in the lease, move it into a documented collections workflow. The point is to distinguish timing from a true collection problem before you report performance.
Use the completed review to make a decision
Once exceptions are explained, the rent roll can support a renewal forecast, cash forecast, lender package, or owner update. Attach the reporting date and a short exception log so the reader knows what is settled, what is pending, and what decision the report should inform.
Do not silently overwrite a historical rent roll to make it cleaner. Correct the underlying lease or ledger with an auditable adjustment, then rerun the report. That preserves both the original observation and the reason it changed.
Prove completeness before trusting the total
Reconcile the population as well as the dollars. Count occupied, vacant, notice-given, move-in, move-out, offline, and inactive units under a written status definition. Compare active lease IDs and tenant ledger IDs, then investigate units missing from either side. A report can total correctly while omitting one receivable and one equal credit or while attaching both amounts to the wrong tenancy.
Tie scheduled rent to executed leases and amendments for the reporting period. Tie posted receipts, returns, refunds, and credits to the tenant ledger and payment evidence. Keep security deposits and other liabilities separate from rental income. If a source changed after the reporting cutoff, log the delta instead of silently refreshing one side of the comparison.
Population check: every managed unit has one supported status and every active lease maps to the correct unit.
Charge check: recurring rent and concessions agree with signed terms for the period.
Cash check: receipts and returns retain stable transaction IDs and settlement evidence.
Balance check: every aged amount, credit, or adjustment has a source and next action.
Package the rent roll for the decision it supports
A lender, owner, buyer, and weekly operator do not need the same commentary, but they should start from the same controlled report. State the entity and property scope, reporting date and timezone, source systems, preparation date, preparer, control totals, material exceptions, and whether later events are excluded. Do not relabel asking rent, scheduled rent, billed rent, and collected cash as interchangeable income.
Attach a concise exception schedule rather than editing the report to look clean. For each unresolved item, record the unit or lease, amount or affected field, reason, evidence reviewed, consequence, owner, due date, and disposition. Preserve the original report and correction trail. The next reviewer should be able to reproduce why the report changed and which open items remain outside the decision.
Action plan
Stage 1 of 3
Freeze the reporting date
Run the report for a stated date, then avoid mixing later payments or lease edits into the review.
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
Freeze the reporting date
Run the report for a stated date, then avoid mixing later payments or lease edits into the review.
2
Prove every exception
Open the lease, ledger, payment record, or communication that explains each nonstandard line.
3
Publish the next action
Give each unresolved balance, expiring lease, or missing record an owner and a due date.
This is general educational information, not legal or tax advice. Rules vary by state and change over time — confirm specifics for your jurisdiction with a qualified professional.
Key takeaways
Set a reporting date; rent rolls are point-in-time control reports.
Trace each unusual balance, rate, credit, and unit status to a source record.
Separate timing differences from actual collection, leasing, or data-quality problems.
End with an assigned exception list, not a prettier spreadsheet.
Frequently asked
What should a landlord check on a rent roll?
Check the tenant and unit, executed lease term, current charge, concessions, payment status, balance, deposit reference, and unit status. Then investigate vacancies, aged balances, rate mismatches, and missing documents before relying on the report.
Why does a rent roll not match collected rent?
Scheduled rent and collected cash answer different questions. The difference can come from an approved concession, a current payment still due, a prior balance, a credit, a return, or an error. Trace the line to the lease and tenant ledger before drawing a conclusion.
Should I edit a rent roll to correct a mistake?
Correct the underlying lease or ledger with a documented adjustment, then rerun the report. Do not silently rewrite a historical report, because the original record and the correction both matter.
Is a rent roll the same as a tenant ledger?
No. A rent roll summarizes units, leases, scheduled charges, and balances at a point in time. A tenant ledger records charge, payment, credit, return, and adjustment activity. Reconcile them rather than substituting one for the other.
Keep reading
All reviewed guidesRent roll control path
From rent-roll definition to a reconciled owner report
Define the report first, inspect unit-level exceptions, then prove the totals against the ledger and cash before using it for an owner or lender decision.
Definition
Rent roll
The fields, reporting date, and limits of the core rental operating report.
Continue
Tool
Rent roll analyzer
Inspect scheduled rent, collections, occupancy, open balances, and lease timing from your inputs.
Continue
Definition
Rent roll reconciliation
The control that bridges a point-in-time report to tenant ledgers and supporting records.
Continue
Guide
Close the rent roll to the ledger
A source-to-bank close procedure with exception ownership and release gates.
Continue
Tool
Rent roll reconciliation tool
Compare scheduled, posted, collected, and unresolved amounts without hiding differences.
Continue
Editorial ownership
Written and maintained by the Aptoria editorial team
Repository and source review completed July 28, 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.
Primary and authoritative sources
Let the agent help with the routine.
Aptoria helps coordinate supported routine work from this guide inside configured limits. Free for your first unit.