Skip to content

New schools get up to 20% off their first payment after the trial — any plan, even a full year.up to 20% off your first payment after the trialA school already on Mimiao invited you: up to 20% off your first payment plus a bonus from that payment for the next one.Try 14 days free

All posts
  • finance
  • school management

Student Payments and Debts Without Spreadsheets

Separate invoices, received payments, remaining lessons and amounts owed. Package examples and practical checks for a clear financial history.

Mimiao Team5 min readUpdated

In this article

To know who owes the school money, check invoices, received payments and completed lessons together. When they live in different places, a payment can be missed or assigned to the wrong package.

Here is how to separate those records and keep a history that staff and families can understand.

First, let’s agree on the words

It’s easy to tangle the terminology of school finances, so let’s pin down three things.

An invoice is a record that says “this student should pay this much for that.” Issue an invoice for 8 lessons and an obligation now exists. Until it’s paid, it’s a potential debt.

A lesson balance is prepayment, expressed in lessons. A student paid for 8 sessions and has attended 3 — five remain on the balance. This is useful for packages; monetary amounts and payment history should be kept separately.

An amount owed may mean an overdue invoice or lessons delivered without enough paid lessons available. Check these separately: an empty package is not itself a debt. Students in the same group may have different balances and payment dates.

If those three concepts are all crammed into a single “payment” column, that’s where most of the confusion comes from.

Lesson balances and confirmed payments

For packages, track both lesson balances and money. Check monthly subscriptions and individual services against their own terms.

Picture this: a student bought a package of 8 sessions. Then one lesson got rescheduled, one was cancelled with a day’s notice, and one was cancelled an hour before (and you have a rule that late cancellations are charged). If you keep everything in currency, at month-end you’re sitting with a calculator reconstructing how many sessions actually “burned.”

When tracking happens in lessons, it’s all simpler: a session is delivered, minus one from the balance; the late-cancellation rule fires, also minus one; a clean reschedule leaves the balance untouched. At any moment the student sees “5 lessons left,” and you see who needs a top-up reminder before they ever go negative.

That’s the real advantage of balances: they work ahead of time. Debt is already the consequence. A balance is the warning.

Invoices you never have to print

An invoice should clearly identify the service, amount and due date. To accept card payments, the school connects a supported payment provider and shares the invoice link with the student or parent.

After confirmation from the connected provider, Mimiao records the payment and corresponding balance. If confirmation is pending or amounts differ, check the payment before entering it again.

When a payment arrives by bank transfer, an administrator or owner confirms it on the invoice. The balance then updates in the same financial ledger rather than remaining in a separate bank statement or notebook.

A debtors view in one click

Here’s a practical test of how mature your tracking is: how long does it take to answer “who owes us right now?”

You can configure an overdue-payment filter in a spreadsheet. In a CRM, it helps to check amounts owed and remaining lessons alongside the student history so you can understand the cause and choose the next action.

In Mimiao, you can check invoices, payments and student balance history. Before sending a reminder, verify what is overdue and whether the money arrived through another method.

This screen changes how the school behaves. When debtors aren’t buried in the depths of a spreadsheet but right in front of you, you start working through them systematically: not “oh, I think someone owes us,” but a calm ten-minute weekly routine.

Why an append-only ledger matters

Now the most important part — and the least obvious. Ask yourself: what happens to a financial record when someone makes a mistake?

Spreadsheets can show version and cell edit history. The reason for a correction and its relationship to a particular payment still need to be recorded. Keeping the original entry alongside its correction makes reconciliation easier.

A healthy financial system works differently — on the principle of a ledger that is only ever appended to (append-only). That means records are never edited or deleted. Got an amount wrong? You don’t erase the old line — you add a correcting entry. The result is that the full history is always visible: here’s the payment, here’s the correction, here’s who made it and when.

Why does a school need this, not just a bank? For three very down-to-earth reasons:

  • Disputes with parents. “But we paid!” — and in a second you show the full transaction history for that student instead of straining to remember.
  • Protection from accidents and abuse. Nobody can quietly “adjust” a debt after the fact in a way that erases the trail. The trail always stays.
  • Calm reconciliations. The totals always match the transaction history, because they’re derived from it rather than living separately.

That leads to one simple requirement for any finance module: no money record can be quietly overwritten or erased. You can only add a new entry that explains the change. If a tool lets you edit payments “in place” with no trace, that’s not bookkeeping — it’s a draft.

Where to start right now

Even if you’re still in a spreadsheet, a few principles can go in today:

  1. Split the three columns — invoices (obligations), balances (prepayment in lessons), and debts (the red). Don’t merge them into one “payment.”
  2. Switch to tracking in lessons wherever you sell packages. Keep monetary amounts for all payments, and track monthly subscriptions under their own terms.
  3. Build a weekly habit of looking at debtors — even if it’s a manual filter for now, make it regular.
  4. Never erase old amounts. Fix a mistake with a new annotated line, not a replacement — that’s your manual stand-in for an append-only ledger.

And when the school grows to the point where holding those four points by hand gets hard, that’s the signal that payments, balances, and debtors should live in one place and count themselves.

If you’d like to see what this looks like in practice, take a look at the finance features page — it shows how invoices, balances, and debtors come together on one calm screen.

Try it on your school

See your school in Mimiao

14 days free with personal onboarding — or wander around the demo school first.

Keep reading

All posts