Every week we talk to rent a car companies that have been using the same Excel spreadsheet for 10, 15 or 20 years. The conversation always starts the same way: "It works, so why change?".
It works, but it costs you money. More than you think. And it's not because of the tool itself — it's because of everything the tool doesn't do for you. Let's put some numbers on it.
What you can measure easily: lost hours
A typical week in a rent a car business with a fleet of 25 vehicles, a single office and two employees:
- Creating contracts by hand (Word + data copied from Excel): 12 contracts × 8 minutes = 96 minutes/week.
- Balancing the cash register at the end of the day (the day's payments against Excel): 6 days × 25 minutes = 150 minutes/week.
- Looking up a returning customer (no database, so you have to open several sheets): 8 searches × 5 minutes = 40 minutes/week.
- Generating a company's monthly invoice (gathering the month's contracts by hand): 1 hour.
- Calculating the quarter's IGIC with your advisor: 4 hours/quarter = approx. 60 minutes/month prorated.
- Checking which vehicles are due for their ITV soon (manual Excel sheet): 30 minutes/week.
- Fixing mistakes (wrongly copied data, overwritten sheets, broken formulas): at least 1 hour/week.
Total: ~7 hours a week lost on tasks that software handles on its own. Multiplied by 50 weeks a year = 350 hours/year. If that hour is worth €15 (employee salary cost), that's €5,250 a year thrown away on admin work that no customer pays for.
What's hardest to measure: costly mistakes
There are no hard statistics here, but the whole industry knows them:
- An invoice with incorrectly calculated IGIC that you have to correct three weeks later.
- A contract charged twice because employee A didn't see that employee B had already processed the payment.
- A vehicle booked twice because two employees were looking at different Excel files.
- An expired insurance policy discovered during a Guardia Civil inspection.
- A fine from the tax authorities for irregularities in your quarterly invoicing.
Each of these mistakes costs between €50 and €2,000 depending on the case. The chance of none of them happening in a year is practically zero. Count on 2-3 incidents a year.
What nobody measures: the customer who doesn't come back
This is the invisible cost. A customer who comes to pick up their car and has to wait 15 minutes because "we're printing the contract" doesn't come back. And they won't tell you why.
With software:
- The contract is generated in 30 seconds.
- The invoice reaches them automatically by email.
- Next time they come back, their details are already on file and they only need to confirm.
With Excel:
- You write the contract yourself by copying and pasting data.
- You create the invoice by hand in another program.
- Next time, you ask them for their details all over again.
How many repeat customers do you lose each year because of this? If you lose 3 corporate customers worth €2,000 a year each, that's €6,000 that never comes in.
The total: €12,000 a year
Adding up the three blocks:
- Hours lost on admin: ~€5,250/year
- Mistakes and corrections: ~€1,500/year
- Lost repeat customers: ~€6,000/year
Estimated total: €12,000 a year that Excel is costing you without showing up in any line of your accounts.
The most expensive software on the market for a 25-vehicle fleet costs less than €1,000 a year. The investment pays for itself in less than a month.
What you gain on day 1
We're not going to sell you smoke and mirrors: the first month with software also takes work. You have to add vehicles, set up rates, import customers. But from day 30 on, you win back those 7 hours every week.
And by the end of the year:
- Cash close-outs in 5 minutes instead of 25.
- Correct invoices with no need to redo them.
- Automatic alerts for ITV and insurance 30 days before they expire.
- See which cars are free today and next week at a glance.
- The modelo 420 fills itself in from the software's report.
What to do tomorrow
Try car-rent.es free for 14 days. No card required. Add your fleet and create three test contracts. If after a week you're not convinced, you walk away and nothing happens.
The hard part isn't choosing software. The hard part is deciding to stop losing money.