Rental Property Tracker (Pro) — Google Sheets + Excel with Rent Roll, Net Cash Flow, Occupancy & Gross Yield
Advanced rental property tracker for Google Sheets & Excel. A portfolio view with equity and gross yield, a rent roll with occupancy and lease-renewal flags, income and expense logs that roll up into net cash flow per property, and a tax-deductible expense total. 7 connected tabs, live formulas.
Run your rentals like a business — and know your cash flow, occupancy and equity at any moment. A complete tracker for landlords and real-estate investors: hold your whole portfolio in one place, keep a live rent roll, log every rupee in and out, and see net cash flow and gross yield per property. Works in Google Sheets and Excel.
7 connected tabs:
- Dashboard — monthly rent roll, occupancy rate, net cash flow, portfolio equity and value, vacant units, leases renewing soon, income-vs-expense by property and an expense breakdown, with charts.
- Properties — value, mortgage and equity per property, plus units, occupancy, monthly rent and gross yield calculated from the rent roll.
- Rent Roll — one row per unit with tenant, lease dates, rent and deposit; occupancy and days-to-renewal flag automatically.
- Income & Expenses — log rent and every cost by property, marking what's tax-deductible for easy year-end totals.
Property types and expense categories are editable on the Lists tab; the dropdowns follow. Every number is a live formula, verified error-free in Excel. Delivered as an .xlsx: open in Excel, or import to Google Sheets via File ▸ Import ▸ Replace spreadsheet.
- Complete Real Estate CRM (duplicate to your Notion workspace)
- 7 connected databases: Deals, Contacts, Listings, Showings, Tasks, Commissions, SOI
- Pre-built dashboards: Daily Command Center, Pipeline, Weekly Business Review
- Commission & GCI goal planner with split calculators
- Contract-to-close checklist with auto-calculated deadlines
- 40+ AI prompt pack (listing copy, follow-ups, social captions)
- Client-facing share views + QR open-house sign-in template
- Video walkthrough (20+ min) + written setup guide (PDF)
- Sample data you can clear in one click
This product is perfect for:
- Real estate agents & realtors (residential or commercial)
- Solo agents who want to replace an expensive CRM subscription
- Small teams & brokerages managing shared pipelines
- New agents building a repeatable listing-to-close process
- Beginners and advanced users alike
- Remote workers and digital nomads
Customer Reviews
Excellent product! Saved me so much time. Highly recommended.
This is exactly what I was looking for. Beautiful and functional.
Great value for money. Very well organized and easy to customize.