What's in the template
One list with the columns most teams start with: Employee, Week starting, Date, Project, Task, Hours, Billable, Notes and Status. Three example rows show how a week looks once people fill it in. Delete them before your team starts.
Set it up in SharePoint
- Open the SharePoint site where your team works, select New, then List, then From CSV.
- Upload the template. Before you create the list, check the column types SharePoint suggests: Date and Week starting as dates, Hours as a number, Billable as yes or no, and Status as a choice of Draft, Submitted and Approved.
- Create a view called My time that filters on Created By equal to [Me], so people see their own entries first.
- Create a view called This week by person that groups by Employee and shows the total of Hours, so a manager can check the week at a glance.
- Share the site with the people who log time.
When a list stops being enough
A list works well for a small team that trusts each other's numbers. As the team grows, the same questions come up. Who approved this week? Why did someone's hours change after payroll ran? Why can everyone see everyone else's time? Adding approvals, locks and reports to a list means building and maintaining flows, permissions and views yourself.
That's the gap Timesheet for SharePoint fills. It runs on a SharePoint page too, with a weekly grid, manager approvals, approved weeks that stay locked, and reports you can export for payroll. Your data still lives in lists in your own site.