Is a spreadsheet enough to run a rental business?

As long as one person takes every booking and hands over every vehicle, a spreadsheet does the job. It costs nothing to run. It starts costing money with the first mistake it lets through: two bookings for the same vehicle, a scratch nobody recorded at pickup, a deposit nobody took. All three become more likely once a second person enters bookings in the same file. Whether a rental business needs software depends more on how many people enter bookings than on fleet size.

What the spreadsheet gets right

Google Sheets is free, and a company already paying for Microsoft 365 pays nothing extra for Excel. A sheet can have any column the owner wants. Whoever built it needs no training. Rental software has to be set up, and staff have to be talked into using it. A subscription is a fixed cost, billed in the off season too.

When one person does all of it, the spreadsheet wins. The owner's memory checks what the sheet cannot, and as long as that memory holds, there is nothing for software to fix.

Where it goes wrong

A spreadsheet stores what is typed into it and checks none of it. It will not notice that two rows contradict each other or that someone skipped a column.

Two bookings, one vehicle

A sheet will take two rows for the same van on the same weekend without flagging it. With one person taking bookings, memory catches the clash. With two, bad timing is enough: one takes a booking by phone while the other takes one by email. A copy on a laptop can also be half a day behind one on a phone. At worst the clash surfaces at pickup, with two customers at the counter holding confirmations for the same vehicle.

On a software review site, a wedding decor rental owner describes working from a spreadsheet and a separate calendar, with enquiries arriving by email and Instagram. The owner was never sure a second wedding on the same weekend would fit. In a review of a bike rental shop in New York, a customer writes that their group prepaid for two tricycles through a tour marketplace, but the shop had only one and it was already out with another customer. They waited an hour for a substitute.

Booking software that checks availability before saving will refuse the second booking, whether it comes from the phone, the website or a colleague.

Disputes over damage

The sheet knows the dates, the vehicle and the price. The vehicle's condition at pickup is recorded somewhere else: on a paper form in a binder, in the camera roll of whoever handed the vehicle over, sometimes nowhere at all. When a scratch turns up on a door at return, what happens next depends on what the business can show. A form with no time on it proves little, and photos on an off-duty employee's phone are out of reach.

A useful record has the time of pickup, photos attached to the booking and the customer's signature under the condition notes. A spreadsheet can hold the time. The photos and the signature sit elsewhere and have to be dug out.

Deposits nobody tracks

In a sheet, the deposit is a number in a column. The column does not say who took the money, in what form, or whether any of it was kept at return. Anyone with access can overwrite it, and version history only helps someone who already knows what to look for. A deposit that was never taken comes to light at return, which is exactly when there is missing fuel or damage to pay for.

A second person matters more than fleet size

The usual rule of thumb sorts rental businesses by fleet size: a spreadsheet at five cars, software at twenty. Fleet size sets the subscription price, but risk depends on how many people and channels feed bookings into one file.

An owner with twelve cars who takes every call and hands over every car can run a spreadsheet for years without a single clash. A business with four campers, where the owner, a business partner and a website form all take bookings, has three sources of bookings and one file that checks none of them.

Even the smallest business gets a second user in the end, if only for a week. When the owner falls ill in peak season, whoever stands in inherits a file whose rules exist only in the owner's head: which colour means the deposit is paid, which rows are provisional and which are confirmed.

A spreadsheet stops being enough when any one of these is true:

• a second person enters bookings;
• bookings arrive through more than one channel, such as the phone, email and a website;
• returns involve charges for fuel, kilometres or missing items.

The cost of one lost booking

OneRental publishes this article, and the prices below are its own. The Starter plan costs €29 a month, or €23 a month billed yearly, for up to five units. Growth, for up to 25 units, costs €89 a month. All prices exclude VAT.

Say a vehicle rents for €100 a day, excluding VAT, and is booked for three days. That booking brings in €300. If two bookings land on the same vehicle and there is no spare, one of them is lost along with the whole amount. That is more than ten months of Starter, or more than three months of Growth.

The €300 is revenue, not profit. The comparison also holds only where clashes happen: a business that has gone three seasons without a double booking gains nothing from a subscription.

When a spreadsheet is enough

A business with one person taking bookings, one channel and no return charges does not need booking software, and a subscription would be money spent on a problem it does not have. Such a business may be a small owner-run fleet, or a larger one whose owner still takes every booking and keeps the schedule in their head.

Making a spreadsheet safer

For a business staying with a spreadsheet, a few habits lower the risk of double bookings, damage disputes and lost deposits:

1. One file in the cloud, with no copies on a laptop or a phone. Every copy is a separate version of the schedule.
2. One row per booking, with a booking number, the vehicle, the date and time of pickup and return, and the name of whoever took the booking.
3. A conditional formatting rule that highlights clashes. COUNTIFS works in both Excel and Google Sheets: for each row it counts bookings for the same vehicle that start before this one ends and end after it starts. Any result above one is a clash.
4. Three columns for the deposit: the amount, who took it and how, and what happened to it at return.
5. Pickup photos in a folder named after the booking number.

The rule in point 3 flags a double booking only after the second one is in the sheet. Booking software refuses it at the moment of saving.