M-Pesa Reconciliation Template (Free Template)

Match each sale meant to be paid by M-Pesa against the corresponding receipt on your till statement. A sale with no matching payment, or a payment with no sale, is a gap to trace. Doing this daily keeps gaps small and traceable.

The usual causes are a sale recorded but not paid, a sale paid but not recorded, or a customer paying the wrong number. Matching line by line tells you which one it is.

The money is real but went elsewhere, so it reads as a shortfall until traced. Deactivating old till numbers prevents this, and the customer can request a reversal for a genuine misdirected payment.

Every day at close. A daily reconciliation keeps any gap small and recent enough to trace, while a monthly one buries gaps under a month of transactions with a cold trail.

Veira links each sale to its M-Pesa payment automatically, so reconciliation is done as you trade and any unmatched sale or payment is flagged for you.