How to reconcile M-Pesa payments with invoices

Start with two clean source lists

Keep the invoice list and payment list separate before you start matching. Each invoice should have a stable reference, customer or payer name, expected amount, issue date and current balance. Each M-Pesa record should keep the transaction reference, date, amount and the name or phone information available in the source record.

Do not rename or overwrite the original evidence just to make a match look cleaner. Keep the source value and record your interpretation separately.

Match strong identifiers before amounts

A payment reference, invoice number or clearly recorded customer reference is stronger evidence than an amount alone. Start with exact identifiers, then use amount and timing as supporting evidence.

If several invoices share the same amount, an amount-only match should stay unresolved until another detail confirms it.

• Exact invoice or payment reference
• Payer or customer identity
• Expected versus received amount
• Payment date relative to the invoice
• Any note explaining a split or combined payment

Treat partial and combined payments explicitly

A partial payment should reduce the open balance without making the invoice look fully settled. If one M-Pesa payment covers several invoices, keep a clear allocation showing how much was assigned to each invoice.

Likewise, if several payments settle one invoice, preserve every payment reference. This makes later review much easier than replacing the history with a single total.

Finish with an exceptions list

A useful reconciliation does not force every row into a match. Finish with a short list of unmatched payments, unpaid invoices, duplicate-looking references and amount differences that need a person to review.

ClerkOps Reconciliation can keep invoices, payment evidence and unresolved differences together so the next review starts from the evidence rather than from memory.