Please note that this is not a regular spreadsheet template. This is a pre-made Sheetgo spreadsheet-based workflow, which is basically a ready-to-use system based on Google Sheets and operated by Sheetgo.

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 timesheet template

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

It is requested to sign in with your Google account and after authorizing a few steps, your Sheetgo account is also automatically created. Consequently, you are redirected to the Sheetgo web app from which you can easily install the timesheet template for Google Sheets.

Example

Timesheet Management Template Overview on Sheetgo

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 you can see on the Network View below.

Example

Network Illustration of Timesheet Management Template Workflow

Step 3: Share the timesheets with your colleagues

You can find the master sheet “Timesheet Management” and 3 “Colleague #” spreadsheets. Access this folder in your Google Drive Folder > Sheetgo Templates > Timesheet Management > Colleagues. Share the “Colleague #” spreadsheets with your colleagues. Firstly, each colleague should rename the spreadsheet. For example “John Smith Timesheet”.

The “Timesheet Report” tab is the tab where each colleague registers all the work done per project and task. The data in the master spreadsheet automatically generates the project and task names meaning that each colleague should align with the manager whether or not their tasks and projects are up-to-date.

Example

Spreadsheet Shared with Colleague in Google Sheets

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, and the Timesheet Report coming from the separate Colleague spreadsheets. Above all, it creates 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 then simultaneously populates into the colleagues’ spreadsheets. As a result, each colleague can choose their projects and tasks from a dropdown.

Example

Timesheet Management: Input Projects and Tasks in Google Sheets

Step 5: Update the Timesheet Report and Dashboard

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

Step 6: Manager consults the timesheet dashboard

The manager now automatically receives the Timesheet Reports of all colleagues. On the dashboard, he can therefore easily consult the projects and tasks per colleague, how far in the process they are and how much time it takes.

Example

Timesheet Management Template Dashboard in Google Sheets

Congrats! 🙂

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

Share This