Rental Property Tracker β Leases, Rent Roll, Expenses & Repairs
π₯ Rental Property Tracker: Instant Download
Keep properties, leases, rent payments, expenses and repairs for your rentals in one workbook.
A rental property tracker in one Excel workbook: 6 working tabs plus Instructions and Disclaimer, in one file that is yours to keep.
β¨ What It Does for You
- See every property and lease, including expiring ones
- Compare rent due vs paid with late fees each month
- Tag expenses by category for tax time
- Track repair tickets with priority and status
π¦ What's Inside
- Instructions and Disclaimer: portfolio name, currency, and fiscal-year start, a 7-step how-to, a sheet map, and a plain-language disclaimer
- Properties: address, type, units, purchase date and price, mortgage balance, manager, and status (Occupied, Vacant, Rehab, Listed)
- Tenants Leases: tenant, contact, lease start and end, monthly rent, deposit, pets, and status (Active, Expiring, Notice, Ended, Vacant)
- Rent Roll: month, due date, amount due vs amount paid, late fee, and payment method for each tenant
- Expenses and Maintenance: expenses by category (repairs, insurance, management, utilities, taxes, mortgage, turnover, CapEx) with a tax tag, plus repair tickets with priority, status, vendor, and estimated cost
- Dashboard: property count, active leases, vacant units, rent collected, expenses, and open repair tickets, calculated from your tabs

π‘ Who This Is For
- DIY landlords with one or several rental units
- Small investors tracking duplexes and multi-unit buildings
- Owners who use a property manager but want their own records
π Before and After
- Before: Lease end dates buried in separate documents. After: A Tenants Leases tab with start and end dates and an Active / Expiring / Notice status
- Before: Not sure who paid in full this month. After: A Rent Roll comparing amount due vs amount paid, with late fees and payment method
- Before: Repair notes and receipts everywhere. After: An expense log by category and tax tag, plus a Maintenance ticket list with priority and status
β‘ Get Started in Minutes
- Download the .xlsx and open it in Excel or Google Sheets
- Set your portfolio on Instructions
- Add properties and leases
- Log rent, expenses and repairs
- Pick from the dropdowns as you fill it in
Organization tool only: NOT landlord/tenant, tax, or investment advice. Lease terms, deposits, and local housing laws vary; verify with professionals.
Sample data is fictional. Replace it with yours.
π Instant Access
Once you purchase, you get immediate access to your file. It is yours to keep.
Weβre a new store, but our digital tools are built to save you time, simplify your workflow, and help your business grow. Your trust matters β and every product is designed to deliver real results.
Thank you for supporting a growing brand.
β Kyle P. Herrick, Founder
βοΈ Satisfaction Guarantee
If this template doesnβt help you save time or improve your workflow, message me and Iβll make it right. Your success matters.
π¬ Need Help?
Message me anytime. Iβm here to help you get the most out of your templates. Email herrickkyle87@outlook.com.
Organize your rentals today. Click Buy Now.