How to Track Salon Staff Commissions: A Guide

Key takeaways

• Match your tracking method to your pay structure: paper for 1-2 stylists on a flat split, a spreadsheet for tiered or sliding-scale setups up to about five staff, and software once retail commissions or booth renters enter the mix.
• Name your commission model first: flat service percentage, retail percentage, tiered, or sliding scale, because each one breaks manual tracking at a different headcount.
• Build a commission spreadsheet with one tab per pay period, a Stylists tab holding each rate, and VLOOKUP or IF formulas to calculate flat, tiered, and sliding-scale payouts.
• Keep booth renters and commission stylists as two separate lists in the same system, since rent flows in and commissions flow out.
• Keep every payout tied to a dated record with the service total, rate, amount, and pay date, and retain commission records for at least four years per IRS employment tax recordkeeping rules.

Track salon staff commissions by matching your pay structure to a tracking method: paper works for one or two stylists on a flat percentage, a spreadsheet handles tiered or sliding-scale setups up to about five staff, and salon software pays for itself once retail commissions, booth renters, or multiple services make manual math eat your evenings. This guide gives you the decision framework plus a copy-ready spreadsheet build.

How do you track salon staff commissions without losing a day to payroll?

You have three options: paper, a spreadsheet, or salon software. The right one depends on your headcount and pay structure. One commission stylist on a flat 50/50 split? Paper works.

Two to five stylists with service and retail splits? A spreadsheet. Booth renters plus commission chairs, deposits, or tiered rates? Software, because manual math is where payout disputes start.

The 60-second rule: pick the simplest method that records the service, the stylist, the amount, and the date for every job, and that you can actually keep. The IRS requires employers to keep wage records for at least four years (IRS employment tax recordkeeping), so whatever you choose has to survive that long. If you want the tracking handled alongside booking and inventory, see how the pieces fit together.

Which commission model is your salon actually running?

Before you pick paper, a spreadsheet, or software, name your pay structure. Most single-location salons run one of four.

Flat service commission

You pay a set percentage of each service, usually 40-60% for commission stylists. Tracking is simple: service dollars times the rate. If everyone sits at one number, a notebook can hold the line.

Retail commission

Stylists earn a smaller percentage, often 10-20%, on product sales they ring up. This is the model owners forget to track, because retail rides along with services in the same ticket. Separate the two lines or your payouts drift.

Tiered commission

Hit a weekly or monthly service target and the rate steps up, say 45% under $4,000 and 50% above. Tiers reward your busiest chairs but make every payout a two-step calculation.

Sliding scale commission

The rate itself varies by service type or price point, so a color job pays differently from a haircut. This is the model that breaks manual tracking first.

The four models at a glance:

• Flat service %: one rate times the service total. Rarely breaks a notebook, with 1-2 stylists.
• Retail %: two rates per ticket. Breaks once retail rides in the same ticket.
• Tiered: the rate changes at a threshold. Breaks once targets shift weekly.
• Sliding scale: the rate varies by service. Breaks once you have 3+ stylists.

Whichever model you run, write the rates down in one place before you track anything. If you use salon software like ours, check its commission settings against your structure before you commit; our current setup and any known gaps are always listed at Status | My Tech Touch.

When is a paper or notebook system good enough?

Paper works if you hit all three: fewer than 3 commission stylists, one pay structure (say, everyone on 50/50), and a weekly payout you do yourself. Write each service on the ticket, tally Friday, pay, done. A notebook also fits a two-chair barbershop where the owner is the only bookkeeper.

It breaks fast once those conditions change. Two pay structures, a booth renter, or a stylist who asks "what did I do in March?" and you are reconstructing history from memory. Deposits, rebooking bonuses, and product retail splits each add a column that paper cannot hold.

Capterra's salon software reviews found support is the single most-repeated buyer theme, alongside scheduling, payments, marketing, and staff management. Support matters more than paper versus software; if you do switch, My Tech Touch keeps commissions inside the booking record so the tally is never retyped.

How do you build a salon commission spreadsheet step by step?

Columns to set up

Open a new Google Sheet and make one tab per pay period. Set these columns across row 1: Service Date, Stylist, Client, Service, Service Price, Commission %, Commission Owed, Products Sold, Product Commission, Tips, Deposit Applied, Notes. Add a Stylist tab listing each commission stylist with their base rate and any tiered splits, so you reference rates by name instead of retyping them.

Formulas for each commission model

For a flat split, use =E2*VLOOKUP(B2,Stylists!A:B,2,FALSE) in the Commission Owed column. For tiered splits (say 40% up to $1,000 in weekly services, 50% after), use =IF(E2<=1000, E2*0.4, 1000*0.4+(E2-1000)*0.5). For product retail, multiply the Products Sold column by that stylist's product rate. Sum each column at the bottom with =SUM() filtered by stylist name, or use a pivot table grouped by Stylist.

A worked example week

Say Maria books $1,850 in services at a 45% split with $120 in retail at 15%. Her services commission is $832.50, product commission is $18, tips pass through untouchable at $210, and a $50 deposit she collected gets subtracted from what you owe her. One row per service, one summary line per stylist, payout in under ten minutes.

