How do I get one dashboard that shows my whole property management portfolio?
Short answer: A property management dashboard is one screen that shows your key numbers (occupancy, late rent, expiring leases, open work orders, income against last month) across every property, so you do not open ten reports to find out how the business is doing. You have four routes: the dashboard built into your software, a spreadsheet, a business intelligence tool such as Power BI (Microsoft's tool for charts and dashboards), or a custom dashboard that reads from your software's data. Pick by how many people need the view and how often the numbers must refresh.
You run properties from a property management system plus a few spreadsheets, and you want one place that shows the whole portfolio without a Monday morning of copying numbers.
I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.
Almost every property management system has some kind of dashboard. The trouble starts when your picture of the business lives in more than one place: rent in the system, maintenance in a vendor tool, leasing leads in email, budget in a spreadsheet. This page covers what to put on the dashboard, the four ways to build it, what each costs as of November 2026, and how to get data out of AppFolio, Buildium and DoorLoop.
What the dashboard should show
Resist the urge to show everything. Six to eight tiles is plenty. My starting set:
- Occupancy, as occupied units out of total, per property and overall.
- Rent collected so far this month against rent billed.
- Delinquency: the number of tenants and dollars past due.
- Leases expiring in the next 30, 60 and 90 days.
- Open work orders (maintenance requests), with a count older than 30 days.
- Vacant units and days vacant.
- Owner approvals waiting, meaning repairs or expenses an owner has not signed off.
- Income against last month.
The numbers and their formulas are in property management KPIs. The idea of a dashboard as a working tool, not a wall chart, is in our KPI dashboard guide.
The four routes compared
| Route | Cost as of November 2026 | Refresh | Best when |
|---|---|---|---|
| Dashboard inside your software | Included, or on a higher plan | Live | All your data is already in one system |
| Excel or Google Sheets | Free to low | By hand or scheduled paste | Under about 50 doors, one person reads it |
| Power BI | Free account with Desktop, Pro $14 per user per month billed yearly | Scheduled | You have someone who can set up data connections |
| Custom live dashboard | Quote based | Live or near live | Many properties, several data sources, owners or staff need logins |
Route 1: the dashboard in your software
AppFolio, cloud property management software, lists Advanced Data Analysis on its Plus plan at $3.20 per unit per month, with minimum spend and units that apply (contact AppFolio for the amounts). Buildium, a similar tool, describes an Analytics Hub for tracking KPIs with industry benchmarks. Its Growth plan starts at $202 a month and Premium at $420 a month. Check both pricing pages for the current plan and what it includes.
Start here. If your system already shows what you need, you are done. The limit is that it only shows what is in that system. It will not know your budget sheet or your vendor invoices from another tool. If growth is the goal, see how to grow a property management company.
Route 2: Excel or Google Sheets
Excel is Microsoft's spreadsheet program. A sheet works for a small portfolio: export the rent roll and the open work order list on the first of the week, paste them into a tab, and let formulas fill the summary. It is cheap and you control it. It breaks when the person who built it leaves, when two people edit at once, or when you grow past what one person can paste by hand. There is a walkthrough in turning a spreadsheet into a dashboard.
Route 3: Power BI
Power BI is built for combining data from several sources and drawing charts. Microsoft's page shows a free account that lets you create reports with Power BI Desktop, and Power BI Pro at $14.00 per user per month, billed yearly (as of November 2026; prices can vary by country, so check Microsoft's page). Microsoft's page says you need Pro or Premium to share reports, and its licensing notes say what viewers need, so check them. If five staff each needed a Pro license, that would be about $70 a month in licenses, plus whatever it costs to set up.
The setup is the real cost. Power BI needs a way to get your property data in. That is a data connection, and it is not a button you click in AppFolio or Buildium. Plan for someone to build it and look after it when the vendor changes a report. Google also has Looker Studio, a reporting tool that reads from sheets and other sources; check Google's page for its current terms.
Getting data out of your system
Whatever tool draws the dashboard, it needs data. Here is what each vendor says, as of November 2026.
- AppFolio: the pricing page lists AppFolio API (read only) on Plus and AppFolio API (read and write) on Max. API means a way for another program to ask the system for data. Its accounting page also describes export functionality so you can organize your data outside AppFolio.
- Buildium: the Open API is named on the Premium plan, starting at $420 a month. Its Marketplace of ready-made integrations is separate.
- DoorLoop: property management software priced per unit. Its pricing page lists full API access with the One plan, which starts at $2.50 per unit per month on yearly billing ($3.00 monthly), with minimums that apply.
Notice what that means. The plan you are on may decide whether a live dashboard is possible. Ask before you sign, or before you plan a dashboard project.
Route 4: a custom live dashboard
A custom dashboard is a small web app that reads from your system's API or exports, combines it with your other data, and shows it to whoever you log in. It can have different views for you, your leasing agent and each owner. Because it is yours, it does not change when a vendor redesigns a screen. The tradeoff is cost and the need for someone to keep it running. This is where I do work: a spreadsheet that has outgrown itself can become a proper app, as described in Excel to web app, and the same thinking applies to internal tools generally.
Who sees what
Decide the audience before the layout. You need the whole portfolio. A leasing agent needs vacancies and showings. A maintenance coordinator needs the work order list. An owner needs only their own properties, with money first. One dashboard with different views by login is better than four separate files, and it keeps owners away from numbers about other owners, which matters for privacy.
How to build your first version in a week
- Write down the six questions you ask every Monday. Those are your tiles.
- Find where each answer lives. Which report in which system?
- Export and paste into a sheet for four weeks. Notice what you check twice and what you never look at.
- Cut the tiles nobody used.
- Check the data route. Does your plan include an API or scheduled export?
- Only then pick the tool: stay in the sheet, move to Power BI, or build custom.
Mistakes I see
- Building the dashboard before agreeing on definitions. If "occupied" means leased in one report and move-in done in another, the tile will fight with the owner's statement.
- Too many charts, no thresholds. Red and green beats a trend line nobody reads.
- Giving owners access to the internal view. Owners need a different, cleaner page. See the owner report template.
- Forgetting who maintains it.
How I'd approach this
If you have fewer than 100 doors and one system, use the dashboard that comes with it and a sheet for anything else. Spend nothing more until you feel the pain.
If you have several systems, multiple staff and owners who ask for their own view, a live dashboard starts to earn its cost. At that point check your plan's API first, because that decides what is possible. Then ask for a first version that does only the eight tiles above. A dashboard that is small and trusted beats one that is large and ignored.
Questions people ask
What is the best property management dashboard software?
Usually the dashboard in the software you already run, plus something extra for the gaps. If your numbers sit in several places, Power BI or a custom dashboard works better than Excel. Pick based on doors managed and who needs to see the numbers.
What KPIs should a property management dashboard show?
Occupancy, rent collected against billed, delinquency, leases expiring, open work orders, vacant units and income against last month. Formulas are in property management KPIs.
Can Power BI connect to AppFolio or Buildium?
Both vendors offer ways to get data out: AppFolio lists a read only API on Plus and a read and write API on Max, and Buildium names its Open API on Premium. Neither vendor's pages describe a ready-made Power BI connection, so plan for setup work.
How much does Power BI cost?
As of November 2026 Microsoft's page shows a free account that lets you create reports with Power BI Desktop, and Power BI Pro at $14.00 per user per month billed yearly. Prices can differ by region, so check Microsoft's pricing page.
Is a custom dashboard better than Excel?
It is better once several people need live numbers or you combine more than one data source. For one person and one system, Excel is cheaper. See Excel to web app for when to switch.
More in this topic: US property management: reports and owner statements (9 guides) →