Move Kids' Class Registration from Spreadsheets to Online Booking
A practical switch plan for studios and camps: reconcile existing enrollments, protect reserved places, test registration and give families one clear booking link.
Updated November 9, 2026
A spreadsheet can work well for a small class. The difficulty starts when the roster, payment notes and parent messages disagree: a child has a confirmed place in one list, an unpaid balance in another, and a different start date in an email. Moving registration online is useful when it gives your team one dependable answer to who is coming and what they booked.
Start with one upcoming class or term. Keep existing commitments intact, reconcile the available places and decide exactly when new registrations move to the booking page. This guide includes a worked capacity example, a record checklist and a first-week review you can adapt to an art studio, dance school or children's camp.
Choose the first class and the changeover date
Pick a program with a clear age range, location, schedule and price. A new term with no existing bookings is simpler than a class with active installments, credits and make-up visits. If you start mid-term, list those exceptions before changing any registration links.
Write down three decisions: which class is moving, when the new booking link becomes the registration destination, and who resolves discrepancies. Keep a dated copy of the old roster for reference. During the transition, choose one place to record new enrollments so two people cannot sell the same remaining seat from different lists.
Reconcile places before opening registration
Count children for each dated class, rather than counting payment rows or households. A family with two children needs two eligible places; one child paying in installments still occupies one place.
The calculation is 12 total places minus seven confirmed places minus two active holds: three places remain. Do not enter 12 as the number of newly available seats unless the system already accounts for those nine commitments. Check how your chosen software treats total capacity, imported enrollments and manual holds.
A drop-in place also needs a seat on that particular date. A recurring student, a make-up visit and a trial child can all attend the same meeting. Review the dated roster before offering the last spot. If the numbers do not agree, pause new sales for that class while you reconcile them.
| Illustrative 12-place class | Places | Action before launch |
|---|---|---|
| Confirmed children | 7 | Keep their places reserved |
| Promised places awaiting payment | 2 | Resolve or hold according to your stated policy |
| Available for new registration | 3 | Open only these places while the two holds remain |
| Separate waitlist | 4 requests | Keep as requests, not confirmed attendance |
Example only. These are not KidzMaps booking figures or a claim about automatic migration.
Prepare a small, usable registration record
Separate the family record from each child's class enrollment. Do not merge siblings just because they share an email address, or create a duplicate child because two adults use different addresses. Match uncertain records with the original registration before making changes.
Ask your software provider which records can be imported and which must be entered or completed again. Moving a roster does not automatically move saved payment methods, recurring charges or signed forms. Confirm the supported process before asking parents to act. Use the system's designated fields for necessary private information; keep it out of public class descriptions and shared sample files.
| Record | What to confirm |
|---|---|
| Family and child | Correct child, responsible adult and current contact details |
| Class assignment | Location, age group, day, time and first attendance date |
| Enrollment | Confirmed, pending or waitlisted, with the original reference |
| Payments | Amount already paid, remaining balance and next due date |
| Exceptions | Credits, transfers, make-ups and any promised place |
| Required forms | Which forms are complete and which still need a parent response |
A planning checklist, not an import-file specification.
Check the parent journey and the class-day result
The selection: On a phone, find the class from your website and check ages, location, included dates and the price. Make sure a trial, single visit and recurring enrollment are distinguishable.
The payment: Check the full checkout amount and billing terms. An existing paid family should not be asked to buy the same enrollment again merely to appear on the new roster.
The roster: In an approved test environment, confirm that a completed test registration creates the right child on the right dates. Check a sibling enrollment and a full-class or waitlist case if you plan to offer them.
The handover: Have the person teaching the class find the roster and arrival information. A successful payment alone does not establish that the team can run the session.
Keep testing separate from real inventory and customer counts. If you cannot complete a checkout test safely, ask for a supported test process; do not charge a family or consume a live place just to see what happens. Resolve a wrong price, duplicated enrollment or incorrect roster before sharing the link.
Give existing and new families different instructions
New families need the current booking link and a clear description of the class. Existing families need to know whether their place is already confirmed, whether they owe anything, and whether they must complete a form or account step. Sending both groups a generic 'book now' message can create duplicate registrations.
A useful message structure is: 'Registration for [class and term] opens at [link] on [date]. Your existing [specified enrollment] remains confirmed. Please [required action, if any] by [date]. For questions about a previous payment or credit, contact [your team].' Fill in only statements you have checked against that family's actual record.
Update the class page, schedule page and other links you control. Keep useful program information available, but stop accepting new registrations through an old form once the changeover takes effect. Decide who monitors questions and late replies during the first week.
Start with one program on KidzMaps
KidzMaps provides activity listings, bookings and payments, schedules, rosters and an optional booking embed for an existing website. Begin by creating a provider account and preparing one activity with accurate dates, ages, location and pricing. Confirm the activity's payment and booking setup before inviting families to enroll.
Use the public activity link as the registration destination, or follow the website-booking guide to add a schedule to your existing site. Your current families and payment arrangements still need the reconciliation steps above: creating a listing does not itself transfer historical registrations or authorize new charges.
Before rolling out more classes, compare the actual roster with your transition record. Check each new registration once, verify any remaining balance or credit separately, and resolve exceptions with the family. Expand only when the first class is consistent from parent confirmation through attendance.
Review the first complete week
Enrollment accuracy: Count confirmed children, duplicate registrations, unresolved payments and roster corrections. Investigate the underlying records rather than treating every form submission as a new customer.
Parent experience: Record repeated questions about dates, fees or next steps. Fix the unclear sentence or link that caused the question.
Time spent: Track time spent on registration administration, including the initial setup. Compare a similar enrollment week; do not promise savings before you have measured them.
Discovery: Keep new families who found you through search separate from existing families using a new payment link. A smoother registration process and new customer acquisition are different outcomes.
Frequently Asked Questions
Do I need to move every class at once?
No. Start with one clearly defined class or upcoming term. Preserve existing registrations and resolve capacity, balances and exceptions before opening the next program.
Should existing families register and pay again?
Do not ask them to repurchase an enrollment they already paid for. Reconcile each record, confirm the supported transfer or setup process, and tell families exactly which action is still needed.
What should I check before moving existing registrations?
Reconcile each child’s confirmed place, original payment, remaining balance and start date. Agree the transfer process before opening new registration, then check that existing families are not asked to pay twice.
How do I avoid overselling a class during the switch?
Reconcile confirmed children and active holds against each class date, then open only the remaining capacity. Use one source for new enrollments after the changeover and check how your software counts existing places.
How will I know the switch worked?
Look for accurate dated rosters, clear parent confirmations, fewer unresolved registration questions and measured administration time. Review a complete comparable week and exclude staff tests from customer counts.
Sources and further reading
Prepare your first program with a KidzMaps provider account, the booking-software checklist, the website-booking guide, monthly tuition and drop-in choices
