Should Your School Keep Fee Records in Excel or Use Software?
If one person handles all the fees, parents mostly pay cash at the counter, and nobody asks for more than a monthly total, Excel can be enough. Once parents pay by UPI, more than one person edits the sheet, or you spend days chasing dues, fee software saves time and mistakes. Most schools cross that line sooner than they expect.
Here is how to tell which side of the line your school is on, and how to move across without losing your history.
What Excel does well
Excel is a good tool, and there is no shame in running fees on it. A spreadsheet arranges data in rows and columns and recalculates totals as soon as you change a number.
For a school office, that means:
- No setup. Your accountant already knows how to use it.
- Flexible. A new fee head, a new column for transport, a new sheet for a new term: all done in a minute.
- Cheap. You may already have it on the office computer.
- Easy to print. A class-wise list is one filter and one print away.
For a small school with one clerk and mostly cash payments, a well-kept sheet with a printed receipt book can work for years.
Where the sheet starts to break
The trouble is rarely Excel itself. It is what happens when a fee sheet has to keep up with real parents, real money and more than one person.
Dues are only as right as the last update
A dues list in Excel is correct only if someone has entered every payment. If a parent paid on Saturday and the clerk updates on Monday, the dues list sent out on Sunday is wrong. That is how a parent who has already paid gets a reminder call, which is awkward for everyone.
Formulas also go wrong quietly. Research cited on Wikipedia estimates that around 1% of formulas in operational spreadsheets contain errors. In a fee sheet, one dragged formula that skips a row can hide a family's dues for months.
Receipts live somewhere else
In most offices the receipt book and the sheet are two separate records. A receipt is written by hand, then the amount is typed into Excel later. If the two do not match, nobody knows which one is right. A receipt torn out of the book or a cell overwritten leaves no trace.
If you still write receipts by hand, at least make them consistent. Our free fee receipt format maker gives you a printable receipt with a student copy and an office copy.
Parents now pay by UPI
UPI is India's instant payment system, developed by the National Payments Corporation of India. At the time of writing, Wikipedia reports that it accounts for about 84% of digital payments in India.
Parents like it. Accountants often do not, because a UPI credit in the bank statement shows a name and an amount, not a student and a class. Someone then has to:
- Download the bank statement.
- Guess which student each payment belongs to (the father's name, the mother's name, an uncle's phone).
- Type it into the sheet.
- Send a receipt on WhatsApp.
With fifty payments in the first week of a term, this becomes a full-time job. And every guess is a chance to post money to the wrong child.
More than one person edits the sheet
The moment the principal, the accountant and a clerk all touch the same file, problems start:
- Two copies of the file exist, each with different payments.
- Someone sorts one column and not the rest, and fees land against the wrong names.
- A concession is entered as a lower fee, so a year later nobody remembers why that child pays less.
Wikipedia notes that spreadsheets suffer from a lack of auditing and revision control, so it is hard to see who changed what and when. It also notes that spreadsheets lack controls on who can see and modify particular data. For money, that matters.
The file lives on one computer
If the office PC fails, the fee history can go with it. A common rule for backups is 3-2-1: at least three copies of the data, on two different types of storage, with one copy kept offsite. Very few school offices do this for their fee sheet.
One person knows how it works
Many school fee sheets were built by one clerk over many years. When that person leaves, the formulas, colours and hidden columns effectively leave with them, because nobody else understands them.
A quick check: is Excel still enough for you?
Answer yes or no to each line.
| Question | If yes |
|---|---|
| Do more than a few parents pay by UPI or bank transfer? | Matching payments by hand is costing you time |
| Do two or more people edit the fee file? | You need a record of who changed what |
| Have you ever sent a reminder to a parent who had paid? | Your dues list lags behind payments |
| Do you have instalments, concessions or late charges? | Formulas will get complicated and fragile |
| Would the office struggle if the fee clerk left tomorrow? | Your process depends on one person |
| Is the fee file kept on only one computer? | One failure could lose your history |
If you answered yes to two or more, it is worth looking at fee software. If you answered no to all of them, keep your sheet, tidy it and back it up.
If you stay on Excel, do these five things
- One file, one owner. Only one person enters payments. Others get a read-only copy.
- One row per student, one column per instalment. Never merge cells or use colours as data.
- Record concessions as their own column, with a short reason, not as a reduced fee.
- Match the bank statement weekly, not at the end of the term.
- Back up every week to a pen drive and to one copy kept outside the office.
What fee software changes
Good fee software is not just a nicer spreadsheet. It joins up the things that live apart in Excel: the fee plan, the payment, the receipt and the dues list.
For example, 8plabs School fee management sets heads, terms, instalments and concessions once per class. A parent pays by UPI or card from the app, and the receipt, the ledger and the dues list all update themselves. Cash, cheque and bank transfers recorded at the counter go into the same ledger. Dues can be seen by class, section or family, with reminders by app and SMS.
That last part solves the two biggest Excel headaches: guessing who a UPI payment belongs to, and sending a dues list that is a day out of date.
If you want a side-by-side view, see our page on school software vs registers and Excel.
How free and paid fee software is usually priced
Price models in this market tend to follow a few patterns:
- Per student per month, so a small school pays less than a large one.
- Free tier for small schools up to a set number of students, then paid above that.
- Module pricing, where fees are one module and attendance, exams or transport cost extra.
- Payment gateway charges, which are separate from the software and apply to online payments.
Ask any vendor which of these applies, and whether gateway charges are passed to parents or paid by the school. For more detail, read how much school management software costs in India and whether there is free school management software.
Moving your fee sheet across
The move scares most accountants more than it should. A simple plan:
- Pick a clean start date, ideally the start of a term, so old and new records do not overlap mid-term.
- Clean the sheet first. One row per student, admission number on every row, no merged cells.
- List your fee heads and instalments exactly as they are charged, class by class.
- Note every concession and its reason.
- Carry forward opening dues for each student as of the start date.
- Run both for one month. Keep the sheet alongside the software and compare totals at month end.
- Then stop editing the sheet and keep it as an archive.
With 8plabs, you do not have to type it all in yourself: you point the team at what you have, and a person on their side enters student records and fee history. You can read how schools move to 8plabs.
Ready to stop chasing dues in a spreadsheet?
If UPI payments, late dues lists or a shared fee file are slowing your office down, see how 8plabs School handles fee collection, receipts and reminders and book a demo.