The Summarized Timesheet report provides an overview of timesheet entries for a single employee for a timesheet period.
The report includes only summary data for hours that are entered on the employee's timesheet. If revision auditing is enabled for the employee, you can also include revision information on the report.
You print or preview this report in Timesheets by clicking
on the Timesheets form. This generates a PDF file that you can print and save. You can also click
on the Timesheets form to set up the report to generate automatically when you submit a timesheet.
Report Header: Summarized Timesheet for the Period Ending <Date>
The heading lists the timesheet period, the date the report was printed, and the employee's company.
Field | Description |
Employee
|
This field displays the employee's identification number and name (Last Name, First Name).
|
Signed/Approved
|
If
Employee Signature Required is set to
Yes in
, the name of the employee who submitted the timesheet and the date and time when it was submitted display above the
Signed line.
If
Use Time Approvals is set to
Yes in
, the name of the employee who approved the timesheet and the date and time when it was approved display above the
Approved line.
If
Employee Signature Required or
Use Time Approval is set to
No, the name of the employee who submitted or approved the timesheet displays below the
Signed or
Approved line. You can use the lines for handwritten signatures.
The current status of the timesheet also displays in this section:
-
Draft Copy: The timesheet is In Progress.
-
Submitted: The timesheet has been submitted for processing but has not yet been approved.
-
Approved: The timesheet has been approved and is ready to be posted.
-
Posted: The timesheet has been posted to your database.
|
Organization
|
If you use organizations, the code for the employee's assigned organization displays here.
|
Report Columns: Timesheet Contents
Field | Description |
Project
|
These columns display the number and name of the project to which the employee is charging time.
Items in these two columns display on the report in the following order:
- Special categories always display first. The order in which they display is determined by the sequence numbers you assign them in the Timesheet Special Categories form on the Time Categories tab in Time Settings. A special category displays on the report only if hours and/or comments have been entered for the category. For each special category, the category name shows in both columns.
- Projects (and phases and tasks) display in descending order. Phase and task numbers (if applicable) are shown below the project number and name.
|
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
|
This column displays the labor code number to which the employee is charging time.
|
Labor Category
|
This column displays the labor category for which the employee is charging time. Labor category information displays on the report only if you are using Accounting, Billing, or Resource Planning.
|
Project 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
Allow Project's tax locale to be overridden on Timesheet is selected in
in the desktop application, and the employee's
Locale Method is set to
Follow Project Locale on the Payroll tab of the Employees hub.
|
Total Hr
|
This column displays total regular and/or overtime hours charged to each individual project, phase, and task for the selected labor period.
- Total regular hours display in the
REG row.
- Total overtime hours display in the
OVT row.
- Total secondary overtime hours display in the
OVT-2 row.
The
OVT and
OVT-2 rows display only if overtime hours are entered on the timesheet.
|
Day/Date
|
The report has a separate column for each day in the selected labor period. Each column shows the day of the week and the corresponding calendar date.
The regular, overtime, and secondary overtime hours that the employee has charged to each project, phase, and/or task for each day in the timesheet period display in the
REG,
OVT, and
OVT-2 rows.
The
OVT and
OVT-2 rows display only if overtime hours are entered on the timesheet.
|
Daily Totals: Timesheet Hours
Field | Description |
Daily Totals
|
In this section, the
Total column displays total regular, overtime, and secondary overtime hours charged to all projects, phases, and/or tasks for the selected labor period.
|
Unit Quantities
Report Header: Unit Quantities
The report includes units if they were entered on the timesheet.
Field | Description |
Employee
|
The field displays the employee's identification number and name (Last Name, First Name).
|
Signed/Approved
|
If
Employee Signature Reqiured is set to
Yes in
, 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:
-
Draft Copy: The timesheet is In Progress.
-
Submitted: The timesheet has been submitted for processing, but has not yet been approved.
-
Approved: The timesheet has been approved and is now ready to be posted.
-
Posted: The timesheet has been posted to your database.
|
Organization
|
If you use organizations, this column displays the code for the employee's assigned organization.
|
Report Columns: Unit Quantities
Field | Description |
Project Number
|
The first column on the report displays the number of the project to which the employee is charging units.
|
Phase
|
If you are using phases, the phase number to which the employee is charging units displays in this column.
|
Task
|
If you are using tasks, the task number to which the employee is charging units displays in this column.
|
Unit
|
This column displays the unit name to which the employee charged units.
|
Unit Table
|
This column displays the unit table to which the employee charged units.
|
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. These columns display the total units the employee has charged to each project, phase, and task for each day in the labor period.
|
Daily Totals: Unit Quantities
Field | Description |
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
This revision information only displays on the report if revision auditing is enabled for the employee and if you selected the
Include Revision Audit Report check box on the Print Report dialog box or, for automatically generated reports, the Timesheet Settings dialog box.
Field | 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 Day/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 number from the revised timesheet row.
|
Labor Category
|
This column displays the labor category number 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.
|