The verdict in three sentences
In 2026, manual mobile money reconciliation costs a Senegalese SME 8 to 15 hours of accounting per month, because neither Wave nor Orange Money directly exports the SYSCOHADA codes (511, 516, 571). An automation chain — Wave webhook to Google Sheets mapping to Sage 100 import — brings this work down to under 2 hours for about 25,000 FCFA of setup. Automating account mapping turns a monthly chore into a near-error-free flow.
What Wave and OM really export
The problem isn't missing data, it's its format. Wave provides a clean CSV but without an accounting code; Orange Money only exposes an Excel export via portal, with no stable API in 2026.
| Source data | Wave (daily CSV) | Orange Money (portal Excel) | Target SYSCOHADA field |
|---|---|---|---|
| Transaction ID | transaction_id | ref_operation | Voucher / journal |
| Gross amount | amount | montant | 411 / 701 |
| Operator fee | fee | commission | 627 bank services |
| Net collection | computed | computed | 516 mobile money |
| Timestamp | timestamp | date_heure | Voucher date |
| Customer phone | phone | numero | Third party / 411 |
| SYSCOHADA code | missing | missing | to be mapped |
Key finding: the SYSCOHADA code is always missing at the source. That's exactly the layer automation must add via a lookup table.
Reconciliation methods compared (2026)
| Criterion | Manual (entry) | Google Sheets + Sage import | Juriconseil connector |
|---|---|---|---|
| Initial setup | 0 FCFA | 25,000 FCFA | 0 FCFA |
| Recurring cost | 0 FCFA | 0 FCFA | 15,000 FCFA / month |
| Monthly time | 8-15 h | 1-2 h | < 1 h |
| Possible frequency | monthly | daily | real time |
| Error rate | ~6% | < 0.5% | < 0.3% |
| Technical dependency | none | medium | external |
| OM via API | no | Excel export | partial |
The Google Sheets mapping solution is the best cost/benefit for an SME: a one-time setup, zero subscription, and the ability to reconcile daily rather than in a month-end block.
How the automation chain works
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
The Wave webhook pushes each confirmed transaction to a Google Sheet. A formula column assigns the SYSCOHADA code by operation type (511 cash, 516 mobile money, 571 bank, 627 fees). The cleaned file is then imported into Sage 100 in the expected format. For Orange Money, lacking an API, the portal Excel export is pasted into the same workbook and gets the same mapping. The result: a normalized accounting entry, ready to import, with no re-keying.
Mini case study
Fatou, accountant at an online shop in Dakar, handled about 900 Wave + OM transactions per month. Manually, she spent 12 hours and corrected on average 54 entry errors (6%). After setting up the Google Sheets mapping at 25,000 FCFA, her time drops to 1h30 and errors below 5 lines per month. At an estimated internal hourly cost of 3,000 FCFA, she saves about 31,500 FCFA of time per month: the setup pays for itself within the first week (estimate, 2026 order of magnitude).
FAQ
Why don't Wave exports contain SYSCOHADA codes? Because Wave is a payment operator, not accounting software: it provides raw data (amount, fee, timestamp) and it's up to your chart of accounts to classify it as 516, 571 or 627.
Does Orange Money have a reconciliation API in 2026? Not in a stable, general way. The Excel export via the merchant portal remains the most reliable path, integrable into the same mapping table as Wave.
How often should you reconcile? Daily is ideal: it avoids month-end pile-up and detects a fee gap or a missing payment faster.
Is the 15,000 FCFA/month connector worth it? For high volume (> 3,000 transactions/month) or a real-time need, yes. Below that, the Google Sheets at 25,000 FCFA setup is more cost-effective over the year.
What error rate should you target? Below 0.5%. Above that, it usually signals incomplete mapping (mis-allocated OM fees, undeduplicated duplicates).
Let's talk about your project. We set up your Wave + OM to Sage 100 SYSCOHADA chain, tested and documented. 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.
