How to run a small school's fee collection without spreadsheets

In many small schools the fee register lives in three places at once: a bound notebook at the front desk, a spreadsheet on the accountant's laptop and a stack of carbon-copy receipt books. Each one is correct on the day it is written and slightly wrong a week later. A parent says they paid in cash last Tuesday, the notebook agrees, the spreadsheet doesn't, and nobody can find the receipt copy.

None of this happens because people are careless. It happens because the same payment has to be written down more than once, by different people, at different times. The fix is less about software and more about process: one record per fee, one place where payments are entered, and one receipt that comes from that record. Software just makes that process easier to stick to.

This guide walks through a fee process that works for a school of any size, and then shows how it maps onto ESmarts360's school template.

Step 1: Decide what a "fee" is in your school

Before touching any tool, write down the fees you actually charge. Most schools have a short list:

• Monthly tuition, often different by class
• Admission fee, charged once
• Annual or exam charges
• Optional items such as transport, uniforms or books

For each one, agree on a clear name ("Tuition – March", not "fee"), the amount, and the due date. The name matters more than it seems: when a parent asks what is outstanding, "Tuition – March, due 10 March" is an answer; "fee pending" starts an argument.

Step 2: One fee record per student, per charge

The heart of a reliable system is that every charge to every student exists as its own record: student, fee name, amount, due date. A payment is then always attached to a specific record. This is what spreadsheets make hard — one row per student with a column per month quickly turns into merged cells, colour codes and notes in the margin.

With separate records you can answer the questions that matter at a glance: who has paid March tuition, who has paid part of it, and who hasn't paid at all.

In ESmarts360, the Fees screen holds exactly these records. Each fee record belongs to one student and has a title, amount and due date. At the time of writing, fee records are added per student; generating a whole class's monthly fees in one step is on our roadmap but not available yet, so plan a few minutes at the start of each month for this.

Step 3: Take payments in one place only

Choose who is allowed to take fee payments — usually the accountant and perhaps the front desk — and make a simple rule: if it isn't entered, it isn't received. Cash handed to a teacher in the corridor is the most common source of disputes.

When a payment comes in, it is recorded against the fee record, with the amount and date. If a family pays part of the amount, record what they paid; the record then shows as partly paid with the remaining balance, instead of somebody remembering it.

• Unpaid — nothing received yet
• Partial — some of the amount received
• Paid — the full amount received
• Waived — the school decided not to charge it, with a reason recorded

ESmarts360 uses these same four states for fee records. Staff roles control who can do what: for example, the built-in Accountant role can collect fees, while a Teacher role can't see fee screens at all unless you allow it. You can adjust this under roles and permissions.

Step 4: Every payment gets a numbered receipt

A receipt protects both sides. The parent has proof of payment, and the school has a reference number to search for when there's a question. The important parts are a running receipt number that can't be reused, the student's name and class, what was paid for, the amount, the date, and the school's name.

When a fee is collected in ESmarts360, a receipt number is generated automatically from the school's sequence. The receipt can be printed or downloaded as an A5 PDF with your logo and contact details, so you no longer need carbon-copy receipt books.

Step 5: A short weekly routine

Most fee problems are found late because nobody looks until the end of the month. A fifteen-minute weekly routine catches them early:

1. Open the list of fees that are unpaid or partly paid and past their due date.
2. Call or message the families on the list — politely, with the exact fee name and amount.
3. Check that the cash in hand matches the payments recorded that week.
4. Note any agreed payment dates so the next follow-up is informed.

ESmarts360's school dashboard shows fees due, and reports summarise collections with a CSV export if your accountant wants the numbers in another tool. Automatic SMS or WhatsApp reminders are not part of ESmarts360 today, so follow-ups are still made by your staff — which, for many schools, is how parents prefer it anyway.

Step 6: Let parents see their own fee records

Many phone calls to the office are simply "Have we paid?" or "Can you send the receipt again?". Giving parents a way to look this up themselves saves time on both sides.

If you turn on the parent portal, staff invite a parent or guardian by email. The parent creates their own login and sees only their own children: class, recent attendance, fees with receipts (including the PDF), and exam results. They can't see other families or any staff screens, and you can remove access at any time. Parents don't count towards your plan's user limit.

Step 7: Close the month

At the end of each month, take ten minutes to close it properly. Compare the total collected in the fee report with the cash and bank deposits, list anything still outstanding, and agree with the principal which balances carry forward. Once a month is closed, corrections should be visible as new entries rather than silent edits.

ESmarts360 keeps an activity log of important changes, so an administrator can see who changed what and when if a question comes up later.

Moving off spreadsheets without a big-bang switch

You don't have to move everything on day one. A sensible order is:

1. Add your classes and students.
2. Record the current month's fees and start taking payments in the new system.
3. Keep last year's records where they are for reference.
4. Invite a few parents to the portal first, fix any questions, then invite the rest.

Whatever tool you use, the process above is what makes fee collection calm: one record per charge, one place to take payments, one numbered receipt, and a short routine every week. If you'd like to see the school screens with your own data, you can start a free trial or book a live tour and we'll walk you through them.