Five signs your HR spreadsheet has become a liability
Spreadsheets run plenty of good companies — until they do not. Here is how to tell when yours has crossed the line, and what to fix first.
There is nothing wrong with running HR on a spreadsheet. Plenty of profitable companies do it for years. The problem is that the moment it stops working is not obvious — the file keeps opening, the formulas keep calculating, and the trouble only shows up when somebody asks a question you cannot answer.
Here are the five signs, in the order they usually appear.
1. Only one person can answer questions about it
Every spreadsheet develops a keeper. They know which tab is current, which column is a formula and which was pasted over, and why the leave balance for one employee is hard-coded. When that person is on leave, HR stops. When they leave the company, you inherit a file nobody can safely change.
2. Two numbers for the same thing
Headcount in the HR file, headcount in the payroll file, headcount in whatever the finance team keeps. They agreed once. Now they are within a few of each other and nobody knows which is right, so everybody quietly uses their own.
This is the expensive one, because it does not look like a problem until you are reconciling something under time pressure.
3. You cannot answer "who changed this, and when"
An employee says their salary should have gone up in March. The spreadsheet says what it says today. There is no history, no note, and no way to tell whether the increase was missed or never agreed. Whatever the truth is, you are now negotiating from a weak position.
4. Everyone can see everything
A single file with everyone's salary in it is one accidental share away from being company-wide news. Passwords on files are not access control — they are one password, known by everybody who has ever needed it.
5. The month-end scramble has become normal
Chasing timesheets, re-checking overtime, fixing the same three formulas, and finishing late. Once a scramble is normal, nobody flags it — which means nobody fixes it, and the next hire makes it worse rather than better.
What to fix first
Not everything. In order:
The employee record. One place that holds who works here, on what terms, since when. Everything else references it, so fixing it first makes the rest easier.
Leave. It is the most-asked question and the hardest to reconstruct after the fact. Move it before you need a year of history you no longer have.
Payroll. Once records and leave are trustworthy, payroll stops being a rebuild every month and becomes a review.
Documents. Visa and ID expiry dates are worth tracking the moment somebody has to renew one urgently.
You do not have to do it all at once, and you should not. Move the employee record, run one month in parallel, and go from there.