Download the full sample rent roll
Sample Property, 65 units. Sample data, fictional property. All 65 rows, the same columns as the table below. No real property, address or tenant.
Summary totals
Calculated from the 65 rows below. Sample data, fictional property.
- Units65 (58 occupied, 3 on notice, 3 vacant, 1 down)
- Physical occupancy93.8% = (Occupied 58 + Notice 3) / 65 units
- Scheduled rent (monthly)$81,125, the sum of Monthly Rent on occupied and notice units
- Potential market rent (monthly)$88,730, the sum of Market Rent on all 65 units
- Economic occupancy (scheduled)91.4% = scheduled rent / potential market rent. Scheduled, not collected.
- Loss-to-lease$2,165 (2.6% of occupied market rent); 47 units below market, 1 above
- Vacancy loss at market$5,440 across 4 vacant and down units
- Deposits held$40,500; occupied units with no deposit: 219
- Past-due balances7 units, $6,725 total
- Credit balances1 unit, -$125
- Leases past their end date7 units still occupied after the lease end date (month-to-month or expired)
- Expiring in the next 90 days10 units with a lease end from Oct 1 to Dec 30, 2026
- Square footage53,600 total, 825 average per unit
| Rent bridge (monthly) | Amount |
|---|---|
| Potential rent (market, all units) | $88,730.00 |
| Less vacancy loss at market (vacant and down) | -$5,440.00 |
| Less loss-to-lease (occupied and notice) | -$2,165.00 |
| Scheduled rent | $81,125.00 |
The bridge ties: $88,730.00 - $5,440.00 - $2,165.00 = $81,125.00, the sum of the Monthly Rent column.
Unit mix
Averages by unit type. In-place rent averages occupied and notice units only.
| Unit type | Units | Occupied + notice | Avg sq ft | Avg market rent | Avg in-place rent |
|---|---|---|---|---|---|
| Studio | 6 | 6 | 480 | $988 | $958 |
| 1BR | 15 | 15 | 680 | $1,208 | $1,181 |
| 1BR (large) | 12 | 10 | 720 | $1,238 | $1,201 |
| 2BR (large) | 15 | 15 | 980 | $1,528 | $1,488 |
| 2BR | 12 | 10 | 940 | $1,488 | $1,456 |
| 3BR | 5 | 5 | 1,180 | $1,806 | $1,752 |
| Total | 65 | 61 | 825 | $1,365 | $1,330 |
Rows a reconciliation would flag
Counts and units found by checking each row against the as-of date and the other columns. Sample data, fictional property.
- Vacant: 3108, 215, 304
- Down (not rentable): 1117
- On notice: 3112, 207, 318
- Lease end date before the as-of date (month-to-month or expired): 7103, 107, 209, 210, 221, 309, 310
- Past-due balance: 7105 ($1,240), 119 ($385), 202 ($2,890), 210 ($450), 213 ($160), 306 ($1,525), 315 ($75)
- Credit balance: 1220 (-$125)
- Rent above market: 1311
- Occupied with no deposit on file: 1219
Full rent roll
Sample Property, 65 units, rent roll as of 10/01/2026. Sample data, fictional property. The Check column is calculated on this page; it is not part of the file.
| Unit | Type | Sq Ft | Tenant | Lease Start | Lease End | Monthly Rent | Market Rent | Deposit | Balance | Status | Check |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 101 | Studio | 480 | Tenant 101 | 01/01/2026 | 12/31/2026 | $955.00 | $975.00 | $500.00 | $0.00 | Occupied | |
| 102 | Studio | 480 | Tenant 102 | 03/01/2026 | 02/28/2027 | $945.00 | $975.00 | $500.00 | $0.00 | Occupied | |
| 103 | 1BR | 680 | Tenant 103 | 04/01/2025 | 03/31/2026 | $1,135.00 | $1,195.00 | $600.00 | $0.00 | Occupied | lease ended |
| 104 | 1BR (large) | 720 | Tenant 104 | 07/01/2026 | 06/30/2027 | $1,225.00 | $1,225.00 | $600.00 | $0.00 | Occupied | |
| 105 | 1BR | 680 | Tenant 105 | 01/01/2026 | 12/31/2026 | $1,195.00 | $1,195.00 | $600.00 | $1,240.00 | Occupied | past due |
| 106 | 1BR (large) | 720 | Tenant 106 | 08/01/2026 | 07/31/2027 | $1,125.00 | $1,225.00 | $600.00 | $0.00 | Occupied | |
| 107 | 1BR | 680 | Tenant 107 | 10/01/2025 | 09/30/2026 | $1,195.00 | $1,195.00 | $600.00 | $0.00 | Occupied | lease ended |
| 108 | 1BR (large) | 720 | - | $0.00 | $1,225.00 | $0.00 | $0.00 | Vacant | vacant | ||
| 109 | 1BR | 680 | Tenant 109 | 05/01/2026 | 04/30/2027 | $1,160.00 | $1,195.00 | $600.00 | $0.00 | Occupied | |
| 110 | 1BR (large) | 720 | Tenant 110 | 01/01/2026 | 12/31/2026 | $1,200.00 | $1,225.00 | $600.00 | $0.00 | Occupied | |
| 111 | 1BR | 680 | Tenant 111 | 01/01/2026 | 12/31/2026 | $1,170.00 | $1,195.00 | $600.00 | $0.00 | Occupied | |
| 112 | 2BR (large) | 980 | Tenant 112 | 11/01/2025 | 10/31/2026 | $1,485.00 | $1,515.00 | $750.00 | $0.00 | Notice | notice |
| 113 | 2BR | 940 | Tenant 113 | 04/01/2026 | 03/31/2027 | $1,460.00 | $1,475.00 | $750.00 | $0.00 | Occupied | |
| 114 | 2BR (large) | 980 | Tenant 114 | 03/01/2026 | 02/28/2027 | $1,395.00 | $1,515.00 | $750.00 | $0.00 | Occupied | |
| 115 | 2BR | 940 | Tenant 115 | 01/01/2026 | 12/31/2026 | $1,460.00 | $1,475.00 | $750.00 | $0.00 | Occupied | |
| 116 | 2BR (large) | 980 | Tenant 116 | 09/01/2026 | 08/31/2027 | $1,485.00 | $1,515.00 | $750.00 | $0.00 | Occupied | |
| 117 | 2BR | 940 | - | $0.00 | $1,475.00 | $0.00 | $0.00 | Down | down | ||
| 118 | 2BR (large) | 980 | Tenant 118 | 05/01/2026 | 04/30/2027 | $1,455.00 | $1,515.00 | $750.00 | $0.00 | Occupied | |
| 119 | 2BR | 940 | Tenant 119 | 12/01/2025 | 11/30/2026 | $1,445.00 | $1,475.00 | $750.00 | $385.00 | Occupied | past due |
| 120 | 2BR (large) | 980 | Tenant 120 | 04/01/2026 | 03/31/2027 | $1,515.00 | $1,515.00 | $750.00 | $0.00 | Occupied | |
| 121 | 3BR | 1,180 | Tenant 121 | 05/01/2026 | 04/30/2027 | $1,740.00 | $1,795.00 | $900.00 | $0.00 | Occupied | |
| 122 | 3BR | 1,180 | Tenant 122 | 07/01/2026 | 06/30/2027 | $1,725.00 | $1,795.00 | $900.00 | $0.00 | Occupied | |
| 201 | Studio | 480 | Tenant 201 | 11/01/2025 | 10/31/2026 | $990.00 | $990.00 | $500.00 | $0.00 | Occupied | |
| 202 | Studio | 480 | Tenant 202 | 08/01/2026 | 07/31/2027 | $950.00 | $990.00 | $500.00 | $2,890.00 | Occupied | past due |
| 203 | 1BR | 680 | Tenant 203 | 04/01/2026 | 03/31/2027 | $1,210.00 | $1,210.00 | $600.00 | $0.00 | Occupied | |
| 204 | 1BR (large) | 720 | Tenant 204 | 04/01/2026 | 03/31/2027 | $1,240.00 | $1,240.00 | $600.00 | $0.00 | Occupied | |
| 205 | 1BR | 680 | Tenant 205 | 08/01/2026 | 07/31/2027 | $1,090.00 | $1,210.00 | $600.00 | $0.00 | Occupied | |
| 206 | 1BR (large) | 720 | Tenant 206 | 06/01/2026 | 05/31/2027 | $1,215.00 | $1,240.00 | $600.00 | $0.00 | Occupied | |
| 207 | 1BR | 680 | Tenant 207 | 12/01/2025 | 11/30/2026 | $1,210.00 | $1,210.00 | $600.00 | $0.00 | Notice | notice |
| 208 | 1BR (large) | 720 | Tenant 208 | 05/01/2026 | 04/30/2027 | $1,190.00 | $1,240.00 | $600.00 | $0.00 | Occupied | |
| 209 | 1BR | 680 | Tenant 209 | 10/01/2025 | 09/30/2026 | $1,200.00 | $1,210.00 | $600.00 | $0.00 | Occupied | lease ended |
| 210 | 1BR (large) | 720 | Tenant 210 | 07/01/2025 | 06/30/2026 | $1,165.00 | $1,240.00 | $600.00 | $450.00 | Occupied | lease ended, past due |
| 211 | 1BR | 680 | Tenant 211 | 08/01/2026 | 07/31/2027 | $1,160.00 | $1,210.00 | $600.00 | $0.00 | Occupied | |
| 212 | 2BR (large) | 980 | Tenant 212 | 12/01/2025 | 11/30/2026 | $1,470.00 | $1,530.00 | $750.00 | $0.00 | Occupied | |
| 213 | 2BR | 940 | Tenant 213 | 09/01/2026 | 08/31/2027 | $1,460.00 | $1,490.00 | $750.00 | $160.00 | Occupied | past due |
| 214 | 2BR (large) | 980 | Tenant 214 | 07/01/2026 | 06/30/2027 | $1,515.00 | $1,530.00 | $750.00 | $0.00 | Occupied | |
| 215 | 2BR | 940 | - | $0.00 | $1,490.00 | $0.00 | $0.00 | Vacant | vacant | ||
| 216 | 2BR (large) | 980 | Tenant 216 | 01/01/2026 | 12/31/2026 | $1,530.00 | $1,530.00 | $750.00 | $0.00 | Occupied | |
| 217 | 2BR | 940 | Tenant 217 | 01/01/2026 | 12/31/2026 | $1,475.00 | $1,490.00 | $750.00 | $0.00 | Occupied | |
| 218 | 2BR (large) | 980 | Tenant 218 | 01/01/2026 | 12/31/2026 | $1,410.00 | $1,530.00 | $750.00 | $0.00 | Occupied | |
| 219 | 2BR | 940 | Tenant 219 | 07/01/2026 | 06/30/2027 | $1,460.00 | $1,490.00 | $0.00 | $0.00 | Occupied | no deposit |
| 220 | 2BR (large) | 980 | Tenant 220 | 01/01/2026 | 12/31/2026 | $1,470.00 | $1,530.00 | $750.00 | -$125.00 | Occupied | credit |
| 221 | 3BR | 1,180 | Tenant 221 | 01/01/2025 | 12/31/2025 | $1,720.00 | $1,810.00 | $900.00 | $0.00 | Occupied | lease ended |
| 222 | 3BR | 1,180 | Tenant 222 | 03/01/2026 | 02/28/2027 | $1,775.00 | $1,810.00 | $900.00 | $0.00 | Occupied | |
| 301 | Studio | 480 | Tenant 301 | 07/01/2026 | 06/30/2027 | $1,000.00 | $1,000.00 | $500.00 | $0.00 | Occupied | |
| 302 | Studio | 480 | Tenant 302 | 12/01/2025 | 11/30/2026 | $910.00 | $1,000.00 | $500.00 | $0.00 | Occupied | |
| 303 | 1BR | 680 | Tenant 303 | 08/01/2026 | 07/31/2027 | $1,170.00 | $1,220.00 | $600.00 | $0.00 | Occupied | |
| 304 | 1BR (large) | 720 | - | $0.00 | $1,250.00 | $0.00 | $0.00 | Vacant | vacant | ||
| 305 | 1BR | 680 | Tenant 305 | 05/01/2026 | 04/30/2027 | $1,195.00 | $1,220.00 | $600.00 | $0.00 | Occupied | |
| 306 | 1BR (large) | 720 | Tenant 306 | 05/01/2026 | 04/30/2027 | $1,225.00 | $1,250.00 | $600.00 | $1,525.00 | Occupied | past due |
| 307 | 1BR | 680 | Tenant 307 | 06/01/2026 | 05/31/2027 | $1,220.00 | $1,220.00 | $600.00 | $0.00 | Occupied | |
| 308 | 1BR (large) | 720 | Tenant 308 | 01/01/2026 | 12/31/2026 | $1,225.00 | $1,250.00 | $600.00 | $0.00 | Occupied | |
| 309 | 1BR | 680 | Tenant 309 | 09/01/2025 | 08/31/2026 | $1,145.00 | $1,220.00 | $600.00 | $0.00 | Occupied | lease ended |
| 310 | 1BR (large) | 720 | Tenant 310 | 10/01/2025 | 09/30/2026 | $1,200.00 | $1,250.00 | $600.00 | $0.00 | Occupied | lease ended |
| 311 | 1BR | 680 | Tenant 311 | 01/01/2026 | 12/31/2026 | $1,260.00 | $1,220.00 | $600.00 | $0.00 | Occupied | above market |
| 312 | 2BR (large) | 980 | Tenant 312 | 06/01/2026 | 05/31/2027 | $1,540.00 | $1,540.00 | $750.00 | $0.00 | Occupied | |
| 313 | 2BR | 940 | Tenant 313 | 06/01/2026 | 05/31/2027 | $1,365.00 | $1,500.00 | $750.00 | $0.00 | Occupied | |
| 314 | 2BR (large) | 980 | Tenant 314 | 05/01/2026 | 04/30/2027 | $1,540.00 | $1,540.00 | $750.00 | $0.00 | Occupied | |
| 315 | 2BR | 940 | Tenant 315 | 11/01/2025 | 10/31/2026 | $1,485.00 | $1,500.00 | $750.00 | $75.00 | Occupied | past due |
| 316 | 2BR (large) | 980 | Tenant 316 | 12/01/2025 | 11/30/2026 | $1,480.00 | $1,540.00 | $750.00 | $0.00 | Occupied | |
| 317 | 2BR | 940 | Tenant 317 | 09/01/2026 | 08/31/2027 | $1,470.00 | $1,500.00 | $750.00 | $0.00 | Occupied | |
| 318 | 2BR (large) | 980 | Tenant 318 | 11/01/2025 | 10/31/2026 | $1,525.00 | $1,540.00 | $750.00 | $0.00 | Notice | notice |
| 319 | 2BR | 940 | Tenant 319 | 12/01/2025 | 11/30/2026 | $1,485.00 | $1,500.00 | $750.00 | $0.00 | Occupied | |
| 320 | 2BR (large) | 980 | Tenant 320 | 06/01/2026 | 05/31/2027 | $1,510.00 | $1,540.00 | $750.00 | $0.00 | Occupied | |
| 321 | 3BR | 1,180 | Tenant 321 | 03/01/2026 | 02/28/2027 | $1,800.00 | $1,820.00 | $900.00 | $0.00 | Occupied | |
| Total | 53,600 | $81,125.00 | $88,730.00 | $40,500.00 | $6,600.00 |
See the sample analysis of this rent roll · Back to Doorcount Roll Call. Roll Call plans are coming soon.
Doorcount products
One product set: free deal calculators, rent roll reports, a written deal analysis and a free weekly auction list.
- Doorcount Deal CheckFree deal calculators.
- Doorcount Roll CallRent roll reports, coming soon.
- Doorcount Deal MemoWritten deal analysis, within 2 business days.
- Doorcount Auction RadarFree weekly auction email.
IMPORTANT: Doorcount Roll Call reports are math calculations performed on the data you provide, for informational purposes only. They are not investment, legal, tax, lending, appraisal, or financial advice, and they are not a recommendation to buy, sell, bid on, or finance any property. If your data is wrong or incomplete, the report will be too. Questions: [email protected].
IMPORTANT DISCLAIMER: Doorcount underwriting is intentionally conservative and is provided for informational purposes only. It is not investment, legal, tax, or financial advice, and it is not a recommendation to buy, sell, bid on, or finance any property. Before making any decision, you must perform your own underwriting using multiple independent sources (including your own lender, inspector, appraiser, title company, attorney, and local market experts). Doorcount accepts no responsibility or liability for any action taken or decision made based on its underwriting or content. Doorcount is not responsible for the accuracy of this document as applied to your individual market. All figures are estimates.