Page Comparison

...

The BUZ commission module calculates the commission on a order line item by order line basis, different commission percentages for Inventory Group and discount percentage off RRP the discount is a combination of Customer Discount and the casual discount given by the rep in entering the order. Alternatively commission can be calculated on GP for each line item.

...

Table of Contents

indent	Circle
exclude	Overview

Commission Calculation

Commissions calculated on discounted value

Each product is setup with commission paid depending on the discount applied to the order

Example If a Blind is discounted between;

0-5% xx% commission is paid

5-15% xx% commission is paid

16-25% x% commission is paid

26% > 0% commission paid

Each line items discount is calculated as a "variance" (the discount includes Customer Group discounts and discounts applied to the total value of the order)

The variance will fall under 1 of the above discount tiers, and the commission is applied to that line item according to the tier.

Commissions calculated on GP

Each product is setup with commission paid depending on the GP of the order

Example If a Blinds GP is between;

39% > xx% commission is paid

36-38% xx% commission is paid

32-35% x% commission is paid

29% x% commission paid

< 29% 0 Commission is paid

Each line items GP is calculated depending on the cost and price of the product, the GP will fall under one of the above tiers and the commission is applied to that line item according to the tier

Commission setup

Settings -> Sales Settings -> Organisation Documents -> +New

Download the Commission Template File

This will give you a template with the formulas setup to calculate commission on discount

In Tab Commissionsyou can edit the below formulas to Calculate the commission accordingly

- Cell J11 you can enter a formula to calculate the commission

...

*NB Disregard all other information on this Excel Tab prior to column J (this is imported to give an example on how the commission will calculate)

In Tab Calculations

- Cell C4 and down is where you have your Inventory Group Codes

- Cell D4 and down is where you have the % Discount- Cell E4 D4 and down is where the discount changes the commission, this discount is entered 100 + 6 will give you 6% (it is set this way to accommodate the times you are adding to the price)

- Cell E4 and down is formulated to give you Inventory code plus Discount

- Cell F4 and down is where the commission % is add added in

IE: for Rollers (ROLL) with 6% to 16% 15% discount a commission of 10% is given in (see the grid below)

The % is found in the Calculations Tab but it is not necessary, an equations equation can be set in in Commission tab in column M11

These must be in C D E and F columns

Quote and Ordering whenever you add an item or edit and item the commission is calculated

Commission Report

Sales Analysis will show the commission in the last column the the RHS

...

** If you edit any part of the order after a manual commission change then all adjustments done manually will be removed **.

Commission Calculation Commissions calculated on discounted order value.

Each product is setup with commission paid depending on the discount applied to the order

Example If a Blind is discounted between;

0-5% > xx% commission is paid

5-15% > xx% commission is paid

16-25% > x% commission is paid

26% plus > 0% commission paid