Overtime tracking template

Everhour turns tracked hours into billing records while federal overtime math still needs clean weekly inputs.

What will your overtime pay be?

Calculate regular and overtime earnings based on your hours and rate. Supports standard time-and-a-half and double-time multipliers.

Total hours including overtime

$

Typically 40h/week

Total pay this period
Regular pay$1,000.00
Overtime pay$300.00
OT hours8h

Everhour does it all — track, budget, report & invoice

The calculator gives you the number — Everhour takes it from there.

Go ahead — start tracking!

One click and you're timing. Start a timer, add an entry, edit the details. This is exactly how it feels in Everhour.

  • One-click timer — browser, desktop & mobile
  • Works inside Asana, ClickUp, Linear, GitHub & more
  • Simple setup, no learning curve
Works with your favorite tool:
Everhour — Time Tracking
Time Entries
01:24:00
00:31:00
01:07:00

No more budget surprises

Set a budget, assign rates, and get alerted before you're over.

  • Real-time cost tracking
  • Set different rates per person or project
  • Alerts before you hit the budget limit
Everhour — Budgeting
Acme Web Project
1
50% of budget used
$2,500.00of $5,000.00
$2,500.00 remaining
75%
Actual costRemaining cost

Measurement

Track your budget through time or costs

Simple, customizable reports

Every report you need — configured your way, always up to date.

  • See who does what in real time
  • Configure any report
  • Scheduled email reports
Everhour — Reports

Your invoice is ready!

Tracked hours flow straight into a polished invoice — no copy-paste, no manual math.

  • Billable hours straight into the invoice
  • Configure invoice templates
  • Copy invoices to QuickBooks or Xero
  • Invoicing dashboard with status
Everhour — Invoices
Your Company LLChello@yourcompany.com
INVOICE
Invoice #1042
Group by:
DescriptionHoursRateAmount
Website Redesign14h$150/h$2,100.00
Brand Guidelines7h$150/h$1,050.00
Marketing Strategy3.5h$150/h$525.00
Total Due$3,675.00
Try Everhour for real yourself

How weekly overtime records turn into pay

What this calculation answers

An overtime tracking template answers one practical question: which hours in a fixed workweek are regular hours, which are overtime hours, and what gross pay follows from that split. For the United States federal baseline, covered nonexempt employees must receive overtime pay for hours worked over 40 in a workweek at not less than 1.5 times the regular rate.

The template should also show the workweek start and end dates, because each FLSA workweek stands alone. A workweek is a fixed and regularly recurring 168-hour period made of seven consecutive 24-hour periods. Averaging two workweeks together to reduce overtime is not allowed under the FLSA federal baseline.

Build the template around inputs

Start with columns for employee name, worker classification, workweek, date, hours worked, regular rate inputs, regular hours, overtime hours, overtime rate, and total gross pay. Add review fields for manager approval, payroll status, and notes about bonuses, multiple rates, or corrections. Those fields stop the template from becoming a loose time log with no audit trail.

Do not mix time not worked into the hours-worked column. The FLSA does not require payment for vacation or federal or non-federal holidays, and those benefits are generally set by agreement, employer policy, or a representative or union contract. If paid holiday or vacation time belongs in payroll, place it in a separate paid-time-off column so it does not inflate FLSA hours worked.

Calculate the overtime line

For a simple hourly case, assume a covered nonexempt employee works 49 hours in one fixed FLSA workweek at a $25.60 regular hourly rate. The template should show 40 regular hours, 9 overtime hours, and an overtime rate of $38.40. Regular pay is $1,024.00, overtime pay is $345.60, and gross pay is $1,369.60 before taxes or deductions.

The regular rate is not always the base hourly rate. Under the FLSA, the regular rate is calculated by dividing total compensation for the workweek, excluding statutory exclusions, by total hours actually worked in that workweek. If the employee earns nondiscretionary bonuses or works at multiple rates, the template needs fields that support the regular-rate calculation before applying the 1.5x overtime multiplier.

Avoid template-specific mistakes

