Commission Calculator
By Stinson Solutions
The first screen to appear when you launch Commission Calculator (except for the initial, brief set up) is the Main Menu. Here, all your options are displayed in clear view – no searching through collapsible menus.
At the bottom of the Main Menu, you can select whether your commissions are calculated on Sales (invoices issued) or (invoice) Payments (this is your Commission Basis).
In the lower right of the Main Menu, you can set the criteria of your Standard Commission. The Standard Commission is the commission you would typically pay most, if not all, of your Sales Reps. For example, if your Commission Basis is Payments and your Standard Commission Rate is 2% (as selected above), each of your Sales Reps assigned the Standard Commission would be receive a commission of 2% or all payments received on his or her invoices (i.e. invoices with that Rep shown). Optionally, you can also set a Minimum that each Rep must reach in order to qualify for commissions and/or an amount at which the commission calculation begins.
After setting the Commission Basis and Standard Commission, click on the “Add/Edit Reps” option. This opens the Add/Edit Reps screen.
If your Sales Reps are not yet shown here, simply click on “Update Reps” to automatically retrieve your Sales Reps from QuickBooks. When your Reps are retrieved, they are assigned the Standard Commission by default. But after the Reps have been retrieved, you can assign each Rep a different commission rate, if desired. As you can see, Commission Calculator has a myriad of commission types from which to choose. You can even base a Rep’s commissions on Sales or Payments within a Class (Classes are retrieved along with the Sales Reps) or on specific Customers/Jobs.
After you have set the commission type for each of your Reps, you are ready to begin your commission calculations, unless there are one or more Items you want to exclude from your commission calculations. To exclude Item(s) from your commission calculations, simply click “Exclude Item(s) from Commission Calculation” on the Main Menu. All of your Items are retrieved from QuickBooks automatically and presented so you can simply click the Item(s) to be excluded.
If at any time you need to change the Item(s) that are excluded, simply click “Exclude Items from Commission Calculator” on the Main Menu again. The Item(s) you selected previously are highlighted. If you click on one of these, the highlight disappears and that Item will now be included in your commission calculations.
Now you are ready to calculate commissions. Click “Retrieve Payments and Calculate Commissions” (or “Retrieve Sales and Calculate Commissions” is you choose Sales as your Commission Basis) from the Main Menu.
Enter the beginning and ending date of your commission calculation, and Commission Calculator does all the work. All Payments or Sales are retrieved from QuickBooks during the period specified, matched up with the corresponding Rep and his or her commission type, calculates each Rep’s commissions for the period, and presents all the pertinent information to you in a Commission Calculation Report. You can even specify that each Rep’s report begins on a new page, making it easy to distribute separately and confidentially.
Try
it today. You’ll wonder how you ever got along without it!