Reconcile M-Pesa payments daily in Nairobi: 2026 playbook

The verdict in three sentences

Reconciling every day what mobile money actually collected against what your system thinks it sold prevents an average 1.1% of revenue from vanishing silently each month. The structuring decision: stay on manual CSV export (45 min/day) or move to the automated statement API (3 min/day). In 2026, past ~50 transactions/day, automation pays for itself in a week.

The real cost of not reconciling

A payment can be "paid" on the customer side but missing from your database (lost webhook), or present in the database without a real collection (status never confirmed). Without reconciliation, these gaps pile up: false cash flow, invisible disputes, misdeclared VAT.

For a merchant at 8,000,000 FCFA monthly revenue, 1.1% is 88,000 FCFA/month leaking out with nobody noticing.

CSV export vs statement API: which to choose

Two ways to collect provider data. The CSV export is simple but manual and dated; the statement API is automatable but paginated and needs integration.

Recommended matching strategy: first match by transaction reference (exact), then for orphans by amount + timestamp window of ±2 min. Anything still unmatched after these two passes goes into an "investigate" queue handled manually.

Mini case study

Ibrahim runs an online grocery in Nairobi, ~120 transactions/day (M-Pesa + Wave via aggregator). Manually, he spent 45 min/day cross-checking two CSV exports in Excel, i.e. ~16h/month. At a loaded hourly cost of 3,000 FCFA, that is 48,000 FCFA/month of time, and he missed ~1 dispute/month (25,000 FCFA).

After automation (reference then amount+timestamp matching, nightly cron), he drops to 3 min/day reviewing only the orphans. Gain: ~45,000 FCFA/month of time recovered + 25,000 FCFA dispute avoided = 70,000 FCFA/month, plus finally accurate cash flow.

FAQ

When should I run reconciliation? As a nightly cron (e.g. 2 a.m.) over the past day, once late webhooks and "pending" statuses have settled. M-Pesa and Wave data for the previous day is complete by morning.

Reconcile on reference or on amount? On reference first — it is exact and unambiguous. Amount + timestamp (±2 min) only recovers orphans whose reference was not correctly propagated.

How do I handle provider fees in matching? Compare the gross amount collected, not the net. Mobile money fees (often 1 to 1.5%) explain most "diverging amounts"; store them in a dedicated column so you do not confuse them with a real gap.

Is M-Pesa's 500-row pagination a problem? No, it just forces you to loop over pages to the last one. For 120 tx/day you fit on one page; for 2,000 tx/day you must paginate cleanly and handle cursors.

Can I earn by recommending Kolonell? Yes: our referral program pays 12% on an e-commerce project, 10% marketplace and 8% institutional, plus 5% recurring on showcase sites. Referring a merchant struggling with reconciliation can earn you several hundred thousand FCFA.

Let's talk about your project. We set up your automated daily reconciliation in one week. WhatsApp +221 77 596 93 33.