Google Sheets for a Kids Program: Where It Breaks

Updated September 17, 2026

Yes, up to a point. Google Sheets works well when you run one to three sites and one person does all the admin. It starts costing real hours once you add sites, instructors and payment plans, because every answer lives on a different tab. Keep Sheets for planning and tracking. Move registration, payments, waivers and rosters into a tool built for them.

Google Sheets is a good product. It costs little or nothing, it is flexible, it opens anywhere, and almost every operator I have ever talked to knows how to use it. When I called veteran operators to ask how they ran their businesses, everybody said the same thing: a spreadsheet. If that is you right now, you have been doing the sensible thing with the tools available. I'm going to show you what it costs, and you decide.

Is Google Sheets good enough to run a kids program?

For a small program, yes. One class at one site, with you teaching it, fits on one tab: kids' names, parent contacts, who paid. You can hold the rest in your head.

Sheets gets three things right. You can shape it to your business in an afternoon. You can share it with an instructor in one click. And you own the data, in a format you can take anywhere. Those are real strengths. Keep them in mind when we get to what should stay in a spreadsheet.

Where does a spreadsheet start to break?

It breaks when answering one question means opening four tabs. Here is the shape of it. Say you run 12 school sites. Each site has an enrollment tab. Each has an instructor tab. There is a billing tracker and a parent communication log. It works. You know where everything is, most of the time.

Then a school coordinator emails. Is this parent's kid in the Tuesday session or the Thursday session? You open that school's tab, find the student, confirm the session, then double-check which session code is Tuesday this term, because you changed the schedule in January. Eleven minutes. Two hours later you remember you were supposed to send that school's October invoice today. The email pulled you off it. You'll send it tomorrow.

Now the hard one. An instructor calls out sick Wednesday morning for a Thursday program. You need someone who is free Thursday afternoon, has been to that school, knows your curriculum and has met the coordinator. None of that lives in one place. You spend 45 minutes on a swap that should take 8. I cover the fix for that one in how to build a sub plan that holds.

Nobody did anything wrong in either story. A general-purpose spreadsheet was asked to be a registration system, a roster, a scheduler and a billing desk at the same time.

What does running on spreadsheets cost in hours?

More than it feels like, because it arrives in 11-minute pieces. Here is an example for a 12-site operator. Swap in your own numbers.

1. Lookups. 6 "which session is my kid in" questions a week x 11 minutes = 66 minutes a week.
2. Roster rebuilds. 12 sites x 5 minutes each Sunday night to get clean rosters to instructors = 60 minutes a week.
3. Payment matching. 20 payments a week checked against the enrollment tab x 3 minutes = 60 minutes a week.
4. Sub swaps. 2 a month x 45 minutes = 90 minutes a month, or about 22 minutes a week.

66 + 60 + 60 + 22 = 208 minutes. That is about 3.5 hours a week. Over a 36-week school year, 3.5 x 36 = 126 hours. More than three full work weeks, spent finding information you already have.

The hours are the smaller cost. The bigger one is the invoice that went out a day late, the kid left off a roster, the parent who asked twice. Those touch the relationships this business runs on. If you want to put a dollar figure on the registration side, try the registration loss calculator.

What should stay in a spreadsheet?

Planning and tracking work that changes slowly and that only your team sees. Spreadsheets are great at it. I would keep all of this in Sheets:

• Your budget and price modeling for next term.
• Your school pipeline: who you've pitched, who said yes, renewal dates.
• Your tracker for invoices you send to schools and PTOs, and when each was paid.
• Supply and curriculum kit inventory.
• End-of-term notes on each site.

What should move out of the spreadsheet first?

Anything a parent touches, and anything an instructor needs to be right at 3 PM. Move them in this order.

1. Registration and payment, together. When the form and the money live in separate places, you become the matching service. One checkout ends that. I wrote about that exact setup in Google Forms and Venmo for class signups, and there is a side-by-side on the comparison page.
2. Waivers. Signed at registration, attached to the kid, findable in seconds.
3. Rosters. A roster should build itself from registrations. In enrops each roster carries names, parent emails, grade and homeroom teacher, with a live count of total enrolled at the top.
4. Payment plans and refunds. Installments tracked by hand are where spreadsheets get expensive. enrops runs payment plans you set and handles refunds from the registration.
5. Instructor assignments and sub coverage. In enrops, instructor onboarding, class matching and sub offers are set up with our team today.

If you run programs at several schools, I go deeper on site records and calendars in how to manage after-school programs at multiple schools.

How do I move without wrecking a season in progress?

Leave the current season alone and start with the next thing you open. Nobody needs a mid-term migration.

1. Pick one upcoming program: next term's class at one school, or one camp week.
2. Create it in enrops and publish the registration link. That takes under 5 minutes. The schedule builder pulls the school calendar, so no-school days are already handled.
3. Put the link and QR code on the flyer the school sends home.
4. Watch one full registration cycle: signups, payments, the roster filling in, the confirmation emails going out.
5. Open the rest of next term the same way. Your old tabs stay as your archive.

Frequently asked questions

How many sites can I manage in a spreadsheet?

In my experience one to three sites is comfortable. From about four sites on, the lookups, roster rebuilds and payment matching grow faster than the business does.

Do I need software if I only run one class?

You need a way to take registration and payment together, and a signed waiver. If your current setup does that cleanly, keep it. If you are matching payments to a form by hand, that is the part to replace.

Does enrops replace my spreadsheets completely?

No. It replaces the registration, payment, waiver and roster tabs. Your budget, your school pipeline and your school invoice tracker can stay where they are.

What does enrops cost compared with a spreadsheet?

Free for businesses. Your only cost is Stripe's standard processing. The details are on the pricing page.

Create your first registration. Free for businesses. Live in under 5 minutes. Or click through a sample registration first.

Arielle Hammond, Ed.D. is the founder of enrops and host of The Youth Enrichment Leader, presented by enrops.