Salon owners rarely lack data – the booking system has plenty. What they lack is one screen that answers whether Tuesday’s colour clients are worth more than Saturday’s cuts, which branch is quietly carrying the group, and how much revenue is walking out as no-shows. The Personal Care & Beauty Dashboard in Google Sheets is that screen: 6 pages, 16 KPI cards, 16 charts, 4 slicers per page and an appointment lookup, all built on native Google Sheets pivot tables and slicers rather than a wall of formulas. The sample file carries 500 appointments across 8 salon branches, 9 service categories and 10 specialists, and the whole thing is pre-wired for 1,000 rows. Built by PK, a Microsoft Certified Professional with 15+ years in spreadsheets and 300K+ subscribers across two YouTube channels. Your download is a PDF with a Make a copy link: one click and an editable copy is in your own Google Drive, with no add-on and no monthly fee.
Key Features of the Personal Care & Beauty Dashboard in Google Sheets
- Pivot-and-slicer architecture. Every chart reads a native pivot table parked to the right of its page. There are no hidden helper formulas, which is why the file stays quick as the appointment book grows.
- Four slicers on every analysis page. Click one and all four charts, the pivots and the sidebar Top 5 panel filter together. Slicers are per page, so filtering Salons does not disturb Services.
- Sixteen KPI cards. Four per page, chosen for the question that page answers – total revenue and average ticket value on Overview, service hours and retail per visit on Salons, premium treatment revenue and largest ticket on Services, no-show rate and unique clients on Clients.
- A sidebar on every page. Each carries a three-stat snapshot, a 12-month revenue sparkline, a Top 5 ranking, a share-of-revenue bar list, a six-row At a Glance panel and a 12-month appointment volume sparkline.
- Branch comparison built in. The Salons page ranks all eight locations on revenue, retail units, service mix and revenue share, so the quiet performer is visible without a separate report.
- Specialist performance. Revenue by Specialist ranks all ten stylists and therapists, and the Top 5 Specialists panel keeps the leaders in view while you filter.
- Membership and age analysis. Revenue by Membership Tier, Appointments by Membership Tier and Age Group Revenue vs Retail Units show which tiers and which age brackets actually buy product rather than just book services.
- Appointment status mix. Completed, Scheduled, Rescheduled and No-Show are tracked as a share, so a rising no-show rate shows up as a number rather than a feeling.
- Payment behaviour. Revenue by Payment Method splits cash, credit card, debit card, gift card, membership credit and mobile pay – useful when negotiating card fees or reviewing gift card liability.
- Appointment lookup page. Pick any Appointment ID and read the full record: date, branch, service category and type, client, membership tier, revenue, retail units, duration, specialist, payment method, status, age group, month and quarter.
What’s Inside the Personal Care & Beauty Dashboard
Six pages, linked by a navigation bar that runs across the top of every one of them.
1. Overview – group-wide performance. Total Revenue, Total Appointments, Retail Units Sold and Avg Ticket Value across all salons and services, with Monthly Revenue Trend, Revenue by Service Category, Revenue by Membership Tier and Salon Revenue vs Appointments. The sidebar adds completion rate, retail per visit, chair hours and the top five salons by revenue.
2. Salons – branch performance. Completed Visits, Service Hours, the top branch’s revenue and Retail per Visit, with Revenue vs Retail Units, Revenue by Salon & Service Type, Monthly Retail Units and Appointments by Status. The sidebar carries average service minutes, revenue per hour, no-show rate and each branch’s share of group revenue.
3. Services – service, category and specialist performance. Premium Treatment Revenue, Bridal & Event Jobs, Hair Colour Revenue and Largest Ticket, with Revenue by Service Type, Category Revenue vs Appointments, Revenue by Specialist and Retail Units by Age Group. This is the page that tells you which categories earn per hour rather than just per booking.
4. Clients – membership tiers, age groups and payment behaviour. Platinum Revenue, Gold Appointments, Unique Clients and No-Show Rate, with Appointments by Membership Tier, Age Group Revenue vs Retail Units, Revenue by Payment Method and Monthly Appointment Volume.
5. Search – appointment lookup. Choose an Appointment ID and the page returns that booking’s full record in one clean table. This is how you settle a dispute about a single visit without scrolling the data sheet.
6. Instructions – a ten-point user guide. How the pivots and slicers are wired, why the KPI cards deliberately show unfiltered totals while the charts are slicer-aware, how to replace the sample data, and how to raise the row limit past 1,000 in the Apps Script file.
Behind those sits the Data sheet, holding one row per appointment with the columns the pivots expect. Replace the sample rows with your own export, keep the headers, and every page follows.
Personal Care & Beauty Dashboard vs. an Excel Report vs. Salon Software Analytics – Where This Fits
| This Google Sheets dashboard | A hand-built Excel report | Salon software reporting module | |
|---|---|---|---|
| Cost | 9.99 once | Free, plus your build time | Bundled into 50 to 200 per month |
| Platform | Google Sheets, any browser | Microsoft Excel on desktop | Vendor web app |
| Setup time | Under 30 minutes with your export | 2 to 3 days for six pages of pivots | Already there, if you use that vendor |
| Real-time team collaboration | Yes, native Google Sheets sharing | Only through OneDrive co-authoring | Per paid seat |
| Mobile access | Yes, free Google Sheets app | Limited | Yes |
| Customizable metrics | Yes – every pivot and card is editable | Yes, if you build them | No, fixed report set |
| Works across multiple booking systems | Yes – it reads a data sheet, not an API | Yes | No, only that vendor’s data |
| Share with an accountant or investor | Yes, a view-only link | Send a file | Usually needs a seat |
| Data volume | 1,000 rows out of the box, extendable | Large | Unlimited |
| Year-1 cost for a 3-branch group | 9.99 | 0 plus several days of work | 600 to 2,400 |
The honest position: if your booking software already produces reports you trust, use them. This dashboard earns its place when you run more than one branch, when you have changed software and your history is split across exports, or when you want metrics your vendor does not calculate – revenue per chair hour, retail attach rate per branch, revenue by age bracket.
Who This Template Is For – and Who It’s Not For
A good fit if you are: a salon or spa owner with two or more locations; a single-site owner whose booking software reports stop at revenue totals; a barbershop or beauty group tracking specialist performance and retail attach rates; a franchise manager comparing branches on the same measures; a bookkeeper or consultant producing a monthly pack for a salon client.
Not the right tool if you are: looking for a booking system – this reads appointments, it does not take them, and the Salon and Spa Management System Web App is the tool for that job; running a single chair with twenty appointments a month, where a dashboard is more machinery than the question needs; or expecting a live connection to your booking software – you export and paste, which takes a couple of minutes a week.
How to Use the Personal Care & Beauty Dashboard
- Open the PDF in your download and click the Make a copy link. Google Drive creates your own editable copy.
- Read the Instructions page first. Ten points, two minutes, and it explains why the KPI cards show unfiltered totals while the charts respond to slicers – which is the one thing people misread.
- Export your appointments from your booking system and paste them onto the Data sheet, keeping the existing column headers so the pivots, slicers and charts stay connected.
- Refresh your eyes on the Overview page. The four KPI cards and the top-five salon list will tell you within seconds whether the import landed correctly.
- Use the slicers to ask questions. Filter to one branch, one quarter or one service category and all four charts plus the sidebar move together.
- Clear a slicer by opening it and choosing Select all. Slicers are per page, so each page keeps its own view.
- Use the Search page for single bookings when a client or a specialist queries one visit.
- Going past 1,000 rows? Open the Apps Script file, raise DATA_ROWS and re-run main(). Everything below that limit already works with no setup at all.
Real-World Use Cases
An eight-branch group deciding where to invest. The Salons page showed Midtown Flagship at 19.7% of group revenue against Lakeside Wellness at roughly 8%, but the revenue-per-hour figure told a different story – Lakeside’s smaller team was close to the group average on productivity and simply had fewer chair hours. The conversation moved from closing a branch to extending its opening hours.
A salon manager chasing retail attach. Retail per visit sat at 1.06 units group-wide, but Retail Units by Age Group showed young adults and 30-44s buying nearly two-thirds of all product. The manager moved the retail display and the staff briefing toward the appointment types those groups book, rather than pushing product uniformly.
An owner working out what no-shows cost. The Clients page put the no-show rate at 4.8% against an average ticket of 104. Multiplied across 500 appointments, that is a number worth a deposit policy – and it was visible in one card rather than reconstructed from a booking export. She pairs the dashboard with the Salon Appointment Data Entry System for the front-desk side.
Frequently Asked Questions
Do I need a paid Google Workspace account?
No. A free personal Google account is enough. Click the copy link in the PDF and the dashboard lands in your own Drive with the pivots, slicers and charts working.
Does it connect to my booking software?
No, and that is deliberate. You export your appointments and paste them onto the Data sheet, which means the dashboard works with any booking system – and keeps working after you switch software, which an API-based tool does not.
How many appointments can it hold?
The pivots, slicers and formulas are pre-wired for 1,000 rows, so anything up to that needs no setup. To go further, open the Apps Script file, raise the DATA_ROWS value and re-run main().
Why don’t the KPI cards change when I click a slicer?
By design. The KPI cards and the At a Glance list use SUMIFS and COUNTIFS on the Data sheet so they always show unfiltered totals – the constant you compare against. The charts, pivots and Top 5 panels are slicer-aware and do respond.Personal Care
Can I add my own salon branches, services or specialists?
Yes. They are values in your data, not hard-coded lists. Paste in your own rows and the pivots, slicers and charts pick up whatever branch, category, service type or specialist names you use.Personal Care
Can I change the colours to match my brand?
Yes. The palette lives in one block at the top of the Apps Script file – a dark ink against a bright accent, plus an amber for second chart series. Change those values and re-run the script.Personal Care
Can I share it with my accountant without giving them edit rights?
Yes. Use the normal Google Sheets Share button and give view or comment access. That is one of the practical advantages over a booking system whose reports usually need a paid seat.
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. Every template is hand-built and tested before release.Personal Care
Explore Related Templates
- Salon and Spa Dashboard in Google Sheets – a lighter single-site view of the same business.Personal Care
- Salon and Spa Dashboard in Power BI – the same analysis with Power BI’s drillthrough and tooltips.
- Salon Appointment Data Entry System in Excel – captures the bookings this dashboard reports on.Personal Care
- Beauty Products Distributor Management Tracker in Google Sheets – the product supply side.
- Salon and Spa Management System Web App – a full booking and management system.
- Browse every Google Sheets dashboard or the full Google Sheets template catalogue.Personal Care
Get Your Copy
Export last quarter’s appointments, paste them in, and look at the Salons page. Most owners find one branch or one service category doing something they had not noticed. If anything does not work as described, contact us and we will put it right.Personal Care
Watch the step-by-step video Demo:
Last updated: 12 August 2026.
Reviews
There are no reviews yet.