Why Batavia salon owners lose every other Sunday to commission math
2026-09-18 · 6 min read
It is Sunday night, every other week, at a kitchen table in Batavia. The salon on Wilson Street closed at four. The owner has the laptop open, the booking software's sales report exported to a spreadsheet, and a second tab she built three years ago that holds the commission tiers.
Six stylists. Four on commission, two renting a chair. Each commission stylist has a tier that depends on her service sales for the period, so the first job is totaling services by stylist and seeing who crossed a line. Then retail, which pays a different rate and which the export lumps in with services unless you filter it. Then tips, from a separate report, because half were on cards and half were cash on a sheet at the desk. Then the corrections: a color rung under the wrong stylist on a Thursday, a redo that should not count toward anyone's total, a gift card redemption that shows up as a sale and is not one.
Around ten she has a number for each stylist. She checks the two who had a slow stretch against their hours, because Illinois sets the adult minimum wage at $15.00 an hour and a thin commission period has to clear that floor. Then the totals go into payroll by hand. If a stylist questions her check on Wednesday, the answer lives in a spreadsheet only the owner can read.
What the Sunday rebuild costs
Commission is the number a stylist watches most closely, and a check that arrives late or wrong, even by a little, gets remembered. Owners who assemble it by hand run it at the last possible moment because it is miserable, so a question on Wednesday gets answered from memory of a spreadsheet closed Sunday night. The people who bring in the clients notice that.
The corrections are where the real time goes. The export is only as clean as what happened at the front desk two weeks ago, and nobody fixes a mis-rung ticket the day it happens because nobody sees it until payroll. So every period starts with the same archaeology.
And the read on the business never gets done, because the evening goes to the payout instead of the pattern. Which stylist never mentions product. Who has gaps on Tuesdays. How many clients from six weeks ago have not rebooked. Those numbers sit in the same export, and by the time the checks are done nobody wants to look at anything.
Definitions drift too. Does a redo count toward tier. Does a package sold in June count when it is sold or when the sessions are used. Those get answered at ten on a Sunday, differently each time, and two stylists on the same tier end up paid two different ways without anyone meaning it.
What replacing it looks like
The rules already exist. They live in the owner's head and in that second tab. The job is to write them down once and let a system apply them every period, so the owner reviews a finished sheet instead of building one.
- We start by writing the pay rules on one page: tiers and what counts toward them, the retail rate, how redos and gift cards and packages are treated, and the hourly floor check. Ambiguities get decided once, in daylight.
- The system pulls the booking software's data on a schedule where the platform allows it, or reads a recurring export that lands in a mailbox. Card tips come with it. The desk enters cash tips on a short form the same day, so the tip sheet stops being a piece of paper.
- Ticket problems surface the day they happen instead of two weeks later. A service rung under a stylist who was off that day, or a redo not marked as a redo, gets flagged that evening so the desk can fix it while everyone still remembers.
- Each period, every stylist's total assembles itself: services, retail, tips, corrections, tier applied, floor checked. The owner gets one sheet with each number and where it came from, and approves it or fixes a line.
- Each stylist gets her own statement showing the same breakdown, so the Wednesday question answers itself.
- The read on the book comes with it, as a page the owner did not have to build: rebooking rate, retail per client, and open hours per stylist, this period next to the last few.
| Moment | How it goes now | With a system |
|---|---|---|
| Assembling the period | Sunday night, three exports, one spreadsheet | Lands on schedule, owner reviews it |
| A mis-rung ticket | Found at payroll, fixed from memory | Flagged the same day, fixed at the desk |
| Cash tips | A sheet at the desk | Entered daily, in the same total |
| Tier rules | Recalled from a tab, applied by hand | Written once, applied the same way every period |
| Stylist asks about her check | Owner opens the spreadsheet | She already has her statement |
| The read on the business | Skipped, the evening is gone | Same page, every period |
I have built this shape in other businesses. A pool service client's leads and payments run through one system, so who paid for what is a lookup instead of a hunt. A freight forwarder's quote requests used to arrive as loose email and now come in structured and tracked. Salon payroll is the same pattern on a two week clock: take what already sits in the software, apply rules agreed on once, and put a finished sheet in front of the person who signs it.
What stays human
Setting the rules is the owner's job, and it is a real one. Where the tiers sit, whether the new stylist gets a guarantee for her first three months, whether a redo counts against anyone. The system only applies what you decided.
Approving the sheet stays human too. A stylist whose total looks low for a period when she was out a week is a different story from one whose total is low because her Tuesdays have gone empty. The second one needs a conversation in the back room, and no sheet has it for you. When a stylist disputes a line, the statement means you are both looking at the same facts. The rest of that talk is yours.
When it is not worth building
If you pay two stylists a flat rate, or everyone rents a chair and you only collect rent, there is nothing here to build. It becomes worth doing when tiers and retail rates turn each check into a calculation, usually around four commission stylists, or after a check has been wrong twice and you felt what that cost.
When it is worth building, builds start at $500 one time, then a flat monthly from $99 after an included run-in period, cancellable. There is more on the salon and med spa page and on what I build for businesses in Batavia.
Where to start
The first step is a free 20 minute process audit. We open your last two pay periods, walk every export and correction, and count the hours. If a system assembling that sheet would give you the Sundays back and put a statement in every stylist's hands, I will tell you what it costs to build. If it would not, you keep the map. Start here.