How to Reconcile M-Pesa Rent Payments Without a Spreadsheet

Reconciliation is the unglamorous job of checking that the money you received matches the rent you expected — unit by unit. For many Kenyan landlords it looks like this: open the M-Pesa statement, open a spreadsheet, and match names to houses one line at a time.

It works for five units. It breaks at twenty.

Where manual reconciliation goes wrong

• Wrong or missing account numbers. "Rent", "August", a phone number, or nothing at all.
• Someone else pays. A parent, spouse or employer sends the money, so the name on the message doesn't match your tenant list.
• Partial and split payments. KSh 10,000 on the 3rd and KSh 5,000 on the 12th for the same house.
• Overpayments. A tenant pays two months at once, and next month you forget they're already covered.
• Duplicates. The same transaction gets entered twice, and suddenly your totals don't add up.

Each of these is small. Together they cost hours every month and create the disputes that damage tenant relationships.

What good reconciliation looks like

1. Every payment is matched to a unit the moment it arrives, using the account number first, then the unit label, then the payer's phone number.
2. Duplicates are ignored automatically, using the M-Pesa transaction code as a unique reference.
3. Payments that can't be matched are parked, not lost, in a short queue you clear with one tap.
4. Money is applied to the oldest balance first, so arrears are always accurate.
5. Overpayments become credit that is applied to next month's invoice automatically.
6. Cash and bank payments go through the same process, so your ledger is complete.

Keep an audit trail

Whenever something is changed by hand — a payment assigned, reversed or an invoice cancelled — it should be recorded with who did it and why. That trail protects you if a tenant or co-owner ever questions the numbers.

Automate it

NyumbaPay does all of the above. Connect your Paybill, give each unit an account number, and the app keeps every balance up to date on its own. Your monthly reconciliation becomes a quick look at the "Needs assigning" list — usually empty.