Salon & Spa Business Profit Tracker

Salon & Spa Business Profit Tracker Excel with service profit per hour, stylist commission and chair rental, retail margin, operating expenses, and a full dashboard. Know what every service, stylist, and shelf actually earns — after product, pay, rent, and the monthly bills.

Built for salon and spa owners who need to know whether the chair is earning its keep — without accounting software. Price a service, pay a stylist, or stock a shelf, and the workbook shows the profit before you commit.

WHAT'S INCLUDED (6 sheets):

- Services — every service: price, product cost, time, profit per service and per hour, and how many times it was done. Service revenue, product cost, and total service profit calculate automatically, with the best service by total profit, by profit per hour, and by profit per service named.

- Stylists and Chair Rental — every stylist: services done, revenue, commission or chair rent, what the stylist takes home, and what the salon keeps. Stylist revenue comes from sheet 1 by formula, and a check row flags it if stylist services do not add up to the services sheet.

- Retail — every retail product: cost, price, margin per unit and margin percent, units sold, revenue, cost, and profit. The best product by profit and the best product by margin are named.

- Expenses — every operating cost: rent, utilities, salon supplies, insurance, marketing, booking software, laundry, cleaning, licenses and permits, and other — monthly and annual, with the largest expense named.

- Dashboard — total revenue, total costs, net profit and margin, revenue mix, best services, best stylists, best retail product, and costs by category.

- Cover and How to Use — start here. Yellow cells are the only ones you edit.

EXAMPLE DATA (2026 — replace with your own numbers):

- Services: 2,230 done, service revenue 142,030, product cost 16,946, service gross profit 125,084, average service price 63.69, service gross margin 88.1 percent.

- Best service by total profit: Women's Cut and Style, 24,780. Best profit per service: Keratin Treatment, 185.00. Best profit per hour: Eyebrow Wax and Tint, 78.00.

- Stylists: Mia, 640 services, revenue 40,761.97, 40 percent commission 16,304.79, salon keeps 24,457.18. Sofia, 580 services, revenue 36,940.54, commission 14,776.22, salon keeps 22,164.32. Ava, 520 services, revenue 33,119.10, chair rent 1,000 per month, salon keeps 12,000. Lily, 490 services, revenue 31,208.39, chair rent 900 per month, salon keeps 10,800. Commissions paid 31,081.01, chair rent income 22,800, stylist pay 72,608.49, salon keeps from services 69,421.51.

- Retail: 1,160 units sold, revenue 26,580, cost 9,455, profit 17,125, margin 64.4 percent. Best retail product by profit: Shampoo 500ml, 2,700. Best retail margin: Nail Polish, 71.4 percent.

- Operating expenses: 4,639 per month, 55,668 per year. Largest expense: Salon Rent, 33,600 per year, 60.4 percent of operating expenses.

- Dashboard example: total revenue 168,610, total costs 154,677.49, net profit 13,932.51, margin 8.3 percent. Revenue mix: services 84.2 percent, retail 15.8 percent.

HOW IT WORKS:

1. Download the Excel file instantly after purchase.

2. On sheet 1, enter each service, its price, its product cost, and how long it takes.

3. On sheet 2, enter each stylist, how many services they did, and whether they are on commission or chair rental. Check the services check row — it must read 0.

4. On sheet 3, enter each retail product and how many units sold. On sheet 4, enter each monthly bill.

5. Read the Dashboard weekly. If a service earns less per hour than the chair could earn, reprice it or replace it.

HOW THE MONEY WORKS:

Profit per service is price minus product cost. Profit per hour is profit per service divided by time in minutes, times 60. Stylist revenue is services done times the average service price from sheet 1. A commission stylist is paid a percent of their revenue; a chair-rental stylist pays monthly rent and keeps the rest of their revenue. The salon keeps the commission from commission stylists plus the rent from chair-rental stylists. Net profit is total revenue (services plus retail) minus product cost, stylist pay, retail cost, and operating expenses.

WHO IT'S FOR:

Salon and spa owners, booth and chair-rental salons, and independent stylists who want clean per-service books and a real profit number before they reprice, hire, or stock the shelf.

PLEASE NOTE:

- This is a digital download. No physical item will be shipped.

- Works in Microsoft Excel and Google Sheets (upload to Google Drive to open in Sheets).

- Example data for 2026 is included. Replace it with your own numbers.

- This is a bookkeeping and planning tool only, not tax, legal, or CPA advice.

- Due to the nature of digital downloads, refunds are not available. Message me before buying if you have a question.

Built by an accountant: B.S. Accountancy, ASU W. P. Carey, with revenue-reconciliation experience at Marriott and audit work at PwC.