Calculate commission based on Fixed + Total Invoice amount
- Choose Fixed option under Commission type.
- Choose Total Invoice amount under Amount to calculate.
- Choose Ladder of Product (Product) option under Commission policy type.
- Choose Product, enter the From amount, To amount and Commission(Fixed)
From amount: Enter the minimum value of the product in the invoice step by step. If this field is left blank, there is no minimum value limit.
To amount: Enter the maximum value of the product in the invoice in increments. If this field is left blank, there is no maximum value limit.
Commission(%): fixed commission will be received according to the product value ladder.
*Note: in case the total product profit in the invoice exceeds the maximum value (To amount) set in the program, only commission in the configured amount..- Go to Applicable staff menu under Commission module from the left sidebar and assign this program to employee.
- Create an invoice and select the sales agent as on of the employees assigned to the program.
- Create payment
Ex:
There is 1 Invoice with 2 products 'Citrus Bergamot' with total value = $3030 , product 'Synology DS920+' with the total value = $33000. Based on the above setting, we will calculate:
Total Tax = 3,234.00 + 1,617.00 = $4851.00
Total Invocie = $40,160.00
Total Payment = $606.00
Payment Percent = Total Payment/ Total Invoice = 606.00 / 40,160.40 = 0.01508949114 (Percentage of the amount paid)
Payment amount = [ Total Payment - ( Total Tax * Payment Percent) ] = [ 606.00 - (4851.00 * 0.01508949114) ] = 532.80087848 (Amount to calculate commission is based on total payment)
Citrus Bergamot:
Payment Percent [Citrus Bergamot] = 3030 / 40,160.40 =0.0754474557 (Percent of Citrus Bergamot's profit to total profit)
Amount [Citrus Bergamot] = Payment amount * Payment Percent [Citrus Bergamot] = 532.80087848 * 0.0754474557 =40.198470676 (amount to calculate commission for Citrus Bergamot)
Commission [ Citrus Bergamot] = $1
- Synology DS920+:
Payment Percent [Synology DS920+] = 33000 / 40,160.40 = 0.82170496309 (Percent of Synology DS920+'s profit to total profit)
Amount [Synology DS920+] = Payment amount * Payment Percent [Synology DS920+] = 532.80087848 * 0.82170496309= 437.805126186( amount to calculate commission for Synology DS920+)
Commission [Synology DS920+] = $2
Total Commission = Commission [ Citrus Bergamot] + Commission [Synology DS920+] =1+ 2= $3.
To amount: Enter the maximum value of the product in the invoice in increments. If this field is left blank, there is no maximum value limit.
Commission(%): fixed commission will be received according to the product value ladder.
*Note: in case the total product profit in the invoice exceeds the maximum value (To amount) set in the program, only commission in the configured amount..
Ex:
There is 1 Invoice with 2 products 'Citrus Bergamot' with total value = $3030 , product 'Synology DS920+' with the total value = $33000. Based on the above setting, we will calculate:
Total Tax = 3,234.00 + 1,617.00 = $4851.00
Total Invocie = $40,160.00
Total Payment = $606.00
Payment Percent = Total Payment/ Total Invoice = 606.00 / 40,160.40 = 0.01508949114 (Percentage of the amount paid)
Payment amount = [ Total Payment - ( Total Tax * Payment Percent) ] = [ 606.00 - (4851.00 * 0.01508949114) ] = 532.80087848 (Amount to calculate commission is based on total payment)
Citrus Bergamot:
Payment Percent [Citrus Bergamot] = 3030 / 40,160.40 =0.0754474557 (Percent of Citrus Bergamot's profit to total profit) Amount [Citrus Bergamot] = Payment amount * Payment Percent [Citrus Bergamot] = 532.80087848 * 0.0754474557 =40.198470676 (amount to calculate commission for Citrus Bergamot)
Commission [ Citrus Bergamot] = $1
- Synology DS920+:
Payment Percent [Synology DS920+] = 33000 / 40,160.40 = 0.82170496309 (Percent of Synology DS920+'s profit to total profit)
Amount [Synology DS920+] = Payment amount * Payment Percent [Synology DS920+] = 532.80087848 * 0.82170496309= 437.805126186( amount to calculate commission for Synology DS920+)
Commission [Synology DS920+] = $2Total Commission = Commission [ Citrus Bergamot] + Commission [Synology DS920+] =1+ 2= $3.
Calculate commission based on Fixed + Profit
- Choose Fixed option under Commission type
- Choose Profit under Amount to calculate.
- Choose Ladder of Product (Product) option under Commission policy type.
- Choose Product, enter the From amount, To amount and Commission(Fixed)
- Go to Applicable staff menu under Commission module from the left sidebar and assign this program to employee.
- Create an invoice and select the sales agent as on of the employees assigned to the program.
- Create payment
Ex:
There is 1 Invoice with 2 products 'Citrus Bergamot' with total profit= $30.00 , product 'Synology DS920+' with the total profit = $3000.00 Based on the above setting, we will calculate:Total Tax = 3,234.00 + 1,617.00 = $4851.00
Total Invocie = $40,160.00
Total Profit = $3030.00
Total Payment = $606.00
Payment Percent = Total Payment / Total Invoice = 606.00 / 40,160.40 = 0.01508949114 (Percentage of the amount paid)Profit Percent = Total Profit / Total Invoice = 3030.00 / 40,160.40 = 0.0754474557 (Percentage of profit to total invoice)
Payment amount = [ Total Payment - ( Total Tax * Payment Percent) ] * Profit Percent = [ 606.00 - (4851.00 * 0.01508949114) ]* 0.0754474557 = 40.19847067603 (Amount to calculate commission is based on total payment)
Citrus Bergamot:Profit Percent [Citrus Bergamot] = 30.00 / 3030.00 = .00990099009 (Percent of Citrus Bergamot's profit to total profit)
Amount [Citrus Bergamot] = Payment amount * Profit Percent [Citrus Bergamot] = 40.19847067603 * 0.0099009909 = 0.39800465979 (amount to calculate commission for Citrus Bergamot)
Commission [ Citrus Bergamot] = $1
Synology DS920+:Profit Percent [Synology DS920+] = 3000/3030 = 0.9900990099 (Percent of Synology DS920+'s profit to total profit)
Amount [Synology DS920+] = Payment amount * Profit Percent [Synology DS920+] = 40.198470676 * 0.9900990099= 39.8004660158 ( amount to calculate commission for Synology DS920+)
Commission [Synology DS920+] = $2
Total Commission = Commission [ Citrus Bergamot] + Commission [Synology DS920+] = 1 + 2 = $3
To amount: Enter the maximum value of the product in the invoice in increments. If this field is left blank, there is no maximum value limit.
Commission(%): fixed commission will be received according to product profit ladder.
*Note: in case the total product profit in the invoice exceeds the maximum value (To amount) set in the program, only commission in the configured amount.