Ladder of Invoice (Product) - Percentage

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

Like the “Ladder of Invoice” type, the commission is calculated according to the product value ladder

Calculate commission based on Percentage + Total Invoice amount 

  1. Choose Percentage 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(%)

  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(%): commission will be received = percentage of invoice value by ladder.
    *Note: In case the product value in the invoice exceeds the maximum value (To amount) set in the program, the commission will be charged only 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 Invoice = $ 40,160.40 
    Total Value = $ 36030.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] = Amount [Citrus Bergamot] * 1% = 40.198470676 * 0.01 = 0.40198470676


    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+] = Amount [Synology DS920+] * 2% = 437.805126186 * 0.02 = 8.75610252372

    Total  Commission
     = Commission [ Citrus Bergamot] +  Commission [Synology DS920+] =0.40198470676+ 8.75610252372= 9.15808723048( round to 9.16)


    Calculate commission based on Percentage + Profit

    1. Choose Percentage 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(%)

    5. Profit = Sale price - Purchase price
      *Note*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 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 Invoice = $ 40,160.40 
      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] = Amount [Citrus Bergamot] * 1% = 0.39800465979*0.01 = 0.00398004659

      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+] = Amount [Synology DS920+] * 2% = 39.800466158 *0.02 = 0.79600932031

      Total  Commission
      Commission [ Citrus Bergamot] +  Commission [Synology DS920+] =0.00398004659 + 0.79600932031 = 0.7960093203 ( round to 0.80)

Views: 186

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