Healthcare teams often review appointments, revenue, departments, patient mix, wait time and satisfaction from different exports or disconnected tabs. The Healthcare Management Dashboard in Google Sheets brings those operating signals into one editable file: a Dashboard page, four analysis pages (Appointments, Departments, Revenue Report and Patients), an Appointment ID search sheet, an Instructions tab and a structured Data sheet for new records.
Every analysis page has its own row of four KPI cards, four slicers and five charts, so a clinic manager, finance analyst or department head can open the page that matches their question and filter it in a couple of clicks. Because the template runs in Google Sheets, you can make a browser-based copy and share it with authorised team members through Google Drive permissions.
🎥 Watch the Video Tutorial
Get the Healthcare Management Dashboard
Key Features of the Healthcare Management Dashboard in Google Sheets
- KPI cards on every page: the Dashboard page shows Total Revenue, Total Appointments, New Patients and Avg Satisfaction; each analysis page adds its own four cards (listed in the table below).
- Five charts per page: revenue by service, monthly appointments for new vs repeat patients, doctor workload, wait time, department revenue, payment method, age group, city, gender and satisfaction trends.
- Page-level slicers: each page has four slicers (for example Year, Month, Department and Patient Type on the Dashboard) that filter every chart and pivot on that page.
- Appointment ID lookup: the Search sheet loads a full appointment record from a dropdown, without scrolling through raw data.
- Structured Data sheet: one row per appointment with dropdowns for fields such as Gender, Age Group, Patient Type, Department, Service, Doctor, City, Visit Status and Payment Method.
KPI Cards on Each Page
The table below lists the cards exactly as they appear in the template, with the sample values from the screenshots so you can see how they relate to each other.
| Page | KPI cards | How the sample values fit together |
|---|---|---|
| Dashboard | Total Revenue, Total Appointments, New Patients, Avg Satisfaction | $319,210 revenue from 500 appointments; 184 new patients; 3.5 average rating |
| Appointments | Total Appointments, Completed Visits, Cancel + No-Show Rate, Avg Wait Time | 391 completed ÷ 500 = 78% completion rate; cancel + no-show rate 12.4% (lower is better); 29 min wait against a 20-minute target |
| Departments | Total Revenue, Active Departments, Avg Revenue / Visit, Avg Satisfaction | 8 active departments across all services; Avg Revenue / Visit shows $692 and Avg Satisfaction 3.5 |
| Revenue Report | Total Revenue, Insurance Revenue, Self-Pay Revenue, Avg Bill Value | $127,950 insurance + $191,260 self-pay (cash, card, online) = $319,210; insurance is 40% of total; Avg Bill Value $692 |
| Patients | Total Patient Visits, New Patients, Repeat Patient %, Female Patients | 184 new ÷ 500 visits = 37%; repeat share 63.2%; female share 53.6% |
Dashboard Pages Explained
The workbook follows the way healthcare managers usually review performance: a high-level Dashboard first, then appointment operations, department analysis, revenue reporting, patient analysis, record lookup and source data.
1. Dashboard Page
The Dashboard page shows Total Revenue, Total Appointments, New Patients and Avg Satisfaction at the top, with slicers for Year, Month, Department and Patient Type.
- Top Services by Revenue: ranks services such as Surgery, Health Checkup, Scan / Imaging and Emergency Care by revenue.
- Monthly Appointments — New vs Repeat: compares monthly demand from new and repeat patients.
- Patient Volume by Department: shows activity across Cardiology, Dental, Dermatology, General Medicine, Gynecology, Neurology, Orthopedics and Pediatrics.
- Revenue Trend by Month: tracks revenue month by month to show seasonality and weak periods.
- Patient Satisfaction by Month: shows the average rating for each month.
2. Appointments
The Appointments page focuses on volume, visit status, doctor workload and wait time. Its slicers are Month, Department, Visit Status and Doctor. Visit statuses in the sample data are Completed, Cancelled, No-Show and Rescheduled.
- Appointments by Month & Status: a stacked monthly view of the four visit statuses.
- Visit Status Mix: the overall share of each status.
- Appointments by Doctor: compares appointment counts across the doctors in the data.
- Avg Wait Time by Month (Minutes): tracks patient waiting time against the target.
- Appointments by Department: highlights the busiest departments.
3. Departments
The Departments page is built for service-line leaders, with slicers for Year, Month, Department and Service.
- Revenue by Department: ranks departments by revenue.
- Revenue vs Appointments by Department: shows whether high-volume departments are also high-revenue departments.
- Service Mix — Appointment Share: shows how appointments split across services.
- Avg Satisfaction by Department: compares patient ratings by department.
- Monthly Revenue by Department: tracks each department’s revenue over time.
4. Revenue Report
The Revenue Report is for billing and finance review, with slicers for Year, Month, Payment Method and Department. Payment methods in the sample data are Card, Cash, Insurance and Online.
- Revenue Trend by Month: the monthly revenue line.
- Revenue by Payment Method: the share of revenue collected through each method.
- Revenue by Service: ranks services by revenue.
- Revenue by Age Group: splits revenue across 0-17, 18-35, 36-50, 51-65 and 65+.
- Monthly Revenue by Payment Method: shows whether the payment mix is changing over time.
5. Patients
The Patients page focuses on patient mix and experience, with slicers for Month, Gender, Age Group and Patient Type.
- New vs Repeat Patients by Month: acquisition and retention side by side.
- Patients by Age Group: the age distribution behind service demand.
- Patients by City: where patients come from (Chicago, Dallas, Houston, Los Angeles, Miami, New York, Phoenix and Seattle in the sample).
- Gender Mix: female and male share.
- Avg Satisfaction by Age Group: spots experience differences between patient segments.
6. Search Sheet
Pick an Appointment ID from the dropdown and the full record appears: Date, Patient Name, Gender, Age Group, Patient Type, Department, Service, Doctor, City, Visit Status, Payment Method, Revenue, Wait Time, Satisfaction, Month and Year. The dropdown grows automatically as you add rows to the Data sheet.
7. Data Sheet
The Data sheet is the input layer. Its columns are Appointment ID, Date, Month, Year, Patient Name, Gender, Age Group, Patient Type, Department, Service, Doctor, City, Visit Status, Payment Method, Revenue, Wait Time (Min), Satisfaction and Count. Add new appointments in the same format so the KPI cards, charts, slicers and Search sheet keep working.
How to Use It With Your Own Data
- Make your own copy of the file in Google Drive.
- Read the Instructions tab, then clear the sample rows on the Data sheet.
- Paste or type your appointment records, keeping the same column order and using the dropdown values for status, department, service and payment method.
- Open the Dashboard page and check that the KPI cards match a total you already know (for example last month’s revenue).
- Use the slicers on each page to answer specific questions, then reset them before sharing the file.
Google Sheets vs Excel vs Paid Healthcare Software
| Feature | This Google Sheets dashboard | Excel dashboard | Paid healthcare SaaS |
|---|---|---|---|
| Cost | One-time template purchase | Template cost plus Excel access | Monthly or annual subscription |
| Platform | Google Sheets in the browser | Excel desktop or web | Vendor-hosted cloud app |
| Setup | Make a copy and replace sample data | Open workbook, replace data, refresh | Implementation and onboarding |
| Team collaboration | Built into Google Drive sharing | Needs OneDrive or SharePoint | Usually included by plan |
| Customisation | Fully editable | Fully editable | Limited by vendor setup |
| Appointment ID lookup | Included | Possible with formulas | Depends on the system |
| Best fit | Fast internal reporting | Offline reporting | System-of-record workflows |
Who Should Use This Template
The template suits clinic managers, healthcare administrators, department heads, practice managers, finance analysts and consultants who need a clean reporting layer for appointments and revenue. It is especially helpful when a team already exports data from another system and wants a shareable dashboard before investing in a full BI rollout.
It is not a replacement for an EHR, EMR, billing system, patient portal or compliance platform. Use patient data only in line with your organisation’s privacy and access-control policies.
Real-World Use Cases
- Clinic operations manager: reviews completed visits, the cancel + no-show rate, wait time and doctor workload before the weekly staffing meeting.
- Healthcare finance analyst: compares insurance and self-pay revenue, revenue by service and the monthly payment-method mix.
- Department head: uses Revenue vs Appointments and Avg Satisfaction by Department to prepare service-line updates.
- Healthcare consultant: builds a quick reporting layer for a client that exports appointment records but does not need a custom dashboard project yet.
Advantages and Limitations
Speed: you can replace the sample appointments and start reviewing performance without building formulas and charts from scratch. Collaboration: authorised users work from the same file. Focus: the pages stick to revenue, appointments, patients, departments, services, doctors, wait time and satisfaction.
Because it is a spreadsheet, it depends on clean input. Inconsistent department names, missing Appointment IDs, duplicate rows or changed column headers will affect the charts. Teams with larger analytics needs may later want automated imports, Power BI reporting or direct integration with operational systems.
Best Practices
- Keep the Data sheet column structure unchanged.
- Use the dropdown values for doctors, departments, services, cities, payment methods and visit statuses.
- Review the Dashboard page first, then use the detailed pages to explain what changed.
- Use the Search sheet for individual records, not for broad performance analysis.
- Limit access to authorised users and avoid storing unnecessary sensitive data in the sheet.
If you want to build dashboards like this yourself, the Excel Pivot Tables & Dashboards course on NextGenTemplates Academy walks through pivots, slicers and chart layout step by step.
Related Healthcare Dashboards
For other views of healthcare data, see the Healthcare Services Dashboard in Google Sheets, the Medical Practice Dashboard in Google Sheets and the Hospital Patient Flow Dashboard in Google Sheets. If you prefer a KPI-style layout with targets, the Healthcare KPI Dashboard in Google Sheets and the Hospital Operations KPI Dashboard are good companions.
Related templates: Healthcare & Hospital Management Bundle.
Frequently Asked Questions
What does the Healthcare Management Dashboard in Google Sheets include?
It includes a Dashboard page, Appointments, Departments, Revenue Report and Patients pages, a Search sheet for Appointment ID lookup, an Instructions tab and a Data sheet. Each analysis page has four KPI cards, four slicers and five charts.
Can I use my own appointment data?
Yes. Replace the sample records on the Data sheet using the same column order and dropdown values.
Does this dashboard connect directly to an EHR?
No. It is a Google Sheets template. Export or prepare your data, then add it to the Data sheet.
Can multiple team members view the dashboard?
Yes. After making your own copy, you can share it through Google Drive permissions as viewer, commenter or editor.
Is the dashboard editable?
Yes. You can edit labels, colours, formulas, charts and sheet names in your copy.
Is this a HIPAA-compliant tool?
The template alone does not guarantee HIPAA compliance. Compliance depends on your Google Workspace configuration, access controls, internal policies and data handling practices.
About the Author
Built by PK, a Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience and founder of NextGenTemplates. Every template is hand-built and tested before release.
Wrapping Up
The Healthcare Management Dashboard in Google Sheets gives healthcare teams one place to review revenue, appointments, new and repeat patients, satisfaction, departments, services, doctors, wait time and individual appointment records. It suits teams that want a fast, shareable reporting layer without a large software rollout. Make a copy, load last month’s appointments and start with the Dashboard page.
Get the Healthcare Management Dashboard
📅 Last updated: October 2026