A template fails when the columns hide the decision that changes the result. The most common mistake is using one total-hours cell for the entire pay period when the pay period includes more than one FLSA workweek. A semimonthly payroll period, for example, can contain parts of three workweeks, but overtime still has to be calculated workweek by workweek.

Another mistake is treating weekend or holiday labels as automatic federal overtime triggers. The FLSA does not require overtime pay merely because work occurs on Saturdays, Sundays, holidays, or regular days of rest. The federal trigger is hours worked over 40 in the workweek unless a more protective state law, employer policy, contract, or other agreement gives the worker a greater benefit.

Use checks before handoff

A one-off template is enough when you need to verify a single week, confirm a payroll line, or model a simple hourly scenario. It works best when the employee has one rate, no bonus adjustment, no daily overtime rule, and a clean weekly hours total. The output should be regular pay, overtime pay, and gross pay.

A managed workflow is the better long-term answer when hours need approval, correction history, billing separation, or payroll handoff. Everhour can keep billable and non-billable time separate, turn approved billable time and expenses into invoices, and export invoices to QuickBooks Online, Xero, or FreshBooks so overtime records do not sit in an isolated spreadsheet.

This content is for general information only, may not be fully up to date, and is provided without any warranty or liability.

High Performer

G2

Summer 2026

Best Ease Of Use

Capterra

Summer 2026

Loved by teams. Proven everywhere.

Rated in the top time trackers across G2, Capterra, and TrustRadius — with consistent praise for ease of use, integrations, and support.

10K+Teams worldwide
90K+Installs Everhour extension
196M+Tasks completed
4M+Projects tracked

Frequently Asked Questions

What fields belong in an overtime tracking template?

Use fields for employee, workweek, date, hours worked, regular hours, overtime hours, regular rate, overtime rate, regular pay, overtime pay, gross pay, approval status, and payroll status. Add separate fields for paid time off, bonuses, and multiple pay rates when they apply, because those entries affect review differently than ordinary worked hours.

How should a template split regular and overtime hours?

For the FLSA federal baseline, a covered nonexempt employee has up to 40 regular hours in one fixed workweek, then overtime for hours worked over 40. The overtime rate must be not less than 1.5 times the employee's regular rate. More protective state rules or contracts can require a greater benefit.

Why should each workweek have its own template row?

Each FLSA workweek stands alone, so the template needs a separate weekly calculation line. Hours cannot be averaged across two or more workweeks to avoid overtime. If a pay period covers multiple workweeks, calculate regular and overtime hours for each workweek first, then summarize the payroll-period totals.

Should paid holiday time be included in overtime hours?

Paid holiday time that was not worked should not be placed in the FLSA hours-worked column. The FLSA does not require payment for time not worked, including vacations or holidays. Holiday, vacation, and other paid leave benefits are generally controlled by employer policy, agreement, contract, or applicable state law.

What template mistake changes the final pay most often?

The largest error is using base hourly pay when the regular rate should include more compensation. The regular rate is total compensation for the workweek, excluding statutory exclusions, divided by total hours actually worked. A template that skips bonus, shift, or multiple-rate fields can understate the overtime rate.

How does Everhour Billing & Invoicing use approved overtime records?

Everhour Billing & Invoicing converts tracked billable time and expenses into invoices, calculates invoice amounts from rates while excluding non-billable tasks, and keeps invoice status visible in Everhour. Teams can export invoices to QuickBooks Online, Xero, or FreshBooks after billable time has been reviewed.

How does Everhour help review overtime before payroll?

Everhour Overtimes supports daily and weekly overtime limits, regular overtime and double-overtime tiers, and overtime visibility in Team Hours. The Payroll dashboard calculates overtime pay and gross pay from employee hourly cost and tracked time when the Overtime app is enabled.

Turn overtime records into invoices

Use a template for quick checks, then move repeat approvals into Everhour so approved billable time becomes invoice-ready with rates, expenses, exclusions, and accounting exports connected.

14-day free trial  ·  No credit card  ·  Cancel anytime

Or