Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesReal Estate & PropertyRental Property ManagementRent Roll

SpreadsheetRental Property ManagementFree

Rent Roll

Units, tenants, lease dates, rent, deposits and payment status across your portfolio.

Shown with sample data

Colour

Rent Roll

Units, tenants, lease dates, rent, deposits and payment status across your portfolio.

Occupancy
83%
Rent roll
$7,575
per month
Collected
$7,025
Arrears
$550
Rent by unit
  • House$2,350
  • 2A$1,500
  • 1A$1,450
  • 2B$1,420
  • 1B$1,380
  • Studio$975

How to use it

  1. 1Add each unit, including vacant ones.
  2. 2Enter lease dates, rent and deposit.
  3. 3Record this month’s payment as it arrives.
  4. 4Act on leases expiring within 60 days.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

The landlord’s master sheet: every unit with tenant, lease start and end, monthly rent, deposit held, this month’s payment and balance. Occupancy, rent collected and leases expiring soon are summarised automatically.

Who it’s for

  • Small landlords with 1–50 units
  • Property managers reporting to owners
  • Investors reviewing a purchase

What’s included

  • Units sheet: All units and tenants.
  • Summary by Status sheet: Monthly rent and Deposit held and the number of entries for each status, calculated from the Units sheet.

How to use it

  1. 1Add each unit, including vacant ones.
  2. 2Enter lease dates, rent and deposit.
  3. 3Record this month’s payment as it arrives.
  4. 4Act on leases expiring within 60 days.
Related searchesrent rolllandlordtenantsrental incomeproperty management

Details

Format
Spreadsheet
Category
Rental Property Management
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetRental Property ManagementFree

Rent Roll

Units, tenants, lease dates, rent, deposits and payment status across your portfolio.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Rental Property Management
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More rental property management templates

View all
Tenant Rent Ledger2 sheets

Charged

$11,250

Collected

$9,300

Outstanding

$1,950

ABCD
1DateTenantTypeDescription
2Oct 1J. Alvarez - Unit 1Rent chargeOctober rent
3Oct 1M. Chen - Unit 2Rent chargeOctober rent
4Oct 1R. Okafor - Unit 3Rent chargeOctober rent
5Oct 1S. Novak - Unit 4Rent chargeOctober rent
Ledger
SpreadsheetRental Property Management

Tenant Rent Ledger

Charges, payments and late fees for every tenant, with a balance per tenant and your collection rate.

10 min setupPreview
Rental Property Income & Expenses2 sheets

Income

$7,575

Expenses

$2,577

Net cash flow

$4,998

Net cash flow by property
$3,485
$913
$600
12 Oak Street7 Pine Court48 Elm Avenue
SpreadsheetRental Property Management

Rental Property Income & Expenses

Track rent and property expenses by category for cash flow and tax time.

10 min setupPreview
Property Maintenance Request Log2 sheets

Open jobs

2

Avg days to resolve

2.7

Repair spend

$487

ABCD
1ReportedProperty / unitIssuePriority
2Oct 212 Oak St 1BNo hot water: boiler faultEmergency
3Oct 948 Elm AveLeaking kitchen tapRoutine
4Oct 217 Pine CtWindow latch brokenUrgent
5Oct 3012 Oak St 2BMould in bathroomUrgent
Requests
SpreadsheetRental Property Management

Property Maintenance Request Log

Log tenant repair requests with priority, contractor, cost and resolution time.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