How to Automate M-Pesa Billing Reconciliation for Your ISP

Manual M-Pesa reconciliation is the single biggest time sink for small ISPs in Kenya. The workflow looks like this: a payment comes in, a team member checks their phone, looks up the subscriber in a spreadsheet, marks the payment, and either manually reconnects the subscriber in MikroTik or sends them a WhatsApp message. Repeat 200 times a month.

The real cost

At 200 subscribers paying monthly, you are looking at 200 payment events. Each manual reconciliation takes 3–5 minutes. That is 10–17 hours a month -over two full working days -on a task that a machine can do in under 60 seconds.

Beyond time, manual reconciliation introduces errors. A payment gets missed. A subscriber stays suspended for three days despite having paid. They leave for a competitor.

How automated reconciliation works

A modern ISP billing system integrates directly with the M-Pesa Business Till or Paybill via the Safaricom API. When a payment arrives:

1. The system receives the transaction in real time via webhook 2. It matches the transaction reference and amount to a subscriber record 3. If the payment clears the outstanding balance, the subscriber is automatically reconnected in MikroTik 4. A WhatsApp or SMS confirmation is sent to the subscriber

The entire process takes under 60 seconds and requires zero human intervention.

What to look for in integration quality

Not all M-Pesa integrations are equal. The critical questions:

**Does it handle partial payments?** A subscriber who pays KES 800 of a KES 1,500 balance should not get auto-reconnected. The system must check against the actual outstanding amount, not just "did a payment arrive."

**Does it handle the till reference correctly?** Safaricom sends a transaction reference (e.g. RHD12KL44N) in the C2B notification. The system must use this to match -not phone number alone, which can be shared across household members.

**What happens when the API is down?** M-Pesa APIs have maintenance windows. A good system queues incoming transactions and processes them when the API recovers, with an audit log.

Getting started

The fastest path is to use an ISP billing platform that already has a certified M-Pesa integration. Building your own consumes weeks of engineering time and requires Safaricom API certification.

Metron ISP includes M-Pesa reconciliation as a core feature. New accounts can be connected to a Paybill or Till in under an hour.