Calculating Sales Commissions

 

Expand/Collapse all Show/Hide All

Sales commission calculations are based on the following:

Before calculating sales commissions, you must make the appropriate selections in the Inventory Management and Accounts Receivable modules.

In Accounts Receivable Options, the following fields determine how sales commissions are calculated:

  • Salesperson Commission Reporting

  • Commissions Paid on Paid Invoices Only

  • Commission Calculation Based On

In Inventory Management Options, the Calculate Commission by Inventory Item field determines how sales commissions are calculated.

If any of the following conditions are met, all sales commissions are based on the selection made in the Commission Rate field in Salesperson Maintenance and are subject to the selections in Accounts Receivable Options:

  • The Inventory Management module is not installed.

  • The Inventory Management module is installed and No is selected in the Calculate Commission by Inventory Item field in Inventory Management Options.

  • The Inventory Management module is installed, Yes is selected in the Calculate Commission by Inventory Item field in Inventory Management Options, and Standard is selected in the Commission Method field in Item Maintenance.

If the Inventory Management module is installed and Yes is selected in the Calculate Commission by Inventory Item field in Inventory Management Options, then each inventory item can be independently configured to be subject to sales commission based on the selection in the Commission Method field in Item Maintenance. If the inventory item is subject to sales commission, the following calculations methods can be used:

  • Standard (subject to settings in Accounts Receivable as noted above)

  • Percent of Cost

  • Percent of Gross Profit

  • Percent of Price

If None is selected in the Commission Method field in Item Maintenance, sales commissions are not calculated for the item.

If commission percentage rates are defined in Line Item Commission Maintenance, they will override percentage rates set up in Salesperson Maintenance and Item Maintenance, but any base commission amount entered in Item Maintenance will still be included in the commission total. If a commission amount is entered in Line Item Commission Maintenance, it will override both the amounts calculated using percentage rates entered in Salesperson Maintenance and Item Maintenance and any base commission amount entered in Item Maintenance.

Expand/Collapse item  Examples

The following examples show which rates and/or amounts will be used for sales commission calculations based on entries in Salesperson Maintenance, Item Maintenance, and Line Item Commission Maintenance.

Note If a value appears in one of the Item Maintenance columns, the example assumes that an option other than None or Standard is selected in the Commission Method field in Item Maintenance.  

Sales Person Maintenance Commission Rate

Item Maintenance Commission Rate

Item Maintenance Base Commission

Line Item Maintenance Commission Type

Line Item Maintenance Commission Rate or Amount

Rate and/or Amount Used

5%

N/A

N/A

N/A

N/A

5%

5%

7%

$20.00

N/A

N/A

7% plus $20.00

5%

7%

$20.00

Percent

9%

9% plus $20.00

5%

7%

$20.00

Amount

$30.00

$30.00

A record created in Line Item Commission Maintenance for one specific salesperson, customer, or item will take precedence over a record created for All salespersons, customers, or items. The following table shows the hierarchy used when multiple records exist for the same salesperson, customer, or item, assuming that no records are eliminated based on the effective date.

Salesperson

Customer

Item

Order of Precedence

Specified

Specified

Specified

1

Specified

Specified

All

2

Specified

All

Specified

3

Specified

All

All

4

All

Specified

Specified

5

All

Specified

All

6

All

All

Specified

7

All

All

All

8

For more information, see Sales Commission Calculation Methods.

Note When calculating sales commission on a per item basis, reports do not display the commission rate per item when the report is generated by invoice (summary). Because the commission rate for individual items may be different, the reports will display 0.00% for the commission rate, even though the commission amount is correct for that invoice. In addition, the Gross Profit Journal, which displays the item detail, prints the salesperson commission rate in the sub-header for the Standard type line item, but does not print the commission rate for items using the Percent of Cost, Percent of Gross Profit, or Percent of Price calculation methods.