Timesheet authorisation system in SharePoint
Problem:
Timesheet information from employees taking one person hours and hours to collect, receive authorisation from managers, collate for wages and do input for project reporting purposes.
Solution:
Use SharePoint to allow employees to create their time sheet from the Staff intranet.
- Use the existing Excel templates that they are familiar with.
- Automatically email managers when the time sheet is complete.
- Email contains a link for managers to view, authorise or reject the time sheet.
- Employee emailed on rejection.
- Accounts emailed on authorisation for final check.
- Data transferred into SharePoint list and spreadsheet stored in library for future reference.
- Cost allocation for time automatically calculated (rate per employee) and moved to project tracking system.
- Spreadsheet with automatic update collates months information for payroll.
Additional Benefits:
Excel spread sheet for collating sickness no longer required, collation of overnight stays for on-site staff no longer required.