Skip to content
Workflow · Finance close · Opening soon

Salon stylist commission

Export your Square sales for the pay period and upload the file. Mammoth totals sales by stylist, finds the service tier for each total, then calculates commission on all service sales at that tier rate and adds 10 percent of retail product sales.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Square sales export
    CSV export · 40 rows
  2. File
    Service commission tiers
    CSV export · 3 rows
  3. Step
    Total sales by stylist
    Step 1
  4. Join
    Find service tier
    5 of 5 paired
  5. Step
    Calculate commissions
    Step 3
  6. Result
    Stylist Commissions
    5 rows
  7. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 5 rows came out, and the join paired 5 of 5 rows.

What you get back

The result of that run, the rows to look at first.

Stylist CommissionsSample data5 rows
StylistCommissionService salesRetail salesTier rate
Ava Chen339.509603535%
Brielle Fox309.258753035%
Nia Patel9402,0804045%
Sofia Ruiz240.806802835%
Tessa Wong574.201,4302240%
5 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Stylist Commissions workflow

  1. 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.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your Square sales for the pay period and upload the file. Mammoth totals sales by stylist, finds the service tier for each total, then calculates commission on all service sales at that tier rate and adds 10 percent of retail product sales. All dates in the export that fall in the pay period are included.
Which Square export should you use?
Use the sales export that includes the transaction dates, stylist names or IDs, and the service and retail sale amounts for the pay period.
What happens to rows that do not match a stylist or item type?
Rows that do not match a rule are left out of that step’s result until you add a rule that covers them. You can review the unmatched rows and decide how they should be handled.
How do you change the commission rules?
Edit the rules in words, for example by changing the tier thresholds, the tier rates, or the retail percentage. Then rerun the workflow on the export to recalculate the commissions.

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.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →