Track income, expenses, occupancy, and net cash flow across every unit. Auto-calculated portfolio totals, vacancy and lease-expiring callouts, per-property cash flow chart.
What's Inside
Start Here — How to add units, link Income & Expenses, and what the Dashboard shows.
Properties — One row per rentable unit. Status pills (Occupied / Vacant / Notice Given). Leases expiring within 60 days highlight yellow automatically.
Income & Expenses — Monthly rent collected and per-property mortgage / insurance / taxes / maintenance. Net Cash Flow auto-calculates per row.
Maintenance Log — Open work orders with priority and status pills, vendor, and cost.
Dashboard — Snapshot (Monthly Income, Expenses, Net Cash Flow, Occupancy, Total Units), per-property cash flow table, vacancy / expiring-lease / open-maintenance alerts, and a column chart of net cash flow by property.
Key Features
Net Cash Flow per row auto-calculated from rent − all expenses.
Occupancy rate auto-calculated from Status column across all units.
Lease expiring within 60 days highlights yellow on the Properties tab.
Vacant unit + open maintenance alerts called out on the Dashboard.
Status pills (Occupied / Vacant / Notice Given) and priority pills on Maintenance.
Currency formatting with red highlights on negative cash flow.
Sample Formulas
Here are some of the formulas powering this template:
We build custom property management systems that track payments, generate financial reports, and send lease renewal reminders — all inside Google Sheets.