click to scroll images
Compensation Calculator
Calculate if the $10K salary increase is worth the 45 minute commute. Many people accept offers based on the salary number alone, only to regret the decision months later when the hidden costs of time, travel, and lifestyle set in.
This Total Compensation Tracker for Google Sheets gives you a high-definition view of your career move. It factors in your time, opportunity costs, and benefits to reveal the true value of every offer side-by-side.
Capabilities
Visualize Salary Breakdowns - Interactive charts and side-by-side comparison tables make the "winner" obvious. Compare jobs by total pay, time commitments, and specific benefit categories instantly.
Tailor Comp Packages - Fully customizable. Build your own categories for salary, bonuses, equity, and perks—or use the built-in defaults to get moving in seconds.
Annualize Time and Money - No manual math required. Select your timeframe (hour, week, month, etc.) or a percentage of base pay, and the tool handles the multiplication for you.
Capture Hidden Costs - Track the "Opportunity Cost" of your time. Account for commutes, tolls, gas, and unpaid hours to see your actual hourly rate for every role.
Deep-Dive Breakdowns - Three layers of data pivots allow you to see totals by Job, by Section (Financial vs. Time), and by specific Category (Retirement, Insurance, etc.).
Audit-Level Transparency - Trace every raw input back to your charts to verify the math. The interactive tables allow you to filter and drill down into the smallest details of your offer.
FAQ
Q: Do I need a paid Google account?
A: No. A free personal Gmail/Google account is all you need.
Q: Is my data safe?
A: 100%. This is a private template that lives in your secure Google Drive. I never have access to your file or your data.
Q: Can I use this on my phone?
A: Yes, via the free Google Sheets app. However, Google limits certain dropdown and slicer functionality on mobile; for the best comparison experience, I recommend using the desktop version.
Q: Can I add more data or rows?
A: Absolutely. The system is flexible and designed to grow with your career.
Video Tutorial
Returns
Els Paxton creates digital products designed to save time and solve real problems. Because these products are delivered immediately after purchase, returns aren't available once a file has been downloaded.
If something isn't right, Els Paxton will make every reasonable effort to fix the issue. Please get in touch if:
The wrong product was delivered.
A file is missing, corrupted, or won't open.
A technical issue prevents the product from working as intended.
When possible, Els Paxton will provide replacement files, updates, or troubleshooting assistance. If a problem can't be resolved, a refund may be issued at Els Paxton's discretion.
Purchased the wrong product or made a mistake during checkout? Reach out.
Every request receives individual consideration, although refunds can't be guaranteed.
Need Assistance? Questions before purchasing are always welcome.
If there's a problem after your purchase, please include:
The product name
A brief description of the issue
I will respond as quickly as possible and work toward a fair resolution.
Thank you for supporting this small business!
Reviews
Loading product reviews...
Specs for Search Answers
Support
Support Contact
help@elspaxton.io
Embedded Support
Links to video tutorials, data error flags
Video Tutorial Link
General Info
Delivered Product
1 PDF Download containing the secure link to your private Google Sheets Template.
License
Single user license; never expires
Product Created
Mar 3, 2026
Product Updated
Mar 3, 2026
Use Info
Minimal Skillset Required
Basic spreadsheet usage; no formula writing required
Typical Use Function
Determining the annual total compensation of current job, previous jobs, and job offers
Typical User Type
Small Business
Typical Setup Time
5 minutes to setup custom categories; seconds to capture compensation data on each job
Product Info
Computation Framework
Advanced formulas (lambda and array formulas), Query formulas, Pivots with Slicers
User Sheet Count
6
User Sheet Names & Functions
JOBS - user creates each job to build a compensation package for (simple capture of Company & Job Title);
COMPENSATION PACKAGES - user builds each job's compensation package;
DETAILS REPORT - user sees auditable breakdown of how all numbers add up;
COMPENSATION CATEGORIES - user can use default categories, or add/edit/delete to build their own compensation package concepts;
DASHBOARD - user sees visual breakdowns of jobs, includes supporting tabular data, user can filter using dynamic slicers;
READ ME - provides How To instruction with links, link to tutorial video, and includes terms/disclaimer small print
Hidden Sheet Count
2
Hidden Sheet Names & Functions
ADMIN - Setup columns to enable formulas; improved simplicity for user experience; formula protection from accidental deletion
ADMIN STAGE TABLE - pulls the data required for the Total by Compensation Section chart. Categories are customizable, making them theoretically infinite, so this gets its own sheet for the potentially large amount of columns needed for category data
Hidden Sheets User Cannot Access
None - user can unhide all sheets
Dashboard Chart Count
2
Dashboard Charts & Functions
TOTAL BY COMPENSATION (Financial vs Time) Bar chart showing total compensation for each job by financial and time
TOTAL BY COMPENSATION SECTION: bar chart showing total compensation for each job offer by compensation types (salary, bonus, equity, etc)
Image Descriptions
Listing Image Descriptions
Image 1
Compensation Calculator — Google Sheet. Compare job offers instantly by building and comparing complete compensation packages, customizing any compensation concept, capturing values by hours, weeks, months, or percentage of base, and toggling between raw data tables and visual charts. Screenshots show the dashboard comparing the financial and time value of each job offer alongside the supporting table with the underlying amounts.
Image 2
Annualize Time & Money — Build compensation packages effortlessly and in real time. Select a timeframe to automatically calculate values, toggle between hours, weeks, months, or years, apply percentages of base pay with one click, and eliminate manual multiplication or formulas. Screenshot of the compensation package table showing line items for each job, with dropdowns, values, and notes that the tool automatically calculates.
Image 3
Visualize Your Value — See total compensation in one view, with breakdowns by Salary, Bonus, Retirement, Commute, and any customizable category you set. Compare time versus money side-by-side for every offer, visualize salary, bonuses, and equity together, and see charts update instantly as you enter data. Screenshot of a bar chart comparing each job offer by compensation category.
Image 4
Detailed Breakdowns — Drill down from total compensation into specific sub-costs and view totals by custom sections and categories. Screenshot of a pivot table showing dollar breakdowns by job and compensation category. Compare across different data perspectives, with pivot tables syncing with the visual charts.
Image 5
Tailor Your Comp Packages — Customize compensation packages for costs and benefits in the way that makes sense for you. Screenshot of the compensation table showing different compensation concepts organized by custom categories and sections. Use pre-set defaults to get started instantly, with automated formulas building your dropdowns.
Image 6
Transparent — Track every raw input to its final annualized total and confirm the math behind your charts with ease. Screenshot of detailed calculations showing how dollar inputs are annualized, with the ability to drill down by category, section, or classification and view all custom data points in one table. Zero code: formula-based.
Image 7
What’s Included — One PDF download containing a secure link to your private Google Sheets template, plus a step-by-step setup tutorial to get your dashboard running in minutes. Add current and past jobs, build compensation packages for any job, use preset or customized compensation structures to calculate an annual dollar value, and view job compensation in charts and tables from a high-level overview to the lowest detail. Includes step-by-step instructions with tutorial video links and direct support from the creator.
Search Optimization
Other Titles Possibly Searched
Total Compensation Calculator, Job Offer Comparison Spreadsheet, Job Offer Comparison Calculator, Salary Comparison Spreadsheet, Total Compensation Spreadsheet, Job Offer Calculator, Compare Job Offers Spreadsheet, Salary and Benefits Comparison Tool, Job Offer Decision Calculator, Career Offer Comparison Tool
Description for SEO
Spreadsheet for comparing job offers based on total compensation rather than salary alone. Calculate the value of salary, bonuses, equity, benefits, commute time, tolls, gas, unpaid time, and other opportunity costs to compare the true financial and time value of different jobs side-by-side.
Terms & Disclaimers
TERMS OF USE - SINGLE USER LICENSE. BY PURCHASING THIS PRODUCT, YOU AGREE TO THE FOLLOWING:
Single-User License: Your purchase grants you one (1) non-transferable license for personal use only.
No Redistribution: You may not share, sell, resell, give away, or distribute the actual file, or any modified version of it, to any third party.
No "Tool" Reselling: You may not use the logic, formulas, or unique design of this spreadsheet to create a competing product for sale.
Usage: You are welcome to save multiple copies of the file for your own personal use (e.g., a "2025 Tracker" and a "2026 Tracker").
Copyright: The design, formulas, and intellectual property within this spreadsheet remain the sole property of Els Paxton LLC.
DISCLAIMER & LIMITATION OF LIABILITY: This spreadsheet tool is provided by Els Paxton LLC for informational and organizational purposes only. While every effort is made to ensure accuracy, Els Paxton LLC does not guarantee the results obtained from using this tool.
Not Professional Advice: This tool does not constitute financial, legal, tax, or accounting advice.
User Responsibility: The user is solely responsible for the accuracy of data entered and for verifying all final calculations.
No Warranty: This product is provided "as is" without any warranties. In no event shall Els Paxton LLC be liable for any damages (including, without limitation, loss of data or profit) arising out of the use or inability to use this tool.
Privacy
Effective Date: July 17, 2026
At Els Paxton, privacy matters. This policy explains what information the company collects, how it is used, and the choices customers have regarding their information.
Information Collected
Depending on how the website is used, Els Paxton may collect:
Contact information, such as your name, email address, and the information you choose to include in your message when you use the Contact page.
Order information needed to process purchases and deliver digital products.
Basic website usage information, such as pages visited, browser type, device information, and general location.
Information you voluntarily provide through emails or customer support requests.
Els Paxton collects only the information needed to operate the business and provide its products and services.
How Information Is Used
Information may be used to:
Process purchases and deliver digital products.
Respond to questions and provide customer support.
Improve products, the website, and the customer experience.
Measure website performance and marketing effectiveness.
Detect fraud, protect the security of the website, and comply with legal obligations.
Els Paxton does not sell or rent your personal information. Personal information is shared only with trusted service providers when necessary to operate the business and provide products or services.
Payments
Payments are securely processed by Lemon Squeezy. Els Paxton does not collect or store your payment card information. Payment information is handled according to Lemon Squeezy's privacy and security practices.
Cookies and Analytics
This website uses cookies and similar technologies to understand how visitors use the site and to improve the customer experience.
Els Paxton may use:
Google Analytics to measure website traffic and understand how visitors use the site.
Google Ads to measure advertising performance and conversions.
Microsoft Clarity to better understand how visitors interact with the website through anonymous usage data, such as heatmaps and session recordings.
These services may collect information such as pages visited, browser type, device information, approximate location, and interactions with the website. This information helps improve the website and measure the effectiveness of marketing efforts.
You can control or disable cookies through your browser settings, although some features of the website may not function as intended.
Third-Party Services
Els Paxton relies on trusted third-party providers to operate the business. These providers may process information only as needed to provide their services.
Current providers may include:
Lemon Squeezy for payment processing and digital product delivery.
Google Analytics for website analytics.
Google Workspace for securely storing and managing customer inquiries submitted through the Contact page.
Google Ads for advertising measurement.
Microsoft Clarity for website usability analytics.
Each provider maintains its own privacy policy and is responsible for the information it collects through its services.
Data Security
Els Paxton uses reasonable administrative, technical, and organizational safeguards to protect personal information. However, no method of transmitting or storing information over the internet can be guaranteed to be completely secure.
Data Retention
Els Paxton keeps personal information only as long as reasonably necessary to provide products and services, respond to customer inquiries, comply with legal obligations, resolve disputes, and maintain business records.
Your Rights
Depending on where you live, you may have the right to:
Request access to your personal information.
Request correction of inaccurate information.
Request deletion of your personal information where permitted by law.
Object to or limit certain processing activities.
To exercise these rights, please contact Els Paxton using the Contact page on this website.
Children's Privacy
This website is not intended for children under the age of 13, and Els Paxton does not knowingly collect personal information from children.
Changes to This Policy
This Privacy Policy may be updated from time to time. The current version will always be posted on this page with the effective date shown above.
Contact
If you have questions about this Privacy Policy, please use the Contact page on this website.