aimpl
← All work

Romania Motorcycle Tours

Motorcycle rental and guided tours · Romania

  • Trip planner
  • Quote generator
  • Fleet calendar
  • Rider portal

One spreadsheet became a business system.

Romania Motorcycle Tours ran 62 motorcycles, bookings and maintenance from a shared spreadsheet. aimpl replaced it with a database, an office app and a booking website.

  • Quote to booking, no retypingA website enquiry becomes a quote, then a booking, in the same record
  • Fleet under controlHand-overs, odometers, service and expenses per bike
  • The day at a glanceA Today board on the phone shows what needs attention
romaniamotorcycletours.comThe new Romania Motorcycle Tours website
The new Romania Motorcycle Tours websiteComplete on staging, waiting on cut-over
BusinessMotorcycle rental and guided tours, Romania
BuiltAbout 7 weeks, September to October 2026
StatusDatabase live. Website and office app ready for cut-over
Core stackNext.js, Supabase, Payload CMS, Vercel, Claude
The story
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.comTwo riders, a guided tour, a bike each, priced live
The planner on a phone
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.comThe bike selector, matched against workshop data
The bike selector, matched against workshop data
03 · 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.comA seven-day tour, day by day
A seven-day tour, day by day
04 · 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.com62 bikes down the side, ten weeks across: free, out, booked, held or blocked
62 bikes down the side, ten weeks across: free, out, booked, held or blocked
07 · 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.comFleet jobs: 140 due, each with its checklist and next pick-up
Fleet jobs: 140 due, each with its checklist and next pick-up
08 · 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
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
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.comSheet sync: every problem the spreadsheet never raised, in one list
Sheet sync: every problem the spreadsheet never raised, in one list
21 functions, each with the screen it runs on
romaniamotorcycletours.comTwo riders, a guided tour and a bike each, priced liveThe same planner on a phone
01 · Sales

A ride planned and priced before anyone enquires

A step-by-step website planner that builds a ride and shows a live price for the whole group.

Prices, dates and bike availability are read live from the operations database, so the website can’t quote something the business isn’t selling. Each rider’s line updates as bikes are chosen, with the deposit and balance dates shown before anyone gets in touch.

romaniamotorcycletours.comThe bike selector, matched against workshop data
02 · Sales

The right bike, with the reason why

A few questions narrow 13 models down to the bikes that suit the rider.

Height, engine size, solo or two-up, luggage, range and surface are checked against the workshop’s numbers for each model, and every verdict says why: flat-foot at 175 cm, for example.

romaniamotorcycletours.comA 7-day tour, day by day
03 · Operations

Every riding day drawn to scale

Tours are broken into days, each with a route and a default hotel for every night.

Tour pages show distance, riding hours and the big days as charts rather than a map, from the same day-by-day data that pre-fills hotel nights when a quote is accepted. Route detail stays inside operations.

The detail

A whole group trip priced in one go

Several riders, each on their own bike with their own gear, pillions, single or shared rooms, transfers, hotel nights, guide and organisation fees, and length and season discounts. The pricing is one pure function: configuration and rates in, priced lines out, covered by tests, with discounts capped so they can’t stack beyond what the rate card allows.

Each quote keeps its own copy of the rates, and any change carries a one-line reason. Changing the rate card never moves a price already sent, and the quote shows exactly where it differs from the standard rates.

Also built

18 more functions, grouped by the part of the business they serve.

Sales
Quote generator
Drafts a quote from the rate card, lets staff adjust any figure, and sends a proposal link.
How it works

Prices riders, bikes, rooms, gear, pillions, transfers, hotels and guide options in one function.

Sales
Proposal page
The rider’s view of a quote: accept, ask a question, request a change or decline.
How it works

Reached by a private link. Accepting creates the booking, bike lines, hotel nights and payment requests.

Sales
Group trips
One organiser shares a link, and each rider picks a bike and room and sees their own price.
How it works

