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
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.
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.
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 >
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.
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.
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
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.
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.