Automating Multi-Channel Commission Payouts for a Driver-Sourcing Network

To grow its driver-partner base, the company sources new drivers through several parallel channels — third-party sourcing vendors, in-house field sales staff, franchise partners running physical onboarding centers, and rural-market-focused vendors — each earning commission at rates that vary by city, performance tier, vehicle model, and product type.

Calculating this by hand each week across multiple channels and a multi-dimensional rate structure was slow and error-prone: the manual process took three to four days each cycle, and any change to the underlying rate card risked breaking whatever manual process was in place.

TopN Analytics built an automated commission-payout engine that classifies each vendor into a performance tier — based on conversion volume, with a separate override for franchise partners — then looks up the correct payout rate through channel-specific logic: a bucketed rate table for standard leasing/EV conversions, a flat per-city rate for a drive-to-own product line, a model-and-year-based rate for another product, and an entirely distinct table for franchise partners.

On top of the per-conversion rate, a weekly milestone bonus rewards vendors who clear a volume threshold, with documented city-specific carve-outs. When the rate card was redesigned partway through the year, the engine was built with an explicit date-based cutover so historical calculations using the old structure remain correct alongside new ones using the redesigned rates.