A rental portfolio dashboard is one screen that shows the state of every property you own: what is occupied, what is costing you money, what is broken and what needs a decision this week. You can build one in a spreadsheet, wire one up from exports, or use software made for owners. The right choice depends on how many properties you have and how much upkeep you want to take on yourself.
This guide covers what the dashboard should show, the KPIs worth your attention, the records behind the numbers, three ways to build it, and how to keep it current and safe.
TL;DR
- A good dashboard answers a few questions at a glance: occupancy, cash flow, late rent, open repairs, debt coverage and cash on hand. It then lets you drill into one property.
- Pick five to eight metrics. A dashboard with thirty tiles gets ignored.
- Keep the records behind it (receipts, leases, warranties, insurance) in the same place. The IRS expects documentation for rental income and expenses.
- A spreadsheet works for two or three properties. Past that, scheduled reminders and a shared vendor and document list save the most time.
- Review weekly, reconcile monthly, and lock down anything containing tenant personal data.
Table of Contents
- What a rental portfolio dashboard should show at a glance
- The KPIs worth your attention
- The records that sit behind the dashboard
- Three ways to build a rental portfolio dashboard
- Perspective: why simpler wins
- Keep it current: update rhythm and reminders
- Know your vendors, not just your numbers
- Protect tenant and personal information
- Putting it together: a 60-minute setup
- Try it on your own portfolio
- FAQ
- Sources
What a rental portfolio dashboard should show at a glance
The most useful dashboards work in two layers. One is a portfolio-level health check you read in a minute. The other is a property-level view you open only when something looks off. One analysis describes this as a morning health check followed by property drill-down.
For the top layer, a guide on portfolio dashboards lists occupancy or vacancy, month-to-date net cash flow, delinquent rent, open maintenance tickets, debt coverage, portfolio equity, cash position and blended cap rate or NOI. That list suits an investor with a loan on each building. If you own a vacation home or two rentals outright, trim it.
Here is a practical starting set, with the question each tile answers:
| Tile | Question it answers | Typical source |
|---|---|---|
| Occupancy by property | Which place is empty, and for how long? | Lease or booking calendar |
| Month-to-date cash flow | Am I ahead or behind this month? | Bank and expense records |
| Late or unpaid rent | Who needs a follow-up today? | Rent payments |
| Open repairs | What is waiting on a vendor or on me? | Task list |
| Upcoming renewals and expirations | What needs a decision in 60 to 90 days? | Leases, insurance, permits |
| Cash reserves | Can I cover a roof or a furnace? | Bank balances |
| Debt coverage | Does each loan still pencil out? | Loan statements and NOI |
Notice that half of these are not financial. A portfolio fails more often from a repair nobody followed up on than from a bad spreadsheet formula.
The KPIs worth your attention
Property management firms track dozens of indicators. An owner of a handful of homes needs a few of them.
Financial KPIs
Net operating income (NOI) is rental income minus operating expenses, before loan payments. It lets you compare a duplex with a beach condo on the same footing. Delinquency tracks rent that is late. One multifamily operations guide names NOI and delinquency among the core financial KPIs.
If you carry debt, add debt service coverage. It compares NOI with your loan payments. If you are weighing how to finance the next purchase, this overview of DSCR versus business HELOC shows why per-property numbers matter when a lender looks at your portfolio.
Occupancy and leasing KPIs
The same guide lists physical and economic occupancy, average days vacant, effective rent, concessions, renewal rate, turnover rate and make-ready time. Most of this is built for large apartment operators. Three carry over well to small owners:
- Average days vacant. The gap between tenants is where most of your annual profit leaks.
- Make-ready time. How long it takes from move-out to rent-ready. It tells you whether your vendors are fast enough.
- Renewal rate. Keeping a tenant usually costs less than finding one.
For context on the market you are renting into, the Census Bureau reported a 7.6% rental vacancy rate in the third quarter of 2026. Compare your own vacancy against that national figure, but remember local markets vary widely.
Maintenance KPIs
Federal housing guidance for multifamily reviews treats preventive maintenance schedules, work-order backlogs, vacant and ready units and turnover time as information worth monitoring. You do not manage HUD properties, but the logic holds for any owner: count open work orders, how old the oldest one is, and how many repairs recur at the same address.
The records that sit behind the dashboard
A chart is only as good as the documents under it. The IRS says rental owners must keep records that support income and expenses on their returns. Deductible expenses generally need documentary evidence such as receipts, canceled checks or bills. The same page notes that ordinary and necessary expenses can include mortgage interest, property tax, advertising, maintenance, utilities and insurance, while improvements are recovered through depreciation.
So your dashboard should link, or at least point, to:
- Property basics: address, purchase details, loan terms, insurance policy and renewal date.
- Lease or booking details: term, rent, deposit, expiration.
- Warranties and manuals: appliances, HVAC, roof, water heater. You will need these at the worst possible moment.
- Vendor records: who fixed what, when, and for how much.
- Receipts and invoices: filed by property and year.
On repairs specifically, owner reporting guidance says maintenance records should include the unit or location, description of work, vendor, invoice amount and completion status. That makes it possible to spot recurring problems and confirm that a repair you paid for was the one you approved.
For a deeper look at how to file this material, see our guide to rental property maintenance schedules and recordkeeping.
Three ways to build a rental portfolio dashboard
Option 1: A spreadsheet
For two or three properties, a spreadsheet is enough. Use one tab per property with the same columns everywhere, and one summary tab that pulls from them. Consistency matters more than polish: reporting guidance for multi-building portfolios recommends the same report package across every property so comparisons are fair.
A simple build:
- List every property in one row on a summary tab.
- Add a monthly income and expense tab per property, with identical categories.
- Pull occupancy, NOI and open repairs into the summary with lookups.
- Add a column for the next date that matters (lease end, insurance renewal, filter change).
- Color the cells that need action.
The weakness is that a spreadsheet does not nudge you. It waits for you to open it.
Option 2: Exports plus a free reporting tool
If your rent and accounting data lives in other tools, you can connect it. One guide suggests scheduled CSV or Excel exports saved to a central folder and connected to Google Looker Studio, and notes that Looker Studio with Google Sheets is a free starting point. This gives you charts and trends. It also gives you a system to maintain: when an export format changes, the dashboard breaks.
Keep source data separate from the charts. If you change a number in one place, every view should update, rather than you retyping it in three tabs.
Option 3: Software built for owners
Enterprise property management platforms are built for managers who run leasing, accounting and tenant communications for hundreds of units. A self-managing owner pays for features they never open. Software made for owners starts with a different question: what do I need to see and do across my homes?
That is the gap we built Property Command Center to fill. It is a dashboard for owners and families with several homes, vacation rentals or short-term rentals, and it deliberately leaves out tenant and rent management. If you want to compare approaches, our guides to the best landlord software for owners, Notion as a property management tool and the best rental property software walk through the trade-offs.
Perspective: why simpler wins
Most owners we talk to do not have a data problem. They have a scattered-information problem. The warranty is in an email from 2022, the plumber's number is in a text thread, and the insurance renewal is on a sticky note at the other house.
We think a portfolio dashboard earns its place by answering three questions fast: what needs attention, who do I call, and where is the paper. Charts of internal rate of return are useful to an investor with twenty buildings. For a family with a lake house and two rentals, the win is knowing that nothing is quietly overdue.
That is why we focus on property status, tasks and repairs, maintenance reminders, a vendor directory and a document vault, and nothing that requires training. A dashboard you open every Monday beats a sophisticated one you open twice a year.
— Francisco
Keep it current: update rhythm and reminders
A stale dashboard is worse than none, because it creates false comfort. A rhythm that works for most small owners:
- Weekly (10 minutes): check open repairs, late payments and anything arriving this week. Close what is done.
- Monthly (30 to 45 minutes): reconcile income and expenses against bank statements, file receipts, update vacancy days.
- Quarterly: review vendors, reserves, and upcoming lease, insurance and permit dates for the next six months.
- Annually: pull the numbers you need for tax filing and review your property-level returns.
For recurring upkeep, attach each task to a date and an owner (you or a vendor), not just a description. Seasonal items such as gutters, HVAC service, smoke detector batteries and water heater flushing should repeat automatically. Short-term rental hosts need tighter cycles around turnovers and guest-facing items; we describe one approach in four cadences for short-term rental maintenance. For tracking the tasks themselves, see maintenance task tracking for small portfolios.
If you manage from a distance, a repeatable routine matters even more. Our remote home management plan breaks it into 90 days.
Know your vendors, not just your numbers
A dashboard that shows an open repair should also show who has it. Record each vendor's trade, contact details, the jobs they did, what they charged and how quickly they finished. After a year you will know which contractor is fast and which one needs three reminders. Our guide to vendor performance tracking in 90 days shows how to start.
Protect tenant and personal information
A dashboard that holds leases, IDs, screening reports or payment details holds sensitive data. The FTC's business guide gives a simple frame: take stock, scale down, lock it, pitch it and plan ahead. Applied to a rental portfolio:
- Take stock. List where tenant data lives: email, phone photos, downloads, spreadsheets.
- Scale down. Keep only what you need. If you do not need a copy of a Social Security number, do not store one.
- Lock it. Use strong unique passwords, two-factor authentication, and share access only with people who need it, such as a spouse or a bookkeeper.
- Pitch it. Delete or shred records you no longer need, once tax and legal retention periods have passed. Ask your tax preparer or attorney how long to keep each type.
- Plan ahead. Decide in advance who you would notify and what you would do if a laptop were lost.
If you want a dashboard without tenant personal data at all, keep it focused on the property side: repairs, schedules, vendors and documents such as warranties and insurance policies. That is the approach we take.
Putting it together: a 60-minute setup
- Minutes 0 to 10: list each property with address, type (long-term rental, vacation home, short-term rental) and owner of record.
- Minutes 10 to 25: add the dates that cost money when missed: insurance renewals, lease ends, annual inspections, service contracts.
- Minutes 25 to 40: add your vendors by property and trade.
- Minutes 40 to 55: gather warranties, manuals and policies into one folder or vault per property.
- Minutes 55 to 60: choose your five to eight dashboard metrics and schedule a weekly review.
For a longer walk-through, see our simple dashboard plan for managing multiple properties and our portfolio system for owners.
Try it on your own portfolio
Property Command Center brings property status, tasks, maintenance reminders, vendors and documents into one dashboard, with smart alerts across homes, vacation rentals and short-term rentals. Plans are based on the number of properties: Starter is $19 per month and Pro is $49 per month, and there is a 14-day free trial with no credit card required. See the details on the pricing page.
If you want to start by loading your contractors, the vendors page shows how the directory works.
FAQ
What is a rental portfolio dashboard?
It is a single view that pulls together the status of all your rental or second-home properties: occupancy, cash flow, repairs, upcoming dates and documents. A good one lets you start with the whole portfolio and click into one property for detail.
Can I build a rental portfolio dashboard in Excel or Google Sheets?
Yes. Use one tab per property with identical columns and a summary tab that pulls from them. It works well for a few properties. As you add more, the lack of automatic reminders and shared document storage usually becomes the pain point.
Which metrics matter most for a small owner?
Start with occupancy, month-to-date cash flow, late rent, open repairs, upcoming expirations and cash reserves. Add NOI and debt coverage if you have loans. Skip anything you would not act on.
How often should I update it?
Glance weekly, reconcile monthly, and review dates and vendors quarterly. Update repairs as they happen so the open-work count stays truthful.
How do I keep tenant information safe in a dashboard?
Store only what you need, use two-factor authentication, limit who has access, and dispose of old records properly. The FTC's guide to protecting personal information is a good checklist for small businesses, and a tax preparer can tell you how long to retain each record.
Sources
- Property management dashboard: Real-time performance (Numetix)
- Real Estate Portfolio Dashboard: A Command Center (OceanFL)
- Multifamily KPIs Every Property Manager Should Track (ResMan)
- U.S. Census Bureau, Housing Vacancies and Homeownership, Q3 2026
- HUD, Management Review for Multifamily Housing Projects
- IRS, Tips on rental real estate income, deductions and recordkeeping
- Property Management Reporting: What Landlords Should Expect (NextGen)
- Which Monthly Reports Should an Apartment Portfolio Get? (TrueDoor)
- Create an AI Property Management Dashboard 2026
- FTC, Protecting Personal Information: A Guide for Business
- DSCR vs Business HELOC (Sizzle Capital Group)