The spreadsheet that's running your business
You built it at 11pm because there was nothing else. It started as a simple job list. Now it has tabs for costs, staff, invoices, and three different versions because you weren't sure which one was current. It works - mostly - but it costs you more than you realise.
Sign 1: You're the only person who knows how it works
If you were hit by a bus tomorrow, could your team run the business from your spreadsheet? If the honest answer is no, you have a single point of failure and it's you.
A spreadsheet that only one person understands isn't a system. It's a liability dressed up as one.
Sign 2: Two people can't edit it at the same time
The moment you have more than one person maintaining a spreadsheet, you have version control problems. Who has the latest one? Did Sharon's updates get saved? Why does mine show 47 jobs and yours shows 49?
This isn't a minor inconvenience. It means decisions get made on wrong data.
Sign 3: Your invoices don't match your costs
Materials logged in a spreadsheet have to be manually transferred to an invoice. Steps between logging and invoicing mean things get missed. UK contractors typically absorb £200–500 per month in costs that never make it onto an invoice because there's no automatic link between cost records and invoice generation.
Sign 4: You can't answer basic questions in under 30 seconds
How much did you invoice last month? What's your average job margin? Which engineer completes the most jobs per week? Which client has the most outstanding balance?
If answering any of these requires opening the spreadsheet, doing a SUMIF, and hoping the data is current, your reporting is broken. A business running on good data can answer these questions instantly.
Sign 5: Your admin takes a full day every week
If you're spending Friday afternoon reconciling the spreadsheet, chasing cost logs from engineers, and manually building invoices, you're spending 8–10 hours a week on admin that a proper system would do automatically. At £35/hour fully-loaded, that's £18,000 a year in time you could be spending on the business.
What to do instead
The answer isn't a more complicated spreadsheet. It's a system where jobs flow from creation → assignment → field updates → cost logging → invoice without manual intervention at each step.
You don't have to migrate everything. Start fresh with your next job. Add clients and properties as they come up. Within a month, your spreadsheet becomes the thing you occasionally reference for historical data rather than the thing running your business.