WorkGuru supports importing timesheets into projects via a import spreadsheet template. This is handy if you capture your timesheets in a third-party system but still need to track time on projects. Importing timesheets is managed from the timesheet dashboard.
Create or modify an existing timesheet export to match the WorkGuru timesheet import template. Import template fields descriptions:
| User | WorkGuru username of the staff member the timesheet will be attributed to. | Required |
| Project | WorkGuru Project Number the timesheet will be attributed to. | Required |
| Task | Project Task the timesheet time is being assigned to. The task MUST already exist on the project or an import error message will appear. | Required |
| Length | Total number of hours in a decimal format. Eg: 15min = 0.25. | Required |
| Date | Start date and time (daily) or date (weekly) timesheet entry occurred. Must be "DD/MM/YYYY HH:MM" format. Note: If you are using the weekly timesheet method, HH:MM is not required. | Required |
From the timesheets dashboard and click the Import Timesheets button.
Click Choose file and select the timesheet import template. Click Save to import timesheets.
The timesheet will be imported. If you are using the daily timesheet method, the finish time is calculated from the start date/time + the duration.