Templates

    Free Template

    Pay Raise Tracker Spreadsheet

    Track yearly pay, raises, inflation, and performance in one place.

    Template Content

    | Date | Salary ($) | Raise Amount ($) | % Increase | Inflation Rate (%) | Real Increase (%) | Key Wins During Period |
    |------|------------|------------------|------------|--------------------|-------------------|-------------------------|
    | Jan 2024 | 80,000 | - | - | - | - | Initial Salary |
    | Jan 2025 | 85,000 | 5,000 | 6.25% | 4.0% | 2.25% | Led Project X, Certified in Y |
    | ... | ... | ... | ... | ... | ... | ... |
    
    Instructions:
    1. Update this table every time your pay changes.
    2. Calculate '% Increase' as (New Salary - Old Salary) / Old Salary.
    3. Find the current CPI (inflation) rate from the ABS website.
    4. 'Real Increase' = % Increase - Inflation Rate. If this is negative, your purchasing power has decreased despite the raise.

    How to Use This Tracker

    • 1

      Copy the table format into Excel, Google Sheets, or a Notion page.

    • 2

      Enter your starting salary and date.

    • 3

      Whenever you get a raise, add a new row with the updated details.

    • 4

      Briefly list 2-3 major wins for each period to remember exactly why you earned that raise.

    • 5

      Use this data to see your long-term career progression and ensure you're keeping ahead of inflation.

    Pro Tips

    • Keep it private: This is for your personal records and career planning.

    • Include total package: If you get bonuses or extra super, add columns for 'Total Compensation'.

    • Compare to market: Periodically check if your 'Real Increase' is keeping up with market salary growth for your role.

    Ivy Sinclair-Wren

    Ivy Sinclair-Wren

    Financial Chaos Analyst

    Connect on LinkedIn

    Ivy Sinclair-Wren is a Financial Chaos Analyst covering investing, AI, wealth psychology, and the emotional consequences of opening finance apps during market crashes. Based in Melbourne, she specializes in demystifying the Australian tax code and helping users navigate the intersection of spreadsheet logic and human irrationality.