Hourly Payroll Calculator Template (Excel)
Gross pay from regular, overtime and double-time hours with FICA and an estimated withholding rate to net pay.
Updated 2026-10-20
Excel any
- Regular, OT and DT pay
- Social Security and Medicare
- Estimated withholding rate
- Net pay
Prefer not to use a spreadsheet? Use the calculator instead.
Gross pay from regular, overtime and double-time hours with FICA and an estimated withholding rate to net pay.
How it works
Gross pay is rate x regular + rate x 1.5 x OT + rate x 2 x DT. Pre-tax deductions come off before Social Security (6.2%) and Medicare (1.45%) are applied. Federal and state withholding use a flat percentage you set, which is a simplification: real withholding follows the 2026 IRS percentage method with brackets and the standard deduction. Use the Hourly Paycheck Calculator for a bracket-based estimate and this sheet for quick what-ifs.