How to Calculate Annual Salary Increase (With Free Template)
.png)
Salary increases shouldn’t feel like guesswork.
But in a lot of businesses, they are.
Raises get decided based on:
- Gut feel
- Inconsistent benchmarks
- Last-minute conversations
- Or worse who asked loudest
That’s not a system. That’s a risk.
If you want to retain great employees, control payroll costs, and scale responsibly, you need a clear, repeatable way to calculate salary increases.
In this guide, I’ll show you:
- The exact ways to calculate salary increases
- When to use each method
- How to structure raises across your team
- And give you a Google Sheets template to manage it all
Why Salary Increase Structure Matters
A raise isn’t just about paying someone more.
It impacts:
- Team morale
- Retention
- Profit margins
- Internal equity
- Performance expectations
When raises feel random, employees notice.
When they feel structured and fair, you build trust.
The 3 Most Common Ways to Calculate a Salary Increase
There’s no one “right” way but there are standard methods that work.
Let’s break them down.
1. Percentage-Based Increase (Most Common)
This is the simplest and most widely used method.
Formula:
New Salary = Current Salary × (1 + Increase %)
Example:
- Current Salary: $60,000
- Increase: 5%
New Salary = $60,000 × 1.05 = $63,000
When to Use This:
- Annual reviews
- Cost-of-living adjustments
- Standard company-wide raises
2. Flat Dollar Increase
Instead of a percentage, you give a fixed amount.
Example:
- Current Salary: $60,000
- Increase: $3,000
New Salary = $63,000
When to Use This:
- Bonuses converted into salary
- Promotions with defined pay bands
- Equal raises across a team
3. Market Adjustment Increase
This is where you adjust pay to match the market.
Example:
- Current Salary: $55,000
- Market Rate: $65,000
Increase = $10,000
When to Use This:
- Retention risk
- Underpaid roles
- Competitive hiring pressure
The Smart Way to Approach Salary Increases
Here’s where most businesses mess this up.
They focus on the calculation—not the strategy.
A strong approach combines:
1. Performance
Top performers should earn more. Period.
2. Market Value
If you’re under market, you’ll lose people.
3. Internal Equity
Two people doing the same job shouldn’t have wildly different pay.
4. Budget Constraints
You still need to run a profitable business.
👉 Free Google Sheets Salary Increase Template
Here’s where you plug in your template.
👉 Open the Salary Increase Template
What the Template Includes
Your Google Sheets template should track:
Employee Details
- Employee Name
- Role
- Department
Salary Data
- Current Salary
- Proposed Increase (%)
- Increase Amount ($)
- New Salary
Performance + Notes
- Performance Rating
- Manager Notes
- Approval Status
How to Use This Salary Increase Template Effectively
A template alone won’t fix your process.
You need a system behind it.
Step 1: Define Your Raise Guidelines
Before touching numbers, decide:
- What qualifies for a raise
- Typical increase ranges (e.g., 3–7%)
- How performance impacts raises
Step 2: Review Employees Consistently
Don’t review raises randomly.
Set a cadence:
- Annual reviews
- Biannual check-ins
- Promotion cycles
Step 3: Compare Across Your Team
Look at your data side by side:
- Are similar roles paid similarly?
- Are top performers rewarded properly?
This is where your sheet becomes powerful.
Step 4: Finalize and Approve
Add an approval layer:
- Manager review
- Leadership sign-off
No surprises.
The Biggest Mistakes to Avoid
Let’s be direct—these are the ones that cause problems fast.
❌ Giving Raises Without a Framework
Leads to inconsistency and resentment.
❌ Ignoring Market Data
You’ll lose good people.
❌ Overpaying Without Performance Justification
Kills margins and creates entitlement.
❌ Not Tracking Raise History
You need a record of:
- When raises happened
- How much
- Why
Where Most Businesses Get Stuck
Here’s the reality:
Calculating salary increases is easy.
Managing them across a growing team? That’s where things break.
Because now you’re dealing with:
- Hours worked
- Overtime
- Labor costs
- Scheduling
- Payroll accuracy
And suddenly spreadsheets start to stretch.
This Is Where Tracking Tools Matter
If you’re still manually tracking:
- Hours
- Pay
- Overtime
You’re making salary decisions without full visibility.
That’s a problem.
Because compensation should be tied to real data:
- Actual hours worked
- Productivity
- Cost per employee
A Smarter Way to Track Hours and Pay
This is where a tool like Updoot comes in.
Instead of guessing or piecing together spreadsheets, you can:
- Track employee hours in real time
- Monitor labor costs automatically
- See overtime before it becomes a problem
- Connect time tracking directly to pay decisions
That means: ✔ More accurate salary decisions ✔ Better cost control ✔ Less manual work ✔ Fewer payroll surprises
Final Thoughts
Salary increases shouldn’t be emotional decisions.
They should be:
- Structured
- Data-driven
- Consistent
- Aligned with your business goals
A simple Google Sheets template gives you a strong starting point.
But the real advantage comes when you:
- Build a repeatable process
- Use real data
- And connect compensation to performance and output
Start with the template. Build the system. Then optimize as you grow.
Opens in Google Drive — view and download for free
Related articles on HR
Which States Require Vacation Payout Upon Termination
How Many Write-Ups Before Termination?
Small Business Employee Benefits to Retain Employees
Job Description Format to Follow and a Template
W2 vs 1099 Employee: Checklist to Choose the Right One
How to Hire for Cultural Fit and a Free Hiring Tracker
Salary Bands Meaning and How to Build Them
Employee Coaching Plan to Improve Performance and Results