Timesheet and Pay Calculator
The time log: one row per shift, hours worked out
The pay run for a pay period
A pay slip for each person, and a paper timesheet
Overtime worked out week by week
The dashboard: hours, overtime and gross pay
What's inside: the file, an example and the guide
1 / 7

Timesheet & Pay Calculator

Log each shift and get everyone's hours, weekly overtime and gross pay for every pay period.

  • Ready-made workbook
  • Filled-in example
  • 8page guide

You need: Microsoft Excel (Windows or Mac) or Google Sheets. Any PDF reader for the guide.

Licence: For use in your own business. You may not share, resell, upload or distribute these files, or copy them to make tools of your own. Full terms · More questions

It helps you

  • Turn shifts into hours, with unpaid breaks and shifts past midnight
  • Work out overtime week by week, with your own threshold and rate
  • See everyone's gross pay for each pay period, every week or every 2 weeks
  • Print a pay run for your records and a pay slip for each person

What you get

  • Your file: Time Log, Team, Pay Run, Pay Slip, Paper Timesheet and Dashboard
  • The same file filled in for an example team, to learn from
  • An 8-page beginner’s guide (PDF)

Results use your own numbers. Check the current fees and tax rules for your business before deciding.

Goes well with