Description
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.
Want your own store like this one? createdigitaltools.com runs on Hostinger WordPress hosting. Start your own shop with Hostinger, or try the no-code Hostinger Website Builder.
Affiliate links: I may earn a commission at no extra cost to you.
