Ghana School Management System (GSMS)

The Challenge

School are managing student records, fee payments, and attendance entirely in Excel spreadsheets. As enrolment grew past 400 students, this became error-prone and time-consuming — administrators are spending hours each week reconciling data across multiple files.

What We Built

We designed and developed a full-stack web portal with role-based access for administrators, teachers, parents/students, accountant. Key features included:

• Student registration and profile management — complete academic history per student
• Term-based fee tracking — automated calculation of outstanding balances with payment receipt generation
• Report Card Creation - automated report cards generation for students at the end of each term
• Attendance logging — per-class, per-day records with absence alerts to parents
• Parent-facing dashboard — real-time access to their child's attendance, grades, and fee status
• Admin reporting — term summaries, financial reports, and export to PDF/Excel

Technologies Used

Next.js · TypeScript · Nest · PostgreSQL · Prisma · Tailwind CSS · Vercel