Salon & Spa Business Spreadsheet | Appointment Book, Client Register, Stylist Commission and Profit Tracker

Saturday is fully booked, three stylists are working, and a regular from two weeks ago still hasn't paid for her color. Which clients are due back this week? What does a balayage actually keep after product and chair time? And at the end of the month — after commission, rent, supplies and towels — what did the salon really keep?

Most salon spreadsheets stop at an appointment calendar or a client list. This one runs the whole operation: your clients and their formula and color notes live in one register with rebook dates that figure themselves, every appointment moves Booked → Confirmed → Done → Paid on one book with balances that figure themselves, every service on your menu shows its true margin, stylist commission figures itself per appointment while booth rent is tracked separately, the retail shelf flags what to reorder, and everything rolls into a monthly profit-and-loss by itself. In the sample month inside, the salon takes $4,288 and keeps $409.75 of it — and two finished appointments are still owed $130, because one client never paid and one paid short. Booked is not the same as banked. The sheet knows the difference.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

THE 8 TABS

• Start Here + Dashboard — plain-English quick start, the two settings that run the whole sheet (your default commission % and your booth rent), and a live dashboard: appointments today, appointments this week, service revenue and retail sales this month, unpaid balances for work already done, unpaid / no-show count, and your top stylist by revenue

• Client Register — one row per client: preferred stylist, usual service, how often they come in weeks, last visit, a Next Due that figures itself from frequency and last visit, contact, and a notes field built for formula / color notes — so any stylist can pick up the client cold

• Appointment Book — one row per appointment: date, time, client, stylist, service, duration, price, and a status that walks the pipeline Booked → Confirmed → Done → Paid. Balance Due figures itself from Price minus Paid, and a No-Show owes nothing and flags itself

• Service Menu & Pricing — every service with its duration, price, product cost per service and chair-time cost. Margin per service and margin % figure themselves, so you reprice with the true margin in front of you

• Stylist Pay & Commission — one row per finished appointment: service revenue times that stylist's commission % is pay due, figured for you, with pay totals by stylist. Booth-rent stylists are tracked separately in their own box — their takings are their own, and their rent due, paid and balance are tracked on the same tab

• Retail Inventory — your retail shelf in one tab: product cost, retail price, stock counts, and a sales log — Sold pulls from the log by itself, On Hand, margin % and an ORDER flag figure themselves per product

• Expenses — one row per bill (rent, supplies, utilities, marketing, laundry, insurance, software) with totals by category that figure themselves

• Monthly P&L — service revenue, retail revenue, stylist pay and expenses roll into profit and profit margin by month, by itself, with the sample month's revenue split by stylist

HOW THE PIPELINE WORKS

An appointment starts as Booked, becomes Confirmed when the client locks it in, Done when the service is finished, and Paid when the money lands in full. Anything sitting at Done with a balance is work you have done and not been paid for — the Dashboard totals exactly that as your unpaid balances, and counts it together with no-shows, so the chase list is always in front of you. A No-Show is its own status: it flags itself on the book and owes nothing.

HOW COMMISSION AND BOOTH RENT WORK

Commission stylists are paid a % of the service revenue they personally complete (Done + Paid appointments only — booked work is not pay yet). Each stylist's % lives in the rates table on the Stylist Pay tab and starts at Maya R. 50%, Sofia L. 55%, Jordan T. 45%; the workbook default on Start Here is 50% for anyone new. Booth-rent stylists are tracked separately: the sample booth stylist keeps his own takings and pays $800/month booth rent, so his appointments never count as salon revenue and he never appears in the commission log. Salon service revenue — on the Dashboard and in the P&L — counts the commission stylists only.

HOW SERVICE MARGINS ARE FIGURED — ONE METHOD, NO HIDDEN MATH

Margin per service = Price − Product Cost per service − Chair-Time Cost (the chair, laundry, utilities and wear for the minutes the service takes). Margin % = Margin ÷ Price. On the sample menu the Balayage keeps $162 of its $220 price (73.64%) after $28 of product and $30 of chair time. A service with a thin margin is not automatically a bad service: check its duration too, because a 15-minute Brow Wax at $21 margin can out-earn a long service per hour.

THE SAMPLE MONTH

It comes loaded with one fictional month (Velvet Chair Salon & Spa, October 2026 — 12 clients, 50 appointments, 4 stylists: three on commission, one renting a booth) so you can watch every formula work before you delete the samples and type your own: Maya R. tops the month at $1,745 of revenue and $872.50 of commission pay, two finished appointments are still owed $130, one client no-showed, Gel Polish Sets and Dry Shampoo sit at ORDER on the retail shelf, and October closes at $4,288 revenue and $409.75 profit (9.56%). Formulas are pre-filled down the columns — 30 register rows, 60 appointment rows, 40 pay rows, ready to go.

FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.

REQUIREMENTS: a free Google account. Your manager lives in Google Sheets — nothing to install, and the day's book is right there on your phone between clients.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.