How to Calculate Annual Salary Increase (With Free Template)

How to calculate a salary increase should not come down to gut feel. In a lot of businesses, though, it does.

Raises get decided by inconsistent benchmarks, last-minute conversations, or whoever asked the loudest. That is not a system. It is a risk to your payroll budget, your team's trust, and your best people staying.

Below are the three standard ways to calculate a raise, when to use each, how to structure raises across your team, a free Google Sheets salary increase template, and a calculator that shows the total payroll impact before you commit.

Why Salary Increase Structure Matters

A raise is not just about paying someone more. Every salary increase ripples through the business. It affects team morale and retention, because people compare notes and notice who got what. It affects profit margins, because payroll is usually the largest expense a small business carries and every raise compounds year after year. It affects internal equity, meaning whether people doing similar work are paid fairly relative to each other. And it shapes performance expectations, since the way you reward work tells your team what you actually value.

When raises feel random, employees notice quickly. A strong performer who gets the same increase as someone coasting starts to wonder why they bother, and an employee who learns a newer colleague earns more for the same job starts looking elsewhere. When raises feel structured and fair, the opposite happens. Even people who hoped for more understand how the decision was made, and that understanding builds trust that lasts well beyond a single review cycle.

The 3 Most Common Ways to Calculate a Salary Increase

There is no single right way to calculate a raise, but there are three standard methods that cover almost every situation. Most businesses use a mix of them, choosing the method that fits the reason for the raise.

1. Percentage-Based Increase (Most Common)

The percentage method is the simplest and most widely used. You multiply the current salary by one plus the raise percentage, using the formula New Salary = Current Salary × (1 + Increase %). For an employee earning $60,000 who receives a 5 percent raise, the math is $60,000 × 1.05, which gives a new salary of $63,000.

Percentage raises are the natural choice for annual reviews, cost-of-living adjustments, and standard company-wide increases. They scale with pay, which keeps relative pay differences intact across the team. The trade-off is that higher earners receive larger dollar increases for the same percentage, which is worth keeping in mind when your budget is tight.

2. Flat Dollar Increase

With a flat dollar increase, you add a fixed amount instead of a percentage. An employee earning $60,000 who receives a $3,000 increase moves to $63,000, the same result as the 5 percent example above, but the amount stays the same no matter what the starting salary is.

Flat raises work well when you are converting a recurring bonus into base salary, promoting someone into a role with a defined pay band, or giving everyone on a team the same raise so that lower earners benefit proportionally more. They are simple to explain, which makes them easier for employees to understand and accept.

3. Market Adjustment Increase

A market adjustment brings an employee's pay up to the going rate for their role. If someone earns $55,000 and similar roles in your area pay $65,000, the increase is the difference, or $10,000. The calculation is simple, but the reason behind it is different from a normal raise: you are correcting underpayment rather than rewarding a year of performance.

Market adjustments are the right tool when you have a retention risk, a role that has fallen behind the market, or competitive hiring pressure that means new hires would earn more than your existing team. They tend to be larger than typical annual raises, so it helps to plan them separately in your budget rather than squeezing them into the normal raise pool.

The table below compares all three methods side by side.

How to Calculate a Raise Percentage

Sometimes you already know the new salary and want to know what percentage raise it represents, for example when comparing an offer against your usual raise range. Use this formula:

Raise % = (New salary - Current salary) / Current salary x 100

For example, going from $52,000 to $55,000 is a $3,000 increase. $3,000 divided by $52,000 is 0.0577, or about a 5.8 percent raise.

In Excel or Google Sheets, with the current salary in B2 and the new salary in C2, use =(C2-B2)/B2 and format the cell as a percentage. Fill the formula down a column of employees and you can see every raise percentage at a glance, which makes it easy to spot anyone who falls well outside your normal range.

Converting Hourly Raises to Annual Pay

For hourly employees, it helps to translate an hourly raise into its yearly cost so you can compare it with salaried raises and plan your budget. Multiply the hourly increase by the hours worked per year. A full-time schedule of 40 hours a week for 52 weeks is 2,080 hours, so even a small hourly raise adds up to a meaningful annual amount.

