Use one row per challan, with columns for student, family number, class, month, fee heads, discount, arrears, amount due, amount paid, date and receipt number. Move to software when siblings, arrears, bank payments or several campuses make the sheet unreliable.
What columns should a school fee register in Excel have?
A good fee register records what was billed and what was received, row by row, so that any family's balance can be rebuilt from the sheet alone. Keep a single row for each student and billing period, and do not merge cells, because merged cells break sorting and filtering.
You can copy the layout below into a blank workbook and use it as a free template. Put the headings in row one and freeze that row.
- Student ID or admission number, student name and father or guardian name
- Family number, so siblings can be grouped
- Campus, class, section and session
- Month or instalment label
- Fee heads as separate columns: tuition, transport, exam, admission and any other head you charge
- Discount or concession, with a reason
- Arrears brought forward from earlier months
- Fine or late fee
- Total due (a formula: fee heads plus arrears plus fine minus discount)
- Amount paid, payment date, payment mode and receipt number
- Balance (a formula: total due minus amount paid)
- Received by, so each entry can be traced to a person
How do you set up a simple fee collection sheet?
Use two sheets in one workbook. The first is a student list with fixed fee amounts for each student. The second is the monthly fee collection sheet, with one row for every student billed in that month.
Fill the due amounts from the student list with a lookup formula rather than typing them again. Use data validation for payment mode and class, so spellings stay consistent. Protect the formula columns so that staff can type only in the paid, date and receipt cells.
At month end, copy the unpaid balances into the next month's arrears column as values. Save a dated copy of the workbook before you do this, so you can always go back.
What reports can you get from a spreadsheet register?
A pivot table over the monthly sheet gives you most of what a school office asks for each day. Filter by class to see who has not paid, or sum the paid column by date for a daily cash-up.
These reports are only as good as the discipline behind them. If one clerk forgets to enter a payment, or two people edit different copies, the totals will be wrong and nothing in Excel will warn you.
- Collection by day and by person, from a pivot of paid amount against date and received-by
- Defaulter list, from a filter on balance greater than zero
- Class-wise collection, from a pivot of class against paid amount
- Head-wise income, from the sums of each fee head column
When does an Excel fee register stop working?
Excel works well for a small school with one campus, one person entering data and few discounts. Problems usually appear gradually, and they tend to show up together.
- Siblings pay together, and the family balance is split across several rows or files
- Parents pay by bank transfer or at a branch, and someone must match each deposit to a student by hand
- Several people need to edit the file, or you keep separate files for each campus
- A discount or a late fee needs a manager's approval, and Excel cannot enforce one
- You cannot see who changed a figure, or when
- Promotion to a new session means copying and re-checking old balances
- Parents ask for a receipt or a balance at the counter and the clerk has to search through the file
- Fee income has to reach the school's accounts, and someone retypes it into a separate ledger
What does fee software handle that a spreadsheet cannot?
EDUBase Fee Management & Challans lets you build fee plans from your own fee heads, generate the month's challans for a campus, class or the whole school in one click, and take payment at the counter or by family. Unpaid balances roll into the next challan, and discounts and payments can wait for a manager's approval.
With Bank Fee Collection, each challan prints a consumer number. Parents can pay through HBL, Bank Alfalah, Meezan Bank, PayPro and KuickPay, and through them 1Bill and 1LINK channels. The payment is posted in real time, so nobody at the school matches deposits by hand.
Fee Automation can create challans on a fixed date, apply late fees after the due date, and send defaulter reminders. Every automation previews its effect before it acts, and run history shows what each run did. Fee Reports & Defaulters then provides the Day Wise Paid Challans cash-up report, defaulters by amount, family or month, and the Fee Audit Report, which keeps last year's figures frozen after promotions.
How do you move from Excel to software without losing history?
Clean the sheet first. Make sure each student has one row and one family number, and that old dues are correct. This work is needed whichever system you choose.
EDUBase supports moving from registers or another system by Excel. During onboarding, the school fills a student data Excel with campus and fee details, and the EDUBase team uploads it and confirms with a screenshot. Old dues and past payments can be loaded so the first challan is right. After go-live, Bulk Data Import lets you upload students, fee plans, first-time arrears and challan payments yourself.
Run the spreadsheet and the software side by side for a billing cycle if you want to compare totals before you stop using Excel.
Excel fee register compared with fee management software
| Task | Excel fee register | Fee management software |
|---|---|---|
| Monthly challans | One row per student; vouchers made by mail merge or typed | Generated in bulk for a campus, class or whole school |
| Sibling payments | Balances split across rows unless you add a family column and formulas | Family numbers group siblings for one payment and one receipt |
| Arrears | Copied forward by hand each month | Carried forward automatically to the next challan |
| Bank payments | Matched to students by hand from statements | Posted by consumer number as the bank calls in |
| Late fees and reminders | Calculated and sent manually | Can run on schedule, with preview and run history |
| Approvals | None; anyone with the file can edit | Discounts and payments can wait for a manager |
| Audit trail | Depends on saved copies | Change records show who changed what and when |
| Multi-campus view | Separate files to combine | Campus-wise reports in one system |
Related modules
- Fee Management & Challans — Fee plans, monthly challans, discounts, family payments and receipts, without spreadsheets.
- Fee Automation — Let the system generate challans, apply late fees and chase defaulters on schedule.
- Fee Reports & Defaulters — Know what was billed, what was collected and who still owes, per class, family or month.
- Bank Fee Collection — Parents pay at the bank, in their banking app or at a kiosk; EDUBase posts it automatically.
- Bulk Data Import & Onboarding Tools — Move from registers or another system by Excel: students, fee plans, old dues and past payments.
- Finance & Accounting — Chart of accounts, journals, ledgers, trial balance, P&L and balance sheet, fed by fees and payroll.