How to Build a Complete Student Fee Management System with Google Apps Script and React | D50

A complete student fee management system that runs on Google Sheets as its database, with a React dashboard on top. Schools that track fees in loose spreadsheets end up with the same three problems: nobody knows who has paid, receipts live in someone's WhatsApp, and reminders never go out on time. This system puts collection, approval and reminders in one place, without a server to rent or maintain.

What it does

Students are registered with their class and section, and linked to a parent record. Fees are raised against a student by category, payments are entered as they come in, and each payment passes an approval step before it counts as paid — so a claimed transfer is never silently treated as cleared. Automated emails go out as fee reminders.

Highlights

• Student, parent and user management with role-based access
• Fee categories and payment methods you define yourself
• Payment approval workflow before any fee is marked paid
• Class, section and academic information setup
• Automated email fee reminders
• Google Sheets as the database — open the sheet and every record is right there
• React front-end, no hosting or server cost

Who it is for

Schools, academies, tuition centres and coaching institutes that collect recurring fees and want the audit trail in a spreadsheet they already understand. It also works as a starting point if you are learning how to wire Google Apps Script to a React front-end on a real system rather than a toy demo.