The verdict in three sentences
Exporting mobile money payments into Sage or QuickBooks requires correctly mapping three elements: the gross amount, the deductible operator fees and VAT at 18 % (Senegal). Sloppy mapping produces up to 5 % duplicated entries on 1,200 monthly transactions. A clean connector brings that rate down to 0.3 % and moves the monthly close from 3 days to 6 hours.
Manual CSV vs API sync
| Criterion | Manual CSV export | API sync |
|---|---|---|
| Monthly close duration | 3 days | 6 hours |
| Duplicated-entry rate | 5 % | 0.3 % |
| Automatic VAT mapping | No | Yes |
| Operator fees split out | Manual | Automatic |
| Volume handled smoothly | ~500 tx | 1,200+ tx |
| Risk of forgetting fees | High | None |
On 1,200 transactions, 5 % duplicates = 60 wrong entries to fix every month, i.e. several hours of retroactive reconciliation.
The correct accounting mapping
| Mobile money element | Ledger account | VAT treatment |
|---|---|---|
| Gross amount collected | Revenue / sales | 18 % VAT collected |
| Operator fee (1 % Wave) | Expense / banking services | Deductible VAT if invoiced |
| Net settled | Bank / cash | — |
| Refund | Sales reversal | VAT adjusted |
The key: never record the net as if it were the gross. The operator fee is a distinct deductible expense, not a mere reduction of the sale.
Mini case study
Aminata, an accountant at a Dakar SME handling 1,200 transactions/month, spent 3 days per close with a CSV export and corrected about 60 duplicates monthly. After deploying a mapped API sync (gross, 1 % fee, 18 % VAT), her close dropped to 6 hours and duplicates to 4 per month. Net gain: about 2.5 days/month recovered and VAT finally correct on the first pass.
Become a Kolonell referral partner
If you support merchants or SMEs on their mobile money accounting, the Kolonell referral (apporteur d'affaires) program pays you for every project you refer. You spot the need, we deliver, you earn a commission.
| Referred project type | Sale commission | Recurring |
|---|---|---|
| Showcase website | 15 % | 5 % |
| E-commerce | 12 % | — |
| Marketplace | 10 % | — |
| Institutional | 8 % | — |
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
A single e-commerce project at 2,000,000 FCFA earns you 240,000 FCFA in commission. Referring becomes income, not just a favour.
FAQ
Why 5 % duplicates in manual CSV?
Because operator exports overlap (the same transaction appears in two period files) and a manual import does not deduplicate by ID. The API sync filters by unique identifier.
Is the operator fee deductible?
Yes, it is a deductible financial-services expense. Record it separately from the sale amount so you do not distort your revenue or your collected VAT.
How do I handle 18 % VAT?
VAT is calculated on the gross sale amount, not on the net after fees. Correct mapping separates the net sale, the collected VAT and the operator fee.
How much does a QuickBooks API connector cost?
Depending on volume, budget a subscription in the order of 20,000 to 50,000 FCFA/month. The payback is immediate once you recover 2.5 days of monthly accounting work.
How do I join the referral program?
Contact us, describe the profile you support, and we formalise your referral status with the commission rates above from your first referral.
Let's talk about your project. We connect your mobile money flows to Sage or QuickBooks and open the referral program to you. 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.
