Verwick
Free Templates   /   REAL ESTATE
VERWICK FREE BUSINESS SYSTEMS

Rent Roll Template

Track leases, occupancy, scheduled rent, payment collections and property-level exceptions.

Editable ExcelWorking formulasDashboard previewFree — no registration
Free Excel workbook · Instant download · No account↓ Download the Excel template

A look inside the workbook

These fictional examples illustrate the included dashboard and working sheets.

V E R W I C K  /  WORKBOOK PREVIEWEXCEL BUSINESS SYSTEM
UNITS5
OCCUPANCY80%
SCHEDULED RENT$10,125
Workbook sheetWhat's inside
Units and LeasesTenant alias, lease dates and rent
Rent PaymentsRent charges, payments and arrears
Property ScorecardOccupancy and collection by property
Lease ActionsRenewals and expiry-related work
PropertiesUnits and LeasesRent PaymentsProperty ScorecardLease Actions

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

  1. Enter each property and unit, including occupancy status and basic lease terms.
  2. Replace sample amounts and tenant aliases with your own authorized records, then log payments against scheduled rent.
  3. 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.