Tracking tutoring sessions in Excel — how many students before I need dedicated software?

We insisted on sticking with Excel at 60 students. When we reconciled the books at the end of the term, we realized we had 14,500 TL in uncollected tutoring sessions simply because a lesson on the teacher's schedule never got transferred to the master sheet. The software pays for itself many times over.

When making the switch, don't try to cram the last 3 years of detailed history into the new system. Just import active student names parent phone numbers recurring weekly class schedules, and current outstanding balances. Keep the older records in your archive Excel file.

Excel is not a relational database. When you cram students, teachers, rooms, and billing into a single spreadsheet, data integrity mathematically collapses as the row count grows. Double-booking a room is a constraint violation at the database level, but Excel has no clue.

sending a parent a duplicate overdue notice is one of the worst hits to your reputation as a business.. and people expect absolute professionalism from an educational institution. 85 students is a solid number switch to professional software without waiting any longer imo.

Roadmap for migrating to software: 1) Verify and finalize the active balances directly with parents. 2) Run both the spreadsheet and the software in parallel for 5 days during the launch week. 3) Set restricted user permissions for teachers so they can only see their own sessions.

If you think hunting for broken macros in an Excel cell at 11 PM while a parent claims 'we paid that in cash' is just part of the tutoring business, carry on; otherwise, go find software tomorrow.

Bottom line: past 50 students, Excel stops being a money-saver and turns into a hidden cost sink. Migrating just your active balances without delay will eliminate both room conflicts and financial leaks.

My questions are cleared up, thanks. Changing habits is harder and more expensive than setting up a system.

Let me summarize the topic, since several different answers were given. If you don't write this down from the start, it leads to arguments later.

Three different views emerged, they all complement each other. Start with a small trial; don't commit to everything at once.

Splitting your budget without knowing where you're losing users is just throwing money in the dark. If you have questions, write them; I'll answer as best I can.

i have a question and when we decide without measuring we always end up in the same place.

i'm also curious if anyone does it differently.

Thanks that was the answer I was looking for. When making a decision, first look at what data you have on hand.

The answer above hits the nail on the head. Look where the bucket leaks; pouring water on top doesn't solve it.

Start with a small trial; don't commit to everything at once. Correct me if I'm wrong.

Great work.

The cheap-looking path usually ends up costing more later. Hasty decisions become decisions you have to fix six months later.

If I were you, I'd go this route.

Correct. Don't enter any agreement without an exit plan.

Good luck with that.

I went through the same thing.

The discussion got scattered, let me summarize. When making decisions, write down the worst-case scenario too, not just the best.