Home Healthcare Dashboard in Google Sheets

The Home Healthcare Dashboard in Google Sheets reports on 950 sample home visits across 6 pages, with 16 KPI cards, 18 charts and 15 slicers driven entirely by native Google Sheets pivot tables. The sample agency covers 45 patients, 14 caregivers, 6 service regions and 5 care services over the 2024 calendar year, and every pivot, slicer and formula is already stretched to 1,000 data rows. Setup takes under 10 minutes: make your copy, paste your visit log over the sample rows, done.

🌍 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 Home Healthcare Dashboard in Google Sheets

🔹 Four analysis pages, four KPI cards each. Overview reports Total Visits, Total Billed, On-Time Visit Rate and Active Patients. Patients reports Active Patients, High Acuity Visits, Readmission Rate and Avg Billed / Visit. Caregivers reports Active Caregivers, Total Travel Miles, Avg Visit (min) and Missed Visits. Services & Billing reports Total Billed, Skilled Nursing Billed, Medicare Billed and Billed per Hour.

🔹 Built on native pivot tables and slicers — no helper formulas behind the charts. Each chart reads a pivot table parked to the right of its page, so the file stays fast as the visit log grows. Fifteen slicers sit in the FILTERS strip: Month, Region, Care Service, Visit Status, Patient Acuity, Payer Type and Caregiver, applied per page.

🔹 Honest about what the cards do. The KPI cards and the AT A GLANCE lists use SUMIFS and COUNTIFS on the Data sheet, so they always show unfiltered agency totals by design. The charts, the pivots and the sidebar Top 5 panels are slicer-aware and move together. The Instructions page states this in plain words rather than hiding it.

🔹 A visit-level Search page. Type any Visit ID (the sample runs HHV-0001 upward) and the page returns that visit’s full 15-field record — date, patient, caregiver, region, care service, visit status, payer type, duration, travel miles, billed amount, acuity, readmission flag, month and quarter.

🔹 Auto-expanding to 1,000 rows, and beyond. Paste new visits anywhere up to row 1001 and every pivot, slicer, chart and formula picks them up with no re-ranging. Need more? Open the bundled Apps Script, raise the DATA_ROWS constant and re-run main().

