A rent roll for 1 to 10 units
A rent roll is the one-page answer to "what do you own and what does it bring in". Lenders, insurers and buyers ask for it. For a small landlord it is also the setup tab every other sheet reads from.
One row per door
| Door | Tenant | Rent | Due day | Lease ends | Deposit |
|---|---|---|---|---|---|
| 412 Alder St · A | Jide Okafor | $1,150 | 1 | Mar 31, 2027 | $1,150 |
| 412 Alder St · B | Rosa Delgado | $1,100 | 1 | Jan 31, 2027 | $1,100 |
| 88 Fenwick Ave | Tom and Ali Brandt | $1,650 | 1 | Month to month | |
| 1907 Larkin Rd · 1 | Kevin Marsh | $925 | 1 | Jul 31, 2027 | $925 |
| 1907 Larkin Rd · 2 | Mei Tanaka | $950 | 1 | Month to month |
Monthly scheduled rent for these 5 doors: $5,775.
Keep it the single source
Type a tenant's rent once, here. The ledger, lease list and deposit list should look it up rather than copy it, so a rent change happens in one cell.
Skip building it. Doorledger's Start here tab is this rent roll, and every other tab reads from it. The full Doorledger workbook ($29 once, no monthly fee) adds a Monday view, 24 recurring repair jobs, leases, deposits, expenses and a Year summary by Schedule E line.