Staff
A free payroll template Excel file shows how to use a payroll template in Excel. It multiplies hours by rate and subtracts a deduction you already know. The sample pay period is the week of March 2, 2026, for three hourly people at Harbor Goods. Amina Rahman worked 30 hours at $18. Gross is $540. The typed deduction is $65, so net is $475. Chris Doyle worked 35 hours at $17, gross $595, deduction $70. Priya Shah worked 34 hours at $16.50, gross $561, deduction $60.
Those deductions are placeholders so you can see subtraction. They are not a tax table.
The free payroll template Excel file does not look up tax. You type the deduction your accountant, your payroll service, or your own written rule already gave you. Gross and net are green. If Chris works 36 hours instead of 35, gross becomes $612 and net becomes $542 while the deduction stays $70. The sheet will not change the deduction for you.
Check the free Excel timesheet template before you type hours here. The free employee schedule template is the plan, and it can still be wrong. Luis Ortega is on the rota for 30 hours in the sample week and is not in this pay example. Read the disclaimer before you treat a net-pay cell as the amount you must pay. This is a calculator, not a payroll service.
Open the free payroll template. The other staff guides are on the blog.
Workbooks for a small shop, a freelancer, or a contractor. Sample amounts are in dollars.
Yes. The free payroll template multiplies hours by rate and subtracts the deduction you type.
No. You type the deduction. The sheet does not look up a tax table.
From the timesheet, after you have checked them. Do not copy a rota that is still wrong.