CSV template
Fee collection tracker
Track fees due, paid and outstanding for each student, with receipt numbers and due dates, for schools and coaching institutes.
What is in it
One row per student per fee period. The tracker shows what is due, what was paid, the balance and the receipt that proves it.
Download fee-collection-tracker.csv (CSV)
Opens in Excel, Google Sheets or LibreOffice Calc.
Columns
- Student ID: Your admission or roll number
- Student name: Full name
- Class or batch: Class, section or coaching batch
- Fee period: Month, term or instalment
- Amount due: Fee for this period
- Due date: When it is due
- Amount paid: Total received for this period
- Balance: Due minus paid (a formula in row 2 you can copy down)
- Receipt number: Matches the receipt given
- Payment date: When it was paid
- Mode: Cash, UPI, cheque, bank transfer
How to use it
- Add every student and fee period at the start of the term.
- Record each payment with its receipt number the same day.
- Filter the balance column to see who is overdue.
Related
Useful next.
- Guide · 7 min readHow Coaching Centres Can Manage Student FeesMost fee problems in a coaching centre come from plans agreed verbally, receipts that do not match the register and dues chased too late. Here is a routine that prevents all three.
- Guide · 7 min readCoaching Centre Administration: The Records, Routines and Roles That MatterA coaching centre office handles enquiries, batches, attendance, fees and test results, usually with very few staff. Clear records, owners and routines keep it manageable.