How to stop reconciling M-Pesa manually

Ask any Kenyan business owner what they hate most about managing their finances. The answer, nine times out of ten, is the M-Pesa statement.

You download it. You open it in Excel. You have a column of cryptic names — “JOHN W”, “PATEL B”, “CUSTOMER REF 2847JK”. You spend two hours matching each one to an invoice. Some don’t match because the customer paid the wrong amount. Some don’t match because they paid from a different number. Some you just can’t figure out and you write “UNKNOWN” and move on.

This process repeats every month. Sometimes every week.

There is a better way.

First, understand what M-Pesa actually offers businesses

Most people think of M-Pesa as a payment method. It’s more than that — it’s a payment infrastructure with multiple tools for businesses.

Paybill is a fixed business number your customers send money to. They enter your Paybill number, then an account number (which you can use as their invoice number or customer ID). The money lands in your account. You get a confirmation SMS and it appears in your statement.

Till number (Buy Goods) is for in-person payments at a physical location. The customer taps “Pay Bill,” selects “Buy Goods,” enters your till number, and pays. Common in supermarkets, restaurants, and shops.

STK Push is when the payment request goes to the customer’s phone rather than the customer initiating it. You enter the customer’s number and the amount, hit send, and a prompt appears on their phone asking them to enter their PIN. It’s smooth, feels professional, and works well for invoiced amounts where you know exactly what they owe.

B2C (Business to Customer) is payments you send out — paying suppliers, refunding customers, running disbursements.

The reconciliation problem

The problem is not M-Pesa itself. The problem is that M-Pesa and your accounts system are two separate things that never talk to each other.

You have:

• A stack of invoices (in Excel, in QuickBooks, or on paper)
• A M-Pesa statement (a PDF or Excel from mySafaricom Business)

Reconciliation is the manual, error-prone process of matching one to the other.

When this works, it takes two hours a month. When it doesn’t work — when customers pay wrong amounts, use different numbers, or send payments in instalments — it can take a full day. And at the end of it, you still have “unknown” payments you can’t account for.

How automatic reconciliation works

A proper business system connects directly to Safaricom’s business API (called Daraja). Once connected, the system:

1. Receives every incoming M-Pesa payment in real time — no statement download needed
2. Attempts to match each payment to an open invoice by amount, customer, or reference number
3. Automatically reconciles the ones it can match
4. Flags the unmatched ones for your review — there will always be a few, but far fewer than today

For STK Push, it’s even cleaner: you initiate the payment request from within the system, the customer pays, and the system receives confirmation and closes the invoice automatically.

Your M-Pesa and your accounts are one system, not two.

What this means in practice

You stop downloading statements. You stop opening Excel to do matching. You stop having unexplained cash in your M-Pesa account.

Your daily close takes 10 minutes instead of two hours. Every payment is accounted for. Your debtors list is accurate because it updates in real time as customers pay.

At month end, your accountant doesn’t spend three days figuring out where the money went. The reconciliation is already done.

The account number trick most businesses miss

One easy improvement you can make today, even before you have a system: tell your customers to use their invoice number as the M-Pesa account number when they pay to your Paybill. This turns an unidentifiable “JOHN K” into “INV-2024-001” that you can match instantly.

It doesn’t solve everything, but it eliminates most of the guesswork.

To see how M-Pesa reconciliation works inside a full business system — with real invoices, real customers, and real transactions — explore the platform. Or book a call and we’ll show you the live demo.