This Tool Saves You From Group Member’s List in excel Hell when registering a CBO/ SHG.

If you’ve ever tried registering a community group — whether it’s an SHG (Self-Help Group) or a CBO (Community-Based Organization) — at the official portal

👉 https://cdmis.socialprotection.go.ke:8002/selfregistration/communitygroupregistration
you already know where the real battle begins.

It’s not the portal.
It’s not the approval.
It’s not even the group name.

No — the nightmare lives in that Excel members list they want you to upload.

The Social Protection Portal is picky with the format — even a tiny mismatch — their system hits you with the dreaded:
“Validation Failed”
…even after you’ve spent hours squeezing your members into their strict template.

Most people get stuck here. Not because they don’t have members — but because the Excel format is unforgiving.

The Required Member’s List in Excel Format

Their template isn’t just a table — it’s a landmine. Every row and column must behave exactly the way the system expects.

Here’s what their member’s list in Excel file MUST contain:

Mandatory Columns (in this exact order):

1. First Name
2. Middle Name
3. Last Name
4. Identity Number (ID number only, no spaces or text)
5. Date of Birth (formatted as YYYY-MM-DD)
6. Gender (Male / Female / Intersex — nothing else accepted)
7. Email Address (must be valid format, even if it’s simple Gmail)
8. Mobile Number (2547… format — not +254, not 07…)
9. Member Role (Chairperson, Secretary, Treasurer, Member, etc.)
10. Disability (None / Yes — with a brief explanation if Yes)

And the rules they don’t tell you upfront:

• No merged cells
• No hidden rows
• No colored headers
• No blank rows in between
• No formulas — values only
• No extra spaces before or after names
• Dates must be actual Excel dates, not text
• Gender must match their approved member’s list in excel exactly
• Mobile numbers MUST begin with 2547

Miss even one detail and the whole file gets rejected like it’s allergic to your effort.

Why People Keep Failing Validation

Because the template is unforgiving, and even tiny typos or “invisible” formatting issues make the system reject the file — sometimes without explaining what’s wrong.

You fix one thing, upload again…
Error.
Fix again…
Error.
Repeat until your patience resigns itself from public service.

So We Built a Better Way — A Tool That Solves the Entire Problem

After watching people suffer with the Excel template, I figured:

Why not eliminate the frustration completely?
Why not let people fill out their member’s list online and export a guaranteed-correct file?

So we built exactly that:

✨ A tool that helps you fill out your SHG or CBO members list step-by-step
✨ Validates everything for you — live
✨ Exports a clean Excel file that 100% matches the government format
✨ Guaranteed to pass validation at CDMIS

No more manual editing.
No more hidden errors.
No more guessing what the system wants.

Just fill → download → upload → done.

Try out the Member’s List in Excel Tool

Updates;

– As of 24th of January 2026, you can now upload and validate/edit your member’s list using the tool.

Check out our Online Shop

Check out Our Latest posts

Sample Form

The image on the left displays a screenshot of the first page of the form last updated in 2022. The full form spans 4 pages and is designed as a well-structured questionnaire to ensure easy and accurate collection of group information.

Download Replacement Form 2022

Simply click on the button below to download or print the document.

Click Here to Download/View/Print CBO Replacement Form (2022) Generate a Constitution for Your Group

Read more
Check out our online shop

Having a clear and simple group constitution is essential for SHGs and CBOs. A constitution is the foundation that ensures your group is democratic, transparent, and accountable.

It provides rules on how decisions are made, funds are managed, and how members engage in shaping the organization’s direction. More importantly, it builds trust among members and potential funders who want to see that the group operates fairly.

This post discusses everything you need to know about a group constitution.

What Is a Group Constitution and Why It Matters

A group constitution is a written agreement that outlines how your group operates. It describes who can make decisions, how meetings are conducted, and how finances are handled.

For funders and partners, it’s proof that your group has a solid structure and is capable of managing resources responsibly. For members, it ensures equality that decisions are not made by a single individual or small group.

A well-written constitution provides clarity, prevents disputes, and sets the tone for good governance.

Planning Your Group Constitution

Before writing a constitution, spend time discussing with your group how you want things to run. Keep it simple, practical, and realistic for your size and capacity.

Most group constitutions cover these key areas:

Building a Democratic Structure

Strong governance starts with fair decision-making.
Many groups appoint a committee to oversee daily activities and make important decisions on behalf of members. A typical committee includes:

Elections should be held annually at an (AGM), where members review progress, approve finances, and plan for the year ahead.

Some smaller groups choose not to have a formal committee but instead share responsibilities equally among members. This works well if everyone is active and committed to teamwork.

Meetings and Member Involvement

Regular meetings are key to keeping members informed and engaged.
Groups should hold an Annual General Meeting (AGM) each year, as well as other meetings every now and then.

AGMs typically include:

• Reviewing the group’s activities over the past year
• Presenting and approving financial reports
• Electing new committee members
• Discussing any proposed changes to the constitution

To guarantee fairness, set a quorum — the lowest number of members who must be in attendance to make decisions.

