Skip to content
← All postsHow-to guides6 MIN READ

Free Biweekly Timesheet Template (Excel and PDF)

If you pay every two weeks, a biweekly timesheet keeps the paperwork aligned with the paycheck. This one tracks two full week blocks with daily hours, per-week totals, a period total, and the overtime trap handled correctly, which most biweekly templates get wrong.

JULY 29, 2026 · BY THE CLOX TEAM

If you pay every two weeks, a biweekly timesheet keeps the paperwork aligned with the paycheck. This one tracks two full week blocks with daily hours, per-week totals, a period total, and the overtime trap handled correctly, which most biweekly templates get wrong.

Biweekly timesheet template
Excel, two week blocks with per-week overtime.
Excel · 4 KB · Free to use and share
Download
All three templates, printable
PDF, one template per page, sized for a clipboard.
PDF · 4 KB · Free to use and share
Download

01

The biweekly overtime trap

Federal overtime computes per workweek, not per pay period. An 88-hour period made of a 50-hour week and a 38-hour week contains 10 hours of overtime, even though 88 is less than two 44s. A template that splits OT from the period total instead of per week underpays week one, and that's an underpayment. Underpayments turn into wage claims. This template runs the split inside each week block, then sums the period, so the math follows the weekly rule automatically.

02

How to use it

  1. Set the period start date in the header cell; both week blocks label themselves from it.
  2. Fill days exactly like the weekly template: in, out, break minutes, optional job.
  3. Read per-week regular and overtime from each block, and the period totals at the bottom.
  4. Anchor the start date to your actual pay period, not the calendar week, or week two of one sheet will overlap week one of the next.

03

When a spreadsheet stops working

Biweekly periods double the collection problem: two weeks of memory in one sheet means Friday-written Tuesdays, and the person doing payroll inherits a stack of them at once. Clox collects punches the moment they happen, splits overtime per week automatically, and exports the approved period straight into your payroll format. The pricing math stays one line at any pay frequency.

04

FAQ

Does this work for semimonthly pay?

No, and be careful with the difference. Semimonthly periods (1st to 15th) split workweeks across periods, which makes overtime genuinely tricky on paper. This template is for true biweekly, a fixed 14-day cycle.

Why does overtime compute per week and not per period?

Because federal law defines overtime on the workweek. The pay period only sets how often you pay. Overtime is still calculated per week.

Can I reuse it every period?

Yes. Duplicate the tab, change the start date, done.

Clox replaces the paper timesheet with one tap per punch. Free for 14 days, no credit card.

Keep reading

How-to guidesHow to Track Employee Hours for a Field Crew: The Complete MethodHow-to guidesHow to Stop Employees From Clocking In EarlyHow-to guidesHow to Prove Hours Worked When a Client or Employee Disputes Them

Friday becomes a review, not a reconstruction.

14 days free, no credit card30-day money-back guarantee$29/month includes your first 3 usersEvery feature on the one plan

Managers run Clox on the web. Crews clock in from their phones.