Rent Roll Template: The Document Every Lender and Buyer Asks For

Rent Roll Template: The Document Every Lender and Buyer Asks For

The rent roll is the most requested document in income real estate — every refinance, every sale, every appraisal, every insurance renewal begins with "send the current rent roll" — and it is also the document most owners assemble badly, under deadline, from memory. That combination is expensive: a rent roll is read by professionals trained to find its gaps, and every field done wrong either costs credibility (the reader assumes the worst) or costs money (the reader underwrites the worst).

This guide covers the standard format, unit by unit and column by column, the residential and commercial variants, what each professional reader actually computes from the document, and the specific fields owners consistently get wrong. All figures are illustrative examples.

What a Rent Roll Is

One row per unit (or per lease, in commercial), a snapshot as of a stated date, showing who occupies what, under which lease terms, at what rent. Not a payment history, not an accounting report, not a projection — the property's current contractual income, laid out so a stranger can verify it against the leases. That last clause is the document's standard of care: in any transaction, the rent roll is audited against the actual lease files, and the drafting discipline throughout is simple — write nothing a lease audit would contradict.

The Standard Columns (Residential)

Every serious residential rent roll carries, per unit:

1. Unit identifier and unit type (bed/bath, square footage)
2. Occupancy status — occupied, vacant, or non-revenue (model, employee, down)
3. Tenant name (or an ID, when the roll circulates widely)
4. Lease start and lease end dates
5. Current contractual rent
6. Market rent for the unit type — the column that turns a list into an analysis
7. Deposit held
8. Other recurring charges — pet rent, parking, storage, utility billbacks (RUBS)
9. Concessions in effect — the free month amortized, or noted
10. Notes — month-to-month status, delinquency, pending notice

Plus a totals block: units, occupied units, physical occupancy, total scheduled rent, total market rent — and the as-of date, prominent, because an undated rent roll is a rumor.

The Commercial Variant

Commercial rolls carry the same skeleton with the lease's greater complexity: rentable square feet and rent per SF (the pricing unit), the lease structure (NNN, gross, modified — the recovery treatment that determines what the rent number even means, per the lease-structure guide), escalation terms (fixed steps, CPI), renewal and termination options with dates, recovery/expense-stop terms, and any co-tenancy or exclusivity notes for retail. The totals block adds the metric commercial readers compute first: WALT — weighted average lease term, the rent-weighted years of contractual income remaining — because a commercial property's value is, to a first approximation, its rent roll's remaining term.

What the Readers Compute

Understanding the audience explains every formatting rule. From your rows, in the first five minutes:

The lender computes in-place income for underwriting (scheduled rent × their vacancy treatment), scans lease-end dates for expiry concentration inside the loan term, and checks month-to-month share — units that can leave on thirty days' notice are underwritten differently than term leases.

The buyer computes loss-to-lease (market minus contractual, summed — the value-add thesis in one subtraction, which is why the market-rent column matters so much), reconciles the roll's scheduled rent against the T-12's collected rent (the gap is your economic vacancy, and they will find it whether or not you show it), and reads the expiry schedule as their year-one turnover forecast.

The appraiser uses contractual rents for the income approach's in-place basis, your market-rent column as a cross-check against their own comps, and the occupancy and concession data for the stabilization judgment.

The common thread: the rent roll is not read, it is computed from — which is why it must be an Excel file with real numbers in real cells, not a PDF of a screenshot, and why internal consistency (rows summing to the totals, totals reconciling to the operating statements) is the whole game.

The Fields Owners Get Wrong

Seven recurring failures, each of which a professional reader treats as information:

1. No as-of date. Instantly signals an assembled-from-memory document; every number inherits the doubt.
2. Vacant units omitted. The roll must show every unit — vacants at their market rent with status "vacant" — because a roll that only lists occupied units conceals the denominator, and readers notice denominators.
3. No market-rent column. Without it, loss-to-lease can't be computed in your favor: a buyer or appraiser will substitute their own market assumption, and it will not be your number.
4. Month-to-month coded as leased. An expired lease rolled to MTM is a different risk than a term lease; hiding it in a stale end date is the kind of misstatement a lease audit surfaces with prejudice.
5. Concessions buried. A $1,300 face rent with a free month is $1,192 effective; showing face rent without the concession note overstates income by exactly the amount the diligence process will subtract — publicly.
6. Gross and net confusion (commercial). A $14 NNN rent and a $14 gross rent are wildly different incomes; the structure column exists so the rent column has a meaning.
7. Delinquency invisible. Scheduled rent from a tenant three months in arrears is not income yet; a notes flag costs nothing and its absence, discovered later, costs credibility on every other row.

