Ladder of Invoice (Product) - Fixed

  • Last Created On Jun 13, 2023
  • 109
0 0

Calculate commission based on Fixed + Total Invoice amount 

  1. Choose Fixed option under Commission type.
  2. Choose Total Invoice amount under 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. 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..
  6. Go to Applicable staff menu under Commission module from the left sidebar and assign this program to employee.
  7. Create an invoice and select the sales agent as on of the employees assigned to the program.
  8. 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.

Calculate commission based on Fixed + Profit 

  1. Choose Fixed option under Commission type
  2. Choose Profit under 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. 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 product profit ladder.
    *Notein case the total product profit in the invoice exceeds the maximum value (To amount) set in the program, only commission in the configured amount.
  6. Go to Applicable staff menu under Commission module from the left sidebar and assign this program to employee.
  7. Create an invoice and select the sales agent as on of the employees assigned to the program.
  8. 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

Views: 109

Recent Articles

  • Google Analytics Dashboard
    7
  • Customizing the metric view in Google An...
    7
  • Connect your Google account
    6
  • Workspaces Management
    7
  • Connect your Youtube account and Sync da...
    22

Popular Articles

  • Warehouse
    681
  • Mapping Setup
    542
  • Item Settings
    519
  • General Accounting Settings
    500
  • Inventory Receiving Voucher
    422