Where spreadsheets break

The honest limit is that a spreadsheet only knows what you type into it. If a stylist books a client through an online booking link, takes payment on the Square reader, and you forget to log it Friday night, the sheet pays her on the wrong number and you find out during the dispute, not before. That is the gap between tracking and a system: the sheet has no connection to your calendar, your register, or your inventory, so every number in it is only as current as your last manual entry. Software like My Tech Touch or Vagaro pulls those numbers straight from booked appointments and payments, which is why the next section covers when the switch pays for itself. If your setup is mostly paper and card cash, the sheet above will hold fine; if you have questions about how our own commission reporting works before committing, our FAQ | My Tech Touch covers it.

When does salon software beat a spreadsheet for commission tracking?

A spreadsheet stops working once one of these is true: you have 4 or more commission stylists, you mix booth renters with W-2 staff, you want retail commissions calculated automatically at checkout, or you run more than one location. At that point you are paying yourself to be a data-entry clerk, and one missed service line means a shorted paycheck.

What to check before you buy

Salon software typically runs from around $50 to a few hundred dollars per month depending on features and staff count. Before you commit, check: does it calculate commission per service and per stylist, can you set different rates for services vs. retail, does it split a ticket between two stylists, and can you export a payroll report your accountant can read.

How the main options compare

Boulevard, Mangomint, and GlossGenius sit at the higher end with deeper commission controls. Square Appointments and Vagaro cover booking and payments broadly. Run any of them through the same four checks above before you pay.

Where My Tech Touch fits, and where it falls short

My Tech Touch (About | My Tech Touch) tracks services, retail, and loyalty on one flat fee: $79/mo for up to 5 users, $99/mo for up to 10. The honest limits: it is single-location only, and if you run a large booth-renter operation you may want deeper rent-invoicing features than it offers.

How should you handle booth renters alongside commission stylists?

A booth renter pays you; a commission stylist gets paid by you. Track them as two separate lists in the same system so payroll stays clean. For renters, log a weekly or monthly rent charge per chair, record each payment as it comes in, and carry any balance forward. Their product sales, if any, flow through your register but produce no payout.

For commission stylists, keep the spreadsheet or software payout run exactly as covered above. In My Tech Touch, both live under one account: staff on commission show up in the payout report, while booth renters show as a recurring charge you mark paid. If a renter switches to commission mid-year, change their status on the effective date so the history stays straight.

How do you run the actual payout without disputes?

Pick a fixed payout day, weekly or biweekly, and run the same four steps every time: reconcile completed tickets against the schedule, apply product and processing deductions from your agreed rate sheet, calculate each stylist's total, then get a signature or a thumbs-up in writing before money moves. If you pay through software, most tools handle this inside the ticket flow; Square Appointments, for example, processes payment and staff payout on the same ticket so commission is deducted automatically at checkout rather than reconciled later from memory.

The dispute-proofing step is the sign-off. A text that says "You earned $612 for the week of the 14th, see attached breakdown" and a reply of "looks good" is a record. Without it, a disagreement two weeks later becomes your word against theirs.

What records do you need to keep for taxes and disputes?

Keep every commission payout tied to a dated record: the service total, the stylist's rate, the amount paid, and the pay date. Save the underlying reports too, such as appointment and payment summaries for each pay period, plus any signed commission agreements.

The IRS expects employers to keep payroll records for at least four years, covering wages, tips, and dates of payment, so a four-year retention rule is a sensible floor for commission records as well. Store them where a former stylist's numbers can be pulled up in minutes, because a dispute usually shows up months after the last paycheck.

FAQ

How do I calculate sliding scale commission for a stylist in a spreadsheet?

List each service type and its rate on a Stylists tab, then use VLOOKUP to pull the rate by service name: =E2*VLOOKUP(D2,Stylists!A:B,2,FALSE). Because the rate changes per line item, every service needs its own row. Sum by stylist with a pivot table grouped on the Stylist column, and check the total against the ticket before payout.

Should I pay commission on the service price before or after product costs and discounts?

Pay on the actual collected amount, after discounts, and write the rule into your rate sheet before anyone asks. Whatever base you choose, apply it consistently and show the math on the payout breakdown. Ambiguity here is the most common source of shorted-paycheck disputes, since a discounted ticket pays less than the menu price the stylist expects.

What is the difference between booth rent and commission pay for tracking purposes?

Money flows in opposite directions. A commission stylist gets paid by you, so they belong in your payout report with rates, service totals, and deductions. A booth renter pays you a fixed weekly or monthly charge per chair, recorded as incoming revenue with any balance carried forward. Keep them as two separate lists so payroll stays clean.

Can I track commissions for two salon locations in one spreadsheet?

Technically yes, with a Location column and filtered summaries, but it gets fragile fast. You double the ticket volume, two people enter data, and one missed line means a shorted paycheck at whichever site you check last. Once you run multiple locations, software that pulls commissions straight from booked appointments and payments is usually worth the monthly fee.