Administration
Why Excel Fails for Tuition Teacher Commission Splits (and What to Use Instead)
By NEXTGEN EDUPRO Team · · 5 min read
Most institutes host visiting teachers on a revenue share: the teacher keeps a percentage of the class fees, the institute keeps the rest for the hall, staff and utilities. The arithmetic is simple. Doing it correctly every month for every teacher, subject and discount is not.
The common payout models
- Percentage split, for example 70% to the teacher and 30% to the institute
- Fixed amount per paid student per month
- Fixed hall rent, with the teacher keeping all fees
- A mix, where different subjects of the same teacher use different rules
Where spreadsheets break
The payout sheet is only as good as the fee data typed into it. Late payments, half-month discounts, free cards for siblings and refunds all have to be re-entered by hand. Each copy of the sheet drifts, and when a teacher asks “why is my payout lower this month?” nobody can show the individual payments behind the number.
Calculate payouts from the fee ledger
The fix is to calculate payouts directly from recorded fee payments, using a rule set per teacher and subject. When a payment is recorded, the teacher’s share is already known. At month end you generate a statement that lists every student payment behind the total.
Make statements the teacher can check
Disputes drop when teachers can see their own statement, with each paid student, before payout day. Give teachers read-only access to their earnings rather than sending a screenshot of a spreadsheet.
NEXTGEN EDUPRO calculates percentage and fixed-rate splits per subject and produces monthly statements. See teacher income accounting.