The verdict in three sentences
A pharmaceutical distributor running a 95-day DSO across 1,800 customers is financing pharmacies, clinics and hospitals with its own credit lines. A receivables dashboard connected to the ERP, with live ageing and follow-up tracked per salesperson, makes a 60-day DSO realistic and frees around 1.1 million USD of cash. The 2026 market range is 25,000 to 45,000 USD, with an 8-week timeline.
Why DSO drifts at a Gulf distributor
The CFO of a Dubai distributor knows the causes: pharmacy chains paying at 90 days instead of 60, private clinics stretching terms, government hospitals paying at year end, and an ageing report pulled from the ERP once a month into Excel. Sales reps cannot see a customer's overdue balance before taking a new order, and reminders go out late with no priority.
| Indicator | Today | 12-month target |
|---|---|---|
| DSO | 95 days | 60 days |
| Receivables | About 3.0 million USD | About 1.9 million USD |
| Over 90 days | 28 % of receivables | Under 10 % |
| Ageing report frequency | Monthly | Live |
| Customers reminded before due date | Under 10 % | 80 % |
| Orders held for credit limit | Case by case | Automatic rule |
Baseline maths: with annual sales of 11.5 million USD including VAT, each DSO day is worth about 31,500 USD of receivables. Moving from 95 to 60 days frees about 1.1 million USD.
What the dashboard includes and costs
The dashboard reads invoices, receipts and credit notes from the ERP (SAP Business One, Microsoft Dynamics, Odoo or Oracle NetSuite), recalculates ageing several times a day and shows it by customer, salesperson, segment (pharmacies, clinics, government) and emirate.
| Module | 2026 range (USD) | Main use |
|---|---|---|
| ERP connector and data store | 6,000 to 10,000 | Reliable hourly data |
| Ageing and DSO by dimension | 5,000 to 9,000 | CFO and board view |
| Sales view and credit limits | 4,000 to 7,000 | Hold before dispatch |
| Automated reminders by email, SMS, WhatsApp | 3,500 to 7,000 | Day -5, +1, +15 |
| Payment promises and disputes | 3,500 to 6,000 | Track customer commitments |
| Payment links (card, bank transfer) | 3,000 to 6,000 | Immediate collection |
UAE e-invoicing under the Federal Tax Authority's programme is phasing in from 2026, so structured invoice data feeding the dashboard is a good investment ahead of that change.
At Kolonell, this project falls into our medium application tier (4,000,000 to 7,000,000 FCFA, or 6,100 to 10,670 EUR) or complex tier (7,000,000 to 15,000,000+ FCFA, or 10,670 to 22,870+ EUR), depending on modules and ERP complexity. Maintenance is 35,000, 75,000 or 120,000 FCFA (53, 114 or 183 EUR) a month. See custom web applications.
An 8-week rollout
| Weeks | Step | Deliverable |
|---|---|---|
| 1 to 2 | ERP data audit, calculation rules | KPI dictionary |
| 3 to 4 | Connector, ageing, DSO | First CFO version |
| 5 to 6 | Sales view, limits, reminders | Pilot with 4 reps |
| 7 to 8 | Payment links, training, go-live | Production |
The dashboard only works if the rules are agreed in advance. Fix a credit limit and payment terms for every customer, decide who can override a hold, and set a weekly review where the CFO and sales managers go through the top 50 overdue accounts. Link part of the sales bonus to collected revenue rather than invoiced revenue, and the DSO curve usually bends within one quarter. Keep the dashboard on mobile so reps can check a balance in front of the pharmacist before writing the order.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Mini case study
Ravi, CFO of a pharmaceutical distributor in Dubai, funds working capital on a bank facility at 8 % a year. Receivables of 3.0 million USD at 95 days cost about 240,000 USD in annual interest. Bringing DSO to 60 days cuts receivables to about 1.9 million USD: 1.1 million USD freed, or 88,000 USD of interest saved each year. Against a 35,000 USD build, payback comes in under 5 months, before counting lower bad debt.
FAQ
Do we need a new ERP for live ageing?
No, the connector reads the existing ERP every hour. SAP Business One, Dynamics and Odoo are the most common cases in Dubai in 2026.
Will sales reps accept order holds?
Limits are set per customer and shown before the order is taken, with a CFO override. In practice 70 % to 80 % of holds clear the same day with a part payment.
Can we send reminders by WhatsApp?
Yes, through the WhatsApp Business API, at roughly 0.03 to 0.06 USD per utility message in 2026. Read rates far exceed email.
How do we handle government receivables?
They sit in their own segment so they do not distort commercial DSO. Tracking purchase orders and approvals helps forecast year-end payments.
How soon does DSO fall?
First effects show in 2 to 3 months, usually 10 to 15 DSO days gained. The 60-day target is a 12-month goal.
Let's scope your project. Tell us about your ERP, customer segments and sales organisation, and we will scope the KPIs and an 8-week rollout. 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.
