The verdict in three sentences
Each operator sends its settlement statement in its own format: 3 to 6 different templates, from 200 to 5,000 lines per day. Handling them by hand costs 5 to 10 hours per week and produces a 3-8 % error rate. A parsing pipeline that maps columns, detects fees and net and exports to your accounting software removes this burden.
What the pipeline must do
A good parser does more than read a CSV: it normalises, validates and flags. Here are the steps and their gains.
| Pipeline step | Action | Gain / risk removed |
|---|---|---|
| Ingestion | Automatic CSV/PDF import | End of copy-paste |
| Column mapping | Align to a common schema | 3-6 formats unified |
| Fee/net detection | Split gross, fee, net | Margin computed right |
| Validation | Check totals and duplicates | 3-8 % error removed |
| Export | Journal to accounting software | Re-keying removed |
| Exceptions | Queue of doubtful lines | Focus on the real issue |
Volumes and gains in 2026
| Store profile | Lines/day | Manual time/week | After pipeline |
|---|---|---|---|
| Small | 50-200 | 3-4 h | ~20 min |
| Medium | 500-1,500 | 6-8 h | ~40 min |
| Large | 2,000-5,000 | 10-15 h | ~1 h |
| Marketplace | 5,000+ | 15 h+ | ~1.5 h |
The pipeline turns linear work (more sales = more hours) into a near-fixed cost: beyond the initial setup, doubling volume adds almost no time.
Mini case study
Fatou, finance lead of a store in Abidjan, processes 1,200 lines/day across Wave, Orange Money and a card gateway. By hand it takes her 7 hours/week and leaves 5 % of lines misclassified. At 3,000 FCFA/hour of internal cost, that is 91,000 FCFA/month of time. After deploying a pipeline she drops to 40 minutes/week: she recovers 6 h/week, reassigned to customer care, and her error rate falls below 0.5 %.
Become a Kolonell referral partner
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Know e-merchants drowning in their statements? Refer them and earn a commission on every signed project, through our referral (apporteur d'affaires) programme.
| Referred project type | Sale commission | Recurring |
|---|---|---|
| Showcase site | 15 % | 5 % recurring |
| E-commerce (settlement pipeline included) | 12 % | — |
| Marketplace | 10 % | — |
| Institutional | 8 % | — |
A single message that leads to a 2,000,000 FCFA e-commerce project earns you 240,000 FCFA.
FAQ
Do I need to code to parse statements? Ideally the pipeline is configured once by a developer, then runs on its own. You only touch flagged exceptions, without writing code day to day.
What if an operator changes its format? The mapping is isolated: you adjust a lookup table without rebuilding the whole pipeline. Plan a check whenever an operator announces a statement update.
Is PDF as manageable as CSV? Yes, with an upstream extraction step, but CSV/API stays more reliable. Always request the CSV export from your operators when it exists.
How long to set it up? Plan 2 to 4 days to map 3 to 6 formats and wire the accounting export. The 5 to 10 h/week saving is recovered in the first month.
What happens to lines the pipeline doesn't understand? They go to an exception queue, never silently into your accounts. You handle a small batch daily instead of re-reading everything.
Let's talk about your project. We build your settlement parsing pipeline, from mapping to accounting export, and can enrol you in our referral programme. 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.