The pattern across all seven: rent rolls fail by flattery, and flattery in a document that gets audited is a loan you repay with interest at the worst moment of the negotiation.

Keeping It Current

The rent roll's operational half is maintenance, and the workable system is the one from the portfolio tracker's discipline: the roll lives as a maintained worksheet — updated at every lease event (signing, renewal, notice, move-out) rather than reconstructed on request — so that "send the current rent roll" is a five-minute export with today's date, not a weekend project with last quarter's. Owners of multiple properties keep one roll per asset feeding the portfolio layer, where the lease-expiry column doubles as the portfolio's rollover calendar.

Two habits complete the system: reconcile quarterly to collections (the roll says scheduled; the bank says collected; the gap is your real economic vacancy and you should know it before a buyer does), and version the snapshots — a dated copy at each quarter-end builds the occupancy and rent history that every future underwriting, yours or a buyer's, will want.

The Rent Roll in a Sale or Refinance Package

In a transaction, the rent roll never travels alone — it is one leg of the diligence trio, and understanding its companions explains its standard of care. The T-12 operating statements are the second leg: the roll says what income is scheduled, the statements say what was collected, and the reconciliation between them — your economic vacancy, concessions, and delinquency, quantified — is among the first analyses any buyer or lender runs. The lease files are the third: every material field on the roll (rents, dates, options, deposits) gets audited against the actual documents, and in commercial transactions the audit is formalized through estoppel certificates — tenant-signed confirmations of their lease terms — which means every rent-roll error graduates into a signed contradiction. The practical drafting rule follows: build the roll from the lease files and reconcile it to the collections before it circulates, because the diligence process will perform both checks anyway, and the only question is whether the discrepancies are found by you or presented to you.

Frequently Asked Questions

What is a rent roll? A dated, per-unit snapshot of a property's contractual income: occupancy, tenants, lease dates, current and market rents, deposits, and concessions — the document lenders, buyers, and appraisers compute a property's income position from.

What is the difference between a rent roll and a lease schedule? Largely usage: "lease schedule" tends to emphasize the term data (dates, options, escalations — the commercial reading), while "rent roll" emphasizes the income snapshot. A well-built commercial roll is both.

Should vacant units be on the rent roll? Always — listed at market rent with a vacant status. The roll's occupancy figure only means something if the denominator is complete.

Do I include month-to-month tenants? Yes, explicitly flagged as MTM with the original lease's expiry noted. It is a legitimate status and a distinct risk profile; the failure is disguising it, not having it.

What does a lender look for in a rent roll? In-place income they can verify against leases, expiry concentration inside their loan term, month-to-month share, concessions, and delinquency — plus the internal consistency (totals, T-12 reconciliation) that tells them whether to trust the rest of your file.

How often should a rent roll be updated? At every lease event, with quarterly reconciliation to collections and a dated snapshot archived each quarter. A roll maintained this way is always "current" by construction.

The Roll, Wired Into the Portfolio

The Portfolio Tracker carries a unit-level rent roll as a working tab — tenant, rent, and lease expiry across up to 30 units, with total rent and occupancy computed, sortable by expiry for the rollover calendar — feeding the per-property register and the lender summary that packages the whole portfolio's metrics as a one-page report. Fully unlocked, formula-transparent, versioned, with a documented methodology PDF; the full model catalog is in the store. And when a lease event is also a modeling event — a commercial expiry that needs downtime, TI/LC, and renewal-probability math — the roll hands off to the lease-tracking and underwriting machinery covered in the lease tracking guide.

This article is for educational purposes only and does not constitute investment, legal, or tax advice. All figures are illustrative examples. Consult qualified professionals before making investment decisions.