Calculate the Cost of Overtime
How will the new federal overtime rules affect your business? Will your costs increase? Our overtime calculation spreadsheet will help you understand the impact of the new FSLA regulations!
What Is Employee Overtime?
According to the Department of Labor, overtime is the amount of hours employees work over 40 per workweek. Under the FLSA, nonexempt employees must receive at least 1.5 times the rate of regular pay for these hours.
Beginning December 1, 2016, new federal rules go into effect which expand overtime eligibility for millions of Americans. Not only do these regulations raise the minimum annual salary level for exempt “white collar” workers to $47,476, they also ensure that the salary threshold is updated every three years to protect employees from overwork and underpay.
working day in office. two businessmen at work.
Calculate Overtime Pay in Excel
If you’re looking for an easy way to understand how the new overtime rule could affect your budget — or how you schedule employee hours — we’ve got you covered. Our free overtime calculator helps you to plan and understand potential employee overtime costs, and make more informed decisions around employee compensation.
How to Use the Overtime Calculator
It’s easy to understand the cost of the new federal overtime rules with our FLSA spreadsheet!
Getting Started:
- Download the overtime calculator
- Open the overtime calculator Excel
Setting Up the Overtime Calculator
- Enter your employee names (or aliases) in the leftmost column, titled “Name”
- Under “Month 1,” enter your employee’s wages, regular hours, and overtime hours for a one-month period. (Please note that federal overtime hours are generally defined as any worked time beyond 40 hours in a given week.)
- Enter this data for “Month 2” and “Month 3”
- For your organization, enter Workers’ Comp, Local Payroll Tax Rate, and Employer Federal Payroll Taxes (social security + unemployment)
Using the Overtime Calculator
- Under Prior Rule, you will see the annual and hourly cost of your employees, extrapolated from the three months of data you entered.
- Under Estimated Cost, you will find two results:
- The annual and hourly costs of your employees if they are non-exempt and are paid overtime wages
- The annual and hourly costs of your employees if they are non-exempt and are earning over 47.5k per year
Time Tracking That Works
ClickTime helps thousands of businesses on more than 55 countries track time, improve operations, and manage employee hours. If any of your employees might be eligible for overtime under the new federal regulations, we can help you automate the process and ensure compliance for your organization.
Time Tracking for:
Want to Track Employee Overtime?
Under the new FLSA rules, millions of white collar workers will become eligible for overtime pay. It’s now more important than ever to track employee time, ensure compliance, and properly manage employee hours.
If you are looking for timesheets with simple but powerful overtime reports, ClickTime offers real-time insights into hours, teams, budgets, and clients. The best part? You can try it free right now!
This calculator is designed to offer general guidance and estimates only and does not constitute legal or tax advice.