# 7 signs your online academy has outgrown spreadsheets

> Your academy has outgrown spreadsheets when class times, invoices, payments and teacher pay need repeated manual checks to stay accurate.

URL: https://halqora.com/blog/signs-academy-outgrown-spreadsheets
Last updated: 2026-10-21

Published: 2026-10-21 · By Halqora team

You can run a tutoring business on spreadsheets until the sheet needs manual checks to show who taught, who owes money and what teachers earned. You have outgrown the spreadsheet when clock changes, hand-built invoices, unmatched transfers, inconsistent cancellation decisions, pay questions or disputed class counts keep breaking that record.

> **Key facts:** - In 2026, UK clocks change on 29 March and 25 October, according to the UK government's clock-change calendar.
> - The London–Cairo gap ranges from 1 to 3 hours during 2026, using [IANA's time-zone rules for Africa](https://data.iana.org/time-zones/tzdb/africa).
> - As of 21 October 2026, [Wise's payment-request guidance](https://wise.com/help/articles/2WvlZST6DiDMUBhyl1N4zM/how-to-request-money) says requests stay active for 30 calendar days.

> **Definition:** A class outcome is the recorded result of a scheduled class, such as completed, student cancelled or student no-show, used to explain billing and teacher pay.

## Sign 1: Do class times break when clocks change?

Class times have outgrown a fixed-offset sheet when someone must correct recurring lessons after a clock change. A spreadsheet can handle date-aware calculations, but a note saying “Cairo is 2 hours ahead” cannot. Store the recurring class time with its named IANA time zone, then calculate the teacher's and student's local times for each class date.

In 2026, London–Cairo moves from a 2-hour gap to 1 hour on 29 March, returns to 2 hours on 24 April, reaches 3 hours on 25 October, and returns to 2 hours on 30 October. These dates follow the IANA rules cited above, as checked on 21 October 2026.

Check the intended local time before changing the schedule. Ask whose local time should stay fixed. Then inspect classes around clock changes on both sides. Fixing the displayed time without fixing the recurring rule leaves the same problem waiting for the next change.

## Signs 2 and 3: Are invoices hand-built and balances unclear?

Hand-built invoices become a warning when you must rebuild the class history to explain every total. An unclear balance is a separate warning: sending an invoice does not tell you whether the family paid. Your records should connect each charge to its classes and each payment to its invoice, with a balance you can explain without opening private messages.

Keep draft, sent, paid and overdue invoices distinct. A draft needs review; a sent invoice may still be unpaid. Copying a total into a “paid” column before checking the incoming payment hides the difference between money requested and money received.

Follow a disputed charge back to the class record. If the trail stops at a manually typed total, improve the underlying record before changing the invoice design. The [lessons from running a Quran academy on spreadsheets](https://halqora.com/blog/lessons-from-running-quran-academy-on-spreadsheets) focus on that connection between daily records and month-end work.

## Sign 4: Do bank transfers arrive that you cannot match?

Unmatched transfers are a warning when checking the bank becomes a search through family names, invoice totals and messages. A matching process needs a clear invoice reference, the correct currency and enough payer information to identify the debt. A similar amount is a clue, not proof that a particular family paid a particular invoice.

Ask families to include the invoice number in the payment reference. Preserve the payer name and currency alongside the amount. Keep uncertain transfers in a review queue rather than assigning them to whichever open invoice looks closest.

Wise (wise.com) lets you mark a payment request as paid, request again or close its link, according to the guidance linked above. A request's status and your academy's invoice record still need to agree. Closing a request is not a substitute for recording where the money went.

## Sign 5: Do cancellation decisions depend on who checks?

Cancellation handling has outgrown informal notes when the same circumstances produce different charges depending on the admin. The problem is usually missing evidence or an unclear rule: who cancelled, when the cancellation happened and whether an exception was approved. Record those facts with the class so the decision survives a change of staff or a later question from a parent.

Use a written policy before asking software to apply the policy. Distinguish a student's cancellation from a teacher's cancellation and a student no-show. Record the actual cancellation time rather than the time an admin happened to read the message.

When reviewing software, bring your real policy and ask how the software handles each outcome. Fixed outcome rules may differ from your existing policy. A tidy interface does not remove that mismatch, and an admin should understand the difference before importing classes.

## Signs 6 and 7: Do teachers question pay and parents dispute counts?

Teacher pay questions and disputed family class counts share a common cause when separate records describe the same lesson differently. The teacher remembers teaching, the schedule shows a booking and the invoice contains a charge. Those records need a recorded outcome between them. A scheduled class proves that a lesson was planned; a scheduled class alone does not prove completion.

For a pay question, inspect the class result, duration, hourly rate and any recorded adjustment. For a family question, inspect the class result and billing rule. The explanation should come from the record rather than an admin's memory of a conversation.

Keep reports distinct from family-facing information. In Halqora, completed-class reports contain a rating and written feedback for admins; families do not see those reports. Payroll for the period waits until reports are in. Teachers record outcomes, while admins resolve the remaining cases and record late minutes, wait minutes and emergency exceptions.

## What does each spreadsheet warning cost you?

| Sign | What it costs you in a spreadsheet | What software replaces it with | Quick test |
| --- | --- | --- | --- |
| 1. Clock changes | Rechecking local class times | Scheduling rules in each IANA time zone | Inspect a class across a clock change |
| 2. Hand-built invoices | Rebuilding charge totals | Draft invoices from class records | Trace an invoice line to its class |
| 3. Unclear balances | Searching for unpaid amounts | Invoice balances and payment records | Explain a family's current balance |
| 4. Unmatched transfers | Searching names and references | Reference matching and an unmatched queue | Resolve a transfer without guessing |
| 5. Inconsistent cancellations | Reopening earlier decisions | Recorded notice and outcome rules | Explain why a cancellation was charged |
| 6. Pay questions | Recalculating earnings from messages | Class-based pay calculations | Trace a teacher's pay to class outcomes |
| 7. Disputed counts | Comparing competing class lists | A per-session status log | Separate scheduled from completed classes |

The cost column describes work and uncertainty, not measured losses. Your own records should decide whether software is worth buying. Track where corrections happen, what evidence is missing and which tasks depend on someone's memory. A spreadsheet remains useful when the record is clear; software becomes useful when connected records remove recurring checks without hiding decisions.

Before moving, take disputed or corrected records through the proposed workflow. Check whether you can explain the result to a teacher and a parent. Then follow a staged approach to [moving from spreadsheets to software](https://halqora.com/blog/move-academy-from-spreadsheets-to-software), keeping the old records available for reference.

## How Halqora handles this

Halqora is management software for online academies from Talt AI; [Murouj Academy, an online Quran academy, runs on it](https://halqora.com/case-studies/murouj-academy). Halqora records an outcome for each class and uses class records for billing and pay calculations. Billing runs create draft invoices; an admin reviews and sends them.

Halqora supports one-to-one classes within a fixed set of 5 Quran and Islamic subjects today. Siblings can share a family invoice. Wise transfers are matched, never created, by Halqora; unclear matches go to an unmatched queue. Class and payroll rules are fixed, so check their fit before moving.

See how [Halqora features connect class records and billing](https://halqora.com/features).

## Sources

- UK government clock-change calendar, checked 21 October 2026
- [IANA time-zone rules for Africa](https://data.iana.org/time-zones/tzdb/africa), checked 21 October 2026
- [Wise payment-request guidance](https://wise.com/help/articles/2WvlZST6DiDMUBhyl1N4zM/how-to-request-money), checked 21 October 2026

## Questions

### Can you run a tutoring business on spreadsheets?

Yes. A solo tutor with a manageable local roster can track lessons and payments in a spreadsheet. The warning comes when recurring classes, teachers and payment methods require repeated copying and checking. Keep using the sheet while you can trace class outcomes, unpaid balances and teacher pay without reconstructing events from messages.

### How many students before I need software?

There is no fixed student count. Look for recurring invoice corrections, payments you cannot match and pay calculations you cannot explain from class records. Those problems matter more than roster size. For a price reference, as of October 2026, Halqora Starter costs USD 39/mo for up to 25 active students. Compare the cost with your own recorded administrative work.

### Why do spreadsheets get time zones wrong?

A spreadsheet can calculate time zones correctly, but a fixed time difference cannot account for changing clock rules. In 2026, the London–Cairo gap ranges from 1 to 3 hours, according to IANA time-zone data. Store the named time zone and check each class date rather than adding the same offset throughout the year.

### What should I move off the spreadsheet first?

Start with the records behind disputes or missed charges, usually class outcomes and invoices. Give each class a recorded result and use that record when reviewing family charges and teacher pay. Check the software against your actual cancellation and payroll policies before migrating. Keep the old spreadsheet read-only so you can trace earlier balances and decisions.