Landlord Rental Property Manager (Excel + Google Sheets)

Landlord spreadsheet for Excel and Google Sheets: rent roll, rent ledger, late fees, lease-end alerts, deposits, maintenance and NOI, cap rate and cash-on-cash per property.

Run your rentals from one tidy spreadsheet: rent roll, rent ledger, late fees, leases, deposits, repairs and the returns on every property. Works in Microsoft Excel and Google Sheets.

Watch the setup guide & full tour

What’s inside (14 connected tabs)

• Start Here: 6 setup steps, colour key, tab guide
• Dashboard: occupancy, rent due vs collected, outstanding, YTD NOI, leases ending, needs-attention list, 2 charts
• Setup: rent due day, grace days, late-fee rules, categories, payment methods
• Properties: up to 20 properties with occupancy, rent, NOI, cap rate and cash-on-cash
• Rent Roll: up to 100 units with tenant, lease dates, rent, deposit and lease-end flags at 90 / 60 / 30 days
• Rent Payments: your rent ledger, 1,000 rows; property and tenant fill in from the unit
• Rent Status: any month: due, paid, balance, days late and late fee per unit
• Expenses: every cost by property, unit and category
• Maintenance: requests, vendor, status, cost, days open, urgent flags
• Deposits: security deposit register
• Monthly: 12 months of income, operating costs, NOI, mortgage and cash flow
• Category Summary: the year’s costs by category and property
• Mileage: trips with a mileage amount at your own rate
• Property Report: one property, month by month

Why landlords like it

• Late fees worked out from your grace days and fee rules
• Every lease counts down and is flagged before it ends
• NOI, cap rate and cash-on-cash per property
• Formulas only: no macros, no add-ons, no subscription
• Sample data for 3 properties and 8 units, following today’s date

Included

• Landlord-Rental-Property-Manager.xlsx
• Setup Guide PDF
• Setup + full tour video

An organising tool for your own records, not tax, legal or financial advice.