Why track employee time per project?

Most HR departments and small business owners have the challenge of tracking employee time per task. However, this mission is critical in order to allocate costs to tasks and budget for future projects. Us at Sheetgo love automation and connecting spreadsheets, we develop real solutions that we use in our business, and then we share them with you so you use our tools as effectively as possible. We have created an easy to implement, customizable timesheet template that allows you to track the hours and progress on tasks of multiple employees.

Let’s get you started

Step 1: Install the template

To install the Sheetgo timesheet template in Google Sheets, click on the button below.

You will be asked to sign in with your Google account and after authorizing a few steps, your Sheetgo account will also automatically be created. This will lead you to the Sheetgo Web App from which you can easily install the timesheet template for Google Sheets.

Example

Step 2. Open all spreadsheets

Start using the template by clicking the spreadsheet icons. The different timesheets are stored in the “Colleagues” folder and consolidated into the master spreadsheet “Timesheet management”, as seen on the Network View below.

Example

Step 3: Share the Timesheets with your colleagues

After installing the template, inside your Google Drive, you will find 1 Master Sheet called “Timesheet Management” and 3 “Colleague #” spreadsheets. Access this folder by going to your Google Drive Folder > Sheetgo Templates > Timesheet Management > Colleagues. Share the “Colleague #” spreadsheets with your colleagues. Each person can rename the spreadsheet to their own name. For example “John Smith Timesheet”.

The “Timesheet Report” tab is the tab where each colleague can register all the work done per project and task. The project and task names are automatically generated from the manager spreadsheet so they will need to ask the manager if they need to have different project or tasks names.

Example

Step 4: Input Projects and Tasks

Open the Manager Sheet “Timesheet Management”. This template consists of an Instructions tab, a tab to fill out all the Projects and Tasks, the Timesheet Report coming from the separate Colleague spreadsheets, and a dashboard that gives you a clear overview of the hours worked on each task and per colleague. To start, fill out the “Projects and Tasks” tab. This data will automatically populate into the colleagues’ spreadsheets for them to choose these projects and tasks from a dropdown.

Example

Step 5: Update the Timesheet Report and Dashboard

To update the connection that Consolidates each colleague’s Timesheet Report to the Timesheet Management spreadsheet, go to the Sheetgo Web App > ‘Workflows‘ > ‘Timesheet Management‘ and click on play button ‘Run workflow’ to update the connection.

Step 6: Manager consults the timesheet dashboard

The Timesheet Reports of all colleagues are now automatically sent to the manager’s spreadsheet. On the dashboard, you can easily consult the projects and tasks per colleague, how far in the process they are and how much time it takes.

Example

Congrats! 🙂

That’s it! You’ve now set up your timesheet template in Google Sheets which allows you to assign projects to collaborators and allows collaborators to report their hours daily to you. The system is now yours. Feel free to customize it as you see necessary.

Share This