When someone’s compensation is based on their performance rather than their tenure, job title, or organization-wide adjustments, HR teams need data. That performance data is scattered across projects, performance conversations, and 360 reviews, among other sources, which makes it difficult to gather when it’s time to adjust compensation. That’s made worse by the platform many organizations still use to manage pay: spreadsheets.
Spreadsheets create a gap between pay and performance data, which leads to errors, unfair decisions, and slower compensation review cycles. Here’s how that happens and what HR can do to fix it, including switching to dedicated performance management software instead of spreadsheets.
Key Takeaways
- Spreadsheets separate performance data from pay decisions.
- That gap makes fair, defensible merit decisions harder.
- Errors in comp spreadsheets carry real legal and financial risk.
- Manual cycles stretch from days into weeks.
- Connected performance and pay data makes decisions faster and fairer.
Why spreadsheets became the default for comp
Spreadsheets have several advantages. They’re familiar. They’re easy to use. They’re cheap. When a team is still relatively small, with few role codes and few signals to track for performance, these advantages far outweigh the drawbacks of using spreadsheets for managing compensation.
But they’re not only used by small orgs. According to Aeqium’s 2025 Compensation Planning Trends Report, 77% of companies still use spreadsheets to plan and manage compensation. They became the default because they’re often the default for most HR tasks, and they stayed the default because most of their drawbacks aren’t immediately obvious. Some are—like how long it takes to manually enter, validate, and update data—but most only show up when it’s too late to do anything about them or they’ve already made their impact.
Where spreadsheets break down for compensation
Spreadsheets add friction to performance-based pay at just about every step, but, in some cases, they can break down completely and cause serious issues.
They separate performance from pay
Performance-based pay requires performance data, and that data doesn’t live in spreadsheets used to manage compensation. It lives in performance management platforms, performance reviews, engagement surveys, and similar sources. A spreadsheet can’t pull from that data automatically and can’t make recommendations based on it. It inherently breaks the link between performance and pay that performance-based compensation tries to build.
This is the gap tools like 15Five are built to close; they surface performance signals from multiple sources in one platform so HR has better visibility into them when planning compensation.
They’re error-prone and the errors are costly
According to research published in IEEE Software, about 94% of spreadsheets contain faults, which a subsequent literature review in Frontiers of Computer Science attributes to the rise of end-user computing. Spreadsheets are no longer built exclusively by IT or software engineering professionals; HR teams build and manage them themselves.
This can lead to data entry, formula, and formatting errors that can have significant consequences. Even large banks like JPMorgan can make errors through spreadsheet use. In 2012, JPMorgan’s own review of a manually run spreadsheet risk model found it added two numbers where it should have averaged them, one of several failures behind the bank’s multibillion-dollar “London Whale” trading losses.
In compensation, errors aren’t just embarrassing or costly. They can create pay inequity and legal exposure. Imagine, for example, a formula error that allows junior hires to out-earn tenured staff. This can create inequity within the organization until the disparity is fixed. In states with pay transparency laws, this disparity might be exposed both inside and outside the organization, such as in a new job posting.
They don’t scale
Spreadsheets become less and less efficient as teams grow. As more role codes and seniority levels get added, compensation becomes increasingly complicated. As more people review and edit the same spreadsheet, new problems emerge. It takes weeks to approve a few changes, multiple copies of the same spreadsheet mean no one knows which version is up to date, and formulas can break when someone makes the wrong edit.
They make collaboration and security harder
The collaboration issues from using spreadsheets aren’t just about inefficiencies; there are also serious security risks. The more versions of a spreadsheet in circulation—as it’s passed among multiple stakeholders and leaders—the harder it gets to keep track of sensitive information. Spreadsheets sent by email can leak to employees or other parties.
Changes to specific rows can’t always be tracked, making it difficult to know which numbers are actually accurate. Spreading compensation around multiple versions of the same spreadsheet magnifies two risks: the data reaching the wrong people, and no one being sure it’s accurate.
What it costs to keep comp in spreadsheets
Many HR teams consider using spreadsheets a cheaper alternative to a dedicated compensation management solution. But even if spreadsheets don’t have a subscription cost that rivals a dedicated tool, they do have their own costs, and these costs pile up.
The first cost? A longer compensation review cycle, often measured in weeks rather than days. Because there’s such a gap between performance data and pay when using spreadsheets, compensation review involves hunting down that data across multiple platforms. That means every review feels like it takes significantly more work and time than it should, tempting many HR teams to lengthen the time between them. Compensation grows less and less competitive as that time gets longer.
The second cost is time. Specifically, the time HR and managers have to spend reconciling and validating performance data. It needs to be pulled from multiple sources and conflicting records have to be fixed. All that time spent on data collection wouldn’t be necessary if HR used a dedicated tool for managing performance-based compensation. It’s time that could go to other tasks and priorities, lost every time compensation needs to be reviewed.
Spreadsheets also make it difficult for pay decisions to truly tie back to performance. Even with hours spent collecting data, tying specific performance signals to compensation is time-intensive for most HR teams—unless they have dedicated data analysts. Even if an organization says it’s using performance-based pay, it’s hard to actually prove that.
This all funnels down to frustration between managers and their teams. When a team member has questions about changes to their compensation, managers can’t always give a clear reason why a certain number was decided on. That makes managers seem less credible and leaves teams frustrated because they can’t get a clear answer.
Connecting performance and pay is the real fix
The answer isn’t to just replace spreadsheets with a more expensive tool. Orgs need a tool that bridges the gap between performance data and pay. As an organization gets better at managing and tracking performance, that data needs to increasingly feed into compensation conversations, and the gaps caused by spreadsheets prevent that from happening.
Compensation decisions based on merit and objective performance data are easier to defend than those that aren’t. That helps an organization’s compensation structure reward top performers, and it gives everyone a clear pathway to improving their compensation.
Connecting performance and pay also brings another key advantage: consistency. That consistency is the foundation for better compensation decisions, which leads to stronger talent and better employee retention. A key part of that consistency is performance rating calibration.
Depending on the circumstances around a specific employee’s work, their performance rating might be arbitrarily different from that of someone doing the same quality work, only because they have a tougher manager. Connecting performance and pay requires building a framework for properly calibrating performance ratings. This keeps performance signals equitable across teams, ensuring everyone gets fair performance reviews and the result of these reviews manifests in more equitable pay.
What good performance-based pay looks like
When HR teams leave spreadsheets behind to look for a better solution, they should look for the following signals:
- Connected performance and pay: A connection that isn’t just theoretical, but is represented in the ways decisions are made and how they’re explained.
- Objective performance inputs: Too many performance conversations and compensation decisions are made with gut feelings and subjective parameters. Objective inputs, like the results of performance reviews and important projects, take priority over other signals.
- Clear view of total compensation: Spreadsheets aren’t the best platform for providing visibility into total compensation. Performance-based pay should both give HR that visibility and hint at the performance signals behind certain pay decisions.
- Everyone working from the same numbers: HR, finance, and managers collaborate on compensation decisions, and they should be working with the same numbers at all times.
How 15Five connects performance to pay
15Five is a dedicated performance management platform that centralizes performance data in one place, building a strong, fair foundation for every compensation decision.
Built-in compensation management features combine performance data from multiple sources, real-time benchmarking, pay ranges, and total rewards in one place, allowing HR to ensure they’re always rewarding top talent, improving employee retention, and building a culture of equitable compensation based on employee performance rather than gut feelings.
15Five’s compensation management features are powered by comprehensive.io, an AI-powered, fully customizable compensation platform. 15Five also has one-click integrations with compensation platforms and a simple view of total compensation for managers and employees, alongside executive-level reporting for HR. 15Five closes the performance-to-pay gap in a way spreadsheets don’t.
Ready to see what a dedicated tool can do? Take a look at 15Five’s compensation solution.
FAQ: Spreadsheets and performance-based pay
What is performance-based pay?
Performance-based pay ties raises and bonuses to employee performance rather than seniority, roles, or titles. It’s meant to create fairer compensation based on equal standards for merit rather than individual conversations.
How do organizations tie pay to performance?
Organizations can tie pay to performance by tracking and analyzing performance signals. A merit matrix is a popular way of doing this, setting raise ranges based on an employee’s performance rating and their current position within a salary range.
What is the merit increase process?
The merit increase process is a cycle used to decide and deliver performance-based raises, usually once a year. It starts with gathering performance ratings. Then HR sets budgets for raises and guidelines for getting them. From there, managers submit recommendations. HR and finance review recommendations based on their requirements and get approval from leadership. Finally, approved compensation numbers are loaded into payroll and managers communicate the outcome.
Why do spreadsheets cause errors in compensation planning?
Spreadsheets can create several errors in compensation planning due to:
- Inaccurate source data.
- Broken formulas.
- Incorrect reconciliation of multiple spreadsheets.
- Manual data merges between systems.
How can HR make merit decisions easier to defend?
Merit decisions are easier to defend when they’re properly documented. Every increase should be tied to calibrated performance ratings, clear merit guidelines, and evidence that these guidelines are applied consistently across teams.
