How to Reconcile M-Pesa Rent Payments Without Losing Your Weekend

Reconciliation means making sure every shilling you received is matched to the tenant and bill it belongs to. Done by hand, it grows with every unit. Done with a routine, it becomes a short daily job.

1. Give every tenant a stable reference

Most mismatches start with the reference a tenant types. A short, unique tenant account number, printed on the lease and the welcome message, is far harder to get wrong than a unit name written six different ways.

2. Match daily, not monthly

A payment matched today takes seconds. A payment matched at month end means hunting through messages, asking tenants and guessing. A ten-minute daily check beats a weekend at month end.

3. Keep an "unmatched" list

Never force an unclear payment onto a tenant. Park it as unallocated, ask the tenant, then match it and note who did it and why.

4. Treat overpayments as credit

When a tenant pays more than is due, record the extra as credit against the next bill. Do not leave it floating on a spreadsheet row.

5. Reverse, do not delete

If a payment was recorded wrongly, reverse it with a reason. Deleting rows destroys the trail an owner or auditor will ask about.

6. Check at month end

• Total received on your paybill statement equals total recorded
• No payments left unallocated
• Arrears match the list of unpaid bills

Platforms such as Oxflare automate steps 1 to 4 and make step 6 a quick review. See how the M-Pesa Centre works.