Key takeaways
- Prepaid tuition is kept separate from earned income.
- Every week labels its own fill level.
- Daily ratios are checked, not remembered.
- No health or allergy records are stored.
Birchwood Day Camp sells five themed weeks and collects most of the money in the first fortnight of August. The account looks strong, but two of those weeks have not run yet, one family owes for two weeks and camp has never been out, and nobody wrote down the two mornings in week one when a counselor called out. CampDesk US records the enrollment, the shift and the head count once, and keeps no health records at all.
Tuition you have not earned
Every enrollment records the session, the camper, the family and any discount, so the tuition due, the amount paid and the balance all derive on the row rather than living in a deposit spreadsheet.
Money collected for a week that has not finished is carried separately as unearned tuition, so the owner can see which part of the bank balance is still an obligation to deliver camp.
Full weeks and thin weeks
Each session counts its enrolled campers against its capacity and labels itself Full, Nearly full, Under-enrolled or Empty, so a week that needs a push is visible while there is still time to fill it.
A waitlisted camper stays on the register owing nothing, ready to be moved into the next week, and a cancellation releases the seat without leaving a phantom balance behind it.
The ratio, day by day
Counselor shifts are logged per week, and each day's record carries the head count and how many counselors were out. Campers per counselor derives from that and is checked against the ratio limit you set.
The days that read Over ratio are the ones a parent will ask about later, and they are usually the days someone called out rather than the days the camp was oversold.
What a week actually keeps
Session margin is tuition due less the counselor shifts logged to that week and the supplies drawn for it, so craft kits, shirts and snacks land on the week that used them.
A week still running reads In progress rather than a margin, because a half-costed week always looks profitable, and the dashboard totals only the weeks that have finished, so the season figure is never flattered.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
CampDesk US Private Google Sheets Web App is designed for use with a Google account, Google Sheets, and Apps Script, using owner-only deployment by default.
No medical, health or allergy records of any kind, no medication, incident or injury logs, no state child care licensing or ratio filing, no payroll or contractor tax filing, and no online registration portal or card processing.

