Rent Roll Template
Track leases, occupancy, scheduled rent, payment collections and property-level exceptions.
A look inside the workbook
These fictional examples illustrate the included dashboard and working sheets.
| Workbook sheet | What's inside |
|---|---|
| Units and Leases | Tenant alias, lease dates and rent |
| Rent Payments | Rent charges, payments and arrears |
| Property Scorecard | Occupancy and collection by property |
| Lease Actions | Renewals and expiry-related work |
Download status: The complete Excel workbook is now available for free. ↓ Download Free Excel System (.xlsx) No account or membership is required.
Browse the Verwick template library →How to use the rent roll template
A rent roll is a property-level view of rented units and their scheduled income. This workbook goes beyond a unit list by connecting property records, lease terms, expected rent, payment tracking and renewal actions to portfolio performance metrics.
Step-by-step workbook workflow
- Enter each property and unit, including occupancy status and basic lease terms.
- Replace sample amounts and tenant aliases with your own authorized records, then log payments against scheduled rent.
- Review occupancy, outstanding collections and lease expirations as part of routine property management.
Frequently asked questions
What is the difference between a rent roll and a ledger?
A rent roll summarizes tenants, units, occupancy and expected rent. A payment ledger records charges and collections over time; both views help explain property performance.
Will this collect rent automatically?
No. It is an offline tracking workbook, not a payment gateway or property-management application. Protect tenant information appropriately.
Related: open house sign-in template. These workbooks are editable templates with fictional sample data, not live SaaS applications or substitutes for professional advice.
