Fee collection software vs Excel: the short answer
Here's the honest answer to fee collection software vs Excel. A well-built sheet is a good way to track who owes what. If you have a short list and do it yourself, you may not need anything else.
Excel starts to cost you when the work around the sheet grows: making bills, sending reminders, checking bank payments, writing receipts and fixing mistakes. That's where fee collection software earns its fee. This page gives you a proper Excel setup first, then helps you decide when to move.
How to set up a fee collection sheet in Excel
Most messy sheets have one column per month running off to the right. It looks natural, but it makes totals painful. Instead, keep one row per customer per month. The sheet gets longer, but every formula becomes simple. The same layout works for a fee collection register on paper.
| Column | What goes in it | Example |
|---|---|---|
| A: Customer ID | A short code that never changes | S-014 |
| B: Name | Customer or student name | Ayesha Khan |
| C: Phone | WhatsApp number, all in one format | 03XX XXXXXXX |
| D: Month | The billing month as a real date (the 1st) | 01-Sep-2026 |
| E: Amount due | This month's fee, including any late fee | 3,500 |
| F: Amount paid | What they actually paid | 2,000 |
| G: Date paid | The date the money arrived | 05-Sep-2026 |
| H: Method | Cash, bank transfer, JazzCash, Easypaisa, 1BILL | JazzCash |
| I: Receipt no. | Your receipt number or the transaction reference | R-0231 |
| J: Balance | A formula: due minus paid | 1,500 |
| K: Status | A formula: Paid, Part or Unpaid | Part |
A few habits that save hours
- Give every customer a short ID that never changes, like S-014. Names repeat. IDs don't.
- Type the month as a real date, not text like "Sept". Formulas need dates.
- Turn the range into an Excel Table (click inside it and press Ctrl+T). New rows then pick up the formulas by themselves.
- Use a drop-down for Method (Data, then Data Validation, then List) so nobody types "Jazz cash" three different ways.
- Enter whole rupees only. No decimals and no "3.5k".
- Don't merge cells or leave blank rows. Both break filters and totals.
- Keep one master file in one place. Two copies means two versions of the truth.
Keeping a paper fee collection register instead
Plenty of schools and academies still use a bound register, and that's fine. Rule the same columns across two facing pages. Write in pen, never pencil. If you make a mistake, strike it through with one line and initial it, so anyone can still read what was there. Use a receipt book with printed numbers and write the receipt number in the register every time. At the end of each month, total the paid column and write the total at the bottom of the page.
Need a monthly bill format in Excel too? Add a second tab laid out like a bill: your business name, the customer, the month, amount due, previous balance, total and how to pay. Fill it from the register and share it as a PDF.
Formulas that do the heavy lifting
These assume the layout above, with headings in row 1 and data from row 2. Swap the dates and IDs for your own.
| What you want to know | Formula | In plain words |
|---|---|---|
| Balance on a row | =E2-F2 | Amount due minus amount paid. |
| Status on a row | =IF(F2>=E2,"Paid",IF(F2>0,"Part","Unpaid")) | If they paid the full amount, Paid. If they paid something, Part. Otherwise, Unpaid. |
| Total collected for September | =SUMIFS(F:F,D:D,DATE(2026,9,1)) | Adds up column F, but only on rows where the month is 1 Sep 2026. |
| Total still owed for September | =SUMIFS(J:J,D:D,DATE(2026,9,1)) | Adds up the balances for that month. |
| How many haven't paid anything | =COUNTIFS(D:D,DATE(2026,9,1),K:K,"Unpaid") | Counts rows for that month where the status is Unpaid. |
| One customer's total dues | =SUMIFS(J:J,A:A,"S-014") | Adds up every balance for customer S-014, across all months. |
| Cash collected this month | =SUMIFS(F:F,D:D,DATE(2026,9,1),H:H,"Cash") | Only the cash payments for September. Handy for matching the cash drawer. |
SUMIFS adds up one column, but only on the rows that match your conditions. COUNTIFS counts the rows that match. You write the conditions in pairs: which column to check, then what to look for. That's all most fee sheets ever need. It's also the simplest answer to how to keep track of customer payments in Excel.
Where Excel and the register break
The sheet itself is rarely the problem. The trouble is everything around it, and it grows with every new customer.
- Reminders. The sheet knows who hasn't paid, but it can't tell them. Someone copies numbers into WhatsApp and sends messages one by one.
- Matching bank payments. A bank alert says Rs 3,500 came in. It doesn't say who sent it or for which month. Someone checks screenshots against the sheet.
- Receipts. Every payment needs a receipt written, typed or sent by hand.
- Several staff. Two people with two copies of the file means two versions. Whose is right?
- Mistakes. A formula dragged one row too far, a typo like 35,00 or a deleted row. Nothing warns you.
- No audit trail. A normal sheet doesn't show who changed a number or when. That matters when cash goes missing or a customer disputes a payment.
- Late fees and part payments. They're possible in Excel, but every special case is a new rule someone has to remember.
- Customers can't see it. Parents and customers can't check their own balance, so they call or message you instead.
A school fee management system in Excel can track fees well. It can't talk to parents, take payments or stop two people editing different copies.
Where Excel still wins
We make software, but we'll be straight with you. Excel or a register is the better choice when:
- Your list is tiny. A home tutor with a handful of students doesn't need a system.
- One person does everything. No handovers, no second copy, no confusion.
- Everyone pays cash in person. If nobody pays online, there are no bank payments to match.
- You need a one-off analysis. Planning next year's fees or testing a discount is quicker in a sheet.
- You want zero monthly cost and have the time to do the work yourself.
If that's you, use the layout and formulas above, and come back when the list grows.
Outgrowing your fee sheet?
Wasooli.Online makes the bills every month, sends them on WhatsApp with a Billing ID and updates each customer's khata when they pay. We help bring your Excel list across.
What Excel really costs: a worked example
Excel is free, but your time isn't. Here's a simple way to price it. The numbers below are an example only, not measurements. Replace every one with your own.
Say you have 120 customers paying a monthly fee, and about half of them need at least one reminder.
| Monthly task | Example time | Example total |
|---|---|---|
| Making or updating each bill | 1 minute × 120 customers | 120 minutes |
| Sending reminders | 2 minutes × 60 customers | 120 minutes |
| Checking payments against the bank app | 1.5 minutes × 120 customers | 180 minutes |
| Writing or sending receipts | 1 minute × 120 customers | 120 minutes |
| Fixing mistakes and answering "did you get my payment?" | A flat guess | 60 minutes |
| Total | 600 minutes, or 10 hours |
Now put a value on those hours. If an hour of your time, or your staff's time, is worth Rs 500 in this example, 10 hours comes to Rs 5,000 a month. Double the customers and the hours roughly double too.
Then think about the part that's harder to count: fees that come in late, or not at all, because nobody had time to remind. Compare your total with the price of fee collection software. If Excel still comes out cheaper for you, stay on Excel. That's a fair result.
Excel vs fee collection software, side by side
| Job | Excel or register | Fee collection software |
|---|---|---|
| Making monthly bills | Copy rows by hand | Created every cycle by themselves |
| Late fees, part and advance payments | Formulas you maintain | Handled for you |
| Reminders | Sent one by one | Sent on WhatsApp for you |
| How customers pay | Cash, or a transfer plus a screenshot | A Billing ID from their bank app or wallet |
| Recording payments | You check and type | Posts to the customer's khata by itself |
| Receipts | Written or typed each time | Sent on WhatsApp after payment |
| Several staff | Copies of one file | Own logins with roles and permissions |
| Owner view | Totals you build yourself | Monthly collections, pending dues and new customers |
| Cost | Free, but costs your time | Monthly subscription |
How to move from Excel to Wasooli.Online
Moving doesn't mean starting again. Your sheet already holds most of what you need.
- Clean the sheet. One row per customer, a unique ID, one phone number format and the fee each person pays.
- Settle the balances. Note what each customer owes, or has paid in advance, on your switch date.
- Pick a start date. The 1st of next month is simplest.
- Send us the list. Our team helps you bring it into Wasooli.Online during setup.
- Tell your customers. Let them know bills will now come on WhatsApp with a Billing ID they can pay from their bank app.
- Keep the old file. Keep it untouched for a month or two in case anyone asks about a past payment.
After that, each month's bills go out by themselves, and payments show in each customer's khata without anyone typing them. Message us on WhatsApp at +92 315 7777653 or book a free demo.