Do you apply a commission system for every product sold? If you do so, then you can set up commissions on product details and assign Sales Person when creating sales transactions, so that later it will generate reports related to commissions received by salespersons based on products sold. For details on how to access the report, you can see the explanation below. There are a variety of report views available when entering the commission report menu and each menu/display has been provided for exporting data.
I. Commission Report by Order Summary
Step 1. Go to Reports, then Choose Tab Person
Notes :
This view will give you the commission report information for all employees.
Step 2. Filter Report as Needed (Optional)
II. Commission Report by Employee
Step 1. Go to Reports, Choose Tab Person, then Select By Employee Button
Step 2. Commission Report by Person was Opened
Notes :
This view will give you the commission report information for all employees separated by each employee.
Step 3. Filter Report as Needed (Optional)
III. Commission Report Detail
Step 1. Go to Reports, Choose Tab Person, then Select By Employee Button
Step 2. Select View Detail
Step 3. Sales Commission Report Detail was Opened
Notes :
This view will give you the commission report information for all employees with the transaction details (Invoice Number, Product Name, etc)
Step 4. Filter Report as Needed (Optional)
IV. Commission Report by Item
Step 1. Go to Reports, Choose Tab Person, then Select By Item Button
Step 2. Commission Report by Item was Opened
Notes :
This view will give you the commission report information for all employees with total orders & item quantity.
Step 3. Filter Report as Needed (Optional)
Table Properties :
By Order Summary | Description |
Sales Person | Sales Person Name |
Orders | Total Invoice |
Quantity | The total quantity of products sold |
Sales | Total sales in currency |
Tax | Total tax in currency |
Sales + Tax | Total sales & tax in currency |
Cost | Total cost in currency |
Profit | Total profit in currency |
By Employee | Description |
Product | Product Name Sold by Employee |
Quantity (QTY) | Quantity of Products sold |
Sales | Total sales in currency |
Commission | Commission in currency |
Total | Quantity*Commission = Total Commission in currency |
By Detail | Description |
Date | Date of Transaction |
Outlet | Name of Outlet |
Number | Number of Transaction |
Name | Product Name |
Sales Person | Sales Person Name |
Quantity | Quantity of Products sold |
Commission | Commission in currency |
Total | Quantity*Commission = Total Commission in currency |
By Item | Description |
Sales Person | Sales Person Name |
Orders | Total Invoice |
Items Quantity | Total products sold |
Gross Revenue | Total gross revenue |
Product Commission | Total product commission |
Related Articles:
To add commission on products, check out these articles: How to Add Product Commission
Does your business have several types of sales? (Example: Online & Offline Sales) You can check performance by type of sales, please check this article for a more detailed explanation: Report Based on Sales Order Type
If you want to see a sales report with the most sold products, maybe you can check the steps in this article Reports Product Sold
To see reports of customers who make transactions the most, you can check this article: Report Top Customer
