Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Calculate Commission Based on a Percentage of Sales

There are a number of situations where it may be necessary to calculate and track commission based on a percentage of sales. For example, you may want to calculate a percentage commission on a sale for a particular sales rep, or calculate various percentages of overall sales for a show or event to go to individual employees.

This article provides steps on how to create a group item which allows one or more fixed percentages to be calculated based on a given sales item. The percentage commission is posted to a liability account and the amount is offset to a clearing or pass-through account. It also shows how to create and use a report to track commission accrued and to clear the commission liability balances when commission is paid to reps or employees.

Detailed Instructions

To calculate one or more percentages based on sales, you will need to create a group item for each employee/rep where the items in the group may be modified based on what is sold. The group item contains an item to track sales as income, another to track commission as a liability, and an item to offset the liability to a clearing account, so that the total amount is not overstated on the sales transaction.

Intuit recommends you to contact your professional bookkeeper or accountant to verify the accounts to be used in the following steps.

KB ID# HOW14006
7/30/2014 2:02:59 AM
PPRDQSSWS404 9102 Pro 2013 e66fb1