The verdict in three sentences
Your accountant wants neither screenshots nor unreadable PDF statements: they want a clean CSV with gross, fee, net and reference. The fix is to build a ledger export mapped to your chart of accounts. In 2026, a well-structured export saves your accountant 4 to 6 billable hours a month, at the equivalent of 15,000-25,000 FCFA an hour.
The 12 essential columns
A good transaction ledger isn't a list of amounts: it's an import-ready table carrying every field accounting needs to allocate entries and file VAT.
| Column | Content | Why |
|---|---|---|
| date | normalised timestamp | period allocation |
| reference | transaction ID | reconciliation |
| provider | MTN MoMo / Vodafone / Wave | revenue channel |
| gross_amount | before fees | customer check |
| fee | provider commission | deductible cost |
| net_amount | actually credited | cash flow |
| type | sale / refund / reversal | classification |
| account | chart-of-accounts code | direct import |
| vat_rate | 15 % or 18 % | filing |
| vat_amount | computed | filing |
| customer_ref | order / invoice | traceability |
| status | cleared / pending | reliability |
MTN MoMo Ghana applies a merchant fee of about 1 % capped; Vodafone Cash has its own structure. These amounts must appear in the "fee" column to be deducted cleanly.
Monthly export or real-time sync?
Two approaches coexist in 2026. A monthly CSV export suits many SMEs; API sync fits high volumes and continuous close.
| Criterion | Monthly CSV export | Real-time API sync |
|---|---|---|
| Setup | fast, low cost | more technical |
| Data freshness | month-end | continuous |
| Risk of omission | moderate | low |
| Suited volume | < 3,000 tx/month | > 3,000 tx/month |
| VAT (Ghana 15 % / franco 18 %) | computed at export | computed continuously |
The right choice depends on volume and dashboard needs. Many start with monthly CSV then switch to API when the close becomes weekly.
Mini case study
Kwame runs a hardware store in Accra with around 1,800 transactions a month across MTN MoMo and Vodafone Cash. Before, he sent screenshots to his accountant, who spent 5 hours a month re-keying everything and computing 15 % VAT. With a 12-column CSV ledger mapped to his chart of accounts, re-keying vanished: his accountant imports the file in 20 minutes. Estimated saving: 5 hours × the equivalent of 20,000 FCFA = 100,000 FCFA a month of billable time, and zero VAT errors.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Become a Kolonell referral partner
Do you know shop owners, restaurateurs or accountants struggling with their mobile-money exports? The Kolonell referral (apporteur d'affaires) program pays you for every project you bring us. The rates are clear and stack with a recurring share.
| Project type | Referral commission | Recurring |
|---|---|---|
| Showcase site | 15 % | + 5 % recurring |
| E-commerce | 12 % | per contract |
| Marketplace | 10 % | per contract |
| Institutional | 8 % | per contract |
A single e-commerce project at the equivalent of 2,000,000 FCFA earns you 240,000 FCFA in commission. One successful introduction is enough.
FAQ
Why a CSV and not a PDF? Because a CSV imports directly into accounting software, whereas a PDF requires manual re-keying. CSV removes human error and saves hours.
How do I handle VAT on mobile money? Add a rate column (15 % in Ghana, 18 % in francophone zones) and a computed amount column. Your accountant files directly from the ledger.
Should I include provider fees? Absolutely. MoMo or Wave fees are deductible costs; omitting them artificially inflates your profit and VAT due.
API or CSV — where to start in 2026? Start with a monthly CSV export — fast and low cost. Move to API sync beyond 3,000 transactions a month or if you close weekly.
How many hours does it really save? Between 4 and 6 billable hours a month, i.e. the equivalent of 60,000 to 150,000 FCFA depending on your accountant's rate. The investment pays back in one to two months.
Let's talk about your project. We can build your ledger export mapped to your chart of accounts — or sign you up as a referral partner. 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.
