A rent roll should show which units and leases belong to a property at a stated cutoff, with the rent basis and status for each row. Build the unit inventory first, attach the applicable lease, and separate contract rent from cash received. A resident-level export can omit vacant units or repeat a unit with several occupants, so inspect the report’s row definition before totaling it.
For a portfolio review, keep the property, unit, and lease identifiers alongside the displayed names. Those identifiers let you connect the snapshot to signed terms, rent charges, and later corrections without assuming that similar property names refer to the same asset. The snapshot is a source for the review, not the full property reporting pack.
Use a unit and lease grain that preserves vacancy
Define whether one row represents a unit, a lease, or an occupant. For residential operations, a unit snapshot with a linked active lease can keep vacant units visible and prevent roommates from multiplying rent. If a unit can have overlapping contracts or separate leased spaces, retain those relationships instead of forcing them into a single resident-name field.
TurboTenant’s rent-roll instructions say its report is organized by lease profile and a vacant unit without a lease profile will not appear. That is a product-specific example of why you should reconcile the export with the full unit register before calculating occupancy or potential rent.
Use stable unit IDs through manager handovers or renumbering, with the earlier reference retained as a mapping. Do not merge Unit 101 at two different properties. Property ID plus unit ID establishes the local identity, while the lease ID distinguishes a departing resident’s agreement from the incoming resident’s agreement for the same space.
Keep contract, status, and evidence fields together
Retain property and unit IDs, lease ID, lease start and end, possession or occupancy status, base rent, rent frequency, effective dates, and the snapshot cutoff. Add currency and source reference. Keep concessions, deposits, fees, and receivable balances in separate fields when included, because their presence does not turn them into base rent.
Distinguish an occupied unit, an active lease, a future lease, and a notice to vacate. The applicable status depends on the question and dates. A signed future lease can help a leasing lead plan a move-in without making today’s vacant unit occupied. Define the rule before showing an occupancy total.
DoorLoop’s rent-roll documentation distinguishes historical unit status from the current rent and balance values returned for a selected date. Check that behavior in any report you use. Selecting a past cutoff does not prove every displayed financial field has been reconstructed as of that date.
Reconcile a hypothetical three-unit snapshot
Assume a synthetic property has three rentable units at an October 31 cutoff. Unit A has an active occupied lease at $1,500 per month; Unit B has an active occupied lease at $1,700; Unit C is vacant, with a proposed market rent of $1,600. There are no concessions, partial-month terms, or overlapping leases in this example.
| Unit | Status at cutoff | Monthly contract base rent | Market asking rent for vacant unit |
|---|---|---|---|
| A | Occupied | $1,500 | Not used |
| B | Occupied | $1,700 | Not used |
| C | Vacant | $0 | $1,600 |
| Total | 2 occupied of 3 | $3,200 | $1,600 for C only |
Contract base rent totals $3,200 per month. Multiplying that recurring amount by twelve gives a $38,400 annualized run rate under the unchanged-lease assumption. It is not a forecast of collected cash or earned revenue. Adding C’s $1,600 produces a different $4,800 monthly scenario that assumes the vacancy leases at the proposed amount.
If A paid $1,400 during October, the payment does not reduce its $1,500 contract rent to $1,400. Inspect applications to rent charges, concessions, arrears, and unapplied receipts before assigning the difference. The property management KPI definitions explain why collection and occupancy require their own denominators.
Rent terms and effective dates.
Amounts billed for a stated period.
Payments and their applications.
Rebuild the cutoff without overwriting later changes
Store the report’s generation time separately from its business cutoff. A rent roll generated in November for October 31 may include corrections entered after October closed. Keep the version and any known limitation beside the file so the receiving analyst can distinguish a historical reconstruction from the report originally issued.
Use effective dates for rent increases. If B’s rent rises to $1,800 in December, an October snapshot should not inherit that amount just because the current lease screen shows it today. Retain the applicable schedule or source version, then compare the October value with the terms in force at the cutoff.
For a manager handover, compare unit counts, lease counts, and recurring rent totals before and after the mapping. Investigate each unmatched unit and each lease attached to several units. A matching grand total can coexist with rents assigned to the wrong spaces, so count and identity checks need to accompany amount reconciliation.
Release the snapshot with its unresolved records
Ask the property owner to confirm unit eligibility and the leasing owner to confirm contract dates. Record a separate resolution for a missing signed agreement, an ambiguous move-out date, or a disputed concession. An empty field should keep its reason instead of receiving a guessed rent that makes the total look complete.
Protect resident-level details when sharing the report. An asset review may need unit identifiers and rent amounts without personal contact information. Select fields and recipients for that purpose, and apply the relevant access policy to downloads as well as screens. A public spreadsheet link can expose the same data as a broad application permission.
Use the rent roll as one input to property management reports, where charges, expenses, and receipts have their own reconciliations. This article’s unit-and-lease snapshot does not reproduce that reporting pack. The handoff should state which rent basis the next report consumes.
Where Permute fits in a portfolio rent view
Permute sells the context layer between business data and the AI tools people already use. We can connect approved spreadsheet and document sources, reconcile property and unit references, and preserve the evidence behind a rent snapshot. An uncertain lease-to-unit mapping remains visible for the property owner to resolve.
We apply your declared cutoff, eligibility, and rent definitions across the permitted records. A portfolio operations lead can ask which units changed contract rent or lack supporting terms and inspect the underlying source references. Shared definitions help keep a leasing view and an asset report consistent without exposing every resident field to every reader.
Explore a dated property snapshot
Start with a permitted unit register and the corresponding lease or rent export.
Keep lease interpretation and source corrections with owners
We read connected sources rather than writing rent changes back into systems of record. We do not determine legal lease terms, choose accounting treatments, or promise a packaged connection to the property systems mentioned here. Property, leasing, and finance owners approve their definitions and resolve conflicting evidence. Historical reconstruction remains limited by the available source history.
A usable rent roll identifies the units, applicable leases, rent basis, and cutoff behind its totals. Reconcile it with the full unit register, then keep vacancy and future leases distinct. Separate recurring contract amounts from charges and receipts, and retain unresolved records at release. Those checks let the next reader use the snapshot without mistaking an annualized rent amount for collected income.
Review the handoff between leases and portfolio reporting
Bring a redacted rent export, unit register, and one disputed cutoff or rent amount.
Questions about rent roll
Should security deposits be included in rent?
Keep deposits separate from contract base rent. If the report includes a deposit field, label it and preserve its source balance. Finance and the responsible property owner determine its treatment under the applicable agreement and rules.
Can the same layout work for commercial leases?
The identity and cutoff checks still apply, but the row structure may need leased areas, rent schedules, and separate charges. Define the lease and space relationships before combining them with residential unit counts.
Should an unknown rent be entered as zero?
No. A zero amount states a value, while an unknown amount states missing evidence. Keep the distinction visible and assign someone to confirm the applicable terms.