The situation
A tour company run from one shared spreadsheet
Bookings, bike allocation, hotels, payments and rider details lived in a Google Sheet, with a calendar tab, free-text notes and passport details copied in from emails. Quotes were written by hand in emails, so every price was retyped and nothing tied a quote to the booking it became.
Nothing in the sheet stopped a bike being double-booked, showed which balances were still owed after a trip ended, or flagged when a bike was due for service.
01 · Planning
A ride planned and priced live, before anyone enquires
BeforeEvery price was a reply to an email, typed by hand.
NowThe website planner reads prices, dates and bike availability live from the operations database. Each rider picks a bike and sees their own line; the group total, deposit and balance dates update as they go. The website cannot quote something the business is not selling.
romaniamotorcycletours.com
Two riders, a guided tour, a bike each, priced liveThe planner on a phone
02 · Choosing a bike
Thirteen models narrowed to the right one, with the reason
BeforeWhich bike suited a rider was a judgement call in an email thread.
NowHeight, licence, two-up riding, luggage, range and surface are checked against the workshop’s data for each model, and every verdict says why. Range is compared with the tour’s longest day.
romaniamotorcycletours.com
The bike selector, matched against workshop data03 · Tours
Every riding day drawn to scale, from the same data that runs the trip
BeforeItineraries were prose, and hotels were booked from memory.
NowTours are broken into days, each with a route and a default hotel for every night. The website shows distance and riding hours as charts rather than a map, and route detail stays inside operations. When a quote is accepted, hotel nights are pre-filled from the tour’s defaults.
romaniamotorcycletours.com
A seven-day tour, day by day04 · Quoting
A whole group priced in one function, with the rates frozen per quote
BeforeA multi-rider quote took an afternoon and a calculator.
NowRiders, bikes, rooms, gear, pillions, transfers, hotel nights, guide and organisation fees, and length and season discounts are priced by one pure function with tests, discounts capped so they cannot stack. Each quote keeps its own copy of the rates, and any change carries a one-line reason, so a rate-card change never moves a price already sent.
05 · Accepting
The rider accepts, and the booking builds itself
BeforeAn accepted quote was retyped into the sheet as a booking, then hotels and payments were added by hand.
NowThe proposal page is reached by a private link. Accepting creates the booking, bike lines, hotel nights and payment requests: a 30% advance and a balance due 30 days before the start. Bank details appear only after acceptance.
06 · The fleet
62 bikes, ten weeks, one view that flags the clash
BeforeDouble bookings were found when two riders turned up for one bike.
NowThe fleet calendar reads bookings and service blocks together. Warnings flag double bookings, unavailable bikes and riders arriving without a bike. Cleaning and prep jobs are created automatically around every pick-up and return, carrying the rider’s chosen setup as a checklist.
romaniamotorcycletours.com
62 bikes down the side, ten weeks across: free, out, booked, held or blocked07 · Prep
A clean and check created for every bike before every pick-up
BeforeBikes were prepared from memory, and a missed one was found by the rider.
NowEvery pick-up and return creates its cleaning and prep job, with a nine-item checklist and the rider’s chosen setup. Jobs roll to the next day if missed and feed the morning fleet digest.
romaniamotorcycletours.com
Fleet jobs: 140 due, each with its checklist and next pick-up08 · The morning
Each role sees what needs attention, and only what it should
BeforeEveryone looked at the same sheet and hoped.
NowThe Today board lists new enquiries, unanswered riders, expiring quotes, payments to chase, arrivals and who is on the road. Each panel is a database view filtered by the signed-in person’s role. Five roles, enforced in the database by row-level security, not in the app.
The Today board on a phone: what needs attention 09 · Money
Balances that cannot drop off the list
BeforeFinished trips with money still owed disappeared from view.
NowPayment requests carry due dates and reminders, recorded payments match themselves to requests, and a Money owed screen catches finished trips that still show a balance.
Bookings from hold to confirmed, with what is dueMoney to chase, ranked by how overdue
What changed
Database, office app and website in about seven weeks
The operations database came first, from 5 September, kept in step with the spreadsheet by a nightly Claude agent that read the sheet and wrote changes into the database.
When the first app’s source code was lost, it was rebuilt screen by screen as the office app in six days. The public website and booking funnel followed on the same database. Every screen was tested against live data: 73 places where a failed query showed an empty screen now show an error. The database, roles and scheduled jobs are live. The website and office app are complete and waiting for the business to cut over from the sheet.
romaniamotorcycletours.com
Sheet sync: every problem the spreadsheet never raised, in one list