...
Table of Contents indent Circle exclude Overview
Commission Calculation
Commissions calculated on discounted value
...
Each line items GP is calculated depending on the cost and price of the product, the GP will fall under one of the above tiers and the commission is applied to that line item according to the tier
Commission setup
Settings -> Sales Settings -> Organisation Documents -> +New
...
If you do not want to include customer group discounts in your commissions you can use column I11, Create a Vlookup to lookup the discount group and discount % and minus the customer discount from your discount% in column B11.
*NB Disregard all other information on this Excel Tab After D (this is imported to give an example on how the commission will calculate)
...
- Cell F4 and down is where the commission % is added in
IE: for Rollers (ROLL) with 6% to 15% discount a commission of 10% is given (see the grid below)
The % is found in the Calculations Tab but it is not necessary, an equation can be set in in Commission tab in column M11
...
When calculating the commissions the below fields are populated in the spreadsheet as per description
| Field | Description | |
|---|---|---|
| Unit Cost | This is a single item and is not multiplied by the QTY | If you use Unit cost in your formula and your products include QTY then you will need to edit your formula to multiple the unit cost by the QTY |
| RRP | The RRP column is either inc or ex GST depending on the setup of pricing. This is a single item and is not multiplied by the QTY | If you use RRP in your formula and your products include QTY then you will need to edit your formula to multiple the RRP by the QTY |
| Amt | Amount is ex GST | |
| Discount | Discount is ex GST |
Commission Report
Sales Analysis will show the commission in the last column the the RHS
Editing the commission manually
...
- Write a note on this if you wish to be recorded in the log
- Update
** If you edit any part of the order after a manual commission change then all adjustments done manually will be removed **.
...
Generic commissions including both discounts_Commissions_BUZ_.xlsm
View file name Commission Setup.pdf height 250