Teacher Payroll From Delivered Lessons
How to pay teachers from lessons actually delivered — fixed rate or percentage — with checks for rescheduling, cancellations, accruals and payouts.
In this article
It’s the end of the month. You open the spreadsheet where you’ve been tallying each teacher’s lessons by hand for thirty days, and you start reconciling: this lesson happened, this one got moved, this student didn’t show — do we pay for it or not? An hour in, your head is buzzing and you’re still not sure you haven’t miscounted by a lesson somewhere.
Sound familiar? Teacher payroll is one of those tasks where manual work survives the longest. And it breaks exactly where a real school lives: in reschedules, substitutions, cancellations, and one-off lessons outside the package.
Why manual recalculation breaks
The problem isn’t the formula. A fixed rate per lesson, or a percentage of what the student paid, is simple arithmetic. The problem is that the basis for the calculation keeps changing throughout the month, and the spreadsheet has no idea.
Here’s a typical month for a single group:
- A Tuesday lesson gets moved to Thursday — now there’s a duplicate row, because someone entered both dates.
- A student falls ill and the lesson is cancelled a day ahead — it was on the calendar but never happened. Does the teacher get paid for it?
- A substitute teacher covers the lesson instead of the regular one — who does that lesson count for?
- One student takes an extra one-on-one session outside their package — easy to forget entirely.
Each of these is trivial on its own. But over a month they pile up by the dozen, and every one needs a “do we count this or not?” decision. The spreadsheet doesn’t make that decision — a person makes it, from memory, every single time. And memory at month-end is not reliable.
The cost of an error isn’t just money
You might think: so we’re off by a lesson or two, what’s the big deal? The damage isn’t the amount. The damage is to trust.
Teachers keep their own count. Not necessarily in a spreadsheet — often just in their head or a note on their phone. And when your number doesn’t match their number, you get the awkward conversation: “I counted 47 lessons, you’ve paid for 45. Where are the other two?” And the two of you sit down and reconstruct the month day by day.
A discrepancy is easier to discuss when both people can see lesson dates, statuses and rates. You can then find the specific cause instead of reconstructing the whole month from memory.
A manual calculation can be transparent too: keep its breakdown and reasons for corrections. Automation helps when it uses journal data and reduces duplicate entry.
How to make payroll self-updating
The alternative is to use the journal of completed lessons as the basis for the calculation. Attendance alone is not enough: rates, lesson prices and cancellation rules also need to be correct.
The principle is simple: separate the plan from the lesson outcome. Moving a planned lesson changes its schedule but does not yet create earnings. Accruals depend on completion or cancellation handling and school rules. Paying out money is a separate action.
The key decision to make up front and write down is exactly what you pay for. There’s no single correct answer, but there has to be yours:
- Delivered lesson — which rate applies and which amount a percentage uses.
- Late student cancellation — whether the agreed rules provide teacher pay.
- Cancellation with proper notice — how it affects the student balance and teacher earnings.
- Substitution — who earns payment and at which rate.
Test each rule on an example lesson before relying on it. Earnings can accumulate during the month, but check the period, rates and exceptions before paying.
Fixed rate or percentage — and both must be transparent
The two most common pay models:
Fixed rate per lesson. The teacher earns the same amount for every counted lesson, regardless of what the student paid. Simple, predictable, easy to explain to a new hire.
Percentage of the student’s payment. The teacher earns a share of what the student paid for that lesson. It ties the teacher’s income more closely to the value of the session, but it requires a clearly defined lesson price — otherwise there’s nothing for the percentage to be a percentage of.
Both models work. In larger schools they often coexist: some teachers on a flat rate, some on a percentage, some with different rates for individual versus group lessons. The important thing is that the rate is stored on the teacher’s profile, not held in the owner’s memory. With twenty teachers on different terms, a memory-based error is only a matter of time.
Transparency the teacher can actually see
The most important part isn’t the calculation itself — it’s that the teacher sees the same picture you do. Not a total that appears out of thin air, but the breakdown: here are the 47 lessons this month, here are the dates, here are the statuses, here’s the rate, here’s the total. Every line can be checked against their own memory.
The breakdown helps both people find a missing lesson or an incorrect rate. Agree how teachers report discrepancies and who checks them before a payout.
In Mimiao, earnings are linked to lesson outcomes and configured rates. Simply moving a planned lesson does not accrue pay. Accrued earnings and actual payouts are recorded separately; teachers can see their own amounts with the appropriate permission.
Payroll shouldn’t be a monthly quest involving a spreadsheet and a reconciliation from memory. When it’s calculated from lessons actually delivered and transparent to the teacher, it stops stealing an evening at month-end and stops straining relationships. You can first test your rules in the free online teacher payroll calculator, then see how automatic payroll works alongside invoices and student balances on the finance features page.