Employee Product Sales & Commission Report – Complete Guide for Performance & Earnings Analysis

A structured reporting module designed to analyse product-wise sales handled by each employee and calculate commission earnings accurately.

The Employee Product Sales & Commission Report in O2VEND ERP provides a consolidated view of:

  • Product-wise sales completed by employees
  • SKU and category-level contribution
  • Quantity sold and order totals
  • Employee-specific commission earnings
  • Branch-level performance comparison

This report is essential for retail, distribution, and service-based businesses that require transparent earnings tracking and productivity evaluation.

Purpose of the Report

The module is built to give organisations clarity on:

  • Products sold by each employee
  • Commission calculations based on organisation rules
  • Category-wise performance
  • Branch-level and consolidated sales activity
  • Order-wise contribution and revenue
  • Quantity movement per employee

This ensures transparent evaluation, fair incentive distribution, and accurate audit tracking.

O2VEND Back Office → Reports → Sales and purchase → Employee Product Sales & Commission Report.

This opens a tabular view powered by filters and export features.

Report Filters & Parameters

1. Branch / Consolidated View

Allows selection of:

  • A specific branch
  • All branches combined (Consolidated)

Ideal for multi-location businesses.

2. Date Range

Defines the time period for sales and commission activity.

Supports:

  • Single day
  • Weekly
  • Monthly
  • Custom date selections

3. Employee

Filters results for a specific staff member.

4. Export Options

Exports the full dataset in:

  • Excel
  • CSV

Useful for HR, audit teams, and financial reconciliation.

Column-Wise Breakdown

1. EmployeeCode

Unique employee identifier used for HR and system mapping.

2. FullName

Displays the employee’s registered name.

3. ProductName

Name of the product sold by the employee.

4. ProductSKU

The SKU associated with the product—for stock, sales, and inventory mapping.

5. CategoryNames

Product category (Category1, Accessories, Apparel, etc.).
Useful for category-level sales analysis.

6. OrderNumber

Unique reference for the transaction in which the product was sold.

7. CreatedOn

Timestamp of when the sale occurred.

8. QuantitySold

Total quantity of the specific product sold in that order.

9. OrderTotal

Final bill amount including tax, discounts, and charges.

10. Commission

Commission amount earned by the employee for that product sale.
This value is auto-calculated based on:

  • Fixed amount rules
  • Percentage-based incentive rules
  • Product-wise custom commission rules (if configured)

Understanding the Report Insights

Product Contribution

Indicates which products generate higher sales through specific employees.

Category Strength

Helps identify which product categories employees perform best in.

Commission Earnings Summary

Direct link between employee effort and incentive earnings.

Revenue Distribution

Shows revenue generated per employee based on orders handled.

SKU-Level Traceability

Useful for validating stock movement and avoiding discrepancies.

Practical Use Cases

1. Commission Payout Processing

Finance and HR teams use this report to compute monthly incentives.

2. Employee Performance Assessment

Tracks how effectively employees sell specific products or categories.

3. Inventory & SKU Analysis

Shows which employees drive movement of high-demand products.

4. Branch Comparison

A consolidated view highlights which location delivers better product sales.

5. Audit & Validation

Cross-verifies:

  • Order numbers
  • Quantities sold
  • Commission claims
  • Date/time of sales

Exporting the Report

Exports are available for:

  • Payroll processing
  • Incentive sheet preparation
  • Documented monthly reviews
  • Audit verification
  • Multi-branch performance presentations