Moving from spreadsheets and forms to a booking system

The setup that got you here

Almost every camp starts the same way: a free form tool collects the bookings, a payment link or bank transfer takes the money, and a spreadsheet ties the two together. It is cheap, it is quick, and for the first camp it works. The organiser is the integration layer — copying, matching, reminding, counting — and for twenty bookings that is an evening's work.

It stops working somewhere between the second camp and the second hundred families. The signs are familiar: a column called 'Paid?' that is never quite right; the same child booked twice; a camp that oversold because two families submitted the form within a minute of each other; a medical note that lived in a form response nobody opened; a parent asking what data you hold and a week spent finding out.

What a booking system actually changes

A booking system is not a nicer form. The difference is that the booking, the place, the payment and the person are one record rather than four, and the system does the things you have been doing by hand.

• Inventory is real. The last place can only be sold once, because the check and the booking happen together. Per-day places stop one full day overselling.
• Payment is attached to the booking. A card payment confirms it; a bank transfer with a unique reference matches it; the balance is one number you never type.
• Deadlines enforce themselves. Unpaid holds expire, reminders go out, and the freed place goes to the waitlist.
• The register is built from the bookings. Medical notes and collection details are where the desk needs them, not in a form export.
• Families have an account. They can see their bookings, reply to a message, and download or erase their own data.

What to look for

Most comparisons focus on features and price. For a camp organiser the questions that matter are narrower, and they are about the morning of the camp and the end of the season.

• Does it hold a place while a family fills in the form, and release it if they walk away?
• Can families pay by card and by bank transfer, with instalments for longer camps, and does each rail land in the same ledger?
• Is there a register you can run from a phone at the door, with medical flags and a sign-out that records who collected whom?
• Can coaches see the safety roster for their camp without seeing bank details or other camps?
• Can you answer 'what do you hold about my child?' with an export, and 'delete it' with an erasure that leaves your accounts intact?
• Is the pricing honest? Per-booking commission grows with your success; a flat plan or a free tier you can run a real camp on is easier to reason about.
• Is it built for the UK: bank transfer as a first-class rail, sterling, UK data protection, DBS tracking?

Moving without losing anything

Switch between seasons, not in the middle of one. A camp that has already sold places on the old system should finish on the old system; the next camp is the one that goes live on the new one. That keeps every family's booking, reference and payment in one place for the life of that camp.

For the families themselves, you do not need to migrate a database. Their next booking creates their contact on the new system, with their children and consents captured fresh. That is also the moment to ask properly for marketing consent if you never did, rather than importing a list you are not sure you are allowed to use.

• Publish the new camp page early and send it to last season's opted-in families first.
• Rebuild your booking form deliberately: drop every question you never acted on.
• Put your bank details and payment deadline into the system once, so references are issued automatically.
• Run one camp end to end — bookings, desk, reviews — before moving everything else.
• When the old season's retention period passes, delete the old spreadsheets and form responses. That is personal data too.

The first camp on the new system

Expect to spend about as long setting up the first camp as you would have spent building the form, and noticeably less the second time. Preview the camp page on a phone, because that is where most families will see it. Make a test booking yourself and check the confirmation email, the payment instructions and the pass. On the day, have the printed register as a backup and use the phone for the real thing.

By the end of the first camp you will have a list of things you used to do by hand that have simply stopped being tasks. That list is the real return on the switch.

If you are not ready yet

Some organisers genuinely are fine on a spreadsheet: one camp a year, thirty families, bank transfer only. If that is you, the two cheapest improvements are a unique reference on every booking so transfers match, and a separate, locked-down place for medical notes. The rest of this series — the Saturday-morning checklist, the payments guide, the safeguarding guide — applies whichever tools you use.

When the second camp appears on the calendar, come back. FormSide's product page shows the whole flow, and a free account lets you publish a camp page without entering a card.