// blog — Oct 1, 2026

Tai Software: From a Fragile Spreadsheet to a Governed Commission System — Live in Six Weeks

How Tai Software retired a 19-tab commission workbook — and got three more revenue workflows out of the same project.

Customer: Tai Software — SaaS transportation management software for freight and logistics operators
Sponsor: Kevin Trosian, Chief Financial Officer
Started: April 2026 · Live: May 2026 commission run

At a glance

  • Before — A hand-maintained Excel workbook driving commission payouts, plus standalone tooling on the side, taking 10+ hours to reconcile every month.
  • Considered — Buying a dedicated commissions tool.
  • Chose — DataFabrIQ: one source of truth for the full revenue operating picture — Commission Reporting, Weekly Sales Pipeline Review, Sales Team Report, and MRR / ARR Rollforward.
  • Outcome — 70% reduction in month-end reconciliation time across all revenue operations. Commission statements that tie to Finance's signed numbers within $0.05–$0.07. Rep questions answered in 5 minutes, not 5 business days. Live in six weeks.

The situation

Tai sells a monthly recurring product into freight and logistics companies and closes a significant number of new deals every month. HubSpot is the system of record for deals, billing accounts key off Recurly, and commissions ran out of a spreadsheet — and not a simple one. Tai's comp plan is genuinely complex:

  • Tiered rates driven by attainment against quota, with senior and junior rate cards and ramp schedules for new hires.
  • An over-quota bonus layered on top, gated on prior-month performance, waivable by management for a specific cohort.
  • A 12-month payment window per deal, starting from its contract-start month, so any given payout month is a blend of deals from a dozen different cohorts, each carrying its own rate.
  • Rate preservation: a cohort keeps its original close-month rate for the full window, even when one of its deals later terminates.
  • Clawback and retro-tiering on churn: if a customer churns inside the 12-month window, the rep's responsible MRR drops, which can move them into a lower tier — and that lower tier gets applied retroactively across the current pay cycle, netted against the current month's check.
  • Five lifecycle states that each pay differently. Active and Onboarding pay. Paused is pulled out of active MRR but still has to be visible. Terminated stops from its termination month. And a "churn/ghost" pattern — a closed-lost deal with a prior closed-won — has to be recognized as churn rather than as a lost deal.

Every one of those rules lived in formulas, in one Excel workbook, maintained by hand. It worked, in the sense that people got paid. But it was slow, it was one person deep, and any question a rep raised meant reopening the file. Prep time alone was over six hours a month, and every rep question added more time spent sharing and explaining calculations.

Why not just buy a commission tool?

Tai looked at the obvious answer: a dedicated commissions platform. Four reasons that path didn't win.

  • The edge cases are the job. Retro-tiering across a pay cycle, cohort rate preservation through a mid-window termination, a bonus gate that management can waive per cohort — these are the parts that consume Finance's time, and they're exactly the parts that sit outside a commission tool's configuration screen. Buying a tool would have meant either bending the plan to the software, or keeping the spreadsheet alive alongside it.
  • Commissions weren't the only problem. The same HubSpot and billing data that drives commissions also drives pipeline review, forecast, and revenue reporting. A point solution would have solved one of four data discrepancies and added another integration to maintain.
  • Finance's number has to win. Tai's signed commission statements are the authority. Any system that produces its own answer and asks Finance to trust it is a non-starter.
  • Expense. Point solutions are $15–30k a year minimum and still wouldn't have delivered a full solution.

How DataFabrIQ met Tai's revenue operations needs

We tailored Commission Reporting to Tai's formulas instead of asking Tai to bend into a predefined template, and cleaned up and reconciled the underlying data so the report drills all the way down to the individual deal, with per-rep and per-month detail. One governed engine now runs what a person used to do by hand.

Underneath it, four auditable governance mechanisms let the system tie out exactly to Finance instead of arguing with it:

  • Commission adjustments — structured, individually justified management deviations (preserve a rate, force a rate, force a payout, waive the gate), each carrying a written reason. Rep questions now get answered in five minutes, instead of days of back and forth.
  • Deal MRR overrides — per-deal and per-month corrections where the CRM value is wrong or a change is timed differently.
  • Historical locks — frozen amounts for cohort tails that can't be recomputed from current data, so a formula change today can't move a month that was already signed off.
  • Reconciliation targets — Finance's authoritative monthly total per rep. The system scales calculated per-deal amounts so a rep-month sums to exactly Finance's number, while preserving full deal-level drill-down.

That last one is the crux: the statement ties to the dollar and explains every dollar.

Once commission reporting was done, the same governed foundation gave Tai three more workflows:

  • Weekly Sales Pipeline Review — the forecast surface the sales team runs its weekly meeting from: pipeline, coverage, and movement, off the same governed definitions the commission report uses.
  • Sales Team Report — VP and team-goal incentive tracking on Tai's plan structure, with attainment locked for historical periods and computed live for open ones.
  • MRR / ARR Rollforward — the account-by-month movement waterfall of new, expansion, contraction, and churn, which is both the revenue reporting Finance needed and the source of truth the commission clawback logic reads from.

Same numbers, all in one place, with one set of rules running across all of it. That's also where generic tooling struggles: the commission report is current-team-only — a departed rep drops out of it entirely, including their history — while every other view keeps that rep through their departure quarter, then drops them. Two different correct answers about the same person, enforced once in the data layer rather than re-implemented in four places.

The result

Tai went from kickoff in April to running the May commission cycle on DataFabrIQ. The 19-tab spreadsheet is retired. Nearly $50k in software fees plus the integration came off the roadmap, and instead of one workflow, Finance and Sales got four — saving 30 hours a month, a 70% decrease in reconciliation time.

"We were considering buying a commissions tool, and we would have still been stuck maintaining the spreadsheet next to it. Our plan has retro-tiering, cohort rate preservation, and a bonus gate for overperformance. This detail takes time to maintain and eats hours every month. DataFabrIQ built our plan, not a generic version of it, and it ties my signed comp statements to the dollar, while still letting my reps and I open any number and see where every dollar came from. We were live for the May run. And the same work gave us our pipeline review and our ARR rollforward, which I wasn't expecting to get out of a commissions project."

— Kevin Trosian, CFO, Tai Software

If your comp plan has rules no template quite fits, come see what we built at datafabriq.co.