Short answer: a rent roll is a dated unit-by-unit snapshot of occupancy, lease terms, recurring charges, deposits, balances, and upcoming lease events. A useful rent roll identifies every unit, distinguishes current facts from calculated measures, ties each value to a source record, and carries an exception queue so the report can be reviewed instead of merely exported.
Buildium defines a rent roll as a portfolio-level report showing units, leases, rent, payment status, and occupancy. HUD's current NSPIRE inspection protocol requires a rent roll or all-inclusive list to identify buildings and units, include non-revenue units, distinguish occupied and vacant units, and identify subsidized units for applicable inspections. The IRS emphasizes records that clearly support rental income and expenses. This independent template is educational and is not legal, accounting, lending, valuation, tax, fair-housing, or HUD-compliance advice.
Put an as-of date on every rent roll
A rent roll without an as-of date mixes facts from different moments. Record the reporting date, portfolio scope, currency, accounting basis where relevant, and generation time. Preserve prior snapshots rather than silently replacing them. Readers should know whether a balance, vacancy, or expiration is current as of today, month end, or another controlled cutoff.
The essential unit and lease fields
- Property, building, unit identifier, address, and unit type.
- Revenue status, occupancy status, and availability status.
- Lease status, start date, end date, notice date, and move-in or move-out date.
- Contract rent, recurring charges, concessions, credits, and market-rent reference if used.
- Security-deposit amount and separately controlled deposit record.
- Current charges, payments, balance, and aging reference.
- Renewal status, next action, responsible person, and exception note.
Do not put unnecessary personal data in the report
Most owner and operational reviews do not need full resident contact details, identity documents, payment credentials, screening records, or sensitive notes. Use an internal resident or lease reference and apply role-based access. Produce a narrower version for external recipients when the full operating report contains information they do not need.
Reconcile the unit universe first
Compare the rent roll with the property and unit master. Every active unit should appear once, including vacant, employee, model, offline, commercial, storage, or non-revenue units where relevant. Duplicate units and missing units invalidate occupancy and income totals before any lease math begins.
Run seven monthly checks
- Unit completeness: every in-scope unit appears once.
- Occupancy consistency: occupied units have an appropriate active record; vacant units do not carry an unexplained active lease.
- Date consistency: lease, notice, move, and availability dates follow a plausible order.
- Charge consistency: recurring charges agree with approved lease terms and amendments.
- Balance consistency: totals reconcile to the controlled ledger or receivables report.
- Deposit consistency: deposit amounts reconcile to the separate liability and custody record required by policy.
- Action completeness: expirations, notices, vacancies, unexplained variances, and missing records have owners and due dates.
Download the rent roll workbook starter
Download the editable property management rent roll template (CSV). It includes fictional example rows, source references, review status, exception ownership, and the operational fields needed for a monthly snapshot. Remove the examples before entering controlled data.
Use the rent roll as a decision queue
Summaries should expose occupied and vacant units, scheduled move-outs, leases expiring in 30, 60, and 90 days, contract rent, recurring charges, concessions, overdue balances, units offline, and unresolved exceptions. Pair the snapshot with the KPI dictionary so every calculated measure has one formula and owner.
Connect it to the monthly owner story
The rent roll explains what is leased and billed; it does not replace an income statement, cash report, delinquency detail, or owner statement. Use the owner statement and performance dashboard guide to decide which view answers each question, and the property accounting workflow to preserve the source-to-report chain.
Frequently asked questions
Is a rent roll the same as a tenant ledger?
No. A rent roll is a portfolio or property snapshot by unit. A tenant or lease ledger is a detailed transaction history for one account. Reconcile them, but do not force one report to serve both purposes.
Should market rent appear on a rent roll?
It can support leasing and valuation analysis when the source and effective date are documented. Keep it distinct from contract rent and do not present an unsupported estimate as a lease fact.
How often should the rent roll be reviewed?
High-volume teams may monitor exceptions daily. A controlled month-end review is still useful for owner reporting and accounting. Lenders, investors, programs, and agreements may require a different cadence or format.
Official references
- Buildium: rent roll definition and fields
- HUD: NSPIRE Inspection Protocol Guide
- IRS: rental real estate income, deductions, and recordkeeping