Reports for beauty academies in Canada, and the numbers they refuse to guess
At the end of a busy autumn of courses, an educator in Edmonton wants to know three things: which courses fill, where applicants drop away, and what the term really brought in. The academy answers those from what was actually recorded, and says so plainly when the records cannot answer.
Three figures it will not invent
Most dashboards would rather show a number than a gap. The academy's reports do the opposite in three places. It shows no completion rate for a group whose students nobody has marked as completed, because a rate of zero there would be a lie about the course rather than a fact about it. It shows no money for a group before any payment has been recorded. And it shows no attendance before a register has been taken.
Where a figure is missing, the report says why, which usually tells you exactly what to record next, and in which group. A report that reads “no register taken yet” on last month's weekend course is a reminder, not a failure of the software.
What the statistics cover
Each over a stated window, so a figure always says what period it is about.
Fill
How full each group ran against its seats, and how many people were left on the waiting list, so you can see whether the March nail course needs a second date.
Conversion
Over the last year, how many applicants became enrolled students and, for those allowed to see payments, how many went on to pay.
Repeat students
How many students came back for another course, the clearest sign that the first one was worth it.
Hours
Teaching hours per teacher and per place over the last ninety days, useful when you pay educators by the hour or rent a room by the day.
Enrolments by month
Twelve months of enrolments side by side, so the quiet January and the busy September are visible before you plan next year.
Takings
Recorded course payments in Canadian dollars, for people with permission to see revenue.
The same page, read by different people
A report respects the permissions of whoever opens it. The owner and a finance manager see takings; somebody without the revenue permission opens the same page and finds the money left out of it. The applicant-to-paid step of the conversion figure follows the payment-status permission, so somebody not allowed to know who has paid does not learn it from a percentage.
The academy's dashboard is built from things to do rather than from charts: applications waiting for an answer, balances past their deadline, sessions short of models. Each item carries the permission that governs it, so a teacher's dashboard does not list overdue balances she cannot see.
After the course: graduates and the log
If a graduate opens her own Slotora salon from her graduation pack, the academy sees seven dates for thirty days: invited, registered, set-up started, activated, published, qualified and first online booking. Nothing about her clients, prices or income is shown. It is enough to see that three graduates of the October group are stuck before publishing their booking page.
Separately, the academy keeps its own log: role changes, certificates issued and withdrawn, exports, deletions and money actions, each with who did it and when. Reading the log is its own permission, usually kept for the owner, and it is the first place to look when a figure in a report surprises you.
The limits of the reports
What they will not tell you.
- Only what was recorded
- Payments you took but did not record, or registers you kept on paper, are not in the figures.
- No tax figures
- Reports show recorded takings, not GST, HST or PST. Your accountant works those out from your own books.
- No profit
- Room rent, product and teacher pay paid outside the academy are not subtracted. Takings are takings.
- Nothing about graduates' businesses
- Past the seven dates, a graduate's salon is hers. The academy cannot see her bookings or revenue, and the dates stop after thirty days.
Questions about academy reports
Why does my report show no completion rate?
Because nobody has marked the students of that group as completed yet. The report refuses to show a rate until the record exists, rather than showing a misleading zero.
Can a teacher see the academy's revenue in reports?
Not with the teacher starting point. Revenue needs its own permission, and the report shows each person only what her permissions allow.
Over what period is conversion measured?
The last 365 days. Teaching hours cover the last ninety days, and enrolments are shown month by month for twelve months.
Can I export the figures for my accountant?
Anyone with the finance export permission can download the payment figures, and the export is written to the academy's log.
Do reports include GST/HST?
No. They show what was recorded as paid, in Canadian dollars. Sales tax is worked out in your own bookkeeping.
Record one term, then read it back
Run a term's groups through the academy, take the registers and record the payments. The first report will show you which course to run twice next year.
