Overtime tracking sheet

Everhour supports approved time records and overtime review, while a tracking sheet helps organize the weekly calculation.

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 overtime tracking sheets work

What this calculation answers

An overtime tracking sheet answers a practical payroll question: how many hours in a fixed workweek are regular hours, and how many are overtime hours. For the United States federal baseline, the FLSA requires covered nonexempt employees to receive overtime pay for hours worked over 40 in a fixed 168-hour workweek, unless a more protective state rule or agreement gives the employee greater rights.

The sheet should show the workweek start and end dates, daily hours worked, total hours worked, regular hours, overtime hours, regular rate, overtime rate, and gross pay. Do not average two workweeks together. Under the FLSA, each workweek stands alone, even when payroll is run every two weeks or twice per month.

Build the weekly formula

For a simple hourly case, separate the first 40 hours from hours over 40. Regular pay equals regular hours multiplied by the regular rate. Overtime pay equals overtime hours multiplied by at least 1.5 times the regular rate. Total gross pay equals regular pay plus overtime pay.

Example: a covered nonexempt employee works 45 hours in one fixed FLSA workweek at a $31.20 regular hourly rate. Regular hours are 40, overtime hours are 5, and the overtime rate is $46.80. Regular pay is $1,248.00, overtime pay is $234.00, and total gross pay is $1,482.00.

Track the right sheet columns

The most common sheet mistake is tracking pay-period totals without preserving the fixed workweek. A biweekly sheet can still work, but it needs separate weekly subtotals. If week one has 45 hours and week two has 35 hours, the federal baseline does not let payroll average them into two 40-hour weeks.

Add columns for paid time not worked, but keep them separate from hours actually worked. The FLSA does not require payment for time not worked, including vacations or holidays; those benefits are generally set by agreement, policy, representative or union contract, or state law. Holiday or vacation pay can belong on payroll, but it should not silently inflate hours worked in the overtime calculation.

When sheets need workflow

A one-off sheet is enough when you are checking one employee, one completed workweek, and one straightforward hourly rate. Use it to explain a correction before payroll runs. The sheet becomes fragile when multiple employees submit late edits, managers need approvals, or payroll needs a record showing who reviewed the time.

A managed workflow is better when overtime review needs rules and accountability. Everhour Team Management supports approval workflows, locked periods, admin time correction, personal tracking limits, weekly capacity, roles, project assignments, team groups, and team-wide time policy defaults, so the overtime calculation starts from reviewed time instead of a loose 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 should an overtime tracking sheet calculate?

It should calculate total hours worked in the fixed workweek, regular hours, overtime hours, the regular rate, the overtime rate, regular pay, overtime pay, and total gross pay. For the FLSA federal baseline, covered nonexempt employees receive overtime for hours worked over 40 in a workweek at not less than 1.5 times the regular rate.

Can one sheet cover a biweekly pay period?

Yes, but the sheet must keep each FLSA workweek separate. A biweekly payroll period can contain two weekly calculations, not one blended total. Hours cannot be averaged over two or more workweeks to avoid overtime, so each seven-consecutive-day workweek needs its own subtotal and overtime line.

Should weekends and holidays have separate columns?

Separate columns can help explain the schedule, but 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 over 40 in the workweek unless another law, policy, contract, or agreement gives the employee a greater benefit.

Where should bonuses or extra compensation go?

Extra compensation that belongs in the regular rate should be included in total compensation for the workweek before dividing by total hours actually worked, excluding statutory exclusions. That regular-rate step matters because overtime is based on the regular rate, not always the base hourly rate shown in the employee profile.

What sheet mistake causes payroll corrections?

The biggest mistake is editing daily entries after approval without leaving a review trail. A changed start time, deleted break, or moved shift can alter weekly overtime even when the total pay-period hours still look reasonable. Lock completed periods or require manager review before using the sheet for payroll.

How does Everhour support overtime sheet controls?

Everhour Team Management gives admins lock rules, approval workflows, admin time correction, personal tracking limits, weekly capacity, roles, project assignments, team groups, and team-wide time policy defaults. Those controls help turn weekly overtime review into an approved record instead of a spreadsheet that can change after payroll review.

How does Everhour show overtime for payroll review?

Everhour Overtimes can use daily and weekly overtime limits, regular, 1.5x, and 2x tiers, and overtime visibility in Team Hours. When the Overtime app is enabled, the Payroll dashboard can calculate overtime pay and gross pay from employee hourly cost and tracked time.

Replace sheet checks with approvals

Track submitted hours, corrections, approvals, and locked periods before overtime reaches payroll. Everhour Team Management keeps the review process controlled and gives teams cleaner overtime records.

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

Or