Timesheet Export

Modified on Mon, 23 Dec, 2024 at 6:24 PM

Line or team managers can use the timesheet export functionality to export all submitted timesheets for the selected period.

You can export data for between different date ranges within custom time span.

The timesheet export can be downloaded from the My Team page.

Column Description

The following table provides descriptions on the different columns that are included in the timesheet export file.

Column & Title	Description
Resource	The resource's name.
ResourceId	The resource's Fluid unique ID.
ResourceRef	The resource's username.
Correction	Indicates whether the timesheet was a correction or not.
WeekStart	The start of the timesheet week.
WeekEnd	The end of the timesheet week.
WeekTotal	The total number of hours booked for the timesheet week.
Monday	The total number of hours booked for Monday.
Tuesday	The total number of hours booked for Tuesday.
Wednesday	The total number of hours booked for Wednesday.
Thursday	The total number of hours booked for Thursday.
Friday	The total number of hours booked for Friday.
Saturday	The total number of hours booked for Saturday.
Sunday	The total number of hours booked for Sunday.
Project	The project the time was booked against.
Subactivity	The activity the time time was booked against.
Financial Reference	The financial identifier associated with the resource.
Is Overtime	Indicates whether an overtime allowance applies to the time booked. Note: this column is only shown if timesheets have been configured to support overtime hours.
Notes	Any notes added to the time booked against the project.
Status	The timesheet status.
AutoAdded	Indicates whether a project resource allocation is associated to this timesheet entry.
IsCapex	Indicates whether the timesheet actuals are capex or opex.
ProjectId	The unique ID of the project that the time is booked against.
ProjectRef	The project's external reference.
Alternative Reference	The project's alternative reference.
Project Cost Center	The organisational department/area which incurs the cost of the project.
Region	The region set up on the resource record.
EngagementType	The resource engagement.
Resource Cost Center	The resource cost center.
Allocation	The maximum allocation that can be made for the resource as a percentage of 1 FTE (100% allocated). When allocating the resource to projects any allocation above this percentage will be considered an overallocation.
Classification	The resource rate card at the time of the timesheet submission.
Manager	The resource manager.
ManagerId	The resource manager Fluid ID.
ManagerRef	The resource manager username.
Accountable Executive 1	The accountable executive who holds ultimate responsibility for the allocation and management of the resource.
Accountable Executive 1 Id	The unique ID of the accountable executive.
Accountable Executive 1 Ref	The accountable executive external reference.
Accountable Executive 2	The second accountable executive who holds ultimate responsibility for the allocation and management of the resource.
Accountable Executive 2 Id	The unique ID of the accountable executive.
Accountable Executive 2 Ref	The accountable executive external reference.
Division	The division the resource belongs to.
Department	The department the resource belongs to.
Team	The team the resource belongs to.
CreatedBy	The name of the user who created the timesheet.
CreatedById	The unique ID of the user who created the timesheet.
CreatedByRef	The username of the user who created the timesheet.
Created	The date the timesheet was created on.
ModifiedBy	The name of the user who last updated the timesheet.
ModifiedById	The unique ID of the user who last updated the timesheet.
ModifiedByRef	The username of the user who last updated the timesheet.
Modified	The date the timesheet was last updated.

Timesheet Export

Column Description

Column & Title

Description