Free Overtime Tracker: Interactive Tool and Complete Guide

Overtime tracking errors are expensive in two directions at once. Underpay overtime and you expose the business to wage claims, DOL investigations, and back pay liability. Overpay it -- through manual math errors, double counting, or misunderstanding which threshold applies -- and you're paying labor costs you don't owe. The right overtime tracker eliminates both problems by calculating automatically from actual hours worked rather than estimates or manual arithmetic.

The interactive tracker below handles up to 10 employees per week, calculates regular and overtime hours automatically against the 40-hour federal threshold, shows a real-time summary of total hours and overtime liability, and exports to Excel with one click. Below the tool you will find the exact formulas to build your own, the overtime rules by threshold type, and the most common tracking mistakes that create payroll and compliance problems.

Free Interactive Overtime Tracker

Enter employee names, select your overtime rule, and log daily hours. Regular and overtime totals calculate automatically. Copy to Excel exports the full week's data as tab-separated values you can paste directly into a spreadsheet.

How Overtime Is Calculated

The federal Fair Labor Standards Act requires overtime pay -- at least 1.5 times the regular rate -- for any non-exempt employee who works more than 40 hours in a single workweek. A workweek is any fixed recurring period of seven consecutive 24-hour days. It does not have to start on Monday and does not have to align with the pay period. Once you define the workweek, it must stay consistent -- you cannot shift it to avoid overtime liability.

State overtime laws layer on top of federal law. When a state rule is more generous to the employee, the state rule applies. The three most common state structures are:

Who Must Be Tracked for Overtime

Non-exempt employees must be tracked and paid overtime. Exempt employees are not entitled to overtime pay under FLSA. The most commonly misapplied exemptions are:

Executive Exemption

Applies to employees whose primary duty is managing the enterprise or a recognized department, who regularly direct the work of at least two full-time employees, and who have the authority to hire, fire, or whose recommendations on those decisions carry significant weight. The employee must also earn at least $684 per week on a salary basis. All three elements must be met -- job title alone does not create the exemption.

Administrative Exemption

Applies to employees whose primary duty is office or non-manual work directly related to the management or general business operations of the employer or customers, and whose primary duty includes the exercise of discretion and independent judgment with respect to matters of significance. $684 per week salary minimum also applies. This is the most frequently misapplied exemption -- clerical work is not administrative in the FLSA sense regardless of how senior the title is.

Highly Compensated Employees

Employees earning at least $107,432 per year who perform office or non-manual work and customarily perform at least one of the duties of an exempt executive, administrative, or professional employee are exempt with a reduced duties test. This threshold is the one most likely to change with regulatory updates -- verify the current figure before relying on it.

How to Build an Overtime Tracker in Excel

The tracker above handles weekly calculations interactively. To build a persistent multi-week version in Excel, use this structure:

The Formula for Daily Hours

If start time is in A2, end time in B2, and break in minutes in C2:

=(B2-A2)*24-C2/60

Format A2 and B2 as time (h:mm AM/PM). The result in the hours column should be formatted as a number, not time.

Federal Weekly Overtime (40-hour threshold)

If weekly total hours are in H2:

Regular hours: =MIN(H2,40)

Overtime hours: =MAX(0,H2-40)

California Daily Overtime (8-hour daily threshold)

For each daily hours cell (e.g. B2 through H2 for Mon-Sun), calculate daily overtime in a separate row:

Daily OT: =MAX(0,B2-8) (applied to each day)

Weekly OT: =MAX(0,SUM(B2:H2)-40)

Total OT: =MAX(SUM(daily OT row), weekly OT)

This prevents double-counting daily and weekly overtime on the same hours.

Overtime Pay Calculation

If hourly rate is in I2 and overtime hours are in K2:

Regular pay: =MIN(H2,40)*I2

Overtime pay: =K2*I2*1.5

Total gross: =regular pay + overtime pay

What Your Overtime Tracker Must Capture

Common Overtime Tracking Mistakes

Using Scheduled Hours Instead of Actual Hours

An employee scheduled for 8 hours who stays 30 minutes late has worked 8.5 hours. If you record the scheduled hours instead of actual hours, you systematically underpay overtime and create DOL liability. The FLSA requires payment for all hours the employer "suffers or permits" the employee to work -- if the employer knows the employee stayed late, those hours must be compensated regardless of whether they were authorized.

Averaging Hours Across Weeks

A common misunderstanding is that overtime can be averaged across pay periods. It cannot. Overtime is calculated week by week. An employee who works 50 hours one week and 30 hours the next is owed 10 hours of overtime for the first week. The 10 undertime hours in the second week do not offset the overtime liability from the first week. Each workweek stands alone.

Excluding Pre-Shift and Post-Shift Time

Time spent in mandatory pre-shift activities -- safety briefings, equipment checks, uniform changes that can only happen at the workplace -- is compensable and must be tracked and counted toward overtime. The same applies to mandatory post-shift activities. If your tracker only captures the main shift start and end times, you may be systematically missing compensable time that accumulates into significant overtime liability over a year.

Not Tracking Salaried Non-Exempt Employees

A salaried employee who does not meet the FLSA salary and duties tests for exemption must be tracked for overtime exactly like an hourly employee. Their overtime rate is calculated from their effective hourly rate -- weekly salary divided by 40 hours -- applied at 1.5x for all hours over 40. Many small businesses assume all salaried employees are exempt. That assumption is frequently wrong and expensive.

Rounding Hours Incorrectly

FLSA permits rounding to the nearest 5 minutes, one-tenth of an hour, or quarter hour if the rounding practice is neutral over time -- meaning it sometimes rounds up and sometimes rounds down. A rounding policy that consistently rounds down or only rounds in the employer's favor is illegal. If you round, document the policy and audit it periodically to confirm neutrality. The safest approach is to track actual minutes and not round at all.

How Updoot Tracks Overtime Automatically

Updoot handles overtime calculation, manager approval, and payroll-ready reporting in one platform so overtime liability is visible before payroll runs rather than discovered afterward.