Tuition Fee Register (Excel)
Know at a glance who has paid for which month. Record each payment as it comes; the register fills a 12-month grid for every student, works out what is still due up to today and writes a polite reminder message for parents.
Free · no sign-up · opens in Microsoft Excel, Google Sheets, LibreOffice and WPS Office. Files contain no macros.
Preview
Real view of the file with its sample data (yellow cells are where you type).
Fee Grid
| Student | Fee | Apr-26 | May-26 | Jun-26 | Jul-26 | Aug-26 | Sep-26 | Oct-26 | Nov-26 | Dec-26 | Jan-27 | Feb-27 | Mar-27 | Total paid | Months due | Fee due | Balance |
| Aarav Sharma | ₹ 1,500 | 1,500 | 1,500 | 1,500 | – | – | – | – | – | – | – | – | – | ₹ 4,500 | 8 | ₹ 12,000 | ₹ 7,500 |
| Diya Kaur | ₹ 2,000 | 2,000 | 2,000 | 2,000 | – | – | – | – | – | – | – | – | – | ₹ 6,000 | 8 | ₹ 16,000 | ₹ 10,000 |
| Kabir Gupta | ₹ 1,800 | – | – | – | – | – | – | – | – | – | – | – | – | ₹ 0 | 6 | ₹ 10,800 | ₹ 10,800 |
What's inside
- Students sheet: name, class, parent phone, monthly fee and start month
- Payments sheet: date, student, month paid for, amount and mode (cash, UPI, bank)
- Fee grid: 12 months from the session start, paid amounts per month, total paid and total due
- Reminder message per student
How to use it
- On the Settings sheet type the first month of the session and your centre name.
- On the Students sheet list your students with their monthly fee and the month they joined.
- When a parent pays, add a row on the Payments sheet: date, student, the month the fee is for, amount and mode.
- Open the Fee Grid to see paid months and total dues.
- Copy the reminder text for a student and send it to the parent.
Tips
- If a parent pays for two months together, add two payment rows, one for each month.
- Dues count every month from the student's start month up to the current month.
- Change the fee on the Students sheet if it changes mid-year; the dues then use the new fee for every month, so note big changes in a new row.
Questions and answers
Can I use it for yearly or quarterly fees?
It is built for monthly fees. For quarterly fees, enter the quarterly amount against the first month of each quarter and set the monthly fee to one-third of it.
Does it send messages?
No. It prepares the text; you copy it into WhatsApp or SMS yourself.
More in the Teachers & Tutors toolkit
Student Attendance Register (Excel)Free monthly student attendance register for Excel: mark P, A or L for up to 60 students, Sundays shaded, totals and att…Excel templateMarks Sheet & Report Card (Excel)Free Excel result sheet: enter marks for up to 6 subjects and 60 students; totals, percentage, grade, rank and pass/fail…Excel templateOnline Report Card MakerMake a student report card online: subjects, marks, percentage, grade and remarks. Print, save as PDF or download as Exc…Online tool
Also useful
GST Invoice Template (Excel)Free GST tax invoice template for Excel. Pick a customer and items; it fills HSN, rates, CGST+SGST or IGST and the amoun…Excel templateGST Monthly Summary (Excel)Free Excel workbook that totals a month's sales and purchases by GST rate: taxable value, IGST, CGST, SGST, B2B and B2C,…Excel templateClient Dues & Ageing (Excel)Free Excel receivables tracker: list bills and receipts, see each client's balance by age (not due, 1-30, 31-60, 61-90, …Excel template