The brief
Every month, one person at the agency lost half a day to commission calculations.
- 5 hours of work pulling sales data, copying it to spreadsheets, and running the maths for each rep.
- Errors and mismatches only showed up after hours of manual checking.
- Sales reps had zero visibility into their own commissions until the email arrived.
The work was slow, error-prone, and unpaid for everyone except the operator stuck doing it.
What we built
We replaced the entire workflow.
Before: Manual collection of sales data → copy to spreadsheet → manual commission calculation per rep → spot-check errors and fix mismatches → email each rep their breakdown.
After: Auto-pull sales data from the CRM → commissions calculated in real time → individual sheet auto-generated per rep with validation → live commission visibility on each rep’s CRM dashboard.
The operator stopped being the calculator. They became the reviewer.
The results
- 98% time saved. 5 hours a month down to 5 minutes.
- End-to-end automated. Pull, calculate, generate, distribute.
- Individual Excel sheets auto-generated for every rep.
- Live commission dashboards so every rep sees their numbers in real time.
- Errors gone — validation runs on every calculation.
What changed for the team
Reps stopped chasing the operator for updates. The operator stopped being the bottleneck. Commissions stopped being a source of disputes.
The system runs in the background. Everyone gets paid right, on time, with the workings out visible.