8 Free Templates
Free Payroll & HR Templates for Excel & Google Sheets
Payroll calculators, timesheets, leave trackers, and employee management tools.
About These Payroll & HR Templates
Payroll calculators, timesheets, leave trackers, and employee management tools. Each template includes a dashboard with key metrics, formula-driven calculations, and realistic sample data. Download any template instantly - they work in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required.
All Payroll & HR Templates
Employee Payroll
Hours against a rate gives gross pay, the deductions you enter come off it, and net pay follows on the same line. The Free Employee Payroll spreadsheet template holds fourteen people on one working sheet and carries a strip for the whole run - gross payroll, deductions, net payroll - with no rates built into the file. A How to Use guide sits on a second tab. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Payslip Template
Enter the hours, the rates they are paid at, a bonus and the deduction percentages, and gross pay, each deduction and net pay come back on the same sheet. The Free Payslip Template template works out regular pay and overtime pay separately before gross, applies four percentage deductions at rates you set, and takes a flat insurance amount that does not move with gross pay. Ten inputs, ten results. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Weekly Timesheet
Fourteen entries across a week, each recording the day, the project, a start and an end. The Free Weekly Timesheet spreadsheet template reads the hours off the clock as end time less start time on every row, takes a rate per row so work that pays differently shares the same week, and works the pay out line by line. One working sheet and a How to Use tab. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Time Card Calculator
Ten shifts on one card, each with a time in, a time out, a lunch break and its own rate, so shifts that pay differently share a single sheet. The Free Time Card Calculator spreadsheet template works the hours out from the clock times and the pay from that row's rate, then totals both in a strip above. How to Use on a second tab. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Vacation / PTO Tracker
Twelve rows, one per person, with what each has accrued and what they have taken side by side, the balance worked out between them, and the date they are next away. The Free Vacation / PTO Tracker spreadsheet template totals accrued, used and remaining for the team at the foot, and repeats the accrued and used totals in a strip above. A balance sheet for time off rather than a request system. Google Sheets or Excel. No macros, no VBA, no sign-up.
Employee Leave Tracker
A row per absence: who took it, the date, the leave type, the day count, and whether it is signed off - yes, no, or still pending. The Free Employee Leave Tracker spreadsheet template holds 16 records on one working sheet, totals the days and counts the entries in a strip above, and leaves the leave types as free text so your own categories work. How to Use sits on a second tab. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Expense Reimbursement Form
A claimant block at the top, a submit-to block facing the other way, and ten itemised lines between them carrying a category, a quantity and a rate each. The Free Expense Reimbursement Form spreadsheet template adds a report number, the trip or period covered, an approval line and the total claimed. It asks to be paid back rather than billing anyone. One working sheet, Google Sheets or Excel. No macros, no VBA, no sign-up.
Take-Home Pay Calculator
A salary goes in, and so do the rates that apply to you - every tax and contribution rate is an input you fill in rather than a figure baked in. Income tax sits at national and regional level as separate rates, payroll contributions as one combined rate, and a retirement contribution as a share of gross. The Free Take-Home Pay Calculator spreadsheet template returns each deduction plus annual and monthly take-home on one working sheet. Google Sheets or Excel. No macros, no VBA, no sign-up.
Need more advanced features?
Our premium spreadsheet templates include multi-sheet dashboards, advanced formulas, native charts, and ongoing updates.