Skip to content
The title slide and first slides of the Bonus and Raise Tracker template

Bonus and Raise Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Pay discussions go better with the numbers in front of you. This bonus and raise tracker holds three views of the same history. Pay History lists base salary and bonus for each year, with base-plus-bonus and the change from the year before. Raises records every increase with its effective date, reason, old and new salary, then works out the dollars and percent. The Summary shows starting salary, current salary, change since hire, bonuses received and the average raise, with a stacked chart of base and bonus by year.

The sample history runs from a hire in 2020 to 2026 with two promotions, which shows how the figures behave. Keep Pay History in year order without gaps; the change column finds the previous year by number. Enter the exact dollar amounts and let the sheet do the percent, because percent figures shown to the nearest whole number can hide a half-point.

Useful for

  • Prepare for a salary review with a record of past raises
  • See how much of your pay growth came from promotions
  • Compare bonuses across years

What's included

  • 4 tabs: Pay History, Raises, Summary, How to use
  • Pay History: a table
  • Raises: a table
  • Summary: a dashboard with 6 summary figures
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Pay History tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I calculate the percent of a raise?

Subtract the old salary from the new one, then divide by the old salary. A move from $60,000 to $63,000 is $3,000 divided by $60,000, which is 5 percent. Each row on the Raises tab is worked out this way.

How do I track pay growth since I was hired?

Note your base salary as it stands each December, then divide the latest figure by the first and subtract one. The Summary tab shows that change for you.

Should I record bonuses separately from salary?

Yes. Bonuses vary from year to year, so keeping them in their own column shows base growth clearly and still lets you see total pay.

  • #tracker
  • #bonus-and-raise-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 33

Also in Finance

All finance templates
Get this template

Preparing your template…