Log daily, not on Friday afternoon
Hours written down the same day are close to right. Hours rebuilt from memory at the end of the week are mostly guesses.
Free template
Project timesheet template
Hours per person, per project, per day, with totals that add themselves up. The numbers you need for invoices, budgets and the next estimate.
Free, no signup. Opens in Excel, Google Sheets and Numbers.
Imports asHours
What is in the template
Example data. Delete it before you add your own.
| Team member | Date | Project | Hours | Notes |
|---|---|---|---|---|
| Sanne de Vries | 2026-11-16 | Website relaunch | 4 | Planning review and client call |
| Sanne de Vries | 2026-11-16 | CRM rollout | 4 | Pilot preparation |
| Sanne de Vries | 2026-11-17 | CRM rollout | 6 | Sales training material |
| Sanne de Vries | 2026-11-18 | Website relaunch | 3 | Change request for extra templates |
| Joris Bakker | 2026-11-16 | Website relaunch | 7.5 | Page templates |
| Joris Bakker | 2026-11-17 | Website relaunch | 6 | Contact forms |
| Joris Bakker | 2026-11-17 | CRM rollout | 2 | Pilot environment fixes |
| Joris Bakker | 2026-11-18 | CRM rollout | 8 | Single sign on issue |
| Amira El Idrissi | 2026-11-16 | Website relaunch | 6 | Content mapping |
| Amira El Idrissi | 2026-11-17 | Website relaunch | 6.5 | Sample migration of 50 pages |
How to use it
Add one row per person, per project, per day. Two projects on one day means two rows.
Use the project name exactly as in your portfolio, so the totals land on the right project.
Write a short note on what the hours were for. It saves a lot of questions when the invoice goes out.
Check the Summary tab at the end of each week for hours per person per project.
What each column means
- Team member
- Full name, spelled the same every time.
- Date
- The day the work was done.
- Project
- The exact project name. The import uses it to put each row on the right project.
- Hours
- Hours worked that day on that project, such as 6 or 7.5.
- Notes
- What the hours were spent on.
How to get timesheets people actually fill in
Per project is enough
Asking for hours per task makes people round and guess. Hours per project with a short note are accurate enough for budgets and invoices.
Show people what the hours are used for
Timesheets get filled in when people see the result, such as a project that got extra budget because the hours proved it was needed.
When the timesheet stops being enough
A timesheet tells you where hours went, but turning them into cost and comparing them with the plan is still manual work. In Vaizy people log hours against the deliverables they work on, and those hours turn into cost at their rate and into progress against the estimate.
See team and hours in VaizyImport it into Vaizy
Start a free trial and open the import dialog from the dashboard.
Drop in the file. Vaizy recognises the columns and maps them for you.
Check the preview and import. Nothing is saved until you confirm.
Questions about this template
Who worked, on which day, on which project, for how many hours, with a short note. That is enough for invoices, budget tracking and better estimates.
Per project is enough for most teams. Hours per task cost more time to log than they save, unless you bill per task.
Yes. The Timesheet tab imports as logged hours per team member, date and project. Names are matched to the people in your Vaizy team.
More free templates
Outgrown the spreadsheet?
Import this template into Vaizy and see it next to your milestones, team and budget. Free for 14 days, no credit card needed.