Financial Accountability

Financial transparency builds trust with both members and funders. Your constitution should clearly state how money will be managed.

Key points include:

• The group will preserve a bank account in its name.
• There will be at least two signatories (from different households).
• Every business will need two signatures or approvals.
• The Treasurer will keep proper records and hand over financial reports regularly.
• All funds raised must be used only for the group’s objectives.

Such rules guarantee that funds are handled responsibly and that every shilling can be accounted for.

Drafting and Adopting the Constitution

Generate a Constitution for Your Group

After discussions, appoint one or two members to draft the group constitution. Review it together as a group before formally adopting it.

At least two members should sign and date the final version to confirm agreement. Keep copies safely filed and share them with all members especially new ones.

The group constitution should be a living document. If your group grows or changes its system, you can amend it through an AGM or Special General Meeting.

Why Funders Value Good Governance

Funders and partners look for groups that show strong internal systems.
A clear constitution signals that your group:

• Makes collective and transparent decisions
• Respects member participation
• Manages finances responsibly
• Has continuity plans and leadership stability

Good governance is a sign of credibility. It shows that your group can handle funding, partnerships, and responsibilities effectively.

Final Thoughts

Starting a community group is exciting — but sustaining it requires structure and accountability.
A well-written group constitution keeps your group organized, fair, and trustworthy. It protects members’ rights, prevents conflicts, and helps you attract support and funding.

If your group hasn’t yet drafted one, now is the perfect time to start. With clear aims, democratic systems, and transparent financial management, your community initiative will stand on strong and lasting foundations.

Need a Sample group constitution in PDF? Got one here or here
Read more

Generate a Constitution for Your Group

Sample Form

The image is a screenshot of the first page of the form last updated in 2016. The full form spans six pages.

Download SHG Form 2016

Simply click on the button below to download or print the form for free.

Get SHG Registration Form (2016)

Download Form 2022

Simply click on the button below to download or print the form for free.

Get SHG Registration Form (2022) Generate a Constitution for Your Group

Visit our online shop

Read what we’ve been talking about.

Sample Form

The image on the left displays a screenshot of the first page of the CBO registration form last updated in 2016. The full form spans six pages and is designed as a well-structured questionnaire to ensure easy and accurate collection of group information.

Download CBO Registration Form

Simply click the button below to access, download or print the form.

Click Here to Download/View/Print CBO Reg Form (2022) Generate a Constitution for Your Group

Visit Our Digital Shop

What we’ve been talking about

Registering a Community Based Organization (CBO) in Kenya is a structured process that ensures your group can operate legally while accessing various benefits, such as funding and government support. A CBO typically operates within a community, focusing on development, welfare, and other community-focused activities.

This article will guide you step-by-step on how to register a CBO in Kenya.

The Short Version: To register a CBO in Kenya, prepare the necessary documents and submit your application through the eCitizen portal under the Department of Social Services.

Requirements for Registering a Community Based Organization

Before beginning the registration process, it is essential to ensure that you have met all the necessary requirements. These requirements to register a CBO include:

1. A Minimum of 10 Members: Your CBO should consist of at least 10 members, and these members must be over the age of 18 and Kenyan citizens.
2. Group Members List in Excel: You will need to provide a members’ list in Excel format, detailing each member’s full name, ID number, phone number, and signature. This list will be part of the official registration process.
3. A Group Constitution: Your group must have a constitution outlining the CBO’s objectives, rules, and operational procedures. The constitution should clearly define the roles of the executive team (chairperson, treasurer, and secretary) and outline the process for electing officers, handling funds, and resolving disputes. You can create one for free using our tool here.
4. Minutes of the Meeting Agreeing to Register: You will need the minutes of the meeting where your group agreed to register as a CBO. These minutes should include details such as the members present, resolutions made, and who was tasked with initiating the registration process.
5. An Application Form: You will need to fill out the CBO registration application form. This form can be downloaded here.
6. Registration Fee: Be prepared to pay a registration fee, which is usually around Ksh 5,000.

Generate a Constitution for Your Group

Steps for Registering a CBO

Once you have met the requirements, follow these steps to register your Community based Organization:

Once approved, your CBO will receive a Certificate of Registration. This certificate gives your group the legal authority to operate as a registered CBO within Kenya.

Benefits of Registering a Community Based Organization

Registering your Community based organization provides several advantages, including:

• Access to Funding: Registered CBOs can apply for government and NGO funding, which is essential for running community projects.
• Government Support: A registered CBO can receive government assistance for projects that align with national or county development goals.
• Legal Protection: The registration process ensures your group operates within the law, protecting members from legal disputes or penalties.
• Networking Opportunities: Registered CBOs can collaborate with other organizations, both locally and internationally, to achieve their objectives.

Registering a Community based organization in Kenya is a straightforward process that empowers your group to legally engage in community development activities. By meeting the outlined requirements and following the steps provided, you can successfully register your CBO and unlock various opportunities for growth and impact in your community.

Check out our recent posts
Check out our online shop