Chama & Investment Group Tracker | Excel Template for Kenyan Businesses

Run your chama with complete transparency — contributions, fund balance, loans, payouts.

Description

Kenya's chama culture is built on trust — and trust is built on clear records. This template manages everything for a group of up to 20 members: monthly contribution tracking with percentage achievement, a running fund balance, group loan management with automatic payoff dates and interest totals, and a merry-go-round payout rotation schedule. Every member can see exactly where the money is at any time.

What's Inside

•       Member Contributions — 20 members x 12 months, % achievement per member

•       Fund Management — running balance, 20-row transaction log, fund summary

•       Loan Tracker — 15 loans, auto payoff dates, total interest, outstanding balance, status

•       Payout Schedule — merry-go-round rotation with pending / paid status

Best For

Chama chairpersons, SACCO committee members, investment club treasurers.

KRA / Tax Note

Supports clean record-keeping for group income and loan interest tracking.