Property Portfolio Dashboard in Google Sheets

The Property Portfolio Dashboard in Google Sheets tracks 4 headline KPIs across 6 interactive pages, with 15 pre-built charts and multiple slicers covering rent collection, occupancy, maintenance, and financial breakdowns, plus a Property ID record lookup. Setup takes under 10 minutes — open the PDF guide, click the Google Sheets copy link, paste your portfolio data into the Data Sheet, and every card, chart, and slicer recalculates automatically.

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI, and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

🔑 Key Features of the Property Portfolio Dashboard in Google Sheets

🏠 4 KPI Cards on the Overview Page — Total Rent Collected, Maintenance Spend, Total Records, and Avg Rent (Occupied). These four headline numbers give portfolio owners and property managers an instant read on income, repair burden, dataset size, and rent efficiency the moment the sheet opens.

📊 15 Pre-Built Charts Across 4 Analysis Pages — the dashboard renders 15 formula-driven charts spanning the Overview, Financial, Occupancy, and Maintenance pages. Every chart recalculates the instant you add or edit a row in the Data Sheet, so there is no manual chart editing or range-dragging.

🔍 Multiple Slicers for Two-Click Filtering let you move from a portfolio-wide view down to a single property type, location, or occupancy status without rebuilding a report. Built for landlords and operations teams who need different slices of the same dataset on demand.

📋 Property ID Record Lookup (Search Sheet) — select any Property ID from the dropdown and the Search Sheet instantly returns Property Name, Type, Location, Units, Tenant, Rent Amount, Payment Status, Maintenance Cost, Maintenance Type, Occupancy Status, and Lease End date, so you never scroll hundreds of rows again.

🖥️ 100% Native Google Sheets — no add-ons, no macros, no monthly fees. It opens in any browser with a Google account, shares by link, and supports several teammates editing at once. Pair it with the Real Estate Property Tracker in Google Sheets for lightweight day-to-day record keeping alongside this analytics view.

📦 What’s Inside the Property Portfolio Dashboard in Google Sheets

Page 1: Overview

The Overview page shows 4 KPI cards — Total Rent Collected, Maintenance Spend, Total Records, and Avg Rent (Occupied) — alongside charts for Occupancy by Status, Rent and Maintenance by Property Type, Revenue by Location, and Rent and Maintenance by Month. Multiple slicers filter the entire page in one click.

Page 2: Financial Analysis

The Financial page breaks income down with Rent Amount by Payment Status, Rent by Property, and Revenue by Location and Property Type — pinpointing which properties earn the most and which tenants have outstanding balances.

Page 3: Occupancy Analysis

The Occupancy page tracks Occupancy by Status, Occupancy by Property Type, Occupancy by Location, and Occupancy by Month — so you can spot vacancy patterns and plan tenant acquisition across the portfolio.

Page 4: Maintenance Analysis

The Maintenance page covers Maintenance Cost by Type, Maintenance Spend by Month, Maintenance Cost by Property, and Maintenance Cost by Location — full visibility into where the repair budget goes and which properties consume the most.

Page 5: Search Sheet

The Search Sheet is a property record lookup. Choose a Property ID from the dropdown and every detail for that property appears instantly — name, type, location, units, tenant, rent amount, payment status, maintenance cost, maintenance type, occupancy status, and lease end date.

Page 6: Data Sheet

The Data Sheet is the single input tab for the whole dashboard. Add your property records in the same column format and every card, chart, slicer, and lookup updates automatically.

📊 Property Portfolio Dashboard in Google Sheets vs. Microsoft Excel vs. Paid Property SaaS — Where This Fits

For landlords and portfolio managers who want rent, occupancy, and maintenance visibility without paying $600–$3,600 a year for enterprise SaaS, the Property Portfolio Dashboard in Google Sheets sits in the sweet spot.

👥 Who This Template Is For — and Who It’s Not For

✅ This template is built for:

• Landlords and portfolio owners managing 5–150 residential or commercial units who track rent, occupancy, and maintenance in spreadsheets
• Property managers preparing monthly or quarterly portfolio reports for owners or investors
• Real estate investors comparing rent yields, occupancy rates, and maintenance spend across properties and locations
• Small property-management firms that want owner-ready reports without paying for Buildium or AppFolio
• Facility and operations teams tracking lease-end dates and repair costs across multiple buildings

