The verdict in three sentences
For a distribution company with 90 sales reps, whether in Dakar or London, a connector between the CRM and the payroll software costs between 4,500,000 and 8,000,000 FCFA excl. VAT (about EUR 6,900 to 12,200) and is delivered in 8 weeks. It calculates commissions directly from sales validated in the CRM, pushes a clean file to payroll and keeps an audit trail line by line. The expected gain is 4 working days per month for the finance team and the near disappearance of commission disputes, which pays back the project in under two years before even counting staff morale.
Why manual commission calculation costs more than it looks
In most distribution SMEs the workflow is the same: an Excel export from the CRM on the 25th, reworking by financial control, applying rates per product line, then re-keying into Sage Payroll or the software of the bureau that runs payroll. Every step adds a risk of error, and every error turns into a complaint from a sales rep. London SMEs using HubSpot and Xero Payroll or BrightPay face exactly the same pattern.
| Item | Current manual process | With automated connector |
|---|---|---|
| Finance director and controller time | 4.5 days per month | 0.5 day of review |
| Observed error rate on commissions | 3 to 6% of lines | Under 0.5% |
| Sales rep complaints per month | 8 to 15 | 0 to 2 |
| Delay between sales close and payroll | 5 to 7 days | 24 hours |
| Traceability during an audit | Successive Excel files | Timestamped log per sale |
| Change of commission plan | 2 days rewriting formulas | 15 minutes of configuration |
| Estimated annual cost of time spent | About 6,500,000 FCFA (EUR 9,900) | About 750,000 FCFA (EUR 1,150) |
The time cost is a 2026 estimate based on a fully loaded cost of 1,200,000 FCFA per month for a senior financial controller in Dakar. In London the same profile costs roughly four times more, which shortens payback accordingly. It does not count the time sales managers spend arbitrating disputes, which is often higher.
What the connector includes and what it costs
The project replaces neither the CRM nor payroll. It creates an intermediate layer that reads won opportunities and collected invoices, applies the commission rules, then produces payroll variables in the expected format.
| Work package | Content | Budget excl. VAT (FCFA) | Duration |
|---|---|---|---|
| Rules scoping | Rates per product line, tiers, targets, special cases (returns, bad debts) | 600,000 to 900,000 | 1 week |
| CRM connection | Salesforce, HubSpot, Zoho or Odoo API, reading validated sales | 900,000 to 1,600,000 | 2 weeks |
| Calculation engine | Configurable rules, simulation before approval, retroactive changes | 1,400,000 to 2,600,000 | 2 weeks |
| Payroll export | Sage Payroll file, bureau format or API, consistency checks | 700,000 to 1,300,000 | 1 week |
| Audit trail and rep portal | Each commission visible to the rep, change log | 600,000 to 1,100,000 | 1 week |
| Acceptance and parallel run | One month alongside the old calculation | 300,000 to 500,000 | 1 week |
| Total | 4,500,000 to 8,000,000 | 8 weeks |
Maintenance runs around 120,000 to 200,000 FCFA excl. VAT per month depending on the number of rules. The low end matches a modern CRM with a documented API and a simple plan. The high end matches an old CRM without an API, commissions on margin and quarterly targets with catch-up.
One point often forgotten is data protection: Senegal's law 2008-12 or UK GDPR in London. Pay amounts are sensitive data, so the connector must restrict access by role, encrypt exchanges and be listed in the record of processing activities.
Mini case study
Mamadou, CFO of a food distribution company in Dakar, manages 90 reps across Dakar, Thiès and Kaolack. His team spends 4.5 days a month on commissions, and he handles 11 complaints on average.
- Chosen budget: 6,200,000 FCFA excl. VAT, plus 150,000 FCFA monthly maintenance, i.e. 8,000,000 FCFA (about EUR 12,200) in year one.
- Time freed: 4 days per month x 12 months x 55,000 FCFA daily cost = 2,640,000 FCFA per year.
- Errors avoided: 4% errors on 38,000,000 FCFA of monthly commissions, half of them against the company, i.e. about 760,000 FCFA per month, 9,100,000 FCFA per year.
- Payback: the project is covered in just under 9 months.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Even if the error estimate is halved, break-even stays under 15 months.
FAQ
Do we need to change CRM to automate commissions?
No in 80% of cases. If the CRM exposes an API or a scheduled export, the connector plugs into it. A CRM without an API requires an automatic daily export, which adds about 500,000 FCFA (EUR 760) to the budget.
Can the bureau that runs our payroll receive the file?
Yes. The connector produces the import format of the bureau's software, often Sage or a standardised CSV. Plan one day of exchange with the bureau during scoping to lock the pay codes.
What happens with a customer return or a bad debt?
The engine claws back the commission the following month, according to the rule you set. Each clawback appears in the audit trail with the original invoice, which prevents 90% of disputes.
Do reps see the detail of their commissions?
Yes, through a simple portal or a PDF statement sent by email and WhatsApp. Transparency is the first lever to reduce disputes, often more effective than the calculation itself.
How long before the first automated month?
Eight weeks including one month of parallel run. Payroll for the third month after signature is usually the first one produced entirely by the connector.
Let's scope your project. Send us your commission plan and the names of your CRM and payroll tools, and we will price a connector between 4,500,000 and 8,000,000 FCFA excl. VAT (EUR 6,900 to 12,200), delivered in 8 weeks. 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.
