A rent roll template can make a multifamily review more consistent, but a clean spreadsheet is only useful when its entries match the underlying records. Before using a rent roll in underwriting, confirm what each field means, trace key figures to source documents, and flag gaps instead of treating them as zeroes.
Explore Slung’s multifamily underwriting workflow
What should a rent roll template include?
A rent roll summarizes the units at a property and the rental arrangements associated with them as of a stated date. The exact layout varies, so record the reporting date and the source of the information. That context helps reviewers distinguish current occupancy from a lease that starts later or a unit that is temporarily offline.
For each unit, a useful working template may include:
- Unit identifier: Building, unit number, and any relevant floor plan or unit type. Use a consistent identifier that can be matched to the property’s unit schedule.
- Occupancy status: Occupied, vacant, notice given, model, or offline, with a note explaining nonstandard statuses.
- Tenant or lease reference: A tenant name or a privacy-safe identifier, plus lease status. Limit personal information to what the review requires.
- Lease dates: Lease start and end dates, renewal status, and any known notice date. Confirm date conventions and whether the listed end date is inclusive.
- Contract rent: The recurring rent stated in the lease, with a clear period such as monthly. Keep it separate from fees and one-time charges.
- Concessions and effective rent: Concession type, amount, timing, and calculation method. If effective rent is shown, preserve the inputs used to calculate it.
- Other recurring charges: Parking, storage, or other recurring amounts in distinct columns. Do not combine these silently with base rent.
- Deposit and balance fields: Security deposit and any reported balance, with the date and source. These are not substitutes for a ledger review.
- Notes and provenance: Source file, extraction or update date, reviewer, and unresolved questions.
Column labels alone do not define the data. A field called “market rent” might mean a broker estimate, a scheduled rate, or an asking rent. Add a definition or source note so the next reviewer does not treat unlike figures as comparable. Keep original labels when standardizing them, and preserve a change log for any normalized values. For a public-sector example of a rent roll used in reporting, see Marin County’s rent roll template and reporting requirements. The county page illustrates a specific funding-reporting context; it does not establish a universal format for private multifamily underwriting.
How should you check the unit list?
Start with the property’s unit schedule or another authoritative inventory supplied for the deal. Compare unit identifiers and counts, then investigate duplicates, missing units, inconsistent numbering, and units that appear in one file but not another. Do not force a match by guessing that similarly named units are the same.
Reconcile the rent roll’s occupied, vacant, and offline counts to the stated total inventory. Ask whether employee units, model units, units under renovation, or other special cases are included. If the source uses an unusual status, document how it was treated rather than folding it into occupied or vacant without explanation.
For example, if the schedule lists 120 units but the rent roll contains 118 rows, do not assume the two missing rows are vacant units. Identify the specific unit numbers, ask whether they are omitted or combined, and leave the count unresolved until the source is clarified. If one row is duplicated, preserve both source references while determining which record is valid.
How do you verify lease and rent details?
Choose a sample of units, including unusual cases, and trace the roll’s entries to lease documents or other source records. Compare lease dates, base rent, concessions, and recurring charges. For a material discrepancy, check the source and ask for clarification; do not resolve it by selecting whichever number supports the preferred conclusion.
Then test the roll at a broader level. Sum the monthly base rent and compare it with the source’s stated total, if available. Check that the calculation includes the intended units and uses the same reporting date. Separately total recurring add-ons and concessions so that they do not obscure the base-rent figure. If rent is stated at a different frequency, convert it only with the period and method documented.
A rent roll is not always a ledger. It may show scheduled contractual rent, while a tenant ledger records charges, payments, credits, and balances over time. Compare the roll with operating records such as a T-12 where relevant, but do not expect every figure to match: the documents may cover different periods or measure different things. Record the reason for a difference and which source supports each assumption.
For scanned or handwritten records, verify a figure against the page image, not only a typed summary or extracted field. Pay special attention to decimal points, unit numbers, date formats, and whether a concession is entered as a one-time credit or a monthly amount. Keep the source page or filename easy to locate so another reviewer can repeat the check.
What should you flag before underwriting?
- Missing or unclear dates: Ask for a reporting date and confirm the period each figure covers.
- Blank cells: Determine whether a blank means unknown, not applicable, or zero. Keep those meanings separate.
- Unexplained rent changes: Check for renewals, scheduled increases, concessions, or data-entry errors.
- Vacancy ambiguity: Distinguish a vacant unit from one leased but not yet occupied, or one withheld from the market.
- Inconsistent units or categories: Standardize carefully while retaining the original label and a record of the change.
- Unusual concessions or balances: Confirm timing, calculation, and source before incorporating them into an assumption.
Keep a short exception log with the unit, field, source reviewed, discrepancy, and follow-up needed. A practical entry might say: “Unit 204, lease end date differs between rent roll and signed renewal; renewal document requested; do not use assumed expiry yet.” This is more useful than silently editing the spreadsheet because it lets another person understand what remains unresolved.
How should you document a review?
Separate source data from reviewer adjustments. Preserve the value as received, the corrected or normalized value, the reason for the change, and the reviewer or date. This makes it possible to distinguish a correction to a transcription from an underwriting assumption. Avoid overwriting a source figure without leaving a trace.
Use a simple review sequence: establish the as-of date; match the inventory; define each rent and status field; trace selected records to leases or ledgers; recompute totals; then resolve or list exceptions. For a larger file, prioritize items that could change occupancy, rent, lease timing, or recurring income. A reviewer can expand the sample when errors cluster around a source file, unit type, or data-entry pattern.
Before relying on a summary, check that formulas include the correct rows and exclude headers, subtotals, and duplicate units. Confirm that monthly and annual figures are not added together. Keep base rent, concessions, and additional recurring charges visible as separate concepts, then show how any derived effective-rent figure was calculated.
How does the rent roll fit into an underwriting review?
Use the rent roll as one input, not as a complete statement of property performance. A reviewer can organize unit-level information, identify questions, and build assumptions only after checking the available source material. A one-page flyer may be an initial starting point, while an offering memorandum, rent roll, and T-12 can provide additional context. The documents still need to be reviewed against one another.
For teams handling these files, Slung describes a workflow in which deal documents are forwarded or uploaded, extracted figures are reviewed, assumptions are adjusted, and an editable Excel model is produced. Users remain responsible for checking classifications, unit mix, and figures against source documents. Evaluations can be inaccurate and are not professional financial, tax, investment, or accounting advice.
To explore that workflow, review Slung’s multifamily underwriting product. If your team is considering a custom AI workflow for its own documents and processes, learn about Slung Enterprise implementation; that is a separate, scoped conversation.
Frequently asked questions
Is a rent roll the same as a lease abstract?
No. A rent roll is a property-level view of units and rental details. A lease abstract summarizes selected terms from an individual lease. A rent roll may contain dates and rent fields, but it does not replace reading the lease when a term needs verification.
Should vacant units have zero rent?
Not automatically. A vacant unit may have an asking or market rent, but that is different from current contractual rent. Label each figure clearly and avoid entering an estimated amount as though a tenant were paying it.
Can automated extraction be used without review?
No. Extraction can help organize information, but a reviewer should verify values and classifications against source documents, especially when files are scanned, handwritten, inconsistent, or unclear.
A rent roll template is most useful when it makes sources, definitions, and exceptions visible, so underwriting decisions begin with data that a reviewer can trace and question.
