The Ultimate Sales Commission Planning Template
Creating sales compensation plans is painful and let's face it - Not everyone is a spreadsheet whizz. That's why we've pulled together the ultimate sales comms planning template in Google Sheets (you can download it into excel), absolutely free for you to use, that can help with your revenue planning.
It covers both SDR & AE pay plans, giving you flexibility and freedom to build pay & commission plans that work.
It also gives you a complete overview of the total costs of the plan (in case you want to link it to the hiring plans you build in the ultimate sales capacity plan template).
Let's go.
Our Free Commission Plan Template for Sales is highly customisable and quick to get going - Simply make your copy in Google Sheets or download it to Microsoft Excel.
Using the template
1. Add in your AE roles (and managers also)
You can add up to 5 different roles, with their base and their quotas, with the minimum amount of commision paid on deals also set. If will already calculate the variable (bonus) giving you the OTE - You can also see how much of the total comms is made up of variable.
2. Adjust the individual plans
You can add up to 5 different roles, with their base and their quotas, with the minimum amount of commision paid on deals also set. If will already calculate the variable (bonus) giving you the OTE - You can also see how much of the total comms is made up of variable.
3. Now add in your
SDR targets
SDR targets are slightly more complex in some areas (in calculating targets), but with a slightly simplified approach to hitting targets.
By setting an OTE to pipeline ratio, and basic data like average contract value and conversion rates, this can help you not only create comms plans but set targets that make sense for their cost.
Targets can be broken out into 3 components of your choosing, with the variable pay set at the chosen fractions.
This is then used to not only set the targets, but also used to calculate how much each target is worth in total commissions. These are then adjusted in the role tables just like in the AE tables.
Now you and your reps can know exactly what they earn per SAO, meeting or deal based on the plan!
4. Build it into a team and hiring plan
Add your reps, select their plan and put in join dates and you'll get full prorated costings of both teams.
No more fussing about with your own comms spreadsheets ever again.
(just imagine what you could do dropping spreadsheets completely eh...?)
Download it for free
Discover Clevenue
Whilst getting a commission plan right is important, it's all done on the assumption that reps are going to achieve target - Commission plans are built to cater for both the scenario of underperformance and overperformance, to ensure that there's enough "carrot" to encourage sales teams towards performance.
But how do you ensure that your sales teams are built in a way that you can ensure they have the right mix of pipeline and capacity to be effective at generating revenue?
This is where Clevenue comes in, with our dedicated Revenue Planning Platform.
Careful revenue design comes from getting the delicate balance of GTM mix right, balancing the the delicate efficiencies of marketing inbound which evolves as spend increases, handling leads with the right level of capacity and the correct amount of outbound to close the gap.
Understanding the cost behind decisions is also important - The CAC of revenue generated by a sales rep is entirely dependent on how that opportunity is generated, and how utilised the sales teams are. That's why in Clevenue we model every sales action at an individual level, mapping performance against pay to get an understanding of the true customer acquisition cost behind every strategy. With Clevenue, you can understand the cost impact of your pay structures beyond current pipeline.
Look at sales and revenue planning differently using Clevenue, leveraging advanced Revenue Projection models to accurately predict capacity and better understand cost.
Found this useful?
Check out our other helpful sales templates aimed at helping sales reps and revenue leaders, all completely free.
.png)