Reconcile Mobile Money Payouts With Your Bookkeeping (2026)

The verdict in three sentences

A mobile money payment generates three distinct amounts: what the customer pays, what the provider deducts as commission, and what actually lands in your account at T+1 or T+2. Reconciliation means automatically matching those three lines by transaction reference, not by hand. Done right, it drops from 8 hours to 1 hour per month and erases unexplained gaps.

Why the amounts never match

The classic trap: your back office shows "10,000 FCFA paid," but your bank shows a settlement of 9,820 FCFA two days later. The gap is the provider fee deducted at source. Multiplied across hundreds of transactions bundled into a single transfer, manual reconciliation becomes impossible.

Settlements arrive aggregated: one transfer for 340 transactions that day. Without a detail file, you cannot tell which sale maps to which line.

The reference-based matching method

Every provider exposes a CSV export of transactions with a unique reference column. The golden rule: that same reference must exist in your order system. Matching then becomes a simple join.

The most common accounting errors: booking the gross as revenue instead of net received, forgetting to record the commission as a deductible expense, and failing to allocate the recoverable VAT on commission (18% in Senegal).

Mini case study

Awa runs a cosmetics shop in Dakar: 420 orders/month, average basket 12,000 FCFA, i.e. 5,040,000 FCFA collected. She used to reconcile by hand: 8 h/month, with 1.4% never-explained gaps (≈ 70,000 FCFA). Switching to Wave CSV export plus reference matching, she cut it to 1 h/month. The 62,000 FCFA monthly commission now goes to deductible expenses, and the VAT (≈ 11,000 FCFA) is reclaimed. Net gain: 7 hours + ~80,000 FCFA/month properly booked.

FAQ

Why is my bank transfer lower than my sales? Because the provider deducts its commission (order of magnitude 1 to 2% in 2026) at source. The transfer reflects net, not gross. This is normal and expected.

How often should I reconcile? Ideally weekly for moderate volumes, at minimum monthly before closing the books. The longer you wait, the more orphans pile up and become hard to trace.

How do I handle VAT on provider commissions? The commission is a billed service: the associated VAT (18% in Senegal) is in principle recoverable if the provider issues a compliant invoice. Allocate it to a dedicated line each month.

Is a spreadsheet enough or do I need an ERP? Below 500 transactions/month, a spreadsheet with VLOOKUP is enough. Beyond that, a script or integrated ERP cuts time by 4 to 8x and makes the result reliable.

What about orphan transactions? Isolate them in a dedicated tab, cross-check against unconfirmed pending payments, and clear them within 15 days. An untreated orphan permanently distorts your margin.

Let's talk about your project. We connect your store, your Wave/Orange Money providers and your bookkeeping for automatic reconciliation. WhatsApp +221 77 596 93 33.