Commission Formulas
Use this section to tell the SalesPro app how to calculate commissions. Commission estimates will
appear in the Results section if you have a field with Total Sale Amount and another field with
Commission Estimate. Commission estimates are calculated first by checking if the Total Sale
Amount entered by the user is greater than a specified formula. If the entered Total Sale Amount
is greater than the Greater Than Formula then the resulting Commission Formula will be used to
calculate the total commission earned. In the event the Total Sale Amount is greater than
multiple formulas , SalesPro will use the highest calculated commission.
You can add a new Commission Formula by clicking the
button.
Placeholders
When creating formulas, SalesPro allows you to use placeholders that will tell the app to populate that field with data from inside of the app. The values and their representations are as follows:- [FP]
- The Dealer Fee from the selected finance option in the estimates section of the SalesPro app. In the event no option is selected, 0 will be used.
- [UA]
- The Additional Amount added to the user.
- [DP]
- The down payment that the user entered into the SalesPro app.
- [B]
- The total price of all added items, from all categories (except the “Custom Product” category). Note: The prices for these items come from the entered price you used when setting up the Price Guide.
- [T]
- The Total Sale Amount entered into the Results.
- [CP]
- The total price of all items from the Custom Product category.
Example
Assume you want to calculate the commission on a sale at 7%. You want to remove any dealer fees from the finance options added to the estimate. You also want to make sure the total sale price is at least 90% of the total of all added items, plus $400. Using the image above, assume the following:- The total price of all added items is $9,000 – [B]
- The total price of all added custom product items is $1,000 – [CP]
- The total down payment entered is $500 – [DP]
- The financing fee selected has a 5% dealer fee – [FP]
- The total sale amount entered is $9,500 – [T]
Test Suite
You can use the test suite to test your Commission Formulas. It will show you which formula is being used by highlighting it in blue and display the Commission Formula Result at the bottom of the page.
This article is for Dashboard 3.0. Click here to view the help article for version 2.9.