The honest cost of running HR in spreadsheets

I've spent more of my career inside HR spreadsheets than I'd like to admit. There's a moment, somewhere around the 80-employee mark, when "we'll just use Google Sheets for now" stops being clever and starts being expensive — but the cost is hidden, slow, and shows up in places nobody is measuring.

This is the math.

#The visible cost is zero. The invisible cost is brutal.

Spreadsheets feel free. There's no per-seat license, no procurement form, no SOC 2 questionnaire. You start with one tab, then a workbook, then a folder, and three years later you have what one head of People I spoke with called "the mausoleum" — fourteen interlinked sheets that exactly one person on the team understands.

The cost shows up in three places:

1. Time — hours the People team spend reconciling, updating, chasing.
2. Errors — the small mistakes that compound into big incidents.
3. Risk — the things you can't see until an audit, a lawsuit, or an exit reveals them.

Let's take each in turn, with real numbers from real teams.

#1. The time tax

The most measurable cost is hours. Across thirty conversations with HR leads at companies between 50 and 300 employees, here's what I keep hearing:

• Headcount reconciliation: 4–6 hours per week. Comparing payroll, the HRIS spreadsheet, the org chart, and the Slack workspace member list — and resolving the differences.
• Leave management: 6–10 hours per week at a 100-person company. Tracking requests, updating balances, sending Outlook invites, chasing approvers.
• Onboarding: 4 hours per new hire on average. Document collection, account creation, hardware allocation, welcome email.
• Payroll prep: 8–12 hours per cycle. Pulling attendance, leave, bonuses, and one-off adjustments from various sheets and emails.

Add it up. A 100-person company is spending 20–30 hours of People-team time per week on manual coordination that doesn't add value. At a fully-loaded cost of ~$60/hour, that's $60,000–$90,000 a year in pure overhead.

That's before you count the cost to managers — who are also spending hours per week filling out forms, signing PDFs, and forwarding emails.

Spreadsheets aren't free. They're a salary you're paying yourself to do the worst part of your job.

#2. The error tax

This one is harder to measure because most errors never get reported. But every team I talk to has war stories. A few patterns I've seen repeatedly:

• Ghost employees in payroll. Someone leaves, the offboarding checklist gets skipped, and they keep getting paid for one or two cycles. I know of a 180-person company where this happened to four people in one quarter.
• Phantom leave balances. Carry-forward rules are mis-applied. People discover they have negative balances at year-end. Someone has to absorb the cost.
• Benefits enrollment errors. People get added to the wrong plan, or missed entirely, and only discover it during a claim.
• Missing documents. ID proofs, address proofs, and signed contracts that should be in the file aren't, and nobody finds out until an audit or a visa application.

Each of these is a small fire. Together they consume an enormous amount of HR's time, and they compound trust debt with the rest of the business. The Finance team stops trusting your headcount. The CEO stops trusting your reports. New hires lose faith on day one.

#3. The risk tax

This is the one that keeps me up at night.

Spreadsheets have no audit trail. There's no record of who changed what, when, or why. If an HR Business Partner edits a salary three months ago and nobody notices, that change is now ground truth — even if it was wrong, even if it was unauthorized.

Specific risks:

• Privacy. PII (PAN numbers, bank details, addresses, salaries) sitting in a Google Sheet shared with twelve people is a data breach waiting to happen. Most companies have no policy on what should and shouldn't go in those sheets.
• Permissions. Spreadsheets have file-level permissions, not field-level. Either someone sees salary or they don't. There's no middle ground.
• Continuity. What happens when the one person who built the master sheet leaves? The institutional knowledge of how the workbook works leaves with them.

#"But our team is small. We don't need software."

I get this a lot. Here's the thing — the right time to move off spreadsheets is not when they finally break. It's about 18 months earlier.

By the time the spreadsheet visibly breaks (an audit finding, a payroll error, a missed offer letter), you've already accumulated:

• A backlog of cleanup work that takes weeks.
• A team that's lost trust in the data.
• A migration project that competes for attention with everything else on your plate.

Whereas if you switch when you have 60–100 employees, the migration is an afternoon. The data is mostly clean. There's no organizational memory to dislodge.

The ROI math, conservatively:

| Cost | Spreadsheets | A real HRMS | | ------------------------------------- | ------------ | ------------------- | | Software (100 employees) | $0 | $7,000/year | | People-team time recovered | — | ~$60,000/year | | Audit / compliance exposure | High | Logged, defensible | | Employee experience | Spreadsheet | Mobile self-service | | Time to first hire on new tool | Weeks | An afternoon |

Even with conservative assumptions, the payback period for any halfway-decent HRMS at the 100-employee mark is under three months.

#The qualitative cost is the one you'll really feel

Numbers aside, here's what I hear when I ask HR leaders what changed when they moved off spreadsheets:

• "I get my evenings back."
• "I stopped dreading payroll week."
• "My team trusts the data again."
• "I can finally answer the CEO's headcount question with one number, not three."

That last one comes up almost every time. The leadership team starts to trust HR more, because HR finally has a single source of truth to point to. And once that trust is back, HR gets pulled into more strategic work — instead of being seen as the team that owns the spreadsheet.

#What to do if you're stuck

If you're reading this and recognizing your own situation, here's what I'd do, in order:

1. Audit your spreadsheet sprawl. List every sheet, what it tracks, who owns it. Most teams find they have 12–20.
2. Pick one workflow to fix first. Onboarding is usually the highest-leverage. Leave is a close second.
3. Demo two or three tools. Don't agonize. Pick one that lets you migrate easily, has a real free trial, and has support that responds.
4. Migrate during a quiet week. January, October, or any week with no payroll cycle. A clean migration is an afternoon. A messy one is two weeks.

The hardest part is starting. But spreadsheets aren't the floor — they're the ceiling. They prevent you from doing the work you want to do.

Move off them. The cost of staying is much higher than you think.