sales_commission_by_range

Sales Commissions with Amount Ranges by Sales/Invoice/Payment

This module provide feature to manage Sales Commissions with Amount Ranges by Sales/Invoice/Payment.


This module allow company to manage sales commission with different options. You can configure after installing module what option/policy your company is following to give commissions to your sales users.
We are allowing you to select When to Pay and Calculation based on . Here you can define policy which will be used to give commission to your sales team.

For every Calculation based on we are allowing you to select:

  • Sales Manager Commission %
  • Sales Person Commission %

And it will also allow you to have sales total ranges and give percentage based on that ranges. For example $1 to $5000 Sales will have Sales Manager Commission = 10% and Sales Person Commission = 15% and $5001 to $20000 Sales will have Sales Manager Commission = 15% and Sales Person Commission = 25% and so on.

Note: If you have configuration by ranges then it will be consider as first preference but if you do not have configuration in by ranges then it will take field of Sales Manager Commission % and 2. Sales Person Commission %. So system is very flexible which allow you to setup your own flow.

If you keep Sales Manager Commission 0% then system will not create sales commission lines and sales commission worksheet. System will work only with single option at time ie for example you can select When to Pay = Invoice confirm and calculation based on = Product category so system will run on that and create commission.

Please note that When to Pay = Customer payment is only supported with Calculation based on Sales Team. - Other options are supported in matrix.


Workflow will be:

    Option1 :Sales Confirmation -> Create Sales commission worksheet (if not created for current month) -> Add Sales commission lines on worksheet -> For every sales of current month, system will append sales commission lines on worksheet. -> End of month Accouant may review worksheet and create commision invoice to pay/release commision to sales person.

    Option2 : Invoice Validate -> Create Sales commission worksheet (if not created for current month) -> Add Sales commission lines on worksheet -> For every invoice validation of current month, system will append sales commission lines on worksheet. -> End of month Accouant may review worksheet and create commision invoice to pay/release commision to sales person.

    Option3 : Customer Payment -> Create Sales commission worksheet (if not created for current month) -> Add Sales commission lines on worksheet -> For every payment from customer of current month, system will append sales commission lines on worksheet. -> End of month Accouant may review worksheet and create commision invoice to pay/release commision to sales person.

Commission to sales person always will be in company currency. Multi currency is supported for this module so sales order/ invoice / payment can be in different currency but system will take care for it and create commission lines in company currency.

Sales Commission product is created using data and you still can change commission product on commission worksheet to create commission invoice.
Commission amount will be based on Net Revenue Model where it consider amounts without taxes. (This module does not support Gross Margin Model)


Menu Items:

  • Invoicing/Commissions
    • Invoicing/Commissions/Commission Worksheets
    • Invoicing/Commissions/Sales Commissions Lines
  • Sales/Commissions
    • Sales/Commissions/Commission Worksheets
    • Sales/Commissions/Sales Commissions Lines

Check App Here

sale_service_purchase