Guide: Ladder of Invoice (Product) - Fixed

Ladder of Invoice (Product) - Fixed

Calculate commission based on Fixed + Total Invoice amount

Choose Fixedoption under Commission type.Choose Total Invoice amountunder 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 staffmenuunder Commissionmodule from the left sidebarand 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.00Total Invocie = $40,160.00Total Payment = $606.00Payment 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] = $1Synology 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.

1. Choose Fixedoption under Commission type.
2. Choose Total Invoice amountunder Amount to calculate.
3. Choose Ladder of Product (Product) option under Commission policy type.
4. Choose Product, enter the From amount, To amount and Commission (Fixed)
5. Go to Applicable staffmenuunder Commissionmodule from the left sidebarand assign this program to employee.
6. Create an invoice and select the sales agent as on of the employees assigned to the program.
7. 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.00Total Invocie = $40,160.00Total Payment = $606.00Payment 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] = $1Synology 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.

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

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.

Total  Commission=Commission [ Citrus Bergamot]+Commission[Synology DS920+] =1+ 2= $3.

Calculate commission based on Fixed + Profit

1. Choose Fixedoption under Commission type
2. Choose Profitunder Amount to calculate.
3. Choose Ladder of Product (Product) option under Commission policy type.
4. Choose Product, enter the From amount, To amount and Commission (Fixed)
5. Go to Applicable staffmenuunder Commissionmodule from the left sidebarand assign this program to employee.
6. Create an invoice and select the sales agent as on of the employees assigned to the program.
7. 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.00Total Invocie = $40,160.00Total Profit = $3030.00Total Payment = $606.00Payment 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] = $1Synology 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+]= $2Total  Commission=Commission [ Citrus Bergamot]+Commission[Synology DS920+] = 1 + 2 = $3

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