Here’s a Salary Negotiation Worksheet Template you can use in Excel, Google Sheets, or any spreadsheet tool. It’s designed to help you systematically prepare, track, and negotiate your salary and total compensation.
Salary Negotiation Worksheet Template
| Component | Market Research / Benchmark | Your Target | Offer | Gap | Notes / Strategy |
|---|---|---|---|---|---|
| Base Salary | $ | $ | $ | $ | Research sources, justify with experience |
| Signing Bonus | $ | $ | $ | $ | Consider if employer can offer one |
| Performance Bonus / Incentives | % or $ | % or $ | % or $ | Track potential targets and conditions | |
| Benefits | Health, dental, vision | Health, dental, vision | Health, dental, vision | Compare coverage and costs | |
| Retirement / Pension | Employer contribution % | Desired % | Actual % | Assess long-term savings impact | |
| Paid Time Off (Vacation / Sick) | Days | Desired Days | Offered Days | Negotiate additional PTO if needed | |
| Flexible Work / Remote | Yes / No | Desired flexibility | Offered | Consider hybrid or remote options | |
| Professional Development | Training, courses, certifications | Desired | Offered | Request support for relevant skills | |
| Relocation Assistance | $ or support | Desired | Offered | Include moving costs if applicable | |
| Stock Options / Equity | Shares / % | Desired | Offered | Clarify vesting schedule and terms | |
| Other Perks | Gym, transport, wellness, etc. | Desired | Offered | Include perks that matter to you | |
| Total Compensation | $ | $ | $ | $ | Sum of all components for comparison |
How to Use the Template
- Research Market Rates
Fill in the “Market Research / Benchmark” column using online resources like Glassdoor, LinkedIn Salary Insights, Payscale, and industry reports. - Define Your Targets
Decide your ideal salary, bonuses, and perks in the “Your Target” column. Include both your minimum acceptable and your aspirational goals. - Record the Employer Offer
Enter the official offer details in the “Offer” column as provided by the employer. - Calculate the Gap
Subtract the offer from your target to see where negotiation may be needed. - Plan Your Strategy
Use the “Notes / Strategy” column to prepare your negotiation points, supporting data, and talking points for each component. - Total Compensation
Add up salary, bonuses, benefits, and other quantifiable perks to see the full value of the offer compared to your expectations.
Optional Enhancements
- Add color-coded conditional formatting:
- Green if offer meets/exceeds target.
- Yellow if it’s close.
- Red if it’s below target.
- Include a priority column to indicate which elements matter most to you.
- Add a weighted scoring system to quantify overall satisfaction with the offer.
Benefits of Using This Worksheet
- Objective Evaluation: Compare the offer against your expectations and market standards.
- Preparation for Negotiation: Organize talking points and justify requests with data.
- Focus on Total Compensation: Look beyond base salary to evaluate the full value of the offer.
- Confidence in Negotiation: Be ready with clear numbers and reasoning.
- Record Keeping: Maintain a reference for future offers or salary reviews.