forumNew topic

Free management software vs. spreadsheets for a music school?

TTuğrulMember
Job title
Solar energy
Joined
Feb 2024
Message
88
#1

We run an independent music studio in the Paris suburbs offering piano, violin, and classical guitar lessons. There are 3 instructors including myself, and our active student count reached 40 this term. Each student gets a one-hour private lesson per week, and we charge an average monthly tuition of 120 Euro.

Up until now, we’ve handled lesson schedules, room assignments, and parent payments through a shared spreadsheet. But things are starting to slip through the cracks. When an instructor cancels a class, they forget to log the makeup session on the sheet, leading to double-booked piano rooms with another instructor. Plus, we can't tell which parents are late on tuition without manually checking every single row at the end of the month.

I’ve seen some free management tools and open-source templates for music schools online. Would switching to software like that solve our issues at the 40-student mark, or is it safer to stick with spreadsheets and just upgrade our formulas?

SSerkan Ç***MemberCommunity member
Joined
Jul 2022
Message
373
Most Helpful#2

Short answer: With 40 students and multiple instructors, spreadsheets are simply no longer adequate to manage room double-bookings, makeup lessons, and a monthly cash flow of around 4,800 Euro without errors.

Spreadsheets hit a wall in three main areas: 1) Room and resource scheduling: Spreadsheets are static tools; they can’t technically stop two instructors from booking the same room at the same time, whereas dedicated software flags conflicts instantly and blocks double-bookings. 2) Billing and overdue tracking: With recurring monthly payments, every student's situation varies between bank transfers and checks; management software lets you filter overdue accounts in a single view and auto-generates receipts. 3) Parent and student communication: Automated instant alerts for cancellations or makeup requests spare instructors from having to handle endless back-and-forth on their personal phones.

It's tough to find a genuinely free, feature-complete music school platform; most tools on the market start charging once you pass 10-15 students. At your scale, the right move is setting aside a modest budget per student to get industry-specific software (running roughly 30-50 Euro a month for a license). Preventing just two botched makeup classes or a single missed tuition payment each month will easily cover the software costs.

MMert P***Expert
Job title
Front office accounting
Sector
Energy
Organization type
regional distributor
Joined
Sep 2022
Message
204
#3

When moving from a spreadsheet to dedicated software, look for three key features: 1) Instrument room-based scheduling, 2) An automated balance tracker for accrued makeup credits, 3) Monthly receipt generation compliant with French tax regulations that can be sent straight to parents.

AAslı O***Veteran
Job title
Project manager
Sector
Software
Organization type
boutique agency
Joined
May 2023
Message
23

Doki · KVKK compliance consulting · 2023

#4

We insisted on using spreadsheets back when we had 35 students. At the end of the year, we realized one parent hadn’t paid for 3 months because a formula error was showing their cell as green. We took a direct hit of 360 Euro just like that.

edit: I wrote something wrong above, sorry about that.

HHüsniye K***ExpertCommunity member
Joined
Jul 2025
Message
1
#5

40 students means dealing with 40 parents and their non-stop schedule change requests. anyway trying to manage that via spreadsheets turns you into a full-time receptionist instead of a teacher.

ÖÖzgür Ç***Expert
Job title
Accounting clerk
Sector
Leather
Organization type
workshop
Joined
Oct 2024
Message
328
#6

Keep in mind that most off-the-shelf software doesn't really get how music schools handle makeup lessons. A lot of platforms just treat them like generic appointment slots. Make sure you test the makeup lesson workflow during their 14-day trial before committing to anything.

KKader G***Member
Job title
Clinic manager
Sector
Retail
Organization type
chain store
Joined
Mar 2024
Message
93

Doki · Backup setup · 2023

#7

Having three instructors edit the same spreadsheet at the same time is always an invitation to data loss. The second someone accidentally deletes a column, rolling back the version history turns into an absolute nightmare.

ZZerrin S***Expert
Job title
Sales Manager
Sector
Software
Organization type
120-person company
Joined
Apr 2023
Message
43
#8

check out open source association management tools imo they're free and handle student fee tracking really well just need someone to set it up on a server.

İİbrahim A***ExpertCommunity member
Joined
May 2024
Message
1
#9

Quick fix until you make the switch: restrict the room column in your spreadsheet using 'data validation' and set up separate protected sheets for each instructor so they can only see and edit their own classes.

HHakan T***Member
Job title
Investment advisor
Joined
Jan 2024
Message
96
#10

If parents' email addresses and phone numbers are being entered into third-party cloud platforms, notifying them and obtaining their consent is essential for institutional transparency.

ZZehra D***Expert
Job title
IT manager
Sector
Food wholesale
Organization type
120-person company
Joined
Feb 2025
Message
44

Doki · Server maintenance contract · 2024

#11

I agree with this. Everyone rushing into music school management software gets stuck at the same point.

Correct me if I'm wrong.

OOnur M***Expert
Job title
Accounting clerk
Sector
Plastic
Organization type
medium-sized business
Joined
May 2023
Message
7
#12

You're right. anyway if code ownership isn't in the contract, you have no bargaining power when leaving.

CCerenMember
Job title
QA Tester
Joined
Mar 2024
Message
178
#13

Three different views emerged they all complement each other. The real issue isn't the number, but what it's based on.

If you have questions, write them; I'll answer as best I can.

HHakan Ş***New memberCommunity member
Joined
Aug 2026
Message
2
#14

I have an objection here. Weekly written progress reports are much more useful than asking for dates.

Hope this helps.

SSerkan K***Member
Job title
Marketing director
Sector
Law
Organization type
family business
Joined
Apr 2023
Message
73

Doki · Incident response support · 2024

#15

I'll argue the opposite, don't get mad. When making a decision, first look at what data you have on hand.

Start with a small trial; don't commit to everything at once.

AAleyna G***MemberCommunity member
Joined
Nov 2024
Message
54
#16

I'm curious too.

LLevent B***MemberCommunity member
Joined
Aug 2025
Message
186
#17

I have a question, don't want to go off-topic though. Start with a small trial; don't commit to everything at once.

I'm also curious if anyone does it differently.

DDilaraMember
Job title
Blog writer
Joined
Feb 2024
Message
134
#18

There's a part I don't understand. Don't hesitate to ask; those who don't ask always pay more.

If acceptance criteria aren't written, when the work is done is open to debate. I'm also curious if anyone does it differently.

İİlknur G***MemberCommunity member
Joined
May 2025
Message
172
#19

I felt relieved reading this answer so it's not just me... If scope grows either time or budget must grow. btw there is no third option.

If you post the result here, it will help others too.

UUğur K***ExpertCommunity member
Joined
Mar 2023
Message
44
#20

I went through the same thing two years ago. Solutions that work at a small scale collapse when you grow; I learned this late.

Correct me if I'm wrong.

This topic has been closed.The moderator marked the topic as resolved. If you have a similar issue, you can open a new topic.
New topic