🔹 Recolour it in one place. The build ships in a Rose / Amber scheme (ink #5A1030, accents #F5A524 and #9AD1D4, four separately coloured KPI tiles). Edit the palette at the top of the script and the whole workbook follows.

🩺 What This Template Does — and What It Deliberately Does Not Do

This is a business reporting template for a home care agency’s visit log. It summarises visits, schedule reliability, travel burden, payer mix and billed value. It is not a care-planning, scheduling, rostering, electronic visit verification, medication or safeguarding system, and it makes no clinical, diagnostic, treatment-outcome, care-quality or patient-safety judgement. “Patient Acuity” and “Readmission” are two columns you fill in yourself; the dashboard counts them, it does not assess them.

Read this before you paste real data. The Data sheet has 17 columns, and two of them hold people’s names: Patient Name (45 fictional patients in the sample) and Caregiver (14 fictional staff). The Patients page charts billed value by patient name, and the Search page prints a named patient record. There are no home addresses, postcodes, GPS coordinates, phone numbers, dates of birth, diagnoses, medications or clinical notes anywhere in the file — Region is a broad service-area label (Central Metro, East Valley, North County, Riverside, South Ridge, West Hills) and Travel Miles is a distance number, not a route or a location. But if you paste real patient names into that column, you have put identifiable health information into an ordinary Google Sheet, protected by nothing more than your Drive sharing settings. Use an internal patient code instead. Every chart, pivot and the Search lookup work identically with codes, because nothing in the build keys off a name format. There is no live connection to any EHR, billing platform or scheduling system, and no compliance certification of any kind is claimed or implied.

📦 What’s Inside the Home Healthcare Dashboard in Google Sheets

Page 1: Overview — agency-wide care delivery

Four KPI cards (Total Visits 950, Total Billed $103,479, On-Time Visit Rate 77.4%, Active Patients 45) sit under Month, Region, Care Service and Visit Status slicers. Charts are Visits Completed by Month, Payer Mix, On-Time Visit Rate %, Top Care Services by Visit Count, Travel Miles vs Visits per Caregiver, and Visit Status by Region. The sidebar carries a Care Delivery Snapshot, a 12-Month Billed Trend, Top 5 Regions by Billed, a Visit Status Mix bar list and an At a Glance panel.

Page 2: Patients — acuity, payer coverage, readmissions and billed value

KPI cards report Active Patients, High Acuity Visits, Readmission Rate and Avg Billed / Visit, filtered by Patient Acuity, Region, Payer Type and Month. Charts are Visits by Patient Acuity, Monthly Patient Visit Volume, Billed Amount by Patient, and Visits by Region & Acuity. The sidebar adds a Patient Snapshot, Top 5 Patients by Billed and a Patient Acuity Mix.

Page 3: Caregivers — visit load, travel burden and schedule reliability

KPI cards report Active Caregivers, Total Travel Miles, Avg Visit (min) and Missed Visits, filtered by Caregiver, Region, Care Service and Visit Status. Charts are Visit Status Mix, Travel Miles by Region, Monthly Travel Miles, Visits by Caregiver, and Caregiver Visits vs Avg Visit Length. The sidebar shows a Caregiver Snapshot, Top 5 Caregivers by Billed and Care Service Workload Share.

Page 4: Services & Billing — service line economics

KPI cards report Total Billed, Skilled Nursing Billed, Medicare Billed and Billed per Hour, filtered by Care Service, Payer Type and Month. Charts are Monthly Billed Amount, Billed by Care Service & Payer, and Billed Share by Care Service. The sidebar carries a Billing Snapshot, Top 5 Services by Billed and a Payer Billed Share list.

Page 5: Search — look up any visit by ID

Enter a Visit ID in the orange input cell and the Visit Details table returns the whole record, field by field, straight from the Data sheet.

Page 6: Instructions — the user guide that ships inside the file

Ten numbered notes covering the pivot-and-slicer architecture, how to clear a slicer, why the KPI cards stay unfiltered, how the auto-expand works and how to re-theme the build.

📊 Home Healthcare Dashboard in Google Sheets vs. an Excel Dashboard vs. a Paid BI Suite — Where This Fits

For a home care agency that wants its visit log summarised without paying per-seat BI licences, the Home Healthcare Dashboard in Google Sheets sits in the sweet spot.

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

✅ Built for:

• Owners and operations managers at home care or home health agencies running roughly 10-60 caregivers, who already keep a visit log in a spreadsheet
• Billing and revenue-cycle staff who need payer mix, billed-per-hour and service-line splits without exporting to another tool
• Scheduling coordinators who want missed, late and rescheduled visit counts by region and by caregiver in one place
• Franchise and multi-branch operators reporting the same numbers across up to six service regions

❌ Not for:

• Anyone looking for an EHR, care-planning, e-prescribing or electronic visit verification system — this reads a log, it does not run care
• Agencies needing HIPAA-scoped hosting, audit trails, SSO or a signed BAA; a plain Google Sheet gives you none of those
• Teams that want a live feed from their billing or scheduling platform — this is a static sheet you paste into
• Agencies past ~1,000 visits a period who are not comfortable editing one constant in an Apps Script file

⚙️ How to Use the Home Healthcare Dashboard in Google Sheets

1. Open the PDF in your download and click the Google Sheets copy link to create your own editable copy in Drive.
2. Read the Instructions page first — it explains the pivot-and-slicer architecture in ten short notes.
3. Replace an identifying column before anything else: swap Patient Name for your internal patient code.
4. Paste your visits over the sample rows on the Data sheet, keeping the 17 column headers exactly as they are.
5. Click any slicer in the FILTERS strip to filter that page’s charts, pivots and Top 5 panel together.
6. Open a slicer and choose Select all to clear it. Slicers are per page, so each page keeps its own filters.
7. Use the Search page to pull any single visit record by its Visit ID.
8. Going past 1,000 visits? Open the Apps Script file, raise DATA_ROWS and re-run main().

💼 Real-World Use Cases

Dana runs a 22-caregiver home care agency across three counties. Every Monday she opens the Caregivers page, filters Visit Status to Missed and Late, and sees which region is absorbing the reliability problem before her scheduling call — instead of reconciling three spreadsheets by hand.

Marcus handles billing for a home health group. He lives on the Services & Billing page: Billed Share by Care Service tells him which service line is carrying revenue, and Payer Billed Share shows how exposed the agency is to a single payer. His quarterly board slide is two screenshots.

Priya coordinates a six-region franchise. She uses the Overview page’s Travel Miles vs Visits per Caregiver scatter to spot the branches where staff are driving a lot for comparatively few visits, then digs into Travel Miles by Region on the Caregivers page to size the mileage cost.

❓ Frequently Asked Questions

What KPIs does the Home Healthcare Dashboard in Google Sheets track?

The Home Healthcare Dashboard in Google Sheets tracks 16 KPI cards across four pages: Total Visits, Total Billed, On-Time Visit Rate, Active Patients, High Acuity Visits, Readmission Rate, Avg Billed / Visit, Active Caregivers, Total Travel Miles, Avg Visit (min), Missed Visits, Skilled Nursing Billed, Medicare Billed and Billed per Hour.

Does this template store patient names?

Yes. The Data sheet includes a Patient Name column and a Caregiver column, filled with fictional sample names. There are no addresses, phone numbers, dates of birth, diagnoses or clinical notes. Replace Patient Name with an internal code before pasting real data — every chart and the Search lookup work exactly the same with codes.

Is the Home Healthcare Dashboard in Google Sheets HIPAA compliant?

No, and it does not claim to be. The Home Healthcare Dashboard in Google Sheets is an ordinary Google Sheets file with no hosting, encryption, audit-trail or access-control guarantees of its own. Compliance depends entirely on your own Google Workspace configuration, agreements and internal policies — not on this template.

How does this compare to a Power BI or Tableau licence?

The Home Healthcare Dashboard in Google Sheets is a $9.99 one-time purchase that opens in a browser with no licence for viewers. Power BI Pro and Tableau Creator run $14-75 per user per month and need a published data model. Choose BI when you have millions of rows; choose this when you have a visit log.

How long does setup take?

Under 10 minutes. Make your copy from the PDF link, swap Patient Name for your internal code, paste your visits over the sample rows keeping the 17 headers intact, and every pivot, chart and slicer in the Home Healthcare Dashboard in Google Sheets updates on its own.

How many visit records can it hold?

Pivots, slicers and formulas cover 1,000 data rows out of the box, and the sample fills 950 of them. To go further, open the bundled Apps Script, raise the DATA_ROWS constant and re-run main() — the whole workbook rebuilds at the new size.

Can it schedule visits or verify caregiver arrivals?

No. The Home Healthcare Dashboard in Google Sheets is a reporting template only. It has no scheduling engine, no electronic visit verification, no GPS or clock-in capture, no care plans and no medication records. It reads a visit log you maintain elsewhere and summarises it.

👤 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

Browse the full range of Google Sheets Dashboards and the wider Google Sheets template library.

Also available as: the same topic on two other platforms — Home Healthcare Dashboard in Power BI for a modelled, drillthrough version, and Home Healthcare Dashboard in Excel for the desktop build.

Different product, same subject: the Home Healthcare KPI Dashboard in Excel is a month-picker scorecard with traffic lights and trend pages, not an analytical dashboard — treat it as a companion rather than a substitute.

Pair it with the Nurse Duty Roster Calendar in Google Sheets, the Patient Follow-Up Visit Calendar in Google Sheets or the Medical Expense & Claims Tracker in Google Sheets.

📖 Click here to read the Detailed Blog Post

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

👉 YouTube.com/@NextGenTemplates

Watch the step-by-step video Demo:

📅 Last updated: September 2026