Running a salon or beauty business takes real skill on two fronts. The craft itself, which most owners have mastered, and the business side, which often gets less attention than it deserves. Booth rentals, service revenue, retail product sales, stylist commissions, supply costs, and payroll all need to be tracked separately and accurately to know whether the business is truly profitable.
Dedicated salon software like Mindbody or Vagaro handles scheduling and payments well but costs hundreds of dollars a year and often more than small independent salons can justify. Excel, set up correctly, handles the financial tracking side completely. Here is how to build a system that works for a salon, barbershop, nail studio, or any other beauty business.
Average ticket, client retention, and the ratio of retail sales to service revenue are the three numbers that most directly predict a salon's long-term profitability. Tracking them consistently tells you where to focus your energy and what changes are actually moving the needle.
Your daily revenue log is the foundation of everything else. Enter totals each day directly from your POS or appointment system, broken down by service revenue, retail product sales, and tip income if you track that separately.
| Column | What to Enter |
|---|---|
| Date | The trading date |
| Day of Week | =TEXT(A2,"dddd") calculated automatically |
| Service Revenue | Total from haircuts, color, treatments, etc. |
| Retail Sales | Products sold to clients |
| Total Revenue | =Service + Retail |
| Client Count | Number of clients served |
| Average Ticket | =Total Revenue / Client Count |
| Stylist on Duty | Who worked, useful for multi-stylist salons |
| Notes | Promotions running, no-shows, weather, anything affecting the day |
In a multi-stylist salon, knowing revenue by stylist is essential for commission calculations, performance conversations, and scheduling decisions. Even in a solo operation, tracking revenue by service type tells you which services to promote and which to reconsider.
| Column | What to Enter |
|---|---|
| Date | Service date |
| Stylist | Who performed the service |
| Service Type | Cut, Color, Highlights, Treatment, Blowout, etc. |
| Service Revenue | Amount charged for the service |
| Retail Sold | Any products sold during or after the appointment |
| Commission Rate | Stylist commission percentage for this service |
| Commission Amount | =Service Revenue * Commission Rate |
Summary formulas that matter most:
Acquiring a new client costs significantly more than retaining an existing one. For salons, retention is the single biggest driver of long-term revenue stability. Tracking which clients are returning and which have gone quiet lets you be proactive about re-engagement before clients quietly move on to a competitor.
| Column | What to Enter or Formula |
|---|---|
| Client ID | Unique code for each client |
| Client Name | Full name |
| Preferred Stylist | Who they usually book with |
| Last Visit Date | Most recent appointment date |
| Days Since Visit | =TODAY() minus Last Visit Date |
| Visit Frequency | How often they typically come in, in days |
| Status | Active, At Risk, or Lapsed |
| LTM Revenue | Total spent in the last 12 months |
The Status formula flags clients automatically based on how overdue they are for their next visit:
Color, chemicals, and professional products are a significant cost for most salons and one of the most commonly undertracked. Knowing your supply cost as a percentage of service revenue tells you whether your product usage is in line with what you are charging.
| Column | What to Enter |
|---|---|
| Date | Date of purchase |
| Supplier | Who you bought from |
| Product Category | Color, Developer, Retail Stock, Tools, Sundries |
| Description | What was purchased |
| Amount | Cost paid |
| For Retail or Service | Is this for resale or internal use |
Track supply cost as a percentage of service revenue monthly:
Industry benchmarks put professional supply costs at 5-10% of service revenue for a well-run salon. Above 15% typically means either product waste, over-application, or pricing that does not adequately account for the cost of materials.
With these four sheets in place your weekly review takes about ten minutes. Daily revenue is logged. Service and stylist performance is visible. At-risk clients are flagged automatically. Supply costs are tracked against revenue benchmarks. The numbers tell you where to focus instead of leaving it to intuition.
Most salon owners who start tracking consistently report the same two things. They discover one or two service types that are significantly more profitable than others and deserve more promotion. And they find their busiest days are not always their most profitable ones once supply and labor costs are factored in.
If you would like a custom salon tracking workbook built for your specific business, with your services, your stylists, and your commission structure, that is exactly what we do at HelpMyData.
Tell us about your salon and we'll build a complete Excel system covering daily revenue, stylist performance, client retention, and supply costs. Starting at just $75.
📧 Get Started Today