Timesheets: Missing Timesheet

Modified on Wed, 02 Aug 2023 at 08:41 PM

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
Missing WeekThe week the timesheet is missing for.
ResourceThe name of the resource whose timesheet is missing for that week.
ResourceIdThe resource Fluid unique ID.
ResourceRefThe resource username.
ManagerThe resource's manager.
ManagerIdThe resource's manager Fluid unique ID.
ManagerRefThe 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.
ProfileRoleThe resource's profile role. 
EngagementTypeThe resource's engagement type.
CostCentreThe resource's cost centre.
ClassificationThe resource's rate card.
PortfolioThe resource's portfolio.
SubPortfolioThe resource's subportfolio.
TimesheetStatusThe 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

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article