The verdict in three sentences
Raw operator exports are not accounting-ready: mixed columns, fees buried in the amount, ambiguous dates. A normalized CSV schema (date, reference, gross, fee, net, VAT, order-id) saves your accountant billing hours. In Dar es Salaam in 2026, that is an order of magnitude of 25,000 to 60,000 FCFA saved per month.
The column mapping
The core work is turning the native export into a file where each column has a single accounting meaning. Here is the typical mapping from a raw wallet export to an accounting-ready CSV.
| Target column | Raw wallet source | Processing |
|---|---|---|
| date | operator timestamp | Normalize to settlement day |
| reference | transaction ID | Copy as-is |
| gross_amount | amount paid by customer | Copy |
| fee | not isolated | Extract (1 % order of magnitude) |
| net_amount | amount settled | Gross minus fee |
| vat | absent | Compute (18 % on net) |
| order_id | merchant reference | Attach to the order |
Before / after: the cleanliness that gets billed
An accountant bills for time spent. Handing over a clean file shifts hours of cleaning into simple verification. Here is the difference, in 2026 order of magnitude.
| Criterion | Raw export delivered | Normalized CSV delivered |
|---|---|---|
| Fees isolated | No | Yes |
| Consistent dates | Ambiguous (T+1/T+2) | Settlement-aligned |
| VAT pre-computed | No | Yes |
| Order attachment | Missing | order_id column |
| Accountant time | 4 to 6 h/month | 1 h/month |
| Billed cost (estimate) | 60,000 to 90,000 FCFA | 20,000 to 30,000 FCFA |
The classic pain is the M-Pesa PDF that must be converted to CSV: while a Wave export is workable, a PDF operator statement forces an extraction step before you even start cleaning.
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
Ibrahima runs an accessories shop in Dar es Salaam, 1,100 transactions a month across two wallets. His accountant billed him 75,000 FCFA/month, much of it for reshaping raw exports. Now delivering a normalized CSV (fees isolated, net computed, VAT at 18 %, order_id attached), accounting time dropped from 5 hours to 1 hour. His bill fell to 30,000 FCFA/month: 45,000 FCFA saved each month, or 540,000 FCFA over the year.
FAQ
Why not just hand over the raw wallet export? Because fees are not isolated and VAT is not computed. Your accountant redoes that work and bills you: 4 to 6 hours a month that add 30,000 to 60,000 FCFA to your bill.
How do I handle M-Pesa statements in PDF? They require a PDF-to-CSV conversion step before any processing. Automating that extraction avoids re-keying errors and saves valuable time at every close.
What are the minimum columns for an accounting CSV? Seven are enough: date, reference, gross amount, fee, net amount, VAT and order_id. This schema enables reconciliation, VAT filing and sale attachment without reprocessing.
On what amount do I apply VAT in the CSV? On the net amount (gross minus operator fee). In Tanzania, the 2026 standard rate is 18 %. Computing VAT on the gross overstates your taxable base.
Let's talk about your project. We generate accounting-ready CSV exports and cut your accountant's bill. 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.
