Build a commercial rent roll in a few minutes.

Weighted average lease term: the average remaining term across your leases, weighted by each lease's annual base rent, so a large tenant's expiration matters more than a kiosk's. A roll with 4.0 years of WALT has, on average, four years of contracted rent left. Lenders and buyers use it to gauge how stable the income is. This generator counts only occupied suites that have a lease end date and rent entered, and treats an expired lease as zero years left.

By area: leased square feet divided by the total rentable square feet of every suite you list, including vacant ones. A suite counts as vacant when its status is Vacant or it has no tenant name; month-to-month tenants count as occupied. The totals row also shows occupancy by unit count. Occupancy here is physical (who holds a lease), not economic, so it doesn't reflect tenants in a free-rent period or behind on payments.

Yes, as a separate column. CAM, tax, and insurance recoveries are real monthly billings to the tenant but aren't base rent; keeping them apart makes rent per square foot comparable across properties and leases, and lets a reader see how much of the income is a pass-through of operating costs.

Set the status to Month-to-month. The suite counts as occupied and its rent is included in the totals. If you leave the lease end blank, it's also left out of WALT and the 12-month expiration count, because there is no fixed term to measure. Lenders and buyers usually treat month-to-month income as less secure than income under a signed term, so it helps to say so in the notes.

Typically, for every suite: the tenant, square footage, lease start and end dates, current base rent, recoveries, scheduled increases, renewal options, and security deposits, along with vacant space and an as-of date. Many lenders ask the owner to certify the rent roll and compare it with tenant estoppel certificates, so every figure should match the signed leases and amendments.

Percentage rent, free-rent periods and abatements, security deposits, option-period rent, and future rent steps: the escalation column is a note and isn't applied to the rent. It also shows contracted rent, not what was actually collected, so it isn't a delinquency report. Add those details in the notes, or keep them in the lease records the rent roll is built from.

No. It lives in your browser's localStorage on this device only, so you can come back to it later. Clearing your browser data, using a private window, or switching devices means you won't see it. Download the CSV to keep a copy or share it. TenantPoint never sees what you enter here.

The template is a spreadsheet you fill in yourself. The generator calculates occupancy, rent per square foot, WALT, and near-term expirations as you type, and exports the finished roll to CSV. Use whichever fits how you work; the CSV opens in Excel or Google Sheets either way.