The verdict in three sentences
When commissions for 90 reps live in a 40-tab spreadsheet, finance loses three days a month and every error becomes a dispute, sometimes a wage claim. A commission SaaS such as Spiff or CaptivateIQ costs roughly USD 30 to 70 per rep per month, while a custom app runs about USD 30,000 to 65,000 in 2026, with CRM and payroll connectors. Custom wins when your rules are unusual (retroactive tiers, split deals, product accelerators) or when you exceed 80 reps over more than three years.
The real problem for a New York CFO
The CFO of a B2B services firm in Midtown or a SaaS company in Flatiron lives the same month every month. Export closed-won deals from Salesforce or HubSpot, adjust for credits and churn, apply quarterly tiers, check individual quotas, push to payroll before the cutoff. Then the Slack messages arrive: my deal closed on the 30th and is missing, the accelerator should have kicked in.
New York law adds pressure. Under New York Labor Law section 191, commissioned salespeople must have a written commission agreement describing how commissions are calculated, and earned commissions are treated as wages. A fragile spreadsheet is a legal risk as much as an operational one.
| Criterion | Excel | Commission SaaS | Custom app |
|---|---|---|---|
| Annual cost for 90 reps | Internal time only | USD 32,400 to 75,600 | USD 5,000 to 12,000 maintenance and hosting |
| Upfront investment | None | USD 5,000 to 25,000 implementation | USD 30,000 to 65,000 |
| Unusual rules | Possible but brittle | Limited to vendor engine | Unlimited, coded and tested |
| Monthly close time | 3 days | 0.5 to 1 day | 0.5 day |
| Observed error rate | 2 to 5% of lines | Under 0.5% | Under 0.3% |
| Rep-facing simulator | No | Yes, standard | Yes, tailored to your plans |
| Data ownership | Internal | Vendor-hosted | Internal, your cloud |
What the custom app includes
Five building blocks cover a 90-rep company. A CRM connector (Salesforce, HubSpot, Pipedrive) pulling closed deals and their status. A versioned rules engine: each comp plan has an effective date, so a past month can be recalculated with the rules in force at the time. A simulator where every rep sees their commission live and tests what-if scenarios. An approval workflow from manager to CFO, with comments on adjustments. A payroll export to ADP, Gusto or Paylocity.
| Item | 2026 ballpark (USD) | Timeline |
|---|---|---|
| Comp plan discovery and workshops | 4,000 to 7,000 | 2 to 3 weeks |
| CRM connector and credit reconciliation | 6,000 to 14,000 | 3 to 4 weeks |
| Versioned rules engine and tests | 10,000 to 22,000 | 4 to 6 weeks |
| Simulator and rep portal | 5,000 to 10,000 | 2 to 3 weeks |
| Approvals, audit trail, payroll export | 5,000 to 12,000 | 2 to 3 weeks |
| Total | 30,000 to 65,000 | 2 to 4 months |
What makes the difference is testing on real data: replay the last twelve months of the spreadsheet in the app and compare line by line. The gaps usually uncover two or three historical errors in the file.
For maintenance after delivery, Kolonell offers three plans: 35,000, 75,000 or 120,000 FCFA per month (EUR 53, 114 or 183). Hosting and further changes are quoted on request.
When to stay with SaaS
If your rules fit on one page, you have fewer than 40 reps and a mainstream CRM, Spiff, CaptivateIQ or QuotaPath can go live in 4 to 8 weeks and will do the job. Custom makes sense when SaaS implementation exceeds 20 consultant days, when plans change every year, or when leadership wants compensation data in its own cloud account.
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Rachel, CFO of a 90-rep company in New York, compares options. SaaS: USD 50 per rep per month, so 90 × 50 × 12 = USD 54,000 a year, plus USD 15,000 implementation. Custom: USD 50,000 build, then USD 8,000 a year for hosting and maintenance.
Over three years, SaaS costs 15,000 + 3 × 54,000 = USD 177,000, custom 50,000 + 3 × 8,000 = USD 74,000. Both options free 2.5 analyst days a month at about USD 600 loaded per day, so USD 18,000 a year. Calculation errors drop from 3% to 0.3% of lines, a tenfold reduction in disputes.
FAQ
How long does it take to replace Excel?
Allow 2 to 4 months, including 3 to 4 weeks of testing on the last 12 months of data. Run both in parallel for one month before retiring the spreadsheet.
Can the app handle retroactive tiers?
Yes, it is the most common reason to go custom. The engine recalculates the full quarter once the tier is hit and posts a true-up to the next payroll.
What happens when the comp plan changes?
The new plan gets an effective date. Earlier months stay calculated under the old plan, which protects you if a claim covers the last 6 years, the New York statute of limitations for wage claims.
Do reps see the detail of their calculation?
Yes, each line shows the deal, the rate applied and the tier. In practice this transparency cuts disputes by 70 to 90%.
Do we need to change CRM?
No. Mainstream CRMs expose APIs, and the connector costs USD 6,000 to 14,000 depending on data quality.
Let's scope your project. Send us your comp plans and CRM details, and we will define an app deliverable in two to four months, tested on your real data. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
