Salon stylist commission
“calculate each stylist's commission for the pay period: their total service sales earn the rate of the tier that total falls in, applied to all of it, plus a flat 10 percent on retail product sales”
Calculate each stylist's commission for the pay period: their total service sales earn the rate of the tier that total falls in, applied to all of it, plus a flat 10 percent on retail product sales; all dates in Square sales export count for the pay period.
What the agent built
3 steps, each one an ordinary Mammoth step you can open and change.
- FileSquare sales exportCSV export · 40 rows
- FileService commission tiersCSV export · 3 rows
- StepTotal sales by stylistStep 1
- JoinFind service tier5 of 5 paired
- StepCalculate commissionsStep 3
- ResultStylist Commissions5 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 5 rows came out, and the join paired 5 of 5 rows.
- Download Square sales export sample (40 rows)Square: Reports > Sales summary > Itemized sales export
- Download Service commission tiers sample (3 rows)Square: Account & settings > Payroll > Stylist commission tiers > Export
What you get back
The result of that run, the rows to look at first.
| Stylist | Commission | Service sales | Retail sales | Tier rate |
|---|---|---|---|---|
| Ava Chen | 339.50 | 960 | 35 | 35% |
| Brielle Fox | 309.25 | 875 | 30 | 35% |
| Nia Patel | 940 | 2,080 | 40 | 45% |
| Sofia Ruiz | 240.80 | 680 | 28 | 35% |
| Tessa Wong | 574.20 | 1,430 | 22 | 40% |
How it works
How to use the Stylist Commissions workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Stylist Commissions: questions
How do you calculate salon stylist commission from Square sales?
Which Square export should you use?
What happens to rows that do not match a stylist or item type?
How do you change the commission rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent