Incentive Estimator

You can use the Incentive Estimator area to estimate incentive compensation based on current plans and attainment.

important: The Incentive Estimator requires that you have direct credit from sample
orders.

Estimator Actions

1. Import Opportunities—Import sales opportunities from your Salesforce account
2. Upload Excel—Upload an Excel spreadsheet of sample orders
3. Estimate—Calculate the estimated commission, bonus, and credit based on sample orders
4. Add Row—Add a new row for entering sample orders into the application

Screen Shot 2017-01-31 at 10.38.35 AM

Incentive Estimator Screen

All Fields

The following table describes the information you need to specify when estimating incentive compensation:

FieldDescription
ProductThe name of product.
Customer Name The name of the customer.
Geography The name of the geography.
Incentive DateThe Incentive Date when the payment will be released.
Order Type The sample order type.
Quantity The sample order quantity.
Amount The sample order amount.
Amount UnityTypeThe unity type for the sample order.
DiscountThe sample order discount (as a percentage).

How to…

This section describes how to estimate your incentives. To estimate incentives you need to create at least one sample order by doing one of the following:

  • Manually entering sample orders
  • Importing opportunities
  • Uploading sample orders from Excel

Manually Enter Sample Orders

1. Click the Incentive Estimator tab. The Estimator screen appears.

2. In the Data for Estimation section, click the Screen Shot 2017-01-31 at 11.13.35 AM button to add a new row, if necessary.

3. (Optional) In the Product field, click the Screen Shot 2017-01-31 at 11.14.01 AM button. The Select Product dialog appears. Select the appropriate product in the list and click the Screen Shot 2017-01-31 at 11.14.20 AM button. The product appears in the field.

note: To remove an entry, click theScreen Shot 2017-01-31 at 11.17.54 AM button in the corresponding field.

4. (Optional) In the Customer Name field, click theScreen Shot 2017-01-31 at 11.14.01 AM button. The Select Customer dialog appears. Select the appropriate customer in the list and click theScreen Shot 2017-01-31 at 11.15.28 AM button. The customer appears in the field.

5. (Optional) In the Geography field, click theScreen Shot 2017-01-31 at 11.14.01 AM button. The Select Geography dialog appears. Select the appropriate geography in the list and click theScreen Shot 2017-01-31 at 11.15.48 AM button. The geography appears in the field.

6. In the Incentive Date* field, click the Screen Shot 2017-01-31 at 11.16.06 AMbutton and select the incentive date of when the payment should be estimated.

note: The incentive date is the date used to calculate the commissions and
bonuses for the order.

7. (Optional) In the Order Type field, click theScreen Shot 2017-01-31 at 11.14.01 AMbutton. The Select Order Type dialog appears. Select the appropriate order type in the list and click theScreen Shot 2017-01-31 at 11.15.54 AM button. The order type appears in the field.

8. (Optional) In the Quantity field, type the quantity ordered.

9. In the Amount* field, type the order amount, and choose a unit type from the drop-down list.

10. (Optional) In the Discount field, type the discount amount.

11. Add additional rows, as necessary, by clicking theScreen Shot 2017-01-31 at 11.13.35 AM button.
To delete a row, click the Screen Shot 2017-01-31 at 11.21.23 AMbutton for the corresponding row. To delete all rows of data, click the Screen Shot 2017-01-31 at 11.21.16 AM button.

Import Opportunities

important: You must have a Salesforce account to import opportunities.

1. Click theScreen Shot 2017-01-31 at 11.22.42 AM button. The Import Opportunities screen appears.

Screen Shot 2017-01-31 at 11.24.48 AM

Import Opportunities Dialog

2. Enter your Salesforce account information.

Do the following:

a. In the Username field, type your Salesforce user name.
a. In the Password field, type the password for the account.

3. (Optional) Define the filter criteria for importing your opportunities.

Table 1: Import Salesforce Opportunity Fields

Opportunity NameThe name of the opportunity in Salesforce.
Close DateThe opportunity close date in Salesforce.
AmountThe amount of the opportunity in Salesforce.
Probability (%)The probability of the opportunity closing in Salesforce.
Forecast Category The forecast category with which to (optionally) filter
the Salesforce.com opportunities imported into Incent.

note: When setting the Amount field, be aware that specifying a “greater than” amount can cause the application to return products that, individually, are less than the amount you specified.

For example, if a $10000 opportunity consists of 10 products of $1000 each, and you select an amount of >$9000, the application may return all 10 products in an Estimator List, even though individually each of them is not greater than $9000.

4. Click the Screen Shot 2017-01-31 at 11.30.04 AM button.

Upload Sample Orders from Excel

You can create sample orders by uploading the orders from a Microsoft Excel file.

1. Click the Screen Shot 2017-01-31 at 11.30.12 AM button.

2. Click the Click here link to download the Excel template file.

Depending on your browser, a dialog might appear allowing you to specify where to save the file.

3. Edit the template file, and specify the sample orders. Save the file.

note: All required fields in the Excel file, are marked with an asterisk (*).

4. Click the Screen Shot 2017-01-31 at 11.30.20 AM button and locate the template file you would like to upload.

5. Click the Screen Shot 2017-01-31 at 11.30.26 AM button.

Estimate Incentives

• Click the Screen Shot 2017-01-31 at 11.32.39 AMbutton. The estimation results appear.

Screen Shot 2017-01-31 at 11.33.01 AM

Incentive Estimator Results

Hovering over the commission or bonus charts displays a pop-up showing the current and estimated values for each.

note: If your incentive calculation is 0, make sure that you entered all required data for your compensation plan.

The data you enter for a sample orders is dependent on your compensation plan. Please contact your administrator if you have questions.