Need a Template for a Sales Commission Plan?

Written by:  • Edited by: Michele McDonough
Updated Mar 16, 2011
• Related Guides: Microsoft | Accounting Software | Medicare

If you pay employees on commission, a special template or form to help calculate these earning can be very helpful. Jean Scheid offers some useful tips along sample forms that you can download for free.

 

Slide 1 of 3

Handshake by Spring Stone
click to enlarge
Salespeople are usually paid a percentage from what they sell whether it is automobiles, art, homes or any kind of product. Most sales commission and compensation plans come in a written agreement compensation form so the salespeople understand how they are paid. You can find a sample commission compensation agreement in our Media Gallery and modify it to make it specific to your industry.

A good sales commission plan will pay the employee a percentage on the gross sale amount and not the net sales amount. Gross sales commission are based on what the company made before expenses and net sales commission are what a salesperson might receive once all the expenses for selling the product are deducted.

In the auto industry, it is standard to pay sales commissions and draws based on the gross sales amount, less dealer pack. There are a couple good ways to create a sales commission and compensation plan template.

Sales Commission Payout Templates

Slide 2 of 3

First, you can find a sales commission and compensation plan template in our Media Gallery that will give you an idea on what to include in your own company’s sales commission form. How you pay out commission depends upon what type of commission plan you have.

Screenshot Commission Examples 80 20 Sales Performance on Draws
click to enlarge
Basically there are two kinds, a recoverable draw and a non-recoverable draw. If you click on the image to the right, you’ll see an example of both a recoverable draw and a non-recoverable draw. Now let’s explain the difference.

  • Recoverable Draws – In this type of commission pay plan, the salesperson is given a draw against their commissions with no federal, state, social security or Medicare taxes taken out. Recoverable draws are usually paid between the 1st and the 5th of each month. When actual commission are paid out later in the month, if the commissions made exceed the draw previously paid, the salesperson is paid what is owed, less the draw received earlier in the month.
  • Non-Recoverable Draws – This works much the same where the salesperson receives a draw early in the month and when actual commission are calculated if the commissions exceed the draw, the salesperson is paid that amount less the prior draw. The difference here is that if the salesperson's commission is less than the draw received, he or she does not “owe” the draw back and the board or commission plan is wiped clean for the next month.

In these types of sales commission and compensation plan template examples, the salesperson is taxed on the draw when its commission payday, not on draw day. Consider a draw as a way to keep the employee financially afloat until commission payday.

Other Sales Commission Templates

Slide 3 of 3

Along with your sales commission agreement, there are two types of sales commission and compensation template examples that you can create using Microsoft Excel or purchase from companies that specialize in sales commission forms.

Great American offers two types of commission form, a sales voucher and a sales commission report.

In today’s world of accounting software systems, however, it’s best to utilize the accounting program to keep track of sales commission through journal entries made to the general ledger as each item is sold. The forms offered by Great American are hand fill-in forms and not computerized forms.

Screenshot Great American Business Forms Commission Voucher
click to enlarge
Sales vouchers are helpful to salespeople, however, to keep track of what they can expect come sales commission payday. Once the commission is calculated in the accounting software program, the sales manager can use this three-part sales voucher, seen here at the left, and give one to the salesperson, keep one for the sales folder, and give one to the accounting department.

When you create a sales commission and compensation plan template, make sure you make it industry specific based on whether or not you will include draws and how you will keep track of each salesperson’s commission due. If you do pay employees on commission, you may also want to explore sales commission software like Qcommission that integrates with accounting systems like Intuit’s Quickbooks.


Comments

Showing all 9 comments
 
Jim Jan 10, 2012 12:12 AM
RE: Need a Template for a Sales Commission Plan?
If you were given a commission advance and quit the company do they have the right to go after you to pay them back the advance, in California.
Wendy Nov 3, 2011 6:20 AM
RE: Need a Template for a Sales Commission Plan?
does the sales rep need to buy the samples or the company need to provide the samples?
Jean Scheid Oct 25, 2011 2:34 AM
RE: Need a Template for a Sales Commission Plan?
Hi Schoneveldj,<br>My first thoughts on paying back this draw would be no, however, it would depend on the sales commission agreement you signed. Can you offer more info?
Schoneveldj Oct 24, 2011 10:34 PM
RE: Need a Template for a Sales Commission Plan?
can a company you quit from over two years ago make you pay bake the drw from comission?
Anonymous Mar 25, 2011 7:25 PM
What rights do I have
What if I'm paid a percentage of my commission say 20% every week, and I end up leaving the company. Does anyone know what rights I have to recover the amounts in my draw account?
Jean Scheid Feb 28, 2011 4:17 PM
To Ed - Draws
Hi Ed,
Legally, if you received a draw check in 2009 that was not taken out of your commission checks and therefore, taxed, your employer was right to issue you a 1099. 1099 wage statements must be included as income when you file your tax return. If your employer is now offer draws and then taking them out of your commission check with the appropriate taxes (on the draw too), then you shouldn't receive any 1099s in the future.
Hope this helps,
Jean
Ed LeBaron Feb 28, 2011 3:55 PM
Taxes on a recoverable draw
I was given a draw in the amount of $2400 for the month of November 2009. I was then given a 1099 at the end of the year with the $2400 included. The draw was against future commissions. My employer has opted to take out the draw from commission checks in the future however I just got a tax bill for 2009 on the draw amount given to me. If I have to pay back every penny of the draw from 2009 how is it that I am paying taxes on that amount? Isn't this the same as paying taxes on income you do not get to keep? What am I missing here?
Krish Feb 27, 2011 12:22 PM
To solve the problem we need a Sales Performance Management (SPM) Tool.
Hi,
Automating the sales commission is the future for the entire incentive industry.

Constant review of the sales commission plan to find the best plan increases the productivity of the company. SPM tools like easy-commission.com ( an online low cost SaaS software is the best solution for small and medium sized business's ) and www.qcommission.com is higher end version which can handle more complex sales commission plans.

These tools once set-up can automate the calculation and reporting part as it invvolves lot of manual work.

Integration with Quickbooks and other accounting packages are done easily by these software's.

This tool is must for all small and medium and large business as well.

COMMISSION STRUCTURES

At the core of any incentive plan is determining what role commissions play in the overall sales compensation package. Four of the most common commission structures are:

* Commission only;

* Commission plus salary;

* Commission plus bonus; or

* Commission plus salary, plus bonus.

http://findarticles.com/p/articles/mi_m0ICC/is_2_71/ai_90984177/


For more details pls refer the above url link as well.
Anonymous Oct 12, 2010 8:31 PM
advances
What kind of rules would you do around advances? Any guidelines here?
 
blog comments powered by Disqus
Email to a friend