Detailed Timesheet Report
The Detailed Timesheet report displays timesheet entries by employee and labor period. The report includes all information entered on the employee's timesheet.
If revision auditing is enabled for the employee, you can also include revision information on the report.
You can preview or print this report for one employee from the Timesheet form and for one or multiple employees from the Select Employee Timesheet dialog box. (If you generate it from the Select Employee Timesheet dialog box, the option to include revision information is not available.) You can use the Timesheet Audit Detail report (Reporting > Employee > Timesheet Audit Detail), a similar report, to review timesheets for multiple employees over multiple timesheet periods.
Contents
Timesheet Hours
Report Header: Timesheet Hours Tab
Column | Description |
---|---|
Employee |
The field displays the employee's identification number and name (Last Name, First Name). |
Signed/Approved |
If you selected Require electronic signature when submitting timesheets on the Setup tab of Company Timesheet Configuration, the name of the employee who submitted the timesheet displays under the Signed line and the name of the employee who approved the timesheet displays under the Approved line. If you are not using the electronic signature feature, these lines are blank. In either case, you can use the lines for handwritten signatures if you wish. The current status of the timesheet also displays in this section, as follows:
|
Organization |
If you are using the Organization Reporting feature, the code for the employee's assigned organization displays here. |
Report Columns: Timesheet Hours Tab
Column | Description |
---|---|
Project |
These columns display the number and name of the project to which the employee is charging time. Items in these columns display on the report in the following order:
|
Phase |
These columns display the number and name of the phase for which time was entered, if applicable. |
Task |
These columns display the number and name of the task for which time was entered, if applicable. |
Labor Code |
The labor code number to which the employee is charging time is shown below the project number and name (or the phase/task number if applicable). |
Labor Category |
The labor category for which the employee is charging time is shown below the labor code number, if applicable. Labor category information displays on the report only if you are using Vision Accounting, Vision Billing, or Vision Resource Planning. |
Payroll Tax Locale |
The project's payroll tax locale (for example, CA, MA, or NY) is shown below the labor category information, if applicable. Payroll tax locale information displays only if you selected Allow Project's tax locale to be overidden on Timesheet in Payroll Configuration and the employee's Locale Method is set to Follow Project Locale on the Payroll tab of the Employee Info Center. |
Client Name |
The name of the client associated with a project displays on the same row as the project name and number. The client name displays only if you selected Include client name on detailed timesheet report on the Setup tab of Company Timesheet Configuration. |
Comments |
If the employee has entered any comments about time charged to a specific project, phase, and/or task, the comments display below the Day/Date boxes for the associated project, phase, and or task. The comment is preceded by a date to indicate the charge to which the comment applies. Comments display only if you selected Include comments on detailed timesheet report on the Setup tab of Company Timesheet Configuration. The expanded text content in this field displays on the report if you select Include Comments on the Setup tab in Company Timesheet Configuration. |
Total ( Reg., Ovt, Ovt-2) |
In this section, the Total column displays total regular and/or overtime hours charged to each individual project, phase, and/or task for the selected labor period.
The Ovt and Ovt-2 boxes display only if overtime hours are entered on the timesheet. |
Day/Date |
There is a separate column on the report for each day in the selected labor period. Each column shows the day of the week and the corresponding calendar date. Within each column, there is a Reg., Ovt, and Ovt-2 box for each project on the timesheet report. These boxes show the regular, overtime, and secondary overtime hours the employee has charged to each project, phase, and/or task for each day in the labor period. The Ovt and Ovt-2 boxes display only if overtime hours are entered on the timesheet. |
Daily Totals Section: Timesheet Hours Tab |
|
Daily Totals |
In this section, the Total column displays total regular and/or overtime hours charged to all projects, phases, and/or tasks for the selected labor period.
The Ovt and Ovt-2 boxes display only if overtime hours are entered on the timesheet. |
Unit Quantities
Report Header
Even though you cannot record units on Navigator timesheets, the report will include units that are assigned using Vision Timesheet.
Column | Description |
---|---|
Employee |
The employee's identification number and name (Last Name, First Name) display here. |
Signed/Approved |
If you selected Require electronic signature when submitting timesheets on the Setup tab of Company Timesheet Configuration, the name of the employee who submitted the timesheet displays under theSigned line and the name of the employee who approved the timesheet displays under the Approved line. If you are not using the electronic signature feature, these lines are blank. In either case, you can use the lines for handwritten signatures if you wish. The current status of the timesheet also displays in this section, as follows:
|
Organization |
If you are using the Organization Reporting feature, the code for the employee's assigned organization displays here. |
Report Columns
Column | Description |
---|---|
Project |
This column displays the number of the project to which the employee is charging units. |
Phase |
This column displays the number of the phase for which unit quantities were entered, if applicable. |
Task |
This column displays the number of the task for which unit quantities were entered, if applicable. |
Unit |
The unit name to which the employee is charging units displays in this column. |
Unit Table |
The unit table to which the employee is charging units displays in this column, if applicable. |
Total |
In this section, the Total column displays total units charged to each individual project, phase, and/or task for the selected labor period. |
Day/Date |
There is a separate column on the report for each day in the selected labor period. Each column displays the day of the week and the corresponding calendar date. Within each column, there is a box for each project on the timesheet report. These boxes display the total units the employee has charged to each project, phase, and/or task for each day in the labor period. |
Daily Totals Section | |
Daily Totals |
In this section, the Total column displays total units charged to all projects, phases, and/or tasks for the selected labor period. |
Revisions
Column | Description |
---|---|
Revision | This column displays the timesheet revision number. Once auditing starts for a timesheet, the revision number is incremented each time changes to regular hours, overtime hours, or start and end times are saved, new timesheet rows are saved, or the timesheet is submitted or approved. |
Revision Date/Time | This column displays the date and time that the revision was saved or that the timesheet was submitted or approved. |
Updated by
Submitted by Approved by |
This column displays the name of the employee who made the revision.
Which of these three column names displays depends on the type of revision. |
Timesheet Date | This column displays the date from the timesheet row. |
Project | This column displays the project number from the revised timesheet row. |
Phase | This column displays the phase number from the revised timesheet row. |
Task | This column displays the task number from the revised timesheet row. |
Labor Code | This column displays the labor code from the revised timesheet row. |
Labor Category | This column displays the labor category from the revised timesheet row. |
Field | This column displays the field from the revised timesheet row for which the value was changed. If multiple fields were changed on a timesheet row as part of the revision, the report displays a detail row for each field that changed.
The fields for which revisions are audited are those for regular hours, overtime hours, and start and end times. |
Old Value | This column displays the value of the field before the revision. |
New Value | This column displays the value of the field after the revision. |
Revision Explanation | If an explanation was required for the revision, it displays in this column. |