How to reconcile mobile money statements for a group fund
A monthly reconciliation routine for group funds using MoMo, M-Pesa or other wallets — matching payments to members, spotting fees and reversals, and fixing differences.
Reconciliation means checking that your records match the money actually received and paid by the provider. It's the most important control a group fund has. It catches missed payments, duplicate entries, unexpected fees and, occasionally, fraud. With mobile money it's also where most "I paid but you didn't record it" disputes get solved. This guide is a monthly routine any treasurer can follow.
What you need
- the wallet statement for the month from your provider (app, USSD request or agent);
- your member payment records for the same period;
- the bank statement if you sweep wallet funds to a bank (see opening a group bank account).
The five-step routine
1. Agree the opening and closing balances. Your records' opening balance should equal the statement's opening balance. If not, last month's reconciliation wasn't finished, so fix that first.
2. Match every incoming payment. For each credit on the statement, find the member payment in your records with the same amount and date (allow a day either side). Tick both. Watch for:
- members paying from a spouse's or relative's number; record the extra number against the member;
- one payment covering several months; split it in your records;
- two members paying from one number; confirm the split with them.
3. Match every outgoing payment. Each debit should correspond to an approved loan, welfare payment, sweep to the bank or expense. Any debit without an approval is a red flag; investigate immediately (see preventing fraud in group funds).
4. Account for fees, charges and reversals. Withdrawal and transfer fees are real expenses; record them. Reversed transactions appear twice (out and back in), so make sure your records don't treat them as two payments.
5. List and resolve the differences. Whatever doesn't match goes on a list:
- statement items not in your records (usually unrecorded payments; add them);
- record items not on the statement (payment claimed but not received; ask the member for proof);
- unidentified credits (put them in suspense until confirmed).
When everything is matched, closing balances agree. The treasurer and a second officer sign off.
Common problems and fixes
| Problem | Likely cause | Fix |
|---|---|---|
| Member says they paid, not on the statement | Sent to wrong number or failed | Ask for the transaction ID; check with provider |
| Screenshot shown, not on statement | Fake or edited screenshot | Rely on the statement, not screenshots; see receipts and proof of payment |
| Balance lower than records | Unrecorded fees | Record fees as an expense |
| Same payment recorded twice | Manual double entry | Remove duplicate; add a check for same amount and date |
Make it easier next month
- Use a group short code, till or payment link so every payment carries a reference; see collecting dues with mobile money.
- Ask members to include their member number in the payment reference.
- Keep a register of members' paying numbers.
- Move off manual matching. Software that records payments automatically from the provider removes most of the work. See spreadsheet vs software for group records.
Then report
Once reconciled, publish your monthly financial report. A report built on reconciled numbers is one members can trust.
Frequently asked questions
How often should we reconcile?
At least monthly, before the monthly report goes out. Busy funds with many daily payments benefit from a weekly check.
What if a payment can't be matched to any member?
Put it in a suspense list, post a neutral message asking who sent that amount on that date, and don't credit it to anyone until it's confirmed.
Who should do the reconciliation?
Ideally someone other than the person who records payments. At minimum, a second officer should review and sign it off.
This guide is general information to help groups organise themselves. It isn't financial, tax or legal advice — rules for savings groups differ by country, so check with a qualified adviser for your situation.