Ultimate Payroll & HR Templates
3 advanced payroll & hr templates for Excel and Google Sheets.
Employee Payroll Ultimate
Twenty people on a roster with position, department, pay type, rate and status, salaried and hourly in the same list. The Ultimate Employee Payroll spreadsheet template runs Monthly Payroll across every department for twelve months, estimates each person's annual tax with the employer's own contributions worked separately, and lets a status drop someone from the figures without deleting the record. Six working sheets. Google Sheets and Excel, one file.
Weekly Timesheet
Fifteen people, each with the seven days of the week and a rate of their own, so the labour cost is not built on an average. The Ultimate Weekly Timesheet spreadsheet template splits regular from overtime for every person, allocates the hours across eight projects, costs each project at its own blended rate with its share of the total, and rolls four weeks into a month. Six working sheets. Google Sheets and Excel, one file. No macros, no VBA.
Vacation / PTO Tracker
A roster holds department, start date, allowance, carry-over and a daily rate for every employee, and total available comes from allowance plus carry-over. The Ultimate Vacation / PTO Tracker spreadsheet template logs requests with dropdowns for employee, type and status, an approver and notes on each, and pulls used days from the approved entries rather than typed ones. Monthly accrual, low-balance flags and the value of unused days, counted in days. Six working sheets, Google Sheets and Excel. No macros, no VBA.
Looking for free templates?
We also offer free payroll & hr templates with basic features. Try them first, then upgrade to Ultimate.