From Spreadsheets to a Single System
Context
When Kerstin Klier and her husband Zdeněk Štybar launched 54-11 Bikeholiday in Mallorca in 2016, they entered a mature and highly competitive cycling rental market. As Kerstin describes it, “It was already a shark pool.” Success was never going to come from novelty. It came from operational discipline.
Every bike was prepared to the same mechanical standard, regardless of price tier. Enquiries were handled quickly, and staff were knowledgeable and customer focused. The business built its reputation on reliability and service rather than price competition.
In the early years, the company operated from a single location and tracked its fleet in an Excel workbook, and for a single store, this worked.
Kerstin knew the bikes, understood the booking cycles, and could hold most of the operation in her head. The spreadsheet was a support tool, not the engine of the business.
That changed when they opened a second location in Alcudia.
The Operational Constraint
This expansion increased commercial opportunity, but it also introduced a coordination problem.
One fleet now served two physical locations as bikes moved between Palma and Alcudia. Repairs were handled locally, and returns didn’t always follow to schedule. The spreadsheet needed to reflect transfers, workshop status, and availability across both sites.
In theory, being disciplined and with everything kept up to date this shoestring model should work. But in practice, peak season in Mallorca is busy, with nearly seventy percent of annual demand arriving within March and April. During these busy periods, staff priorities focus on fitting customers and preparing bikes, so updating a spreadsheet inevitably becomes secondary.
As a result, availability shown on the spreadsheet lagged behind reality. A bike transferred between locations might still appear in the previous shop. A bike returned early could remain blocked for days. A bike in the workshop could appear rentable.
None of this meant the business was failing, it simply meant the system was no longer scaling.
If this stage feels familiar, where operations begin to feel more complicated than they should, it’s often an early sign that coordination has outgrown manual tools. That’s explored in more depth in When Bike Rental Operations Start to Feel Unnecessarily Complicated, which looks at how complexity quietly accumulates as rental businesses grow.
The Cost of Staying the Same
Continuing in this way created breakpoints that were easy to tolerate in the short term but were inevitably going to cause problems over time.
The first cost was time. Kerstin found herself increasingly absorbed in administrative oversight. She was converting email enquiries, managing group bookings of ten to fifty riders, overseeing hotel partnerships, and coordinating logistics between two sites.
The second cost was online booking, because availability wasn’t reliably live, the business couldn’t confidently allow customers to book and pay online against real-time stock. So, displaying inventory was possible; guaranteeing its availability was not. This meant missing customers who expected immediate confirmation, particularly international visitors planning ahead.
If your team is still manually confirming availability before approving bookings, the structural limitation is rarely poor decision making, it’s usually a lack of visibility. For a closer look at how live availability changes booking confidence, you can explore How Good Rental Shops Know Exactly Which Bikes to Prepare Every Day, which breaks down the operational shift behind that clarity.
The third cost was utilisation insight. Fleet investment decisions were based largely on experience rather than structured reporting. It was difficult to clearly see which bikes were generating the strongest returns and which were underperforming.
Some bikes are constantly out while others sit idle, and without accurate reporting the pattern remains more anecdotal than fact. The dynamics behind that issue are unpacked further in Why Some Bikes Are Overworked While Others Sit Idle.
The business was growing, but its decision-making tools were not evolving with it.
What Changed
54-11 moved from spreadsheet-based coordination to Bike Rental Manager as the operational backbone across both store locations.
The change was structural and gave visibility of fleet movements across a live system. When a bike transferred between Palma and Alcudia, availability was updated immediately. When a bike entered the workshop, it was removed from rental stock in real time. Both locations operated from the same source of truth.
This removed the need for secondary verification before confirming bookings. Staff could answer customers immediately, without calling the other shop or checking storage areas.
Crucially, the company enabled online bookings against live availability. Customers could select a bike, choose a date and location, pay online, and receive confirmation instantly. Seasonal pricing applied automatically. Discount vouchers could be managed within the system to stimulate demand outside peak months.
If you’re exploring what a unified rental platform looks like in practice, especially across multiple categories, locations, and workflows you can view how the bike.rentl Manager platform structures fleet management, online booking, and reporting within a single system.
The Outcome
The switch to a purpose built all-in-one system produced measurable operational benefits.
Administrative load reduced significantly. Kerstin no longer needed to personally respond to every website enquiry because bookings could be completed automatically. Counter staff confirmed availability immediately rather than verifying it. Time previously spent checking information was redirected toward customer service and business development.
Online bookings increased because customers could secure bikes instantly. Younger riders and advance planners completed their bookings on mobile devices without waiting for manual confirmation. Seasonal pricing adjusted automatically without recalculation, protecting margins during high-demand periods.
Reporting also helped change management behaviour with new data available to make better business decisions. Location-specific demand patterns were clearer. Investment decisions could be based on measurable performance rather than intuition. Planning for expansion into a third location carried less uncertainty because the business could see how its fleet was performing.
As Kerstin explains, “The reports are really, really essential. To see what you can do better or what is already really good.”
The business became more predictable, more scalable, and less dependent on manual oversight.
Kerstin summarises it directly: “Bike Rental Manager is the vertebra of our business. The website together with the right software. Without that, you totally cannot manage the business.”
What This Means
54-11’s challenge wasn’t about demand; it was coordination against a backdrop of growth.
The spreadsheet that supported a single location became a bottleneck when the business expanded. Moving to a unified system did not change their service standards, but it did remove the challenges that prevented those service standards from scaling across locations.
For rental businesses experiencing similar pressure…rising admin, uneven utilisation, difficulty enabling online booking, or expansion across categories, the operational model matters more than incremental adjustments. Growth increases complexity, and manual coordination has limits.
If repeat bookings are growing but admin is growing faster, the issue is rarely marketing volume, it more often than not, structural efficiency. And if you are operating across bikes, skis, tours, multiple locations or services, fragmentation becomes a risk in itself. That is where a single operating platform changes the trajectory.
In 54-11’s case, availability became reliable. Bookings became immediate. Planning became measurable. Expansion became less risky.
That is what changed.
If your bike rental business is experiencing similar challenges, then you should read how bike.rent Manager can help remove these complexity and bring clarity to the chaos.
Free up time with bike rental Software – bike.rent Manager
