Real Estate Tax Calc
What a rent roll contains
A rent roll is a snapshot of a rental property's current income stream. For each unit, it typically shows: unit number, tenant name, lease start and end dates, monthly rent, security deposit amount, and current payment status (current, delinquent, month-to-month).
For multifamily and commercial properties, the rent roll is the primary document investors and lenders analyze to underwrite income. For a single-family or small multifamily, a rent roll may be as simple as a table with a few rows — but even a two-unit building should have one on file.
What the rent roll reveals
The rent roll tells you more than just current rents. Lease expiration clustering — many leases ending in the same month — creates rollover risk: if multiple tenants leave at once, you face simultaneous vacancy and re-leasing costs. Below-market rents indicate upside potential but also require a leasing strategy after acquisition.
Month-to-month tenants can be positive (flexibility to raise rents) or negative (unpredictability). Delinquencies on the rent roll signal collection issues that a P&L statement might obscure. Always request the rent roll alongside the prior 12 months of actual bank deposits to verify the income is real, not just scheduled.
Rent roll in tax reporting
For tax purposes, the rent roll helps you document the rental income you are required to report on Schedule E. It also supports the "held for investment or business use" element of the property's status, relevant to depreciation eligibility and 1031 exchange qualification.
Security deposits shown on the rent roll are generally not income when received — they are liabilities until applied or returned. Your rent roll tracks these so you know what you owe back to tenants and avoid accidentally treating deposits as income.
The columns a complete rent roll should have
A bare-bones rent roll lists unit and rent, but a genuinely useful one carries far more. At minimum, include: unit identifier, tenant name, lease start and end dates, current monthly rent, market/asking rent for that unit, security deposit held, other recurring charges (pet rent, parking, storage, utility reimbursements), concessions (free-rent months or discounts), payment status (current, days delinquent, balance owed), and square footage so you can compute rent per square foot.
For commercial and larger multifamily properties, add lease type (gross, modified gross, or triple-net), escalation or CPI clauses, renewal options, and any tenant improvement or reimbursement obligations. The more complete the columns, the fewer surprises after closing — a rent roll that hides concessions or omits delinquency is a rent roll designed to flatter the seller's income, not to inform your underwriting.
Scheduled rent vs. effective (actual) rent
The single most important distinction on any rent roll is scheduled (gross potential) rent versus effective rent actually collected. Scheduled rent assumes every unit is occupied at the stated rate with zero loss. Effective rent subtracts vacancy, concessions, and credit loss (uncollected rent from delinquent tenants). A property showing $240,000 of scheduled annual rent might only produce $210,000 of effective rent after a 7% vacancy and a couple of non-paying tenants.
Sellers naturally present the rosier scheduled figure, sometimes inflated further with above-market "pro forma" rents. Always underwrite to effective rent, and demand the trailing 12 months of actual collections to prove it. The gap between scheduled and effective rent is where overpaying happens — and where a seemingly attractive cap rate quietly evaporates.
A worked example: reading risk from the rent roll
Imagine a 6-unit building. The rent roll shows four units at $1,500, one at $1,200 (a long-term tenant well below the $1,500 market), and one vacant. Scheduled rent at market would be $9,000/month; the roll actually shows $7,200 collected. Two immediate takeaways: there is $300/month of upside in the below-market unit once that lease turns, and a vacant unit to fill.
Now look at the lease dates: four of the five leases expire in the same 60-day window next summer. That is rollover risk — if even two of those tenants leave at once, you face concurrent turnover cost and vacancy right after purchase. A savvy buyer prices that risk in, plans staggered renewals, and budgets make-ready and leasing costs. The same rent roll that looks like a clean income stream to one buyer reveals concentration risk and value-add opportunity to another.
How lenders and appraisers use the rent roll
The rent roll is not just a buyer's tool — it is central to financing and valuation. Commercial lenders use it to compute the property's net operating income and the debt service coverage ratio (DSCR), the ratio of NOI to annual debt payments that determines whether (and how much) they will lend. Most lenders want a certified rent roll and often a "rent roll and operating statement" package as a condition of the loan.
Appraisers rely on the rent roll for the income approach to value, capitalizing the property's stabilized NOI at a market cap rate. Because both the loan amount and the appraised value flow from the rent roll, an inflated or sloppy roll can derail a closing when the lender's verification comes back lower than the seller claimed. Expect the roll to be scrutinized, and make sure the version you rely on is the one the lender will accept.
Verifying a rent roll before you close
Never take a rent roll at face value. Standard due-diligence steps include: (1) estoppel certificates — signed statements from each tenant confirming their rent, deposit, lease dates, and that no side agreements exist; (2) matching the roll against actual bank deposits for the trailing 12 months, not just the seller's ledger; (3) reading the actual leases to confirm rents, escalations, and expirations; and (4) requesting a delinquency and eviction history.
A seller-certified rent roll "as of the closing date" should be a closing deliverable, and many contracts include a rent-roll representation the seller must stand behind. Discrepancies you uncover — phantom tenants, deposits that were never actually collected, concessions omitted from the roll — are legitimate grounds to renegotiate price or credits. The cost of an estoppel campaign is trivial next to the cost of buying income that does not exist.
The rent roll and your tax records
After closing, the rent roll becomes an ongoing recordkeeping tool that ties directly to your tax return. The rents it tracks are the gross rental income you report on Schedule E, and its security-deposit column keeps those tenant funds properly classified as liabilities rather than income until they are applied to unpaid rent or retained for damages — at which point they become reportable income.
A well-maintained rent roll also documents the property's status as held for the production of income, which supports depreciation eligibility and, if you later exchange the property, its qualification for 1031 treatment as investment property. Keep periodic rent-roll snapshots with your annual tax file; alongside your bank deposits and leases, they substantiate the income you report and the deposits you hold if the return is ever examined.
From rent roll to cap rate and cash flow
The rent roll is the top of the underwriting funnel — every downstream metric starts with its numbers. Take the rent roll's effective gross income, subtract operating expenses (taxes, insurance, management, maintenance, utilities, and reserves), and you have net operating income (NOI). Divide NOI by the price and you have the cap rate; layer in financing and the cash you invested and you get cash-on-cash return. A rent roll built on inflated pro-forma rents pushes an error straight through all three metrics, which is why disciplined buyers rebuild the roll from verified collections before computing anything.
A practical workflow: (1) reconstruct the rent roll from the trailing 12 months of bank deposits and current leases; (2) haircut it for realistic vacancy and credit loss; (3) build the operating statement to reach NOI; (4) test the deal at that NOI, not the seller's. When the seller's advertised cap rate uses scheduled rent and understated expenses while yours uses effective rent and full expenses, the gap between the two is precisely the negotiation — and it all traces back to how honestly the rent roll was assembled.
Frequently asked questions
What is the purpose of a rent roll?
To document current and expected rental income from a property, including unit-by-unit details on tenants, leases, and rent levels. It's the primary income verification document in a property acquisition.
How do I verify a rent roll?
Cross-check it against actual bank deposit records for the prior 12 months, copies of current leases, and a lease expiration schedule. Ask the seller to certify it as of the closing date, and collect tenant estoppel certificates confirming rent, deposits, and lease terms.
Are security deposits shown on the rent roll taxable income?
No. Security deposits held in trust are not taxable income when received. They become taxable only when applied to unpaid rent or retained for damages.
What is the difference between scheduled rent and effective rent?
Scheduled (gross potential) rent assumes 100% occupancy at stated rates. Effective rent subtracts vacancy, concessions, and uncollected (credit-loss) rent — it is what the property actually produces. Always underwrite to effective rent, and verify it against 12 months of actual collections.
Why do lenders ask for a rent roll?
Lenders use the rent roll to compute net operating income and the debt service coverage ratio, which determine loan eligibility and size. Appraisers use it for the income approach to value, so an inflated roll can cause the loan or appraisal to fall short at closing.
What is a tenant estoppel certificate?
A signed statement from each tenant confirming their current rent, security deposit, lease start and end dates, and that no undisclosed side agreements exist. Estoppels are a key tool for verifying that the rent roll reflects reality before you close.
Sources
Educational information and estimates only. Not tax advice. Tax rules change and vary by situation; consult a qualified tax professional before acting.