The short answer
- One row per session, written the same day. Not from memory on Sunday - memory is where fees go to die.
- The fee belongs in the row, not in your head. Rate times what actually happened, including the half-length cancellation you quietly absorbed.
- A separate line per student for what is paid and what is not. The unpaid total is the number that decides whether the term pays.
- Count no-shows honestly, both kinds: the late cancellation and the slot you gave away free because asking felt awkward.
- Eight minutes, once a week, same slot. That is the entire discipline.
Setting it up
- List your students once: name, subject, rate per session, and a parent contact if you deal with a parent rather than the student.
- Decide your session statuses before the first row: held, cancelled, no-show. Three is enough; more is procrastination.
- After each lesson, write one row: date, student, minutes, what you covered, what homework you set.
- Let the fee column fill itself from the student's rate. If you are typing 18.00 by hand twenty times a month, the file is fighting you.
- At month end, read three numbers: sessions held, income earned, income actually paid. Everything else is detail.
The awkward numbers
The file is brave so you do not have to be: it shows the number, you choose the words.
- The unpaid total is not an accusation - it is a fact you are allowed to know. Most of it collects in two or three households, and it is always the same ones.
- A no-show policy decided in advance is kinder than one improvised at 9pm: written down, shown at sign-up, applied to everyone including the nice ones.
- If 'how is he doing?' gets answered with a dated note instead of a vibe, parents renew. Progress notes are retention work disguised as record-keeping.
- Watch the gap between billed and paid over the term, not the week. A gap that grows for two weeks means the conversation is overdue.
Where this goes wrong
- Tracking in a notebook you leave at the student's house. Paper is for the lesson; the list is for the year.
- Rounding fees down 'to keep it simple'. Small kindnesses to others, billed to yourself, add up to a month of income over a term.
- A spreadsheet with a formula per student per month that only its author understands. If you cannot read it at 11pm, you will stop opening it.
- Waiting for the parent to mention the unpaid balance. They will not. That is not dishonesty; it is the same inertia you have about your own bills.
The free tool for this
There is no calculator that answers this one honestly, so here is the free set: eight calculators for rates, quotes, invoices, splits, prices and fees. They run in the page and send nothing anywhere.
If you would rather not build it yourself
Tutor OS is the whole thing as one file: students with rates and contacts, a session log where the fee fills itself, a progress tab for the renewal conversations, and a summary that counts what is still owed. Tutor OS is $19. See it on the shop, and there is a plain page about it here: what it holds.
Questions people actually ask
Is a spreadsheet enough for a tutoring business?
For most private tutors, yes: one file with students, sessions and a paid column covers the whole job, and it never logs out, never subs and never holds your data hostage.
How do I know what to charge per session?
Work backwards from the income you need per teaching hour, not forwards from what feels polite. Your rate has to survive the unpaid sessions and the gaps, not just the full ones.
Read next
What records should a private tutor keep?, How do I ask a parent to pay for tutoring lessons?.