Remember that overtime is paid at one and a half times the regular rate for nonexempt employees under the Fair Labor Standards Act, so an hourly raise also raises the cost of every overtime hour. If your team works regular overtime, include those hours in your estimate.

The Smart Way to Approach Salary Increases

This is where most businesses go wrong. They focus on the calculation and skip the strategy, when the math is the easy part. The harder question is how much each person should get and why, and a strong approach answers it by weighing four factors together.

1. Performance

Top performers should earn more. If your best people receive the same raise as everyone else, you are quietly telling them their extra effort does not count, and they will eventually take that effort somewhere that rewards it. Performance should be the biggest single driver of how raises differ from person to person.

2. Market Value

If your pay falls under the market rate for a role, you will lose people, often the ones who have the easiest time finding a new job. Checking what similar roles pay in your area keeps your raises grounded in reality rather than in what you paid last year.

3. Internal Equity

Two people doing the same job at a similar level should not have wildly different pay. Gaps like that usually appear by accident, when one person negotiated harder or was hired in a tighter job market, and they cause real resentment once discovered. Reviewing raises side by side is the best way to catch and close them.

4. Budget Constraints

You still need to run a profitable business. Setting a total raise budget first, then dividing it according to performance, market value, and equity, keeps generosity from turning into a cash flow problem later in the year.

For market data, the Bureau of Labor Statistics Employment Cost Index tracks how fast wages are rising nationally. Its most recent release showed wages and salaries up about 3 percent over the prior 12 months, a useful baseline for your raise budget. For role-specific pay, the BLS Occupational Employment and Wage Statistics program publishes wages by job and location.

Free Google Sheets Salary Increase Template

Use the template to plan raises for your whole team in one place. Make a copy, enter each employee's current pay and proposed increase, and the sheet calculates the dollar increase and new salary for you, so you can see the full picture before anything is approved.

Open the Salary Increase Template

What the Template Includes

A useful salary increase template tracks three groups of information for every employee. The first is the basic employee details: each person's name, role, and department, which lets you sort and compare people in similar positions.

The second is the salary data itself. That means the current salary, the proposed increase as a percentage, the increase amount in dollars, and the resulting new salary. Keeping both the percentage and the dollar figure side by side matters, because a raise that looks modest as a percentage can be a large number in dollars for a highly paid role, and the reverse is true for lower earners.

The third is performance and notes, including the employee's performance rating, the manager's notes explaining the recommendation, and the approval status. Those columns turn the sheet from a calculator into a record of why each decision was made, which is exactly what you will want the next time someone asks how their raise was set.

Free Team Raise Calculator

The 10 percent default for payroll taxes and benefits is a rough starting point. Employer Social Security and Medicare taxes alone add 7.65 percent to most raises, and retirement matches or other pay-linked benefits add more.

How to Use This Salary Increase Template Effectively

A template on its own will not fix an inconsistent process. It needs a simple system behind it, and that system comes down to four steps.

Step 1: Define Your Raise Guidelines

Before you touch any numbers, decide what qualifies someone for a raise, what a typical increase range looks like at your company, for example 3 to 7 percent, and how performance moves someone within that range. Writing these guidelines down first keeps every manager working from the same rules and stops the loudest request from setting the standard.

Step 2: Review Employees Consistently

Do not review raises randomly, whenever someone happens to ask. Set a cadence and stick to it, whether that is an annual review for everyone, twice-yearly check-ins, or reviews tied to promotion cycles. A predictable schedule means employees know when pay will be discussed, and it means nobody gets overlooked simply because they never asked.

Step 3: Compare Across Your Team

Once the proposals are in, look at the data side by side. Ask whether people in similar roles are paid similarly, and whether your top performers are being rewarded properly compared with everyone else. This is where the spreadsheet becomes powerful, because patterns that are invisible one conversation at a time jump out when every employee sits in the same table.

Step 4: Finalize and Approve

