Template · Finance close · Opening soon
Sales commission template
Work out every rep's commission from your closed deals: a base rate, an optional quota and a higher rate above it, month by month.
You bring
Deals140 rows
RepAmountClose date
Mammoth does the work
You get
One table30 rows
Each rep's sales and commission by month, with an accelerator above quota.
RepMonthSalesDealsCommission
- Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
- Your files, as they areUpload a file or connect a source. Your column names do not have to match.
- Runs again by itselfWhen new data arrives, every step runs again and the result updates.
What you get back
The real result of this template, run on sample data.
Sales commission: the resultSample data30 rows
| Rep | Month | Sales | Deals | Commission |
|---|---|---|---|---|
| Priya | 2026-04-01 | 20,553.55 | 1 | 2,055.36 |
| Marcus | 2026-05-01 | 51,223.10 | 2 | 5,122.31 |
| Priya | 2026-05-01 | 136,511.92 | 4 | 13,651.19 |
| Sofia | 2026-05-01 | 36,942.09 | 3 | 3,694.21 |
| Tom | 2026-05-01 | 19,683.02 | 2 | 1,968.30 |
| Wen | 2026-05-01 | 74,272.24 | 3 | 7,427.22 |
| Marcus | 2026-06-01 | 20,104.08 | 1 | 2,010.41 |
| Priya | 2026-06-01 | 80,070.80 | 3 | 8,007.08 |
How is sales commission calculated?
Commission is usually a percentage of sales. Many plans pay a higher rate (an accelerator) on sales above a quota.
How it works
How to use the sales commission template
- 1Bring your dataConnect a source, or upload a file.
- 2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
- 3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.
See the exact columns and steps ›
What it needs
Closed deals: rep, amount, close date
Deals
- Rep
- Amount
- Close date
- Stage(optional)
The steps it runs
- 1Match columns
- 2Only Closed Won deals
- 3Commission by rep and month
Every step is an ordinary Mammoth step you can open and change.
Sales commission: questions
Does it update by itself?
Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.
Can I change the steps?
Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.
Do my column names have to match?
No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.
Get early access to this template
Bring your data, check the columns, and the result rebuilds on every refresh.
More finance close templates
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Vendor spend analysisEach supplier's spend over the last 12 months, its share, and the change on the 12 beforeSee the template
- Multi-entity consolidationEvery entity's balances in one currency, by accountSee the template
- Flux analysisEvery account's last month against the month before, with moves over your limits flaggedSee the template
- Budget vs actualBudget, actual and variance for every account and monthSee the template
- Price-volume-mix analysisThe change in revenue for each product, split into price, volume and mixSee the template
- Trial balanceEvery account's debit or credit balance at the period endSee the template