School Management System: Replacing Paper-Based Operations

The Client

A 30-year-old private secondary school on the outskirts of Nairobi with ~520 students across Forms 1-4. Pre-engagement, all administrative operations were paper-based — fee collection through bank slips, attendance via class registers, report cards typed individually in Microsoft Word, communication with parents through SMS broadcasts and printed letters.

The Problem

• Fee tracking was a nightmare. Bank slips were lost, accountants spent days reconciling who paid what for which child.
• Attendance was retrospective. Parents didn't know if their child was absent until report cards came home — sometimes days after the fact.
• Report cards took 2-3 weeks to produce at end of term — teachers writing comments individually, admins re-typing them.
• Parent communication was one-way — SMS broadcasts didn't allow reply, parents had to physically visit the school for queries.

What We Built

A custom school management platform with three core modules:

• Fee Management: Per-student fee structure, M-Pesa Pay Bill auto-reconciliation, payment plans, automatic receipts via SMS+email, real-time dashboard for accountants.
• Academic Module: Daily attendance via teacher mobile app, gradebook with continuous assessment, automated report card generation with teacher comment templates, customizable for KCSE format.
• Parent Portal: Login per parent, view fees and pay via M-Pesa, see attendance, view grades, receive notifications, two-way messaging with class teacher.

Stack

Next.js 14 frontend, Node.js + Express backend, PostgreSQL database, Africastalking for SMS, M-Pesa Daraja API for fee payment, Cloudinary for student photos, AWS for hosting.

Process

14-week build (longer than typical due to admin training and data migration):

• Weeks 1-2: Discovery, requirements with admins and teachers, sample report card formats
• Weeks 3-7: Core platform development, M-Pesa integration, attendance system
• Weeks 8-10: Parent portal, gradebook, report card engine
• Weeks 11-12: Data migration (520 students, fee history, parent contacts)
• Weeks 13-14: Teacher training (3 sessions), admin training (1 session), parent rollout

Results After 1 Term (3 months)

• Admin time: 22 hours/week saved across the bursar and registrar offices
• Fee collection cycle: 21 days → 7 days (-67%) — auto-reconciliation eliminated manual matching
• Defaulter follow-up: Manual phone calls → automated SMS reminders. Default rate dropped from 28% to 12%.
• Report card production: 2-3 weeks → 4 days. Teachers select from comment templates, system compiles.
• Parent engagement: 14% of parents previously came to school for queries each term. Now 49% engage via the portal monthly (3.5× engagement).
• Late fees collected: +KES 380,000 in the first term (previously not collected because tracking was too hard).

What Worked

• M-Pesa auto-reconciliation was the single biggest time saver. The accountant said it "changed her life".
• Teacher mobile app for attendance took adoption seriously — 2 hours of training per teacher, not just a download link. By week 2 of term, all teachers were using it.
• Parent portal opt-in via WhatsApp instead of email. WhatsApp is universal in Kenyan parent communities — email less so.

What We'd Do Differently

• Earlier teacher involvement. We finalized the gradebook with admins, then teachers found friction at training. Should have prototyped with 2-3 teachers in week 5, not week 13.
• Bilingual (Kiswahili) sooner. Some parents asked for Swahili portal — we hadn't built it. Now retrofitting.
• Better offline support. Some teachers in low-bandwidth classrooms couldn't mark attendance. Adding offline-first PWA capability now.

Engagement Continues

Standard maintenance plan plus quarterly feature add-ons. Currently building Form-by-Form analytics dashboard for the principal.