How to Track Chama Contributions Without Excel (A Treasurer's Guide)

Every chama treasurer knows the feeling: it is the night before the monthly meeting, the WhatsApp group has 40 M-Pesa screenshots, two members say they paid but you cannot find their message, and the Excel sheet has a formula somebody broke in March.

This guide shows how to keep a chama contributions record that members trust, first with a simple manual system, and then by letting chama software do the work.

Why contribution records go wrong

Most disputes in chamas are not about fraud. They come from records that nobody else can check. The usual causes:

• Money arrives in a personal M-Pesa line. Contributions mix with the treasurer's own money, and nobody can see the full picture.
• Payments are matched by memory. Mary paid KES 2,000 from her husband's line. Six months later, nobody remembers.
• One copy of the truth. The Excel file lives on one laptop. When the treasurer changes, history is lost.
• Partial payments and arrears are not tracked. Members who pay half are recorded as "paid", and the gap appears at share-out.
• Fines and contributions are mixed. A KES 200 lateness fine gets counted as savings, and shares come out wrong.

Step 1: Give every member a number

Assign each member a permanent member number, such as UM001, UM002 and so on. Use it on every record, receipt and payment. Names get misspelled. Numbers do not.

Step 2: Stop receiving money on personal lines

Open a group bank account and, ideally, an M-Pesa paybill linked to it. Ask members to pay with their member number as the account number. Now every payment carries the member's ID, and the money never touches an official's personal wallet. This one change prevents most disputes.

Step 3: Keep a proper contributions register

Whether on paper or in a spreadsheet, the register should have one row per payment, not one row per member per month. At minimum:

The Type column is what keeps savings, fines, welfare and loan repayments apart. The reference column is what settles arguments.

Step 4: Summarise monthly, per member

From the register, build a monthly summary: expected amount, amount paid, balance (arrears) and running total of savings for each member. Share this summary with all members after every meeting, not just at the AGM.

Step 5: Reconcile every month

Once a month, check that the total in your register equals the money in the bank and paybill statement, minus withdrawals, loans issued and expenses. If they do not match, find the difference that month. A KES 3,000 gap is easy to trace after four weeks. After a year, it is almost impossible.

Step 6: Write the rules down

Agree, in your constitution, on the contribution amount, the due date, the grace period and the fine for late payment. Also agree what happens to a member who falls three months behind. Records only work if everyone knows what the numbers are measured against. Our guide on running a successful chama covers the rules most groups need.

Where Excel stops working

A well-kept spreadsheet can carry a small group for a while. It starts to fail when:

• you have more than about 20 members, or several contribution types;
• you start giving loans, where interest and repayments must be calculated for each member;
• members want to check their own balance without asking;
• officials change, and the next treasurer inherits a file they did not build;
• you need to share out dividends by share balance at the end of the year.

That is the point where a chama management system pays for itself in the treasurer's time alone.

How ChamaPoint tracks contributions for you

ChamaPoint follows the same principles as the register above, without the manual work:

• Every member has a number and a ledger. Contributions, shares, fines, welfare and loan repayments are posted separately, so they never mix.
• M-Pesa payments post themselves. When a member pays, the payment is recorded against their account automatically, with the M-Pesa reference kept on the record.
• Members check their own statement on the app, the web portal or USSD, so the treasurer stops answering "how much have I saved?" on WhatsApp.
• Reports are ready for the meeting. Member statements and savings summaries export to PDF or Excel.
• History stays with the chama. When officials change, the records do not leave with them.

You can import your member list from Excel and have your chama running in an afternoon. Start a 7-day free trial. No card is required.