The verdict in three sentences
A media group that books spots on spreadsheets usually loses 5 to 10% of its advertising revenue to aired but unbilled spots, misapplied discounts and disputes it cannot prove. Complete ad sales and traffic software costs roughly 25,000 to 60,000 USD as a 2026 ballpark for a group in Accra, Nairobi or Lagos, with a 4 to 6 month build. The module that decides everything is proof of airing: automatic reconciliation between the schedule you sold and each station's actual as-run log.
Why spreadsheets cost more than they seem
In many African media groups the sales flow looks the same: the account executive receives a brief from an agency or advertiser, builds a schedule in Excel, sends it over WhatsApp, then the traffic team retypes the spots into the playout system. Invoicing happens at month end from yet another file. Three entries for one spot means three chances of error.
Every sales director knows the result: a spot squeezed in during a national team match and never billed, a volume discount applied twice, an agency disputing 40 airings because there is no certificate, a receivable sitting at 90 days because the invoice used the wrong rate card. On 3 million USD of ad revenue, a 6% leak equals 180,000 USD a year.
Modules of ad sales software
| Module | Function | Measured impact |
|---|---|---|
| Rate cards | Prices per station, daypart, spot length (15, 30, 45 s), premium surcharges | No more hand-calculated rates |
| Spot booking | Campaign schedules, live inventory check, category exclusivity | No overbooked breaks |
| Traffic log | Export to radio automation and TV playout, running order | One entry instead of three |
| Proof of airing | As-run log import, sold vs aired reconciliation, PDF certificate | Agency disputes cut by 75% |
| Advertiser and agency billing | 15% agency commission, volume discounts, VAT, credit notes | 5 to 10% of revenue recovered |
| Collections | Automatic reminders, mobile money links for small advertisers | Average payment time down 20 to 30 days |
| Digital and social | Banners, sponsored articles and posts with view statistics | Bundled radio, TV and web offers |
| Dashboard | Fill rate per break, revenue per rep and per sector | Weekly steering |
Reconciliation is the heart of it. Every night the software imports each station's as-run log, compares it with what was sold and flags three cases: sold but not aired (re-air or credit), aired but not sold (bill or justify), aired outside the booked daypart (apply a discount). Agencies get a dated airing certificate, which ends most disputes before they start.
Spreadsheet, international package or custom build
| Criterion | Spreadsheet and WhatsApp | International traffic package | Custom build |
|---|---|---|---|
| Upfront cost | Close to zero | Annual licence, often 30,000 USD and up | 25,000 to 60,000 USD |
| Time to go live | Immediate | 6 to 12 months with an integrator | 4 to 6 months |
| Mobile money payments | No | Rarely | Built in |
| Local formats (barter, obituaries, paid announcements) | Manual | Awkward | Planned from day one |
| Link to existing playout systems | None | Often limited to supported brands | Built for your equipment |
| Revenue leakage | 5 to 10% | 1 to 2% | 1 to 2% |
Paid announcements, obituaries and cash notices often make up 10 to 20% of a local radio station's takings and fit poorly in imported software. At Kolonell, this kind of project falls within the complex application grid, 7,000,000 to 15,000,000+ FCFA (10,670 to 22,870+ EUR), scope set in the quote, with maintenance at 35,000, 75,000 or 120,000 FCFA a month (53, 114 or 183 EUR).
Mini case study
Kwame, sales director of a group running two radio stations, a TV channel and a news site in Accra, brings in 3 million USD of ad revenue. A three-month audit of as-run logs shows 6% of spots aired with no invoice or at the wrong rate, i.e. 180,000 USD a year.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
The group commissions custom software at 42,000 USD with about 6,000 USD a year for hosting and support. In year one, 70% of the leak is recovered: 126,000 USD. Average payment time falls from 85 to 60 days, freeing about 205,000 USD of cash (3 million x 25 / 365). First-year cost: 48,000 USD. Payback in a little over 4 months.
FAQ
Can the software connect to our current playout system?
In 80 to 90% of cases yes, through as-run log exports in CSV or XML. Scoping starts with an inventory of each station's equipment, which takes 1 to 2 weeks.
How are media agency commissions handled?
The software applies the agreed commission, often 15%, and invoices the advertiser or the agency according to the mandate. Volume discounts trigger by tier, for example 10% above a committed spend threshold.
Can small advertisers pay by mobile money?
Yes. A payment link goes out with the invoice and the booking is confirmed on payment. For notices and announcements this cuts cash handled at the front desk, often 30 to 50% of those takings.
How long does it take to launch?
Plan 4 to 6 months: 3 weeks of scoping, 3 to 4 months of development, then 4 weeks running in parallel with the spreadsheet on a pilot station.
Is advertiser data protected?
The software must follow local data protection law, such as Ghana's Data Protection Act or Kenya's Data Protection Act 2019. Access is split by role: sales, traffic, accounts, management.
Let's scope your project. We map your sales flow, the link to your stations and a 4 to 6 month schedule with you. 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.
