Free Excel templates for tuition centres
Four sheets a centre actually runs on, with the column names Integratr.ai accepts. Built in your browser, nothing uploaded.
Student register
One row per student, with the parent, the class, the schedule and the fee.
Class and fee schedule
Your timetable and what each class costs, per session, per month and per term.
Monthly attendance register
A month on one sheet, students down the side and the days across the top.
Invoice and payment tracker
Every invoice issued, what is still owing, and what has been paid.
What is in each sheet
Four workbooks, each with the sheet a centre runs on and a How to use tab beside it. The column names are the ones Integratr.ai imports, so a file that goes straight in.
| Template | Sheet | Columns |
|---|---|---|
| Student register | Students | Student full name, Parent or guardian name, Parent phone, Parent email, Class, Weekly schedule, Monthly fee, Start date, Status, Notes |
| Class and fee schedule | Classes | Class name, Subject, Level, Day and time, Teacher, Session fee, Monthly fee, Term fee, Seats, Notes |
| Monthly attendance register | Attendance | Student, then one column per day of the month |
| Invoice and payment tracker | Invoices | Invoice number, Student, Class, Billing month, Amount, Date issued, Due date, Date paid, Payment method, Status, Notes |
How to fill each sheet in
- Student register
One row per student. A student in two classes gets two rows.
Weekly schedule reads the same way as a timetable, for example Tue 4pm and Thu 4pm.
Monthly fee is the amount you bill, in dollars. Leave it blank if you bill per session.
Status is Active, On Leave or Completed.
The column names match what Integratr.ai accepts when you import a student list, so this file can go straight in.
- Class and fee schedule
One row per class, not per student.
Day and time is for the timetable, for example Mon 6pm.
Fill the fee columns that apply to how you charge. A per-session centre fills Session fee and leaves the rest blank.
Keep one price list, so a fee change is one edit rather than a hundred.
- Monthly attendance register
Mark P for present, L for late, A for absent and M for a missed lesson that becomes a credit.
One sheet per month. Change the dates along the top when the month changes.
This is the register Integratr.ai keeps, so a centre that moves across does not lose the history.
- Invoice and payment tracker
One row per invoice, with a number you will recognise on the bill itself.
Put the invoice reference in the bill reference on the PayNow QR, so a payment can be matched back to the row.
Status is Unpaid, Part Paid, Paid or Written Off.
Payment method is PayNow, Card, Bank Transfer or Cash.
What Integratr.ai does with this
The sheet becomes the record
A spreadsheet is a snapshot. Integratr.ai keeps the same fields live: the student, the class, the register and the invoice, so a fee change applies everywhere at once and last month is still readable.
Import it and carry on
These are the columns the product imports, so a centre that has been running on Excel does not start again. It brings the file across and goes live on the same data.
The sheets are free and they work on their own. The product is what stops them needing to be a spreadsheet.
The other tools
All the free toolsTuition fee and proration calculator
What a mid-term joiner owes, what a missed lesson is worth, and what a make-up credit is worth, under the proration policy your centre uses.
Open the toolSingapore PayNow QR code generator
A per-invoice PayNow QR with a bill reference, downloaded as PNG or SVG. It is not an official SGQR merchant label.
Open the toolTax invoice particulars checker
Check a draft tax invoice against the thirteen particulars IRAS lists, and see which one is missing.
Open the toolThe same sheets, live every month.
Integratr.ai imports your list, runs the register, generates the invoices and matches the payments back to them.