Sales

Sales commission calculator template

Tiered commission against quota with an accelerator over target, so reps can check their own number.

How to build this in Numio

How it is wired

Which cell does what, and which worksheets the model reads. These are the assignments you recreate when you import the file.

Cell assignments for the Sales commission template
CellRoleNote
B1InputClosed revenue
B2InputQuota
B3InputBase rate
B6LookupMultiplier from the Tiers sheet
B11ResultBase plus accelerated commission

Reference worksheets

  • TiersAccelerator multiplier by attainment

Functions used

VLOOKUPMINMAXIFROUND

Put this calculator on your site

Change the numbers to yours, then paste it into your own page. It runs in the visitor’s browser and the answers are theirs, not a screenshot of yours.

Embed Sales commission

This template carries example rates, not yours. Paste it as-is and you are quoting our numbers to your customers, and enquiries reach our workspace rather than yours. Copy it into Numio first, change the rates, and publish your own — you get your embed code at the end of that.

Make my own copy
Embed code
<div style="position:relative;overflow:hidden;height:640px;">
  <iframe frameborder="0" style="width:100%;height:100%;" src="https://calc.numioapp.com/calculator/6aa0b5c7a992af8ef71b79c7"></iframe>
</div>

Set the height to suit your page — the iframe fills whatever container you give it.

Build it in Numio
  1. 1

    Copy it into Numio

    Start from this model rather than a blank sheet. The inputs, the results and any lookup worksheets come with it.

  2. 2

    Put your own rates in

    The prices here are examples. Change them in the Formula view and the calculator follows — no rewiring.

  3. 3

    Publish and paste it in

    Publishing gives you an iframe snippet. Drop it into your own page and enquiries land in your workspace.

Sales commission FAQ

Yes — they are rows on the Tiers worksheet. Edit them in the Formula tab and republish; nothing needs rewiring.

The calculator does not store anything by default. Share the link with the team and each person's entries stay in their own browser.

Other templates

See all templates

Build your first
calculator today.

Start trial