A payroll template helps you work out what each employee earns, what is deducted, and what lands in their bank account, without building the calculations from scratch. Below you can download three free payroll templates in Excel: an hourly payroll template with automatic overtime, a monthly payroll register for salaried staff with allowances, bonuses and deductions, and an annual payroll summary that adds up gross pay by employee and month and draws a chart.
Each template is an editable .xlsx file. Type the figures into the yellow cells and the gross pay, deductions, net pay and totals fill in automatically. The files also open in Google Sheets and LibreOffice Calc, and they print on a single page for your records.
What Is a Payroll Template?
A payroll template is a spreadsheet that records the pay of every employee for a pay period and calculates the amounts that depend on it. It usually starts with the hours worked or the monthly salary, adds overtime, allowances and bonuses to reach gross pay, subtracts taxes and other deductions, and ends with net pay, which is the amount the employee actually receives.
For a small business, a family company, a nonprofit or a freelancer who pays an assistant, a spreadsheet is often all that is needed. It keeps the numbers in one place, makes mistakes easy to spot and gives you a ready record at the end of the month or the year.
Why Use a Payroll Template in Excel?
- The math is done for you. Regular pay, overtime pay, gross pay, deductions and net pay are all calculated by formulas, so you only enter the inputs.
- Fewer mistakes. Typing the hours once and letting the sheet do the multiplication is far safer than using a calculator for every employee.
- Overtime is handled automatically. Set the overtime threshold and multiplier once and every row follows the rule.
- Totals are instant. You can see the total payroll cost and the total net pay at the bottom of the sheet.
- It creates a record. Save one file per pay period so you can answer questions about past payments later.
- It is easy to change. Add employees, rename columns or change the rates without breaking the formulas.
What to Include in a Payroll Template
- Employee details: name, ID number and department, so each row is easy to identify.
- Pay period: the dates covered, such as the week ending or the month.
- Pay rate or salary: an hourly rate for hourly staff or a basic monthly salary.
- Hours worked: regular hours and overtime hours, if employees are paid by the hour.
- Allowances and bonuses: extra payments added to the basic pay.
- Gross pay: total earnings before any deductions.
- Tax withholding: the income tax amount or percentage, using the rate that applies to you.
- Other deductions: insurance, benefits, retirement contributions or advances.
- Net pay: gross pay minus all deductions.
- Totals: column totals for the whole team, which show the real cost of payroll.
How Payroll Is Calculated
Payroll follows a simple chain of steps. First, find the regular pay: regular hours multiplied by the hourly rate. If an employee works more than the overtime threshold, the extra hours are paid at a higher rate, commonly one and a half times the normal rate. Add the two to get gross pay.
Next, subtract deductions. Income tax is usually a percentage of gross pay, and other deductions may be a percentage or a fixed amount. What remains is net pay. For example, an employee who earns $18.50 an hour and works 42 hours has 40 regular hours ($740.00) and 2 overtime hours ($55.50), for gross pay of $795.50 before deductions. The first template does this for every row.
For salaried employees, the chain starts with the basic monthly salary instead. Add allowances and any bonus to reach gross pay, apply the tax percentage, subtract insurance and other deductions, and you have net pay. The second template follows exactly this order.
Download the Free Payroll Templates
All three payroll templates are hosted on this website and are free to download. Each preview image matches the download button directly below it.
1. Simple Payroll Template With Overtime
An hourly payroll sheet for up to 15 employees. Enter the pay period end date and four settings at the top: the number of hours before overtime starts, the overtime multiplier, the tax withholding percentage and a second deduction percentage. Then list each employee with an hourly rate and the hours worked. The sheet splits regular and overtime hours, calculates regular pay and overtime pay, adds them to get gross pay, subtracts the deductions and shows net pay, with a totals row for the whole team.
2. Monthly Payroll Register
A register for salaried staff, with room for 14 employees. Each row holds an ID, name, department, basic salary, allowances, bonus, tax percentage, insurance or benefits, and other deductions. The register works out gross pay, tax and net pay for each person. Below the table it shows the number of employees, the total payroll cost (gross pay) and the total net pay going to employees, which is the figure you need when you transfer the salaries.
3. Annual Payroll Summary
A year view for twelve employees. Enter the gross pay for every employee in each month from January to December. The sheet adds a year total and a monthly average for each person, shows a monthly total for the business, and draws a column chart of total gross payroll by month, so a busy month or a change in headcount stands out immediately. It is a handy record for budgeting and for year-end reviews.
Tips for Using a Payroll Template
- Replace the sample rates. The tax and deduction percentages in the templates are examples. Use the rates and rules that apply in your country or state.
- Use the right pay period. Weekly, bi-weekly and monthly payroll need different settings, so decide on one and apply it consistently.
- Keep time records. Hours should come from a timesheet or a clock-in record, not memory. A timesheet makes disputes easy to resolve.
- Check totals before paying. Compare the net pay total with the amount you plan to transfer.
- Save a new file each period. Name files by month, such as payroll-2026-11, so you always have a clean history.
- Protect personal data. Salary information is private, so password-protect the file or store it in a secure folder.
- Review the sheet regularly. When a minimum wage, an overtime rule or a benefit changes, update the settings straight away.
How to Handle Overtime in Payroll
Overtime rules differ from country to country and sometimes by industry, so check the rules that apply to you. A common rule is that hours above 40 in a week are paid at one and a half times the regular rate. The first template lets you set both numbers in the yellow cells, so you can use 40 hours and 1.5, or a different threshold and multiplier such as 8 hours a day or a double-time rate.
Overtime is calculated per employee from the hours worked. If an employee works 38 hours, all of them are regular hours and overtime is zero. If they work 45, the first 40 are regular and the last five are paid at the overtime rate. Because the formula uses the larger of zero and the extra hours, you never get a negative overtime figure.
Gross Pay vs. Net Pay
Gross pay is the full amount an employee earns before anything is taken out. Net pay, often called take-home pay, is what remains after taxes and deductions. Employers need both numbers: gross pay shows the real cost of employing someone, while net pay shows the amount to transfer to their account.
Showing both on one sheet also helps employees understand their pay. If someone asks why the amount is lower than expected, you can point to the tax and deduction columns and explain each step. The monthly register keeps these columns side by side, which makes a pay slip easy to prepare from the same data.
How to Customize the Payroll Templates
To add an employee, type in the next empty row. The formulas are already in place for the blank rows, so the results appear as soon as you enter the data. To remove a person, clear the cells in that row. To change a rate, edit the yellow cell at the top of the sheet and every row updates.
You can rename a column, such as changing “Insurance / benefits” to “Pension”, without affecting the calculation. If you need another deduction, insert a column before Net pay and extend the net pay formula. For payroll in another currency, select the money cells and choose the currency format you need.
These templates are for record keeping and planning. Payroll rules, tax rates and filing duties vary by location and change over time, so check them with the tax authority or a qualified payroll professional before you pay employees.
You can also check these important templates like the salary slip template for giving employees a pay slip, the employee timesheet template for recording hours worked, and the payment voucher template for documenting each payment.
Frequently Asked Questions
What is a payroll template?
A payroll template is a spreadsheet that calculates employee pay for a pay period. It combines hours or salary, overtime, allowances and bonuses to find gross pay, subtracts taxes and deductions, and shows net pay and totals for the whole team.
How do I calculate payroll in Excel?
Multiply the hours worked by the hourly rate to find regular pay, add overtime pay for hours above the threshold, subtract tax and other deductions, and the result is net pay. The templates on this page do all of these steps with formulas.
Can I use this payroll template for salaried employees?
Yes. Use the monthly payroll register, which starts from a basic salary, adds allowances and bonuses, subtracts tax, insurance and other deductions, and calculates net pay for each person.
Are the tax rates in the templates correct for my country?
No. The percentages are sample values only. Replace them with the tax rates and deduction rules that apply in your country or state, and check them with a payroll professional if you are unsure.
How many employees can each template hold?
The simple payroll template holds 15 employees, the monthly register holds 14, and the annual summary holds 12. You can insert more rows and copy the formulas down if you need more.
