Sales Commission (Template only) $25.00

Order Now

This is ONLY the template. The E-book can be purchased here.

This template can be used in conjunction with a formatted Sales By Sales rep report in QuickBooks. You simply run the report in QuickBooks, Export it to excel and then drop the numbers into the template. The template looks up the commission rates (set up on another tab in this template and also can be updated using a Sales Rep List report from QuickBooks).

  • You can manually set up the commission rates in excel
  • Or you can set up a custom vendor field in QuickBooks to track and update them there.
  • Then customize the Sales rep list to include the custom field.
  • This way you can run that report in QuickBooks and export it to update the list in this template.
  • This method is recommended because even a slight typo in a Vendor name will cause the “lookup” formula in the template to fail. The names HAVE to match.

To use the template exactly as it is laid out requires some custom fields in QuickBooks, so if you are not very knowledgeable in Quickbooks it is highly recommended that you download the full video which walks you through step by step how to set everything up exactly as you need it.


  1. Steve January 14, 2012 8:26 am  Reply

    I have 7 different levels of commission that get paid out, for example $350 to 374.99 is 20% commission. I also use group items in Quickbooks. Can your template be modified so that I can use it to do 7 different levels like above and take into consideration the use of group items in quickbooks by just using the total for each group not individula items in the group? Thanks for your anticipated answer.

    • Nerd January 18, 2012 12:05 pm  Reply

      The template could be adjusted to accommodate that, where you will have a problem is in QuickBooks. If you would like more information call me (866) 945-8070 and I would be happy to discuss what your needs are, how this can be customized for you and what that would cost.

  2. John July 6, 2015 3:18 pm  Reply

    Does QuickBooks allow you to mark the Commission as “Paid”, so there won’t be any confusion on whether it has been paid or not?

    • Nerd August 19, 2015 6:02 pm  Reply

      When you calculate the commission, you will enter it as a bill. Once that bill is paid, it will be marked as paid.

Leave a comment

Your email address will not be published. Required fields are marked *