Multi-Location Swim School Roster Management: Weekly Checklist

Thursday afternoon at a three-location swim school always looks the same. A parent at the Westside pool emails asking for a Tuesday makeup, a deck supervisor at Downtown turns in two level promotions on a damp paper slip, and a Google Form drops three new toddlers into a class that already hit maximum capacity.

Reconciling rosters across two or three fixed pools doesn't take an enterprise software suite. It takes an operational habit that never slips. You need a reliable sequence to prevent double-booked lanes, split sibling groups, and frustrated deck managers. Before starting this routine, gather three items: your primary registration sheets, the shared email inbox where parent schedule requests land, and the physical attendance clipboards from each facility.

Step 1: Name one source of truth per class and set a weekly cutoff

Multiple live documents guarantee mismatched rosters. If your North pool uses a standalone Google Sheet, your South pool relies on a physical binder, and the front office processes intake through a separate web form, nobody knows who is actually in the water.

Assign one master file for every class section across all facilities. If you manage rosters through spreadsheets, lock that document down so front-desk staff have restricted edit access. Then set a hard weekly cutoff. Thursday at 3:00 PM is standard for schools running Monday through Sunday programs. Any intake form submitted, email received, or transfer requested after 3:00 PM rolls into the following week. Enforce this rule with no exceptions for friends of the owner or persistent callers.

Here's an illustrative example: an independent school runs 350 swimmers across an East pool and a North pool. An intake form arrives Thursday at 4:15 PM requesting a Saturday spot. The front desk logs the student for the following week instead of slipping them into the upcoming weekend schedule. Program directors get a quiet window to audit lane loading while the data stays put.

Teams that eventually replace manual tracking often study a swim school registration spreadsheet to understand data hygiene. Until you adopt dedicated software, your weekly cutoff is your best defense against roster drift.

Step 2: Set each pool's approved cap from space and ratio, whichever is tighter

Lane square footage and instructor-to-swimmer ratios pull in different directions. The tighter limit wins every time.

Don't apply a blanket cap of four students per class across different locations. At your primary facility, you might lease a 25-yard lap pool with seven-foot-wide lanes, where a 4:1 ratio for preschool beginners leaves plenty of safety margin. At a satellite location, you might rent a warm-water therapy pool measuring fifteen by twenty feet. In that smaller basin, two coaches and eight toddlers make an overcrowded hazard.

Calculate both caps for every scheduled slot at every pool:

1. Spatial cap: Calculate usable surface area. USA Swimming guidelines recommend grouping lessons by ability and maintaining appropriate student-to-teacher ratios. If a lane gives you only 120 square feet of teaching water, physical space limits that station to three children and one instructor.

2. Ratio cap: Local licensing, insurance policies, and curriculum tiers set student-to-teacher caps. Stage 1 beginners typically cap at 4:1, advanced stroke development caps at 6:1, and private lessons stay strictly 1:1.

Compare the two numbers and take the lower one. Write that cap directly into the header row of your class roster. Front-desk personnel and deck supervisors must know the number doesn't move. When a parent pleads to join an already full class, staff can point to facility safety limits instead of taking the blame.

Step 3: Pull this week's changes: enrollments, withdrawals, transfers, level moves

Schedule updates arrive in isolated silos throughout the week. Gathering these requests into a single batch prevents chaotic, piecemeal edits.

Open four intake channels in this exact order: cancellation emails, coach level promotions, transfer requests, and new web enrollments. Process them from inventory-clearing to inventory-consuming.

First, process withdrawals. A family moving away or pausing lessons opens a paid spot. Removing them right away creates the inventory you need for the next steps.

Second, process level advancement slips submitted by coaches. When a six-year-old moves from beginner to intermediate, they must leave their current time slot. If an intermediate slot exists at that exact hour in the adjacent lane, move them across. If no slot exists, put them on a priority internal transfer list instead of crowding them into an over-ratio class.

Third, apply lateral transfers between locations. Families often ask to shift from Saturday morning at North pool to Sunday morning at Downtown. Verify the destination class cap from Step 2 before granting the transfer.

Fourth, accept new enrollments into the vacancies created by withdrawals.

Batching these four channels on Thursday afternoon stops administrative churn and keeps your records synchronized.

Step 4: Reconcile makeups, waitlists, and open spots against capacity

Unmanaged makeups are the fastest way to destroy roster accuracy and operating margins. Treat open spots as free inventory for absent swimmers and you invite confusion.

Audit empty slots across all locations once permanent changes are complete. An open spot belongs to your waitlist first, new paying enrollments second, and makeup requests last. If Lane 2 at your Westside pool holds three regular swimmers against a hard cap of four, that fourth slot is recurring revenue. Contact your paid waitlist for that day and level. If nobody claims the slot for recurring tuition, only then assign it to a family redeeming a missed lesson.

