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.
1. The statement
2. Your customers
Files are read on this device. Nothing is uploaded, and closing the tab discards them.
The result
0payments matched
- Matched
- -
- To check
- -
- Unmatched
- -
- Duplicates
- -
- Skipped
- -
Add a statement and a customer list, then match the payments.
Columns read
Payments
| Receipt | Date | Amount | Account | Customer | Status | Why |
|---|---|---|---|---|---|---|
| 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.
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 reference | Matched |
| QAB2: Masked phone number fits one customer | To check |
| QAB1: Same receipt as row 1 | Duplicate |
| QAB3: No account, phone or name match | Unmatched |
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 going
Related free tools and guides
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.