Add an approval layer before anything is communicated. A manager reviews and recommends each raise, and leadership signs off on the full set so the total fits the budget. That extra step prevents surprises, both for the business and for the employee who might otherwise be promised a number that later has to be walked back.

The Biggest Mistakes to Avoid

A few mistakes cause most of the trouble with raises, and they tend to cause it quickly.

Giving Raises Without a Framework

Without clear guidelines, raises end up depending on who negotiates hardest or which manager is most generous. That leads to inconsistency across the team and, eventually, resentment when people compare notes.

Ignoring Market Data

Setting raises based only on last year's pay, without checking what the market pays for each role, is how businesses fall behind without noticing. You will lose good people to competitors who are paying the going rate.

Overpaying Without Performance Justification

Large raises that are not tied to results squeeze your margins and create an expectation that pay goes up no matter what. Once that expectation sets in, it is very hard to reverse.

Not Tracking Raise History

You need a record of when each raise happened, how much it was, and why it was given. Without that history, it is impossible to answer questions about fairness, spot patterns over time, or explain a decision to an employee who asks.

A Simple Merit Increase Matrix

A merit matrix ties raises to both performance and where someone sits in their pay range, so strong performers who are already paid well do not automatically get the biggest raise. Read across the row for the employee's performance, then down the column for where their pay sits relative to the market, and the cell gives you a suggested range. Adjust the percentages to fit your budget.

If you do not have pay ranges yet, our guide to salary bands and how to build them walks through it.

How to Talk to Employees About Raises

How you share a raise matters almost as much as the amount. Start by tying it to specifics. Explain what the raise recognizes, whether that is strong results, new responsibilities, or a market adjustment, so the employee understands the reasoning rather than just the number.

Share the new salary and the date it takes effect in writing, so there is no confusion when the next paycheck arrives. When the answer is smaller than the employee hoped, or no raise at all, be honest about why, and explain what would need to change for a bigger increase next time. That conversation is uncomfortable, but vague answers are worse, because they leave the employee guessing and usually assuming the worst.

Close by setting expectations for the next review, so the employee knows when pay will be discussed again. Finally, update payroll before the effective date. A raise that shows up late creates retro pay and frustration, and it undoes some of the goodwill the raise was meant to create.

If a raise is entered late and has to be corrected, our guide to retro pay explains how to calculate what is owed.

Where Most Businesses Get Stuck

Here is the reality. Calculating a salary increase is easy, and after reading this far you can do it in a few seconds. Managing raises across a growing team is where things break down.

As the team grows, pay decisions stop living in a single column of salaries. You are dealing with hours worked, overtime, total labor costs, schedules that shift week to week, and the need for payroll to be accurate every single time. Each of those affects what a raise really costs, and each one usually sits in a different place. That is the point where spreadsheets start to stretch past what they were built to do.

This Is Where Tracking Tools Matter

If you are still tracking hours, pay, and overtime by hand, you are making salary decisions without full visibility. You can see what someone earns, but not what they actually cost or how their time is spent, and that is a problem when you are deciding how to divide a limited raise budget.

Compensation decisions should be tied to real data: the hours each person actually works, their productivity, and the true cost per employee once overtime and benefits are included. Without that data, even a well-designed merit matrix is only as good as the guesses you feed into it.

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, and connect time tracking directly to pay decisions.

The result is more accurate salary decisions, better control over costs, less manual work for you and your managers, and fewer surprises when payroll runs. When raise season comes around, the numbers you need are already in one place instead of scattered across files.

Updoot is business management software that connects time tracking, payroll-ready reports, and performance reviews for $5 per user per month.

Final Thoughts

Salary increases should not be emotional decisions. They should be structured, driven by data, consistent from one employee to the next, and aligned with where your business is going. When raises follow clear rules, your team trusts the process, your budget stays predictable, and your best people have a reason to stay.

A simple Google Sheets template gives you a strong starting point. The real advantage comes when you build a repeatable process around it, feed it real data about hours and costs, and connect compensation to performance and output. Start with the template, build the system around it, and refine both as your business grows.