Enforce strict makeup rules. Require parents to report absences at least twelve hours in advance to earn a makeup token, and close makeup bookings twenty-four hours before lesson time. Never let deck instructors approve makeups verbally at pool edge.

Software like Soljio solves this friction by letting instructors take attendance and mark skills directly from the deck. When deck staff mark absences digitally in real time, administrative staff don't have to decipher wet paper clipboards five days later. If you run manual spreadsheets, log makeups in distinct colored text on your master sheet so you can spot temporary students instantly.

Step 5: Check pool closures and shared-use conflicts by hand

Multi-location swim schools rarely own all their water outright. Operators often rent space from municipal recreation centers, health clubs, or residential communities. Shared water brings outside disruptions that spreadsheets can't predict.

Every Friday morning, review the facility calendar for each location by hand. Run three checks:

1. Scheduled plant maintenance: Confirm backwash cycles, quarterly chemical balancing, and heater servicing with facility engineers. A three-degree drop in leased water temperature turns a toddler lesson into a cancellation crisis.

2. Shared programming conflicts: Check whether host facilities have scheduled aquatic fitness classes, lifeguard certification courses, or open lap sessions that overlap with your rented lanes.

3. High school or club swim meet displacements: Municipal pools routinely adjust weekend access for seasonal swim meets. If your South pool loses two lanes between 9:00 AM and 11:00 AM on Saturday, compress your schedule or notify affected families before Friday afternoon.

Keep standard parent notification templates saved in your desk manual. If an unexpected chemical imbalance shuts down water access, notify parents immediately with alternative makeup dates or account credits. Parents who learn about a closure when they arrive on deck with goggles in hand will remember it.

Step 6: Compare enrolled vs. attended and publish final site rosters

A reconciled roster is useless if your deck supervisors work from outdated printouts. The publishing step must produce a final, uneditable record for deck staff.

Pull physical attendance records from the previous week and cross-reference them against your updated master roster. If a swimmer attended class at North pool on Wednesday but remains enrolled on paper at Downtown, resolve the discrepancy immediately. Confirm which location the swimmer attends, correct the master file, and audit their billing record.

Generate the official site rosters by Friday at 2:00 PM. Lock your master spreadsheet so other team members can't make accidental edits over the weekend. Export static PDF files for each facility. Group the sheets by day, lane, time, and instructor name.

Print these PDFs for deck clipboards or distribute them to facility tablets. Each site roster must show swimmer names, ages, parent contact numbers, medical alerts, and skill milestones. Tell deck supervisors that if a child arrives who isn't on the official printout, the deck lead sends the parent to the front desk. Deck coaches teach swimmers. They don't verify enrollment from the water.

Step 7: Log discrepancies and tighten the routine (troubleshooting and what to do next)

Roster mistakes happen at every multi-location swim school. Unrecorded mistakes repeat. Logging roster breakdowns exposes the failure points in your business.

Create a dedicated tab titled Roster Discrepancies in your master file. Whenever an instructor encounters an unexpected student, a missing family, or an over-ratio lane, log three data points: the date, the pool site, and the reason for the breakdown.

Three recurring issues explain most multi-location roster errors:

1. Sibling booking splits across locations: Parents enroll two children in separate transactions, landing one child at the Eastside pool and the other at North pool. Fix this by grouping family profiles and requiring staff to review all active siblings before confirming a single child's schedule change.

2. Substitute coach ratio breaches: A regular instructor calls out sick, and an inexperienced deck lead merges two lesson pods into one lane. This violates your insurance ratios. Fix it by keeping an on-call substitute roster or canceling the specific section instead of combining pods.

3. Ghost attendees: Swimmers who dropped out or paused payments keep showing up because deck coaches assume the front desk handled tuition. Soljio prevents this by keeping programs, schedules, rosters, families, and progress in one workspace, tying deck attendance lists directly to active enrollment status.

Review your discrepancy log at the end of each month. If sixty percent of your errors come from verbal makeup agreements at your leased community pool, retrain staff at that location.

Conclusion

Disciplined multi-location swim school roster management protects student safety and preserves your profit margins. Running this seven-step reconciliation checklist every Thursday and Friday keeps your fixed pools organized. But managing multiple spreadsheets, email threads, and paper clipboards eventually caps your growth.

Soljio offers swim school software built for independent swim schools, multi-location lesson programs, and club learn-to-swim divisions. At $149 per month for up to 500 active students, Soljio lets you import existing rosters directly from a spreadsheet. Families enroll and pay on your school's own subdomain, while instructors take attendance and track skill progress from the deck. Apply to join our private beta today.