The verdict in three sentences
For an electrical wholesaler in Berlin, the real cost of spreadsheets shows up as stock-outs discovered at the counter and uncontrolled customer credit, not as licence fees. Custom wholesale software linking multi-branch stock, installer quotes and credit limits pays back in 12 to 20 months on revenue of EUR 15 to 30 million. The right starting scope fits in three modules (real-time stock, quotes, credit) and leaves accounting to the tool you already run.
What spreadsheets really cost a 4-branch wholesaler
With 15,000 SKUs (cables, circuit breakers, distribution boards, LED lighting, cable trays), a shared spreadsheet no longer keeps up. Each branch keeps its own tab, updates arrive in the evening, and the salesperson promises a drum of NYM-J cable that is actually sitting at the Spandau branch. Installers, who compare three wholesalers by phone, go with whoever answers fastest.
| Indicator (2026 order of magnitude) | With spreadsheets | With business software |
|---|---|---|
| Average time for a 40-line installer quote | 25 to 40 min | under 5 min |
| Stock-outs discovered at the counter per month | 120 to 200 | 20 to 40 |
| Quote conversion rate | 22 to 28% | 32 to 38% |
| Annual inventory variance | 2.5 to 4% of stock | 0.6 to 1.2% |
| Customer credit above the authorised limit | 8 to 12% of total receivables | under 2% |
| Days sales outstanding (DSO) | 55 to 70 days | 38 to 45 days |
Credit is often the most expensive issue. In Germany, the BGB caps B2B payment terms at 60 days unless expressly agreed, and late-payment interest runs at 9 points above the base rate. A wholesaler that lets small installers drift beyond their limits is effectively financing their cash flow out of its own equity.
Modules to plan for and their budget
Useful electrical wholesale software rests on a few specific building blocks. The table below gives budget ranges for the German market, and the Kolonell price for a custom build.
| Module | Key function | German market budget (EUR excl. VAT) |
|---|---|---|
| Real-time multi-branch stock | quantities per branch, reservations, reorder points | 20,000 to 40,000 |
| Installer quotes | customer discount grids, kits (board + breakers), one-click PDF | 15,000 to 33,000 |
| Receivables and credit limits | automatic blocking, reminders, simple scoring | 13,000 to 29,000 |
| Inter-branch transfers | request, approval, shuttle tracking | 9,000 to 20,000 |
| Installer portal | net prices, orders, invoices | 18,000 to 45,000 |
| Connectors (accounting, manufacturer price lists) | Datanorm price imports, DATEV export | 13,000 to 33,000 |
| Total full project | 90,000 to 200,000 |
Kolonell builds this type of custom application for 2.5 to 15M+ FCFA (EUR 3,810 to 22,870+) depending on complexity, with the rest quoted separately. A first release (stock, quotes, credit) is usually delivered in 10 to 14 weeks.
The business rules that make the difference
The software must handle packaging units (cable sold by the metre, in 100 m coils or on drums), cross-brand SKU equivalences, and net prices negotiated per job site. Without these three rules, salespeople drift back to spreadsheets within a month.
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.
Jonas, managing director of a 4-branch electrical wholesaler in Berlin, generates EUR 21 million in revenue at a 22% gross margin. He estimates losing 1.5% of sales because stock-outs are flagged too late, i.e. EUR 315,000 in revenue and about EUR 69,000 in margin per year. By cutting over-limit receivables from 10% to 2% on total receivables of EUR 3.2 million, he frees EUR 256,000 of cash, saving about EUR 15,000 in interest at 6%. With a EUR 150,000 project and EUR 16,000 of annual maintenance, the annual gain of EUR 68,000 gives a payback of roughly 26 months, before counting the time saved by salespeople, which typically brings it under 20 months.
FAQ
Do we need to replace our accounting software?
No, in 80% of cases the wholesale software exports invoices to the existing accounting tool (DATEV, Lexware or other). The connector typically costs EUR 7,000 to 13,000 excl. VAT and avoids a heavy migration.
How long does it take to load 15,000 SKUs?
Allow 3 to 5 weeks of data migration, most of it spent cleaning duplicates and equivalences. Automatic Datanorm imports of manufacturer price lists cut this by 30 to 40%.
Does the software keep working if a branch loses its connection?
A degraded mode lets the counter keep selling and resynchronises within minutes. For 4 branches, a 4G backup line at around EUR 30 per month is enough.
How do we enforce credit limits without blocking good customers?
The software blocks orders above the limit, but a manager can release them in one click with a full audit trail. In practice, 90% of releases concern fewer than 50 known customers.
Is an installer portal profitable in year one?
If more than 30% of your quotes come from regular installers, yes: each online order saves 10 to 15 minutes of sales time. Otherwise, plan it for release 2.
Let's scope your project. Send us your number of branches, SKUs and current tools: we will price a first release covering stock, quotes and credit with an indicative budget and schedule. 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.
