It Took 20 Days to Calculate Payroll. Reps Didn't Know What They Earned Until Half the Month Was Gone.

The Setup

A wellness-coaching company doing roughly $30M/year in revenue. Fifty sales reps — a mix of setters and closers — running on a high-ticket offer with commission rules that changed by role, by tenure, and by offer type. The ops lead was respected, sharp, and drowning.

The Problem

Payroll closed on the 20th. Reps didn't know what they'd earned until the month was already half over.

The numbers were right. Usually. But the ops lead spent four days every month reconciling five separate spreadsheets — one from the CRM, one from Stripe, one from the setter commission template, one from the closer template, and one from the bonus-pool override. Three people had to agree on every number. Every month, at least one rep disputed a number that turned out to be correct. Every month, at least one number turned out to be wrong and nobody caught it until the rep pushed.

The CEO knew payroll was a problem. He didn't know how much it was costing him in rep trust until we showed him the dispute log.

What We Found

When we pulled the historical commission data into one place, two things became obvious.

First, about 3% of monthly commission payouts were incorrect — in both directions. Overpayments and underpayments roughly canceled out, but the pattern was random. That's worse than a consistent bias: reps were being overpaid one month and underpaid the next with no way to predict which.

Second, the single source of truth didn't exist. The CRM said one thing about a deal. Stripe said another because of a refund the CRM hadn't been updated to reflect. The commission spreadsheet said a third thing because it was calculated before the refund posted. Every commission cycle, three people were reconciling three versions of the truth by hand.

What We Built

We built a commission engine that pulls from the CRM and the payment processor on a daily schedule, applies the commission rules per rep, handles refund clawbacks and chargebacks automatically, and generates a per-rep statement that lands in their inbox on the 1st.

The rules themselves — role-based splits, tenure bonuses, offer-specific overrides, bonus-pool thresholds — live in a single configuration the CEO and the ops lead can edit without touching spreadsheets. When a new offer launches, the commission logic gets updated once. Not in five places.

The dispute workflow is built in. If a rep flags a number, the system shows them the exact deals behind it, including refund status. Most disputes resolve before they hit the ops lead.

The After

The commission cycle dropped from 20 days to 1. Reps see the number on the 1st. The ops lead's four-day monthly reconciliation disappeared.

In the twelve months after we went live, there were zero commission disputes that required manual reconciliation. The CEO stopped being the escalation path for payroll. The ops lead got her fourth week of every month back. Rep retention, measured by 12-month tenure among closers hired after the system went live, is up 18%.

Closing

This client has been on retainer with us for four years. We've rebuilt the commission model twice as the business added offers and restructured the rep tiers. The engine itself hasn't broken once.