No products in the cart.
Managing a Language Center with Excel
01/04/2026
No Comments
Share:
10 min read
Opening a language center often starts with a passion for teaching. But after just a few months, the operator realizes they're spending most of their time on entirely different things.
Specifically: room scheduling conflicts, teachers asking how their salaries are calculated, parents messaging on Zalo to inquire about outstanding balances. Meanwhile, they themselves are wondering — which classes are profitable, and which are losing money?
This isn't a unique problem. This is an operational challenge that most language centers with 50–200 students face.
The solution is often piecemeal: an Excel sheet for scheduling, a ledger for tuition collection, a separate salary spreadsheet. They have all the files, but none of them communicate with each other.
This article shares specific pain points in managing a language center with Excel and a more systematic approach.
“I opened the center because I wanted to teach — but 70% of my time is spent on scheduling, calculating salaries, and chasing tuition fees. Many days, I no longer feel like a teacher.”
— A common saying in the language center management community
In this article
- Làm sao xếp lịch dạy hiệu quả cho trung tâm ngoại ngữ?
- Vì sao thu học phí nhiều mà không biết mình còn bao nhiêu?
- Quản lý lương giáo viên với 4 loại hợp đồng thế nào?
- Which classes are profitable, and which incur losses? — a question most center owners can't answer.
- Solution: ClassPilot — Structured Excel for centers with 50–500 students.
- Frequently Asked Questions
Scheduling — A Never-Ending Combinatorial Challenge
Imagine this: 5 classrooms, 10 teachers, and 20 classes running simultaneously. Each class has a fixed schedule. Each teacher has their own constraints — some only teach in the evenings, some cannot be scheduled for 2 consecutive shifts.
Additionally, classrooms vary in capacity — kids' classes need smaller rooms, IELTS classes require smart boards. All of this creates a complex combinatorial problem.
When a teacher is absent — the domino effect begins.
Normally, things run smoothly. But come Monday, a teacher calls in sick. The operator has to find a substitute teacher within a few hours.
Therefore, this is when everything starts to unravel. The available substitute is already teaching another class at that time. Or isn't familiar with the students' level. Or the classroom is already fully booked. The result: urgent rescheduling announcements, frustrated parents, and students missing classes.
Manual Scheduling
- Visually checking conflicts per shift
- Replacing a teacher = re-evaluating the entire weekly schedule
- Uncertainty about room availability
- Schedules change constantly, and parents receive late notifications.
- Lose 2–3 hours each week just to reorganize.
Systematic Scheduling
- Dashboard displaying available rooms / teachers by time slot.
- Conflict alerts in real-time during data entry.
- Find suitable substitute teachers in 5 minutes.
- The class schedule always reflects the actual status.
- Save 80% of the time spent on manual scheduling
The core problem isn't a lack of information — it's scattered information. Everyone knows which teacher teaches which class, and which rooms are available.
However, when you need to quickly look it up in an emergency, there's no single place to look. That's the difference between with data and having a system.
Tuition & receivables — lots of money collected but no idea how much is left
Managing tuition fees might sound simple: tick off those who paid, remind those who haven't. But the reality is far more complex. Parents pay through multiple channels — bank transfers, cash, or via an app.
For example, some pay for an entire 6-month semester at once, while others pay monthly. Some new students receive discounts as part of promotional programs. All this information typically resides in: a Zalo group, a payment ledger, and the administrative staff's memory.
The deferred revenue trap — money in hand isn't necessarily yours.
This leads to a problem that few recognize: the deferred revenue trap (deferred revenue). When parents pay 6 months of tuition fees at the beginning of a term, that money isn't actual revenue yet.
It is an obligation to provide future services. Only when the student completes that month of study do you “recognize” a portion.
Specific example: 90 million collected ≠ 90 million revenue
In September, the center collected tuition fees for the new term: 90 million VND from 60 students, who paid for a 6-month term.
- Actual revenue for September: 15 million (1/6 of 90 million)
- Expenses for September (teacher salaries, rent, utilities): 40 million
- Result for September: a loss of 25 million — even though the bank account balance shows a positive 90 million
If you can't distinguish between cash collected and actual revenue, you might mistakenly spend money that isn't yet yours to spend.
Unaccounted receivables — the amount “no one remembers”
Beyond the deferred revenue trap, there's another common issue: unaccounted receivables.
Students who dropped out mid-term but haven't been refunded. Students with a partial tuition debt from the previous term. Students who registered for additional classes but haven't paid the extra fees. If these amounts are not tracked by the system, year-end summaries often don't reconcile.
And the operator doesn't know where the money “went”.
Teacher salaries — 4 types of contracts, one incorrect spreadsheet means losing staff.
No industry has a compensation structure as complex as private foreign language education. A medium-sized center typically has 4 types of teacher contracts simultaneously:
| Contract type | Salary calculation method | Calculation challenges |
|---|---|---|
| Fixed monthly | X million/month regardless of the number of sessions | The simplest — but few teachers accept this type. |
| % of class revenue | 20–35% of tuition fees collected from assigned classes | Requires tracking actual tuition collected per class, per month. |
| Per teaching hour (hybrid) | Base salary + X thousand/hour × number of actual hours taught | Requires cross-referencing actual teaching schedules with registered shifts. |
| Progressive based on class size | Rate per hour increases with the number of students in the class. | Class size fluctuates when students join or leave mid-term. |
When there are only 3–4 teachers, manual calculation is still feasible. But when the center grows to 8–12 teachers with mixed contract types, everything changes.
The payroll spreadsheet becomes a complex matrix. A small error in the formula can lead to underpayment or overpayment — that no one immediately detects.
More importantly: Good teachers are extremely sensitive to salary.. A single miscalculation — even unintentional — can sow seeds of doubt about management's transparency. In an industry where good teachers always have many options, this is an unnecessary risk.
Which classes are profitable, and which incur losses? — a question most center owners can't answer.
This is the most important business question — and often the most overlooked. The reason is simple: to answer it, you must allocate costs down to each class.
Specifically, you need linked data between class schedules (room hours occupied per class), payroll (teacher costs), and tuition fees (actual revenue).
When this data resides in three different files, aggregation is impractical. Or worse — partly in Excel, partly in a notebook. Most center owners operate by feel: “a full class is a profitable class”. But that's not true.
3 questions to instantly check your classes
- How many students in this class are paying full tuition — and how many are receiving discounts/exemptions? (Enrollment ≠ revenue)
- What percentage of the tuition collected does the teacher's cost for this class represent? (If >60%, the class is losing money on staffing)
- Is the room occupied by this class proportionate to the number of students? (5 students in a 20-person room = wasted facility costs)
For example, an IELTS class with only 6 students but an expatriate teacher, teaching in a large room — might be losing money despite high tuition fees.
Meanwhile, a basic communication class with 15 students, a local teacher, and a small room — turns out to be the most profitable class. Without linked data, you would never know this.
Solution: ClassPilot — Structured Excel for centers with 50–500 students.
ClassPilot is designed for precisely this problem: language centers that are performing well academically but need to upgrade their management system. No need to spend tens of millions on ERP software or hire additional administrative staff.
All operations are contained within a single Excel file, with 12 interconnected sheets. No VBA, no hidden macros. Just pure Excel formulas with a clear structure, verifiable and customizable by anyone with basic Excel knowledge.
What does ClassPilot solve?
6 Core Features of ClassPilot
- Intuitive Class Schedule: room × time slot × teacher dashboard, conflict warnings upon entry
- Student Management: track each student's status — active, on leave, deferred, completed
- Structured Tuition Collection: Differentiate between cash received and actual revenue by month, class, and semester.
- Automated Accounts Receivable: List of students with outstanding debt, amount, and overdue days — no manual compilation required.
- Payroll for Diverse Contract Types: supports all 4 types of teacher contracts, automatically calculated based on actual teaching schedule data
- Profit Reports per Class: Allocate costs and revenue to each class — immediately know which classes are profitable and which need adjustment.
ClassPilot is suitable for centers with 50–500 active students. ERP software is still too heavy and expensive, but fragmented Excel is no longer sufficient. It's a one-time price of 499.000đ, with no monthly fees, no internet dependency, and no limit on the number of users within the same organization.
See ClassPilot details and download it here →
Frequently Asked Questions
My center only has 3 teachers and 60 students, do we need to use ClassPilot?
Yes — in fact, this is the most ideal time to start. When you're small, setting up a system takes less effort, and foundational data will be clean from the start. By the time you grow to 150–200 students, your entire history will have been properly recorded instead of having to start over.
Can the file be customized according to the center's specific tuition fee structure?
Yes. ClassPilot is designed with an open structure. You can adjust tuition fees, enrollment packages, and discount policies per class or by quantity. No programming knowledge is needed, just basic Excel. All formulas are visible and verifiable.
Regarding Usage and Integration
Can multiple users use it simultaneously? Can admin and accounting update it together?
A pure Excel file works best when one person updates it at a time. This is a limitation of the Excel platform, not ClassPilot.
The most common approach is to save the file on Google Drive or OneDrive, assign specific sheets for updates, and synchronize at the end of the day. For centers with fewer than 300 students, this method is entirely workable.
I'm currently using student management software, can ClassPilot replace it?
ClassPilot does not replace specialized software for online attendance or parent communication via app.
However, ClassPilot excels at what student management software often lacks. For example: profit analysis per class, calculating salaries based on complex contracts, and tracking actual revenue. Many centers use both in parallel.
PROFESSIONAL TOOLS
ClassPilot — Comprehensive language center management in one Excel file
Scheduling · Tuition & receivables · Teacher salaries · Profit per class
12 linked sheets · 100% Excel native · No VBA · Suitable for 50–500 students
Related Posts
- Excel or Google Sheets — A Comparison for Small Businesses
- Managing Interior Construction Costs
- Small business operating system
A Digital Asset Ecosystem and Work Operating System for Individuals & Teams
SUPPORT
Copyright © 2026 BEUP Learning Solutions
MST: 3301755602