The ability to stay on track with each resource's progress ensures a smooth organisational process. As a timesheet administrator, keeping track of submitted/unsubmitted timesheets is important.
You can export missing timesheets from the Timesheet Administration page using:
- The export functionality on the Timesheet Compliance component,
- Or the export to Excel functionality under Tools.
Export Weekly Missing Timesheets
Use the Timesheet Compliance component to export the missing timesheets if you need the see who has not submitted their timesheets for a given week.
Simply click on the missing timesheet icon (red excel export option) against the week you need to missing timesheets for.
Export Missing Timesheets for a custom date range
If you need to export the missing timesheets for a specific date range, use the Missing Timesheets functionality under the Tools menu.
Missing timesheet option can be accessed via Export to Excel under Tools.
Select the date range you want the missing timesheets for and either download the report or get it emailed to you.
Field description of the missing timesheet report
Column & Title | Description |
| Missing Week | The week the timesheet is missing for. |
| Resource | The name of the resource whose timesheet is missing for that week. |
| ResourceId | The resource Fluid unique ID. |
| ResourceRef | The resource username. |
| Manager | The resource's manager. |
| ManagerId | The resource's manager Fluid unique ID. |
| ManagerRef | The resource's manager username. |
| Account Exec 1 | The accountable executive the resource report into. |
| Account Exec 1 Id | The accountable executive's unique ID. |
| Account Exec 1 Ref | The accountable executive external reference. |
| Account Exec 2 | The direct report of accountable executive the resource report into. |
| Account Exec 2 Id | The accountable executive 1's unique ID. |
| Account Exec 2 Ref | The accountable executive 1external reference. |
| ProfileRole | The resource's profile role. |
| EngagementType | The resource's engagement type. |
| CostCentre | The resource's cost centre. |
| Classification | The resource's rate card. |
| Portfolio | The resource's portfolio. |
| SubPortfolio | The resource's subportfolio. |
| TimesheetStatus | The status the timesheet is currently in (i.e Not Started, Open or Amend). |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article