Operations · 6 min read
Running a rental business on spreadsheets: what it really costs
14 July 2026
Almost every hire business starts in a spreadsheet, and there is nothing wrong with that. A single counter, forty items and one person who remembers everything does not need software. The trouble is that the spreadsheet does not tell you when you have outgrown it. It just quietly starts costing money.
1. Double bookings
A spreadsheet stores a number, not a unit. It says you have three breakers, but not which three, nor that one has been in the workshop since Tuesday. The moment two people take bookings — or one person takes a booking while the file is open on another machine — you are exposed.
The cost is rarely the lost hire. It is the customer who drove forty miles for a machine that was not there, and who now hires from your competitor permanently.
2. Deposits that go missing
Deposits are the easiest money in the business to lose track of, because they are not revenue and they are not yours. In a spreadsheet they end up in a column that nobody reconciles. Six months later you cannot say how much you are holding, and neither can your accountant.
3. Damage nobody can prove
Without a photograph taken at handover and another at return, every damage claim becomes an argument you will probably lose. Most operators stop trying to charge for damage altogether, which means the repair cost silently moves onto your margin.
4. Machines you cannot rank
The most expensive gap is the one you never notice. Without revenue and repair spend recorded per unit, you cannot tell which machines earn and which quietly lose. So the fleet grows by instinct: you buy more of whatever you happened to buy last time.
- Utilisation per item — how many days it was actually out
- Revenue per item — what it earned in that time
- Repair spend per item — what it cost to keep running
- Age and purchase price — whether it has paid for itself yet
Four numbers. If your spreadsheet cannot produce them for a specific serial number in under a minute, it is no longer telling you how the business is doing.
When to move
The honest trigger is not a size. It is the second person. As soon as more than one human takes bookings, the spreadsheet stops being a record and becomes a guess. Everything above follows from that.