Free Semi-Monthly Timesheet Template(Excel, Google Sheets, PDF)
A semi-monthly timesheet template is a specialized payroll document designed for organizations that pay employees twice per month (typically the 1st through the 15th and the 16th through the final day of the month), totaling 24 pay periods annually. Featuring dynamic formulas, it adapts to varying month-end lengths (28, 29, 30, or 31 days), subtracts unpaid lunch breaks, and segregates standard 40-hour weekly work intervals to ensure compliance with FLSA overtime laws.
| Date | Day | Time In | Lunch Out | Lunch In | Time Out | Reg. Hrs | OT Hrs | Total |
|---|---|---|---|---|---|---|---|---|
| Oct 01 | Thu | 08:00 AM | 12:00 PM | 12:30 PM | 05:00 PM | 8.00 | 0.50 | 8.50 |
| Oct 02 | Fri | 08:00 AM | 12:00 PM | 12:30 PM | 04:30 PM | 8.00 | 0.00 | 8.00 |
| Period 1 Totals: | 80.00 | 6.50 | 86.50 | |||||
Template Architecture & Formula Design
Dynamic month-end logic, break deductions, and FLSA weekly split formulas.
Dynamic Month-End Logic
Automatically populates row dates for Period 2 (16th–End of Month) and hides non-existent dates (such as February 29th, 30th, or 31st), preventing invalid payroll entries.
Elapsed Shift Net Duration
Calculates total worked duration by subtracting the unpaid lunch window (Lunch In - Lunch Out) from gross shift time, converting the result into base-10 decimal hours.
FLSA Workweek Overtime Isolation
Organizes daily logs into consecutive 7-day FLSA workweeks rather than aggregating the entire 15-day period, ensuring overtime thresholds are legally accurate.
Step-by-Step Payroll Workflow
Select Pay Period Range & Enter Identifiers
Select Period 1 (1st–15th) or Period 2 (16th–EOM). Enter employee legal name, ID, department, manager, and base hourly rate. The template populates correct calendar dates automatically.
Log Daily Shift Intervals and Meal Deductions
Record daily clock-in, lunch departure, lunch return, and end-of-day clock-out timestamps in 12-hour AM/PM format.
Review Split-Week Overtime Allocations
Verify hours worked against your company’s designated standard 7-day workweek. Check that hours exceeding 40 within any single workweek populate into the overtime column.
Execute Sign-Off and Archive for Payroll
Employee and supervisor review final decimal hour totals and sign the verification block. Completed records are exported to PDF or transferred to your payroll processing system.
Semi-Monthly vs. Biweekly Payroll Analysis
Compare 24 annual pay periods (semi-monthly) against 26 pay periods (biweekly).
| Operational Dimension | Semi-Monthly Payroll (24 Pay Periods) | Biweekly Payroll (26 Pay Periods) |
|---|---|---|
| Pay Schedule | Twice per month (e.g., 15th & Last Day) | Every two weeks (e.g., Every other Friday) |
| Annual Payroll Runs | Exactly 24 pay cycles per year | 26 pay cycles per year (27 every 11 years) |
| Employee Cash Flow | Consistent monthly budgeting dates | Variable calendar payment dates |
| Benefits Deductions | Evenly split twice per month (1/24th each) | Requires deductions across 24 or 26 cycles |
| Hourly Overtime Complexity | High (Pay period cuts across 7-day workweeks) | Low (Pay period always equals 2 full workweeks) |
| Best Suited For | Salaried employees & predictable cash flow | Hourly workers & shift-based workforces |
The Split-Week Trap: Why You Cannot Average Overtime Across 15 Days
The most common legal violation in semi-monthly payroll is averaging overtime across the entire 15-day pay cycle. Under Fair Labor Standards Act (FLSA) regulations (29 CFR § 778.104), an employee's workweek is a fixed and regularly recurring period of 168 hours—seven consecutive 24-hour periods.
Because semi-monthly pay periods divide the calendar by the 15th, a pay period boundary often cuts directly through the middle of a standard workweek. If an employee works 30 hours in the first half of the workweek (falling into Period 1) and 20 hours in the second half (falling into Period 2), the 10 hours of overtime must be credited to that specific workweek, not erased by the pay period boundary. Our template includes workweek allocation columns to prevent this compliance failure.
Why Growing Companies Upgrade from Spreadsheets to Automated Software
While static templates are useful for small teams, managing split-workweek overtime and varying month-end dates across 10 or more hourly employees creates substantial administrative drag. According to payroll benchmark studies, payroll administrators spend an average of 4.2 hours per cycle validating split-week timecards, resolving formula errors, and re-entering data into accounting systems.
- Complex split-workweek formulas
- Variable month-end day errors
- Manual collection across teams
- Manual re-keying into payroll
- Zero real-time project WIP
- Automated FLSA workweek tracking
- Dynamic month-end calculations
- 1-click mobile timecard submit
- 1-click sync to QuickBooks & GL (Sage Intacct)
- Live project margin realization + employee expense management
Ready to automate semi-monthly time and overtime calculations?
Track hours accurately across workweeks, eliminate month-end formula errors, and sync with accounting using our time and billing software.
Get Started FreeRelated Programmatic Templates & Tools
Biweekly Timesheet
14-day 80-hour template for companies operating on 26 annual pay periods.
Download Biweekly TemplateWeekly Timesheet
7-day single-week timecards for fast, weekly hourly payroll cycles.
Download Weekly TemplateDaily Hourly Timesheet
Granular task-based daily log for consultants and client billable hours.
Download Daily Hourly TemplateTime Clock Calculator
Convert clock-in/out timestamps to decimal hours and gross payroll pay.
Use Time Clock CalculatorQuestions about semi-monthly payroll
What is a semi-monthly pay schedule?
How does overtime work on a semi-monthly timesheet?
How do I handle varying month lengths (28, 30, 31 days) in Excel?
Why do some employers prefer semi-monthly over biweekly payroll?
Stop Manually Calculating Split-Week Overtime
Eliminate month-end formula errors, manual payroll reconciliations, and FLSA overtime risks. Upgrade to TimeTrackerOn to collect, approve, and sync semi-monthly timesheets directly into your accounting software.