Commission Calculator

Sales Incentive Optimization Tool

Role

Product Manager

Commission Calculator - Image 1

Overview

An internal commission tracking and calculation system designed to help the sales team track individual and team targets while automating commission payouts.

Why was it built?

  • Manual commission calculations were time-consuming and error-prone.
  • No visibility into personal and team performance metrics.
  • Complex commission structures were difficult to track.

The product

It was developed using TypeScript with the Next.js framework. The tool integrates with Pipedrive (the company's CRM) via API. The database is PostgreSQL, and the entire system is containerized using Docker for scalability and deployment efficiency.

What I did

  • Conducted user interviews to define pain points and requirements.
  • Designed an automated commission tracking tool with real-time calculations and collaborated with developers to ensure accurate logic.
  • Designed and implemented API integration with Pipedrive to sync sales data in real-time.
  • Integrated team and individual sales goal tracking.
  • Implemented a portal for progress checking.
  • Led User Acceptance Testing and iterated based on feedback.
  • Implemented a settings screen for the accounting department to adjust team and personal targets.

Results

  • Reduced calculation errors by 85%.
  • Decreased commission processing time from 3 days to under 2 hours per cycle.
  • Reduced manual data entry.