Find payments your records missed
See money that reached M-Pesa but never made it into the sale, invoice or customer record it belongs to.
Free business template
M-Pesa
Reconciliation Template
If M-Pesa and your records do not match, one of them is lying about your business.
A payment can be missing from your sales records. A sale can be marked paid with no matching transaction. A withdrawal can go unexplained. Match every M-Pesa transaction to the business activity behind it, then investigate every difference before it becomes part of a bigger problem.
Free to use. No sign up required.
M-Pesa Reconciliation
Business Name: Your Business Name
| Date | M-Pesa ref | Type | Money in | Money out | Business ref | Variance | Status |
|---|---|---|---|---|---|---|---|
| 2026-09-01 | TIA4K8P2Q1 | Customer pay | 3,800 | 0 | #1048 | 0 | Matched |
| 2026-09-01 | TIA7C2M9R4 | Customer pay | 6,500 | 0 | #1049 | 0 | Matched |
| 2026-09-02 | TIB1N6L3X7 | Withdrawal | 0 | 5,000 | EXP-218 | 0 | Matched |
| 2026-09-02 | TIB4V8D6H2 | Customer pay | 4,200 | 0 | #1050 | 2,200 | Review |
| 2026-09-03 | TIC5B3W1J8 | Customer pay | 8,400 | 0 | — | 8,400 | Unmatched |
| 2026-09-03 | TIC9Q7E5K3 | Charge | 0 | 35 | FEE-091 | 0 | Matched |
M-Pesa money in22,900
Matched14,500
Needs review8,400
Catch duplicates before they distort revenue
Spot repeated references and duplicated entries before the same payment quietly gets counted twice.
Explain where the money went
Separate customer payments from transfers, withdrawals, refunds, reversals and charges instead of treating every movement as sales.
Make unexplained differences impossible to ignore
Keep unmatched and mismatched transactions visible until someone can explain exactly what happened.
Everything you need to make M-Pesa money explainable.
Record each movement, connect it to the business activity behind it and keep differences visible until they are resolved.
M-Pesa transaction log
Money in and money out
Business reference matching
Charges and fees
Automatic variance check
Match status
Discrepancy notes
Reconciliation trail
Customer payments
Withdrawals, refunds and reversals
Till, PayBill and Pochi references
Example entries to help you get started
Use it where you already work.
Google SheetsUse it online
Open the M-Pesa Reconciliation Template in your browser, update transactions as they happen and keep the latest version accessible across devices.
The live Google Sheets link will appear here after delivery is approved.Microsoft ExcelWork offline
Download the M-Pesa Reconciliation Template to Excel, work offline and keep your reconciliation records with the rest of your business files.
The Excel file will appear here after the download-delivery approach is approved.Do not make the numbers agree. Make every difference explainable.
Start with the transaction, find what it belongs to, compare the amounts and clear only what you can prove.
Add the M-Pesa transaction
Start from the transaction itself. Record the date, reference, type and amount exactly as it appears in your M-Pesa records.
| Transaction | Value |
|---|---|
| Date | 2026-09-01 |
| M-Pesa ref | TIA4K8P2Q1 |
| Amount | 3,800 |
Find what it belongs to
Match the transaction to the sale, expense, refund, transfer or other business record that should explain why the money moved.
| Matching | Value |
|---|---|
| M-Pesa ref | TIA4K8P2Q1 |
| Business ref | #1048 |
| Type | Sale |
Compare the amounts
Check whether M-Pesa and your business records agree. If they do not, keep the variance visible until you understand why.
| Variance check | Value |
|---|---|
| M-Pesa amount | 4,200 |
| Recorded amount | 2,000 |
| Variance | 2,200 |
Clear what you can prove
Mark a transaction reconciled only when you can explain what happened. Leave unresolved transactions open instead of forcing the sheet to balance.
| Status | Value |
|---|---|
| Matched | 14,500 |
| Needs review | 2,200 |
| Unmatched | 8,400 |
A balance tells you what is there. Reconciliation tells you whether it makes sense.
What is M-Pesa reconciliation?
M-Pesa reconciliation connects transactions in a Till, PayBill, Pochi or other M-Pesa account to the sale, expense, refund, transfer or withdrawal that explains them.
Does every M-Pesa movement have a business record behind it?
Not every payment is sales revenue. A strong reconciliation record keeps customer payments, charges, withdrawals, refunds, reversals and transfers separate so they do not quietly distort the picture of the business.
Frequently asked questions
Is this M-Pesa Reconciliation Template free?
Yes. The template is free to use. You can use the Google Sheets version online or download the Excel version and keep your own copy once those delivery links are connected.
What is M-Pesa reconciliation?
M-Pesa reconciliation is the process of comparing M-Pesa transactions with the sales, expenses, refunds, transfers and other transactions recorded by your business. The goal is to confirm that every movement of money has a valid business record behind it and to investigate anything that does not match.
Why reconcile M-Pesa if I can already see my balance?
Your balance tells you how much money is currently in the account. It does not tell you whether every sale was recorded, whether a payment was counted twice, whether a withdrawal was accounted for correctly or whether an unexplained transaction exists.
How often should I reconcile M-Pesa?
Daily is best for an active business with frequent M-Pesa payments. The longer you wait, the more transactions you have to reconstruct and the harder it becomes to remember why a payment, withdrawal, refund or transfer happened.
Can I use the template for Till, PayBill and Pochi transactions?
Yes. The reconciliation principle is the same: record the transaction, identify what it relates to, compare it with the business record and investigate anything that does not match. Add a field for the M-Pesa account or collection method if your business uses more than one.
What should I do when an M-Pesa payment has no matching sale?
Mark it as unmatched instead of forcing it against another transaction. Check the reference, amount, customer, date and related order information until you can identify what the payment belongs to. An unexplained payment is something to resolve, not something to hide.
Can I record M-Pesa charges, withdrawals, refunds and reversals?
Yes. They matter because not every M-Pesa movement is sales revenue. Keeping them separate helps you understand why money entered or left the account and prevents those movements from distorting your sales numbers.
Do I need accounting knowledge to use this template?
No. The core job is simple: record what happened in M-Pesa, identify the business activity behind it, compare the amounts and investigate what does not agree. The discipline matters more than accounting jargon.