Seats are tracked per rider. The owner controls group discount, room pairing and whether one person pays for everyone.

Operations
Today board
The morning screen: new enquiries, unanswered riders, expiring quotes, payments to chase, arrivals and who is on the road.
How it works

Each panel is a database view filtered by the signed-in person’s role.

Operations
Bookings and trips
Each booking from confirmed to returned: riders, dates, bikes, hotels, messages and change requests.
How it works

A nightly job advances booking statuses and lists held bookings whose dates have passed.

Operations
Operations scheduling
Cleaning and prep jobs created automatically around every pick-up and return.
How it works

Jobs carry the rider’s chosen bike setup as a checklist and roll to the next day if missed.

Operations
Rider portal
Trip status, a preparation checklist, bike setup, messages, flights and change requests.
How it works

Row-level security limits each rider to their own rows.

Fleet
Fleet calendar
Every bike down the side and ten weeks across the top: free, out, booked, held or blocked.
How it works

Warnings flag double bookings, unavailable bikes and riders arriving without a bike.

Fleet
Maintenance scheduling
Forecasts services due per bike and suggests free workshop windows.
How it works

Learns each bike’s daily kilometres from hand-over odometer readings and checks inspection expiry dates.

Fleet
Hand-overs
Guided photos, kilometres, a damage diagram and the licence at pick-up and return.
How it works

Before and after photo sets sit side by side.

Finance
Payments
Deposit and balance requests with due dates and reminders.
How it works

The standard plan is a 30% advance and a balance due 30 days before the start. Recorded payments match themselves to requests.

Finance
Money owed
Finished trips that still show a balance.
How it works

Catches bookings that dropped off the unpaid list once marked complete.

Finance
Rate card
The prices every quote starts from, plus the cost side used for margin.
How it works

Each quote keeps its own copy, so a rate change never moves a price already sent.

Systems
Roles and permissions
Five roles, each with view or edit rights per area.
How it works

Enforced in the database by a permission check inside row-level security policies, not in the app.

Systems
Website security boundary
The public website reads prices and submits enquiries without access to any table.
How it works

The public key can only call a fixed list of functions with explicit columns, so route detail is unreachable by construction.

Systems
Scheduled jobs
Booking statuses, enquiry hold and quote expiry, maintenance sync and the fleet digest.
How it works

Eight jobs run inside the database, with secrets held in a vault.

Systems
Website CMS
Staff edit words, photos, page sections and search settings.
How it works

Prices and dates always come live from operations, never from the CMS.

AI
Nightly sheet sync agent
A scheduled Claude agent that read the spreadsheet each night and wrote changes into the database.
How it works

Pulled bookings, calendar notes and rider notes out of free text, and raised warnings for anything it couldn’t place.

Built, waiting on cut-over

The database, roles and scheduled jobs are live. These are built and tested against live data, waiting for the business to move off the spreadsheet.

Public website
Complete on staging, with planner, bike chooser and proposal pages.
Office app
Deployed, waiting on its own domain before staff sign in.
Go-live guide
47 steps inside the app, about half of which tick themselves when the database sees the gap has closed.

Under the hood

62motorcycles managed
50database tables
8automated jobs
102 database functions176 row-level security policies248 website tests117 hotels on file

How it was built

The operations database came first, from 5 September, with a phone-first staff app and a rider portal on top. A nightly sync kept it in step with the spreadsheet, so it held real data while the office carried on as normal.

When the first app’s source code was lost, it was rebuilt screen by screen as the office app in six days, then the public website and booking funnel were built on the same database. Every screen was tested against the live data. What changed:

  • 73 places where a failed query showed an empty screen now show an error.
  • The trip prep editor saves again after a database change had dropped two columns.
  • A Money owed screen was added after finding finished trips with balances no screen showed.
  • Negotiated quote figures no longer reset to the rate card when the rates panel closes.
  • The morning digest secret moved into the vault after two copies drifted apart.