HR and rota templates
Track hours, overtime and pay, and put together the weekly rota for your team, with spreadsheets made for small UK employers.
These templates cover the two things every small team needs written down: who worked how long, and who is in when. The timesheet turns start, finish and unpaid break times into daily hours, including night shifts, splits the week into contracted hours and overtime, and estimates gross pay from an hourly rate and an overtime multiplier. The staff rota uses shift codes in drop-down lists, works out hours per person and shows how many staff are on each shift so you can spot gaps before the week starts.
Every file uses dd/mm/yyyy dates and A4 paper, and works in Excel, Excel for Mac, Google Sheets and LibreOffice without macros. Download the .xlsx or make a copy in Google Sheets and keep one sheet per week.