Payroll Data Entry tracking and reporting

Sargeqb7

Hello, I have a payroll template that we use that consists of Straight time hours, Overtime hours, Job number, and job area. Does anyone know how I can set up a template for each day , week, month to report how many hours were worked on a particular job? the templates available are soo close to what I need but they always lack at least one key feature. Help Please!

TIA

Karoline from Sheetgo

Hi Justin,

Are you working with our Employee timesheet management template?

Sargeqb7

Karoline from Sheetgo I was trying, but it was not in a workable format that coincides with how we enter time.

Karoline from Sheetgo

I think we can adapt the “Attendance Management template” to deliver what you want. I’ll check with my team

Sargeqb7

Karoline from Sheetgo

Thank you! I can share my weekly timesheet… we have several job numbers and sometimes guys work on different jobs each day or week.. it would be great to be able to report hours on jobs per time windows. we have to report monthly our man hours. and when we look at our profit margins it would be great to be able to pull up total hours per project via job number.

Karoline from Sheetgo

Sargeqb7 That would be great! Please share with me at karoline@sheetgo.com

Sargeqb7

Karoline from Sheetgo

shared. thank you

Sargeqb7

Sargeqb7 what do i do next?

Karoline from Sheetgo

Sargeqb7 Hi there! We’re working on it! :)

Sargeqb7

Karoline from Sheetgo

Thank you

Karoline from Sheetgo

Sargeqb7 Justin, Happy new year!

So, if you change a little bit your spreadsheet you can use this template here to track your employees
Attendance Management Template

Of course, they need some customization, but instead of History or Maths, you can track the months of the year.