❌ This template is NOT for:

• Large operators needing tenant portals, automated rent collection, and built-in payment processing
• Enterprise teams requiring SOC 2 compliance, audit trails, and granular role-based permissions beyond Google Workspace
• Firms needing automated lease-document generation, e-signatures, and tenant-screening integrations

⚙️ How to Use the Property Portfolio Dashboard in Google Sheets

1. Open the PDF guide in your download and click the Google Sheets copy link to create your own editable copy in Google Drive.
2. Go to the Data Sheet and replace the sample property records with your own, keeping the same column order.
3. Open the Overview page to see all 4 KPI cards and charts update, then use the slicers to filter by property type, location, or occupancy status.
4. Review the Financial, Occupancy, and Maintenance pages for detailed breakdowns of rent, vacancy patterns, and repair spend.
5. Use the Search Sheet to pull a single property’s full record by selecting its Property ID.
6. Share the file by link with teammates or owners for real-time collaborative access.

💼 Real-World Use Cases

Priya owns a 35-unit residential portfolio in Pune. She uses the Property Portfolio Dashboard in Google Sheets to track monthly rent collected across four property types, flag tenants with pending payments on the Financial page, and share an occupancy summary with her investors through a single link — replacing a recurring SaaS subscription.

Daniel manages a 12-building commercial portfolio in Texas. Each month he updates 200+ rows in the Data Sheet, and the Maintenance page shows him cost by building and by repair type while the Overview cards report total rent, maintenance spend, and average occupied rent without touching a formula.

Aisha handles 9 rental properties for private owners across two cities. She duplicates the sheet per client, drops in their data, and walks owners through occupancy and maintenance trends during quarterly reviews — a one-time $9.99 purchase instead of a monthly property tool.

❓ Frequently Asked Questions

What KPIs does the Property Portfolio Dashboard in Google Sheets track?

The Property Portfolio Dashboard in Google Sheets tracks 4 headline KPIs — Total Rent Collected, Maintenance Spend, Total Records, and Avg Rent (Occupied) — plus 15 charts covering financial, occupancy, and maintenance analysis across 6 interactive pages with slicer-based filtering.

How long does setup take?

Setup takes under 10 minutes. Open the PDF guide, click the Google Sheets copy link, paste your property records into the Data Sheet, and every KPI card, chart, slicer, and the Search Sheet lookup update automatically — there are no formulas to write.

How does this compare to Buildium or AppFolio?

Buildium and AppFolio typically run $50–$300 per month with multi-week onboarding. The Property Portfolio Dashboard in Google Sheets is $9.99 one-time, sets up in minutes, and delivers the reporting layer most landlords need — without per-unit fees or contracts.

Can I customize property types, locations, and maintenance categories?

Yes. Every field in the Data Sheet is fully editable in the Property Portfolio Dashboard in Google Sheets. Add property types, rename locations, or introduce new maintenance categories and the charts and KPI cards pick up the changes automatically.

Does the dashboard work on mobile devices?

Yes. It runs in the Google Sheets app for iOS and Android, so the Property Portfolio Dashboard is viewable on tablets and phones, though a desktop browser gives the fullest view of the charts and slicers.

Can I track occupancy trends over time?

Yes. The Occupancy page includes Occupancy by Month to follow vacancy trends over time, plus Occupancy by Status, Property Type, and Location for cross-sectional analysis — all responsive to the slicer filters.

Is this a one-time payment?

Yes. The Property Portfolio Dashboard in Google Sheets is a one-time $9.99 purchase with lifetime access — no subscription, no per-user fees, and free updates whenever the template is revised.

👤 About the Author

Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PK-AnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

🏠 Property Management Dashboard in Google Sheets — the close companion view focused on day-to-day management reporting.

📊 Property Management Dashboard in Power BI — the Power BI version for organizations on Power BI Service.

🏢 REITs KPI Dashboard in Excel — investment-trust metrics like FFO, NAV, and dividend yield for fund-level analysis.

🔎 Home Inspection Dashboard in Google Sheets — track inspections and property condition alongside your portfolio.

Browse the full Google Sheets Dashboard Templates library for 200+ industry-specific dashboards.

📖 Click here to read the Detailed Blog Post

Watch the step-by-step video Demo:

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates