How is overtime calculated?

Hours above your weekly threshold in each workweek are paid at the multiplier. Under the U.S. FLSA that's generally 40 hours at 1.5×; Ontario's ESA uses 44.

Why does the workweek matter?

Overtime is counted per workweek, which can start on any day and can differ from your pay period.

Log them in the Tips column; they're kept separate from hourly gross.

Free template · Excel & Google Sheets

Free Work Hours & Paycheck Checker Spreadsheet (Excel & Google Sheets)

Fifteen unpaid minutes a shift at $25 an hour is over $1,600 a year. This sheet is how you find out whether it's happening to you.

⬇ Download the .xlsx Or use the EarnCheck app

No sign-up, no email. Opens in Excel, Google Sheets, Apple Numbers and LibreOffice.

What's inside

Overnight shifts handled correctly
Weekly overtime with your own threshold and multiplier
Workweek that matches your employer, not the calendar
Expected gross vs pay-stub gross, line by line
Stacked chart of regular vs overtime hours

Preview

Yellow cells are the ones you type in. Everything else calculates.

Workweek	Hours	Regular	Overtime	Expected	Pay stub	Status
8 Nov	44.5	40	4.5	$1,051.88	$1,000.00	Difference to review

How to use it

In Settings, set your hourly rate, overtime threshold (40 U.S. federal, 44 Ontario) and the day your workweek starts.
After each shift, type the date, start, end and unpaid break.
Workweeks list themselves on Paycheck Check. Type the gross from each pay stub.
'Difference to review' means the numbers don't match — check hours, rates and premiums before raising it.

Using Google Sheets?

Upload the file to Google Drive, then open it with Google Sheets. Formulas, drop-downs and colour rules carry over.

An estimate tool. Your contract, collective agreement or local law may add daily overtime or premiums this sheet doesn't model.

EarnCheck: Shift & Pay Tracker

EarnCheck confirms shifts in one tap, shows the math behind every amount, and compares your stub line by line — regular, overtime and premiums separately.

Get it on the App Store

Questions people ask

How is overtime calculated?: Hours above your weekly threshold in each workweek are paid at the multiplier. Under the U.S. FLSA that's generally 40 hours at 1.5×; Ontario's ESA uses 44.
Why does the workweek matter?: Overtime is counted per workweek, which can start on any day and can differ from your pay period.
What about tips?: Log them in the Tips column; they're kept separate from hourly gross.

Share or reuse

This template is free to use, share and adapt under CC BY 4.0. If you post it on your site, please link back to this page.