Professional Excel templates for rent tracking, maintenance logging, and lease management. Built for landlords who self-manage 5–20 units.
Pre-formatted to work with RentGuard — connect any template in under 10 minutes and get automatic alerts.
Track rent payments with the exact columns RentGuard auto-detects: Unit, Tenant, Amount, Due Date, Status. Color-coded. Summary formulas included.
Log maintenance requests with the exact columns RentGuard auto-detects: Unit, Created Date, Status, Priority, Notes. Summary tab auto-calculates.
Track lease dates, rent amounts, security deposits, and renewal status. Leases expiring within 60 days are auto-highlighted yellow. Expired leases turn red.
Track every rental expense with categories mapped to IRS Schedule E. Monthly and annual summary tabs. No more scrambling at tax time.
Plug in purchase price, rent, and expenses. Get cap rate, cash-on-cash return, NOI, and debt service coverage ratio instantly. All formulas built in.
Document every tenant interaction. Phone, email, text, in-person. Color-coded by resolution status. Never forget a follow-up.
RentGuard monitors your existing spreadsheet and sends alerts when rent is overdue or maintenance goes stale. These templates are pre-formatted — connect and get alerts in under 10 minutes.
$29/mo flat. 10-minute setup. 30 days free.
Start Free Monitoring →