Spreadsheets or Madrasa Management Software: When to Switch

Switch when the spreadsheet stops being a list and becomes the place where money and parents are handled. A spreadsheet is good at holding names, classes and phone numbers. It cannot take a fee from a parent. It cannot tell a parent anything. And it keeps no trustworthy record of who changed what. If your admin spends Saturday morning matching bank transfers to rows, chasing unpaid fees on WhatsApp and answering parents who want to know whether they have paid, the spreadsheet has already been outgrown.

What a spreadsheet does well

It costs nothing extra, everyone has used one, and the person who built it knows where everything is.

For a register of names, dates of birth, classes and emergency numbers, it works. A new class can be set up in an evening.

The trouble starts when the same file is asked to do work it was never built for.

Spreadsheet or software, job by job

The table compares a spreadsheet with madrasa management software on the jobs a madrasa office does every week.

The first row is why spreadsheets get chosen. The rest are why madaris leave them.

Job one it cannot do: collect a fee

A spreadsheet can say a fee is owed. Somebody has to tell the parent, wait for a transfer or cash, find the payment and type it into the right row.

That last step is where errors creep in. A transfer arrives with the reference fees and no child named. Cash is handed over at the door and written on a scrap of paper. By the end of term the file says one thing and the bank says another.

Software joins the two. In Hidayah, parents pay outstanding fees by card or Bacs Direct Debit through Stripe from their own login, and cash taken at the door is recorded in the same ledger as online payments.

For a madrasa that is a registered charity in England and Wales, matching the records to the bank is part of good financial control. The Charity Commission's guidance on internal financial controls lists accounting records and bank statements being compared each month, and a second person reviewing the reconciliations. The same guidance says more than one person should be involved in all financial transactions, with a different person authorising a transaction from the one who made it.

A single file kept by a single admin makes that hard to show.

Job two: tell a parent

A spreadsheet knows who owes what and tells nobody. Every reminder is a message someone types by hand, late at night, to the same families each month.

The admin becomes the person who chases. Parents who did pay ask for proof. Parents who did not say they never heard.

Software sends the routine messages itself: a polite reminder before and after the due date with a link to pay, and a receipt after every payment. Parents can also log in and see each child's balance and payment history, so the question of whether they have paid gets answered without a phone call.

Job three: keep a history

A spreadsheet shows what a cell says today. When a fee is changed, a row is deleted or a sort goes wrong, version history may hold the old value, but few people know how to read it and it never says why a figure changed.

A parent disputes a balance from last spring. A trustee asks why a family's fee was reduced. The answer has to be in the records, not in someone's memory.

The Charity Commission's guidance on managing charity finances says a registered charity in England and Wales must keep its accounting records for at least 6 years. Both Charity Commission pages apply to England and Wales, with separate guidance for Scotland and Northern Ireland. This is general information for England and Wales as of October 2026, not legal advice.

Years of fee records in one file, edited by several people, is a lot to trust. In Hidayah, refunds and adjustments are logged, and changes to student records and class assignments are recorded with who did what and when.

Who can see the children's details

A madrasa spreadsheet often holds medical notes, allergies, home addresses and parents' phone numbers. Shared by email or by link, the whole file goes to whoever receives it.

Under the UK GDPR security principle, the ICO says security measures should aim to ensure personal data can be accessed, altered, disclosed or deleted only by those you have authorised to do so. Its guidance on data protection by design suggests role-based or named access controls, and a process to give or revoke access when staff change roles or leave.

A copy of a file sitting on a teacher's phone cannot be taken back. Software can give a class teacher their own classes and nothing else, and give the accountant the money but not the academic records.

The ICO also says you should be able to recover personal data if it is accidentally lost, altered or destroyed. That is hard to promise for a file that lives on one laptop.

This is general information for the UK as of October 2026, not legal advice.

Signs it is time to switch

• More than one person edits the fee spreadsheet, and the totals no longer agree.
• Someone spends hours each month matching bank transfers to students.
• Parents regularly message to ask what they owe.
• Teachers hold copies of a file with every child's medical and contact details.
• Only one person understands the file, and the office would stall without them.

Two or three of these and the spreadsheet is costing more time than it saves.

When a spreadsheet is still enough

Not every madrasa needs to move. A small evening class, with fees paid in cash to one teacher and a handful of families who all know each other, can run on a list for a long time.

If nobody is chasing money, nobody is asking what they owe, and one trusted person holds the data, keep the spreadsheet and keep it backed up.

Questions to ask any supplier

Choosing software means handing a company your families' data, so check before you sign. The ICO gives the example of a charity buying software to manage volunteer information, whose team reviewed how the supplier would store and use personal information and what security measures protected it.

1. Where is our data stored, and who at your company can see it?
2. Who holds card details? Ask whether they go straight to a payment provider.
3. Can we export all our students, fees and payments to a spreadsheet at any time?
4. Can each member of staff see only what their role needs?
5. Is there a record of who changed a fee or a student record?
6. What happens to our data if we leave?

Moving the data across

The old spreadsheet does not go to waste. It becomes the import file. Tidy it first: one row per child, each parent's name and phone number in its own column, and siblings marked so they can be linked to the same family.

With Hidayah you can import your madrasa register from Excel, or send the file and it will be imported for you free. Before inviting parents, check that the student count, class sizes and outstanding fees match the old file.

Start with one class. Check every row of it after the import, and only then move the rest.

Questions madrasa admins ask about leaving spreadsheets

Is madrasa software worth it if we only run one class?

Often not. If fees are paid in cash to one person and parents rarely ask about balances, a tidy spreadsheet with a backup can be enough.

Can we keep the spreadsheet running alongside the software?

For a short handover, yes. Keep the overlap as short as you can, because two places holding the same figures is how totals drift apart.

How long should a madrasa keep its fee records?

For a madrasa that is a registered charity in England and Wales, the Charity Commission says accounting records must be kept for at least 6 years. Elsewhere, check the rules where the madrasa is registered. This is general information as of October 2026, not legal advice.

Is a shared online spreadsheet safer than one on a laptop?

It is easier to back up, but everyone with access usually sees the whole file. The real question is who can see the children's details.

Sources

• Charity Commission: Internal financial controls for charities (CC8), checked 13 October 2026
• Charity Commission: Managing charity finances, checked 13 October 2026
• ICO: A guide to data security, checked 13 October 2026
• ICO: Data protection by design and by default, checked 13 October 2026