Money

M-Pesa paybill reconciler

Match a statement to your customer list in the browser.

Runs in your browser. No signup. Updated 5 November 2026.

Files are read on this device. Nothing is uploaded, and closing the tab discards them.

0payments matched

Matched
-
To check
-
Unmatched
-
Duplicates
-
Skipped
-

Add a statement and a customer list, then match the payments.

Nothing parsed yet

ReceiptDateAmountAccountCustomerStatusWhy
No results yet.

The statement tells you money arrived. The hard part is knowing whose it is. This tool trusts an account reference first, then a full phone number. Anything weaker, such as a masked number or a name, is marked for you to check.

Drop in the statement and a customer list. Each row is marked matched, to check, unmatched, duplicate or skipped, with the reason, and you can download the result as a CSV. Charges and withdrawals are left out because they are not payments.

Before you rely on the number. Nothing is uploaded. The files are read by your browser and discarded when you close the tab. Check the matches before posting anything to your books.

Reference: Safaricom M-Pesa. Rates and rules change; check the current position before acting.

The method

How to reconcile M-Pesa paybill payments

Download the statement from the M-Pesa organisation portal and keep a list of your customers with their account numbers and phone numbers. Check each payment against the account reference first, because that is what the payer typed for the bill. A full phone number is the next best sign.

Statements often hide the middle digits of the phone number, so a masked number or a name is only a suggestion to confirm, not a match. A repeated receipt number is a duplicate, and charges and withdrawals are not payments at all. Reconcile what remains, then follow up the rows nobody can place.

Worked example: four rows from a statement

Two customers on the list, and four statement rows that each end differently.

QAB1: Account referenceMatched
QAB2: Masked phone number fits one customerTo check
QAB1: Same receipt as row 1Duplicate
QAB3: No account, phone or name matchUnmatched

How it works

How to use the M-Pesa paybill reconciler

Bring the statement

Use the CSV or .xlsx you download from M-Pesa, or a cleaned six-column sheet. The tool reads the common Safaricom headers and falls back to the details column for the account.

Bring the customer list

Use your BillGrid account export or the template: account number, customer name and phone. A list without headers, in the order account, name, phone, also works.

Check before posting

A match by account reference is the strongest. Rows marked to check are suggestions and are not counted as matched. Review them, and every unmatched and duplicate row, before you change a balance.

Questions we get

Questions about the M-Pesa paybill reconciler

Is my statement uploaded anywhere?

No. The parsing and matching run in this browser tab. The file is not sent to a server, and the page does not keep it after you close the tab.

Which statement format works?

CSV or .xlsx with the common Safaricom columns (Receipt No., Completion Time, Paid In, Other Party Info, A/C No., Status) works directly. Other sheets work when they have receipt, amount, date and account or phone columns. Save a PDF or old .xls as CSV first.

How are duplicates detected?

A repeated receipt number is flagged as a duplicate. Two genuine payments cannot share a receipt number, so a repeat is usually a row imported twice.

What does a phone match mean?

A full phone number on the statement matches a customer on its last nine digits, which is a good signal but weaker than an account reference. Statements often hide the middle digits. A masked number that fits one customer is only marked to check.

Keep reconciling after the upload

BillGrid imports the statement, applies each payment to the oldest balance first, and keeps the unmatched rows in a queue instead of a spreadsheet.

Or reach us directly

We reply within one business day.