Educational Institute & Tuition Centre Tracker | Excel KPI Dashboard | Students, Fee Collection, Classes

Description
Running a tuition centre or educational institute involves far more than teaching. Every month the owner manages student admissions, fee collection from dozens of families, class scheduling across multiple subjects and grade levels, teacher salaries, building rent, utility bills and the endless challenge of following up with students who have not paid their fees — all simultaneously and often without any organised system in place.

Without proper records, fee defaulters go unnoticed for months, new admissions are not tracked, class schedules exist only in the teacher's memory, monthly profit is never clearly calculated and at year end the owner has no data to make informed decisions about expanding or improving the institute.
This Educational Institute and Tuition Centre Tracker solves every one of these challenges in a single professionally designed Excel file. Six powerful working sheets operate together — Student Register, Monthly Fee Collection Tracker, Class and Subject Schedule, Income and Expense Accounts, Staff and Teacher Register and a comprehensive How To Use guide — each with bright colour coded KPI cards displaying the most critical operational numbers the moment the file is opened.

The Student sheet flags fee defaulters instantly and tracks new admissions this month automatically. The Fee Collection sheet shows today's collection, this month's total and pending fee amounts in real time. The Classes sheet tracks morning, afternoon and evening sessions separately with teacher assignments and enrollment counts. The Accounts sheet calculates net profit automatically.
Designed for all institute types — tuition centres, academies, schools and colleges. Works in both Rs. for Pakistan and India and $ for Gulf based institutes — currency change instructions included in the How To Use sheet. Compatible with Microsoft Excel 2016, 2019, 2021 and Microsoft 365. No macros, no cloud subscription and no IT expertise required.