Chama Arrears: How to Know Exactly Who Owes What

Most Kenyan chamas collapse not over the original idea but over the confusion about who owes what. Someone swears they paid last month. The treasurer's notebook has a different entry. WhatsApp messages contradict each other. By the time anyone knows who is actually behind, three members have stopped showing up.

Chama arrears are not hard to track if you do it right from the start. The answer is one master sheet—paper or digital—where every payment lands the day it arrives, with the member's name, the date, the amount, and the payment method. Nothing else stops arguments the way a dated receipt does.

What counts as arrears

Arrears equals the expected amount minus what the member has actually paid, counting only the positive difference. If your chama expects KSh 5,000 a month from each of 10 members and Jane has only paid KSh 10,000 over three months, she owes KSh 5,000 in arrears.

The maths is straightforward: figure out how much each person should have paid by now, subtract what they have paid, and the rest is arrears. The hard part is keeping that information accurate so that when you need it—usually when tension builds—you have proof, not guesses.

How to set up tracking that works

Five tools carry almost all of chama record keeping in Excel: SUM, SUMIF, COUNTIF, VLOOKUP, and conditional formatting. Use SUMIF to total each member's contributions by referencing their member number. If you are not comfortable with formulas, keep it simpler: one row per payment, one column for the member, one for the date, one for the amount, one for the method. Add them up by hand each month. It takes an hour. Not knowing costs you thousands.

The golden rule: every transaction lives on one sheet. Not one sheet per month. One master transactions sheet from the day the chama starts. When you record a payment in one place and it shows up automatically in three other reports, your tracking is bulletproof.

Write the date the contribution was due (say, the 5th of each month) and the date it actually landed. Record whether it came through M-Pesa, bank transfer, or cash. When someone pays late, that date matters because it triggers penalties if your group has rules for those.

Who to hold accountable each month

After the contribution deadline passes, create a simple list: member name, expected amount, amount paid, arrears. Highlight the people with arrears in red. This is what the committee meets to discuss. No one argues with a number they can see.

Do this check at the end of every contribution period. If you wait two months, you have missed the chance to catch the problem early when a member can still catch up. By month four, people stop coming to meetings rather than face the conversation.

Digital tools that do this for you

Chamabora, the chama record-keeping app, and platforms like Stanbic Chama, ChamaHub, and Chama.ke all calculate arrears automatically. Stanbic Chama lets you track contributions in real time, manage members digitally, and access your chama anytime through a secure digital platform. When a member pays, the app subtracts it from the expected amount and shows what they still owe.

The advantage of an app over a spreadsheet is speed. The treasurer does not have to recount anything by hand. The system tells you instantly who is up to date and who owes. If you have 15 members or more, or if collecting contributions takes more than two hours of the treasurer's time each month, a tool is worth considering.

Small chamas—five to eight members, monthly collections—work fine on paper or a basic spreadsheet. You know the people well enough to have the conversation. Larger groups need something automated because the human memory fails.

What to do when someone falls behind

The moment you see arrears, call the person. Not the group. Not a WhatsApp broadcast. The member, directly. They may have hit hard times, or they may have forgotten. You do not know until you ask. Listen. Then decide together: do they pay everything at once, or spread it over two months, or defer it?

Write that decision in the meeting minutes. Update the expected-to-date figure to match what you agreed. If the group decides to forgive part of it, write that down too. Never delete history. The record should show the original amount, what was forgiven, and what was actually paid. This preserves an appropriate record of the original charge and the approved waiver rather than simply deleting history.

Some chamas apply a penalty—KSh 500 or KSh 1,000 per month late—to discourage arrears. Others do not. Penalties are calculated and applied when contributions are overdue, with no arguments and no manual work. The key is that the group agrees on the rule before the problem happens, not after.

When to bring in help

If your chama has more than 20 members, ongoing loans, separate welfare funds, and investment income, a spreadsheet stops being enough. A small chama can use a structured spreadsheet, while larger or more complex groups may benefit from dedicated chama management software. An accountant on Kaziiko can also help you set up the system and train the treasurer on how to use it. That costs a few thousand shillings once, and it saves thousands more by preventing theft and confusion.

If you are converting from paper records to digital, confirm all outstanding balances first by checking them against the old notebook. Most groups find small discrepancies here—a payment recorded wrong, a date mixed up—and resolving them is where the value shows up fastest.

Frequently Asked Questions

How do I calculate arrears if a member joins late?

Expected arrears are the contribution amount multiplied by the number of periods from when the member joined to the current period, counting both ends. If someone joins in month three of a 12-month cycle, they are expected to pay nine times, not 12.

What if a member pays extra one month?

The extra payment is a credit—it means they are ahead. Record it separately so that when they miss a month later, you can use the credit against the arrears. This keeps the numbers clean and stops arguments about whether they actually caught up.

Can I use a loan repayment calculator to plan payment arrangements?

Yes. If someone has KSh 15,000 in arrears and wants to pay it back over three months, a calculator shows how much per month and keeps both of you on the same page.

What happens if I do not track arrears?

The chama splits. Members who are paying get angry. Members who are behind disappear. By the time the group tries to collect arrears, the person has left town or stopped answering calls. You lose the money and the member.