Kenly Krisaguino
School Tuition Blast
A web-based school tuition billing system developed for a private school in Semarang. The platform automated monthly tuition billing, online payment processing through Midtrans, and synchronized payment records with the school's existing accounting system. Built under NDA as a freelance project.
Problem
Many schools still managed tuition billing manually using notebooks and spreadsheets, making monthly billing slow, error-prone, and difficult to track. Staff had to manually create invoices, verify bank transfers, update payment records, and reconcile financial reports. This process often resulted in delayed payment confirmations, duplicate data entry, and limited visibility into outstanding tuition balances.
Role
As the sole End-to-End Developer, I was responsible for the complete development lifecycle, including requirement analysis, UI/UX design, system architecture, database design, backend development, payment gateway integration, API development, deployment, and ongoing maintenance.
Solution
I built a web-based tuition management system that automated monthly invoice generation, payment tracking, overdue billing, and financial reporting. The platform integrated Midtrans Payment Gateway to enable secure online payments with automatic payment confirmation through webhooks.
The application also synchronized payment data with the school's existing accounting system, reducing duplicate work and ensuring financial records stayed consistent across systems. Scheduled cron jobs automated recurring billing and overdue processing.
Tech Stack
- Laravel
- PHP
- MySQL
- Midtrans Payment Gateway
- REST API
- Cron Jobs
Result
The system significantly reduced manual administrative work by automating recurring tuition billing and payment verification. Online payment integration accelerated confirmation times, minimized human error, and improved visibility into paid, unpaid, and overdue invoices while keeping the accounting system synchronized.