Commission Plan Maintenance

Top  Previous  Next

 

Commission Plan Maintenance is the most important part of this commission Plug-Ins. Here you may maintain several commission plans to calculate commission in different combinations for various type of sales agents.

 

Go to Sales Commission Report > Commission Plan Maintenance,

 

To add a new commission plan, click on New,

 

 

To add a new payment collection rate scheme, click on New,

 

 

Commission11

 

 

 

 

Possible Commission Plan Combinations

 

Generally, it is all about 2 formulas:

 

Formula 1: to calculate Total Sales Commission a sales agent entitled to. Basically, Total Sales Commission = Total Sales x Commission Rate.

 
There are 2 ways to determine Total Sales amount entitled for commission calculation, each has 4 options of 'commission Rate':
 

(1) By Sales Document (means to use the bill's total amount, all items are counted). There are 4 options for Commission Rate:

a. Using a flat rate, regardless of Sales amount;

b. Using a pre-maintained Sales Document Rate
c. Using a pre-maintained Entitlement Rate;

d. Using both pre-maintained Sales Document Rate and Entitlement Rate.

 

(2) By Item (means to use the item's subtotal amount, not all items are counted). There are 4 options for Commission Rate:

a. Using a flat rate, regardless of Sales amount;

b. Using a pre-maintained Item Rate;
c. Using a pre-maintained Entitlement Rate;

d. Using both pre-maintained Item Rate and Entitlement Rate.

 

Formula 2: continue from Formula 1, this Formula will determine how much commission is finally earned. There are 3 ways:

 

(1) By Sales (Commission is considered earned when sales took place, regardless of collection and payment; In this case, the Total Sales Commission calculated from Formula 1 is the same as Earned Commission, there for, Formula 2 is not needed.

 

(2) Fully Payment (commission is earned only when full payment has been received). There are 2 possibilities:

a. Normal Full Payment.... not depending on collection period;

b. Full Payment + Payment Collection Rate ... e.g. if the full payment is collected within 30 days, the earned commission will be 100% of Total Sales Commission; longer than 30 days the earned commission will reduce to 50% or even 0%..)

(3) Partial Payment (commission is earned even only partial payment has been received). There are 2 possibilities:

a. Normal Partial Payment.... not depending on collection period;

b. Partial Payment + Payment Collection Rate ... e.g. if the partial payment is collected within 30 days, the earned commission will be 100% of the proportioned Sales Commission; longer than 30 days the earned commission will reduce to 50% or even 0%..)

 

* The flexibility is that you may set any rate deemed appropriate and make use of formula to rationalise it, especially when combining Entitlement Rate with  Sales Document Rate or Item Rate.

 

 

 

Formula 1

calculate $TotalSalesCommission

choose the Commission Calculation Type, either

By Sales Document or By Item

Formula 2

calculate final Earned Commission

depends on Payment Type, either By Sales, Partial Payment or Full Payment

By Sales Document (based on bill's total) 4 options:

 

1 - Using Flat Rate

$SalesDocTotal * 2.5/100
e.g. 3,000 x 2.5/100 = 75.00

 

$SalesDocTotal * 0.04
e.g. 3,000 x 0.04 = 120.00

 

$SalesDocTotal * 3/1000
e.g. 3,000 x 3/1000 = 9.00

 

By Sales

No calculation/formula needed. F2 is barred.

Earned Commission = $TotalSalesCommission (not depending on collection)

 

 

 

 

Full Payment (earned only after full payment)

 

1 – Normal Full Payment

$Payment / $SalesDocTotal * $TotalSalesCommission

e.g. 3,000/3,000 * 96.00 = 96.00

(assuming $TotalSalesCommission is 96.00)

 

2 – Full Payment + Payment Collection Rate

$Payment / $SalesDocTotal * $TotalSalesCommission * $CollectionRate

e.g. 3,000/3,000 * 96.00 * 50% = 48.00

(assuming $TotalSalesCommission is 96.00, and $CollectionRate is 50%)

 

 

Partial Payment (earned before full payment)

1 – Normal Partial Payment

$Payment / $SalesDocTotal * $TotalSalesCommission

e.g. 1,500/3,000 * 96.00 = 48.00

(assuming $TotalSalesCommission is 96.00)

 

2 – Partial Payment + Payment Collection Rate

$Payment / $SalesDocTotal * $TotalSalesCommission * $CollectionRate

e.g. 1,500/3,000 * 96.00 * 50% = 24.00

(assuming $TotalSalesCommission is 96.00, and $CollectionRate is 50%)

2 - Using Sales Document Rate

$SalesDocTotal * $SalesDocRate2/10
e.g. 3,000 x 3.2/10 = 960.00

 

$SalesDocTotal * $SalesDocRate2/100
e.g. 3,000 x 3.2/100 = 96.00

 

$SalesDocTotal * $SalesDocRate2/1000
e.g. 3,000 x 3.2/100 = 9.60

 

3 - Using Entitlement Rate

$SalesDocTotal
e.g. 3,000 x 2% = 60.00

 

4 - Using Sales Document Rate + Entitlement Rate

$SalesDocTotal * $SalesDocRate1
e.g.  3,000 x 3.0 x 2% = 180.00

 

$SalesDocTotal * $SalesDocRate1
e.g.  3,000 x 3.0/100 x 80% = 72.00

(if entitlement rate set to 80%)

By Item (based on item's subtotal) 4 options:

 

1 - Using Flat Rate

$SubTotal * 2.55/100
e.g. 3,000 x 2.55/100 = 76.50

 

$SubTotal * 0.04
e.g. 3,000 x 0.04 = 120.00

 

$SubTotal * 3/1000
e.g. 3,000 x 3/1000 = 9.00

 

2 - Using Item Rate

$SubTotal * $ItemRate2/100

e.g.  3,000 x 4.0000/100 = 120.00

 

$SubTotal * $ItemRate2/1000
e.g. 3,000 x 4.0000/1000 = 12.00

 

3 - Using Entitlement Rate

$SubTotal

e.g. 3,000 x 2% = 60.00

4 - Using Item Rate + Entitlement Rate

$SubTotal * $ItemRate2/100

e.g. 3,000 x 4/100 x 2% =  2.40

 

$SubTotal * $ItemRate2/100
e.g.  3,000 x 4/100 x 50% = 60.00

(if entitlement rate set to 50%)

 

$SubTotal = item’s subtotal

$Qty * $UnitPrice = same as item’s subtotal but excluding discount.

 

 

 

 

 

Sample Commission Plan 1:

- Calculate commission based on: Sales Document Bill Total

- Using a flat commission rate for any sales amount

- Commission is paid By Sales (as long as Sales Document is issued, not depending on collection).

 

CommissionPlan01

 

 

 

 

Sample Commission Plan 2:

- Calculate commission based on: Sales Document Bill Total

- Using a pre-maintained Sales Document Rate

- Commission is paid By Sales (as long as Sales Document is issued, not depending on collection)

 

CommissionPlan02

 

 

 

 

 

Sample Commission Plan 3:

- Calculate commission based on: Sales Document Bill Total

- Using a pre-maintained Monthly Entitlement Rate

- Commission is paid By Sales (as long as Sales Document is issued, not depending on collection)

 

CommissionPlan03

 

 

 

 

 

Sample Commission Plan 4:

- Calculate commission based on: Sales Document Bill Total

- Using a pre-maintained Sales Document Rate and Monthly Entitlement Rate

- Commission is paid By Sales (as long as Sales Document is issued, not depending on collection)

 

CommissionPlan04

 

 

 

 

 

 

Sample Commission Plan 5:

- Calculate commission based on: By Item subtotal

- Using a flat rate

- Commission is paid By Sales (as long as Sales Document is issued, not depending on collection)

 

CommissionPlan05

 

 

 

 

 

Sample Commission Plan 6:

- Calculate commission based on: By Item subtotal

- Using a pre-maintained Item Rate

- Commission is paid By Sales (as long as Sales Document is issued, not depending on collection)

 

CommissionPlan06

 

 

 

 

 

Sample Commission Plan 7:

- Calculate commission based on: By Item subtotal

- Using a pre-maintained Monthly Entitlement Rate

- Commission is paid By Sales (as long as Sales Document is issued, not depending on collection)

 

CommissionPlan07

 

 

 

 

 

Sample Commission Plan 8:

- Calculate commission based on: By Item subtotal

- Using a pre-maintained Item Rate and Monthly Entitlement Rate

- Commission is paid By Sales (as long as Sales Document is issued, not depending on collection)

 

CommissionPlan08

 

 

 

 

 

Sample Commission Plan 9:

- Calculate commission based on: By Sales Document bill total

- Using a pre-maintained Sales Document Rate

- Commission is paid only when full payment is received, but not depending on payment collection date

 

CommissionPlan09

 

 

 

 

 

Sample Commission Plan 10:

- Calculate commission based on: By Sales Document bill total

- Using a pre-maintained Sales Document Rate

- Commission is paid only when full payment is received and also depending on payment collection date

 

CommissionPlan10

 

 

 

 

 

Sample Commission Plan 11:

- Calculate commission based on: By Sales Document bill total

- Using a pre-maintained Sales Document Rate

- Commission is paid even though only partial payment is received but depending on payment collection date

 

CommissionPlan11

 

 

 

 

 

_____________________________________________________________

Send feedback about this topic to AutoCount. peter@autocountSoft.com

© 2013 Auto Count Sdn Bhd - Peter Tan. All rights reserved.