Accounting & tax
Rent roll reconciliation
Rent roll reconciliation is the documented comparison of the rent roll with leases, unit status, tenant ledgers, and posted recurring charges for the same cutoff.
Glossary
Accounting & tax
Rent roll reconciliation tests whether the operating summary agrees with the records that create rent and occupancy. A rent roll is the report being tested; reconciliation is the control. The reviewer fixes a common cutoff, then compares each unit with the executed lease, current tenancy status, recurring-charge setup, and tenant ledger. Portfolio totals alone are insufficient because an understated unit can offset an overstated one.
The comparison should distinguish contract rent, market rent, concessions, other recurring charges, credits, and balances due. Those amounts answer different questions. A vacant unit with market rent belongs in availability analysis but should not create tenant rent. A signed renewal may govern a future amount without changing the current-period charge. Effective dates and record status therefore matter as much as dollars.
A useful reconciliation leaves an exception record for every difference: property and unit, conflicting values, authoritative source, cause, correction owner, action taken, and retest. The objective is not to make the report look plausible. It is to prove that the summary and the records driving billing describe the same rental position at the stated time.
Small landlords should run the control before statements, renewal decisions, or a software cutover, and after bulk lease or recurring-charge changes. Typical failures include comparing exports from different dates, editing the report without fixing the source setup, accepting equal totals with crossed units, and treating an unsigned draft as an effective lease.
Numbered scenario: one renewal, three different rents
A four-unit building shows $6,050 of monthly contract rent, but the recurring-charge report totals $6,125.
Failure modes that totals can hide
Equal portfolio totals do not prove unit-level accuracy. Crossed tenants, stale vacancy status, early renewals, and concessions entered as lower contract rent can all survive an aggregate check.
Decision artifact: release the rent roll only when
Use this compact acceptance gate before relying on the report.
Rent 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
Guide
Review a rental rent roll
A small-landlord workflow for leases, balances, concessions, vacancies, and exceptions.
Continue
Tool
Rent roll analyzer
Inspect scheduled rent, collections, occupancy, open balances, and lease timing from your inputs.
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