May 11, 2022

Basic Tiered Commission Model Using Finicast

Basic Tiered Commission Model Using Finicast

Nelson Chan
May 11, 2022

How to use Finicast to easily calculate commissions in a basic tiered structure

Commissions is a critical tool to align your sales team’s compensation to your company’s sales goals.  The more they sale, the more they earn, which in turns drives higher revenue to the company.  However, to really super charge the win-win alignment, the best tool is a tiered commission structure (also known as a multiplier commission structure, or accelerators).

In this blog post, we will show you how to use Finicast to build a simple tiered commission model.  In future blog posts, we will expand upon this model to add further complexity.

When you have a small sales team, a simple tiered commission model is more an adequate.  Let’s set the stage:

  • Sales Team: 5 account executives
  • Commission calculation and payment frequency: Quarterly

Finicast Step 1: Create the basic quota schedule by Sales Rep

  1. Create a table for Account Executives (“AE”)
  2. Create a table for commission calculation frequency
  3. Create a pivot table where you have AEs by row and frequency by column
  4. Input the quarterly quota for each AE
  5. Sum up total quota by rep and by period.  The “by period” total is essentially your forecasted quarterly revenue.  (Note: you need to create the “total” in each of the Account Executives and Frequency tables)

Estimated Time: 5 minutes.  (Note: if you also are using Finicast for Sales Planning, you can link the quarterly quota for each AE in your Sales Planning model directly to this Commissions model to automatically populate these numbers, which should save you more than 50% of the time it takes to manually put them in)

Customizing: very easy.  If you want to add a rep (or 10, or 100), in your AE table you can easily add a rep and it will automatically update your quota schedule.  You can even download this list from your HRIS system such as ADP, Paychex, or Gusto.  Or if you want to use monthly as your calculation frequency instead, you can easily update the Frequency table to be by month instead of by quarter.

Let’s say this is your tiered commission schedule:

Let’s translate this to Finicast Step 2: Create Commission Schedule

Finicast Step 3: Build Commission Model

At this point, you have all the tables necessary to create a commission schedule by AE, by period.  Let’s do the follow steps to build the Commission Model:

1. Input actual attainment by AE by period.

2. Build out Commission Model.  Note that you only need to build the formulas once for one AE for one period and the model will automatically populate for all your AEs for all periods.  No need to copy paste anything or accidentally used a wrong formula for one AE for period because of human error.  The totals by AE and total by period requires some formula adjustments, but overall the process is fast and accurate.  This example only uses 5 AEs with quarterly calculation, but to do this for 10,000 AEs with monthly calculation, rolling this out will take the exact same amount of time with no sacrifice in calculation time!  The scalability is vast.  

3. After the model is built, you can filter at this table in many different ways easily:

Quota vs Actual by AE

Commission Calculation Details for each AE

Note: you can use Finicast to send this slice of your commission model to each AE individually - ask us how!

On Target Commissions vs Actual Commission

In conclusion, using Finicast for commissions is easy and scalable.  Contact us today to learn more about how to use Finicast for your commission modeling!