Custom School, College & Training Institute Portals: Automating Fee Reconciliation, Parent Alerts, and Digital Learning

Why Legacy School Software Leaves Bursars and Principals Drowning in Paper

At the start of every academic term or semester, private K-12 schools, international academies, colleges, TVET institutes, and professional training centers face the same administrative chaos: hundreds of parents pay school fees via M-Pesa Paybill, bank deposits, or cheques—and then have to physically queue at the bursar's office with paper bank slips or SMS screenshots to get a gate clearance pass. Meanwhile, the finance office spends three weeks trying to reconcile 400 unmatched payments where a parent typed their own name instead of the student's admission number.

When institutions rent legacy desktop school software or rigid per-student SaaS portals, they face constant LAN crashes, manual grading spreadsheets, and recurring per-student fees that grow every term. At devManue EdTech & Institutional Engineering, we build fast, cloud-and-LAN-resilient School, College, and Training Management Portals with 100% ownership and zero per-student licensing fees.

1. Core Institutional Portal Modules & Fixed-Price Build Breakdown

Our modular architecture unifies admissions, automated fee accounting, academic grading, transport/boarding, and parent WhatsApp/SMS communication:

2. Solving the #1 Bursar Headache: Fuzzy Student Fee Matching & Sibling Splits

Why do 20% of M-Pesa Paybill and bank fee deposits fail to reconcile automatically in standard school systems? Two reasons: either a parent enters a typo in the admission number (e.g., ADM 2041 instead of ADM-2041), or a parent with two children in the school sends a single lump-sum payment of KES 85,000 to cover both children.

Our fee ingestion engine resolves both automatically: first, it normalizes admission numbers and falls back to matching the sender's phone number against registered parent/guardian profiles; second, if a lump-sum payment exceeds Child A's term balance and the parent has a second enrolled child with an unpaid balance, the system can automatically allocate the overflow (or prompt the parent via WhatsApp to confirm the sibling split in one tap):

# Intelligent Student Fee Reconciliation & Sibling Overflow Allocator in Django
import re
from decimal import Decimal
from django.db import transaction
from .models import StudentAccount, GuardianProfile, FeeReceiptLedger

def normalize_admission_ref(raw_ref: str) -> str:
    return re.sub(r"[^A-Z0-9]", "", (raw_ref or "").upper())

@transaction.atomic
def allocate_incoming_school_fee_payment(
    gateway_tx_id: str, sender_phone: str, raw_account_ref: str, amount_kes: Decimal
) -> list[FeeReceiptLedger]:
    """Matches incoming M-Pesa/Bank deposit by Admission No or Guardian Phone and allocates across siblings."""
    clean_ref = normalize_admission_ref(raw_account_ref)
    student = StudentAccount.objects.select_for_update().filter(normalized_adm_no=clean_ref).first()

    if not student:
        # Fallback: Lookup guardian by verified phone number if parent typed wrong admission number
        guardian = GuardianProfile.objects.filter(phone_e164=sender_phone).first()
        if guardian and guardian.students.count() == 1:
            student = guardian.students.select_for_update().first()

    if not student:
        # Park in Bursar Suspense Queue with instant search-and-assign button
        return [FeeReceiptLedger.create_unmatched_suspense(gateway_tx_id, sender_phone, raw_account_ref, amount_kes)]

    receipts = []
    applied_primary = min(amount_kes, max(Decimal("0.00"), student.current_term_balance))
    if applied_primary == Decimal("0.00"):
        applied_primary = amount_kes  # Prepayment credit toward next term

    student.current_term_balance -= applied_primary
    student.save(update_fields=["current_term_balance", "updated_at"])
    receipts.append(
        FeeReceiptLedger.objects.create(
            student=student, gateway_tx_id=gateway_tx_id, amount_credited=applied_primary
        )
    )

    # If lump-sum payment has a remainder, check if a sibling has an outstanding balance
    remainder = amount_kes - applied_primary
    if remainder > Decimal("0.00") and student.primary_guardian_id:
        siblings = (
            StudentAccount.objects.select_for_update()
            .filter(primary_guardian_id=student.primary_guardian_id, current_term_balance__gt=0)
            .exclude(id=student.id)
            .order_by("id")
        )
        for sib in siblings:
            if remainder <= Decimal("0.00"):
                break
            sib_alloc = min(remainder, sib.current_term_balance)
            sib.current_term_balance -= sib_alloc
            sib.save(update_fields=["current_term_balance", "updated_at"])
            receipts.append(
                FeeReceiptLedger.objects.create(
                    student=sib, gateway_tx_id=f"{gateway_tx_id}-SIB-{sib.id}", amount_credited=sib_alloc
                )
            )
            remainder -= sib_alloc

    return receipts

Managing a school, college, or training institution? Estimate your 3-year software savings with our Cloud & SaaS ROI Calculator or schedule an Institutional Portal Discovery Call.

3. Frequently Asked Questions (FAQ)