Timesheet   

 

The Timesheet module provides the ability to add and modify individual employee timesheets using various features and options. Time may be entered daily in a format by week or day using a template, your current task list, or by copying from other timesheets. Time is posted to projects immediately and can be compared to budget or project estimates in real time.  

Time can be accessed from various areas within Webvantage such as from the Employee Menu (Timesheet Module),  Click here to view full listing of where and how Time can be entered.

Supervisor Approval can be enabled (setup is located in Advantage Maintenance) to require their employees to submit their timesheets to their supervisor for approval. Supervisor approval comments can be viewed from their timesheet.

If the Missing Time Service is enabled, employees and supervisors will be alerted when time is missing, based on settings established.  Click here to view the Missing Time Service User Guide.  

The Unity Menu is available in the Timesheet by right clicking in the grid. The Timesheet record that is selected must be at the job/component level.

Viewing a Timesheet

Adding Time

Stopwatch

Edit / Delete Existing Record

Copy To

Copy From

Copy from Projects

Copy From My Recent Assignments

Copy From My Recent Jobs

Copy from Time Templates

Copy from My Calendar

View Timesheet Details

Submit Timesheet for Approval

Printing Timesheets

Settings

Security and Setup


Viewing a Timesheet

From the Main Menu, select the Employee module and then select Timesheet. The initial view defaults to the time sheet for the individual for the current week. Any time that has been already entered for the current week is displayed. Use the vertical scroll bar to review all timesheet rows. The header toolbar will remain locked during scrolling to allow all of the header options to remain visible. Scroll to the bottom of the timesheet to view the daily totals or click on the Day view to see the totals for each Day in the header.

There are three methods that can be used to quickly search for an employee:

  1. Click on the Employee Search icon and double click on the Employee image/name

  2. In the search box, begin typing the employee's first or last name and once located, tab twice and press enter or click the Select button

  3. Click on the Employee Search icon, highlight the specific employee and click the Select button.


Adding Hours to a Timesheet

Productive and Non Productive time can be added directly to the Timesheet multiple ways from the Timesheet application. Click here to view full listing of where and how Time can be entered.

From the Timesheet application

Click the Save button or use the keyboard shortcut Alt + Shift + Enter to save entries or changes to the timesheet. Use the Cancel button to disregard.

Example:

A stopwatch is stopped with 51 minutes and 6 seconds.

51.1 minutes divided by 60 (60 minutes in an hour) = .8516666666.

The time entered for that task would be .85.

IMPORTANT:  Closed Posting Periods:  If the date selected falls within a General Ledger posting period that is closed AND the Agency option called Check for Closed Posting Periods is activated, a message is displayed stating This Posting Period is Closed then after the Refresh button is selected the Save and Add New buttons will not be available. This feature is in place to prevent posting time where the General Ledger posting period has been closed.

If the date selected falls within a General Ledger posting period that is closed and the Agency option
Check for Closed Posting Periods is answered No, time can be entered for any of those days in the week regardless if the period has been closed or not.
Approved Estimate Required

Adding / Editing time for certain functions can be restricted to Job/Component that only have an approved Estimate. This feature will prevent employees from adding / saving hours when the hours will cause the total hours posted to exceed the hours on the approved estimate quote for that function (not by employee). This option applies only to Productive Time.

The following must be setup in order to use the Allow without an Approved Estimate feature:

When activated, if the hours for the function being added or modified will exceed the approved estimate hours, a message can be displayed either as a warning that time will exceed approved amount or as a message that the time will not be added / modified. This message is a custom message setup in Agency Maintenance.

If a function is being added that is not included in the Approved Estimate, no message will be received.


Edit / Delete an Existing Record

Enter or select the Week of: date to edit using the instructions for Viewing a Timesheet. Any changes made to the Timesheet record from the grid must be saved. Click the Save button on the toolbar or use the Cancel button to disregard.

Options Menu

The Options Menu is located to the left of the time record. Click on the Options menu and select:

To view an individual day's time entries, click on the Day/Date in the column header. All records for that day are displayed. To view a different day's records, click on that Day/Date. To view the entire week, click on the Week button or click the Totals section, located after the days.

To view the Edit Time record, double click in the Hours input box. The Comments and Hours can be modified. When done, click the Save button or use the Cancel button to disregard.

For those entries that have jobs that have a process control that prohibits editing, a warning message will display on that row.

To edit the hours for existing record:

If hours have been entered for an incorrect job or function, delete the record using the Delete icon and enter a new record.

Editing Restrictions

Some time records may become non-editable / not available to delete.  

Time entries that meet the following conditions cannot be edited.

 

Item has been selected for billing.

Item has been billed.

Item is part of an Advance Bill record that is not yet processed.

Item has been adjusted or voided and has multiple entries (summary record).

Items that are contained in a closed posting period (If Agency option is activated).

Jobs or components that have been closed.

Job Component does not have an Approved Estimate when required (set on Job Component / Agency option is activated)

Time sheets (all items on related time sheets) that have either been sent to a supervisor for approval (Pending) or that have been approved by the supervisor (Approved).

Editing Options

 

New entries may be added to offset or correct existing entries that have become 'not editable' except when the time sheet is (Pending) approval or is (Approved) by the supervisor (optional feature Supervisor Approval must be activated).

Job Component does not have an Approved Estimate when required (set on Job Component / Agency option is activated)

Edit Comments

To view comments for the Time record, a comment box will display next to the hours. Hovering over the comment box displays that the entry has comments. To view the Comment, double click on the Hours to view the Time record. Comments can be edited in this window.

Delete a Timesheet Record

To delete a record, click the options menu at the beginning of the time record and select Delete. A message will display verifying that the record is to be deleted. Click OK to delete or use the Cancel button to disregard. This option is only available when the record is available to be deleted.

Deleting Multiple Rows

When multiple rows are selected, the delete option (red X) will be enabled. A message verifying that the record should be deleted displays. Click Ok to delete the timesheet record or use the Cancel button to disregard. This option is only available when the record is available to be deleted.


Copy To

Using this copy to feature will copy the Job, Job Component, Function, Category, Department and Hours from a previously entered timesheet, for the current employee, to a selected week. Includes option to copy the entire timesheet to another timesheet. This option is ONLY available if the Agency option Advantage | Maintenance | General | Agency - Timesheet Options tab - Use copy timesheet feature is CHECKED. The Copying From My Projects and My Time Templates are still available regardless if this option is selected or not.

When entering time for another employee, the available timesheets will be for the other employee, not for the employee that is logged into the system.

Exceptions:

From the Employee application menu Select Timesheet. Enter or select the Week of: date for the new time being added using the instructions for Viewing a Timesheet.

Use the Calendar to select the week to apply the time records to. Cannot copy time records to the same week that they are being copied from.

When completed, click the Copy button to copy the timesheet currently being viewed to the week selected in the calendar. Click on the Options menu in each timesheet row to Change Function or Add/Change Assignment.

The records will update and display on the timesheet.

Copying Selected Rows

To copy only selected rows to another timesheet:


Copy From

There are five additional ways to create new timesheet records using existing data.

If any of the data in a timesheet is no longer valid (i.e.: inactive department code), the record will not be copied.

Copy From Projects

Copy From My Recent Assignments

Copy From My Recent Jobs

Copy Time Templates

Copy From Calendar

 

Copy From Projects

Using this copy feature will copy the Job, Job Component, Task, Function Category, and Department from the outstanding project schedule task list for the current employee.  The hours are not copied, but must be entered and saved on the new timesheet. Timesheets can not be copied to a date within a closed posting period. Another employee's tasks are not available to be copied.

When entering time for another employee, the available Projects will be of the other employee, not for the employee that is logged into the system.

Select the Copy From button on the toolbar and select Projects to display a list of Projects to be copied from. All tasks which are currently due for this employee will display. Tasks for future dates will not display here until the Start Date of the tasks is prior or equal to today's date. Use the text filter to narrow down the projects.

Copy From My Recent Assignments

Using this copy feature will provide quick access to the 10 most recent assignments accessed by the employee. Once the assignment details page has been opened, the assignment will be displayed in the recent list of assignments.

Select the Copy From button on the toolbar and select My Recent Assignments to display a list of the 10 most recent Assignments to be copied from. The last 10 Assignments accessed by the employee will be displayed.

Copy from My Recent Jobs

Using this copy feature will provide quick access to the 10 most recent jobs accessed from the PMD. Once the job details page has been opened, the job will be displayed in the recent list of jobs.

Select the Copy From button on the toolbar and select My Recent Jobs to display a list of the 10 most recent Jobs to be copied from.

Copy From Time Template

Time Template allows for the creation of a pre-defined Job / Component / Function Category / Department / Default Comment and Hours template to be used as a quick way to enter time. This template is handy for repetitive time entries for the same Job, Component and Function / Category. Each employee must setup their own Timesheet Template Record.

To set up or edit Time Templates, click Time Template Options (gear icon).

Select the Copy From button on the toolbar and select Time Template to display the Time Templates displaying a list pre-defined Timesheet Template Records.

Time Template Options

The Time Template Options link displays the Copy From Templates Options popup. It displays all Templates. Three icons are displayed in the Toolbar: New (plus sign), Delete (X) and Refresh.

Add a New Timesheet Template Item

To create a new template, click the New button on the toolbar. On the New Template Item popup, enter the following information:

When done, click the Save button to create the timesheet template. To discard all entries prior to Save, click the Clear button. To exit without saving, click the Close button.

Modify a Time Template Item

Modification of a Timesheet Template Item can be done from Copy From Time Template Options The Job / Component cannot be modified.

To change the Function Category or Department, select the new option from the dropdown. Modify the Default Comment and Apply Hours as needed. When all fields have been updated, click Save at the end of each row. To save multiple changes at the same time, click the Save button on the column header. To discard any changes prior to saving, click the Refresh button.

Delete a Template

To delete a Timesheet Template Record, click the Delete icon (red x) at the end of each row to be deleted. A message will display to verify that the Timesheet Template Record is to be deleted. Click OK button to delete the record or click the Cancel button to not delete the record.

To delete multiple Timesheet Template Records, select multiple items using checkboxes at the beginning of each row and click the Delete icon in the Toolbar. A message will display to verify that the Timesheet Template Record is to be deleted. Click OK button to delete the record or click the Cancel button to not delete the record.

Copy From My Calendar

Using this copy feature will allow appointments/events from the Employee's Google, Outlook or Internal calendar to be imported to Timesheet. Calendar Type and related settings must be setup in order to use this feature. Click here for Calendar setup information. A message will be displayed when not setup correctly.

To delete a Calendar Time entry, click the Delete icon (red X) at the end of each row.

To delete multiple rows, click the "Select All" checkbox or select individual rows and click the Delete icon (X) in the ribbon bar.

To insert Calendar Time records into Timesheet, select the row(s) by checking the Select All checkbox or by checking each of the rows.  A single day or a concurrent range of days may be selected.

In the Timesheet, drag and drop the new calendar records into the timesheet.

Once a Calendar Entry record has been dragged and dropped into the timesheet, that record is no longer available in Get Calendar Time.

Calendar Time Settings

To change the Calendar Time Settings, click the Settings/Options button. Update the settings as needed and click the Save Settings button to save the changes.


View Estimate and Schedule Information

To view QvA Drill Down or Schedule Information for a job, click the Options menu and select View Details (magnifying glass) icon to access the Estimate and Schedule Info on the Timesheet Details popup.

Estimate and Schedule Info section

Quote Vs. Actual Information

This view will display actual hours posted against the job compared to what was on the Estimate. When the 'Employee Only (Displays quoted and actual hours by employee)' is selected, it will default to only the employee logged into Webvantage. To view for all employees, uncheck the Employee Only checkbox.

If Employee Only was not checked, Others will display in the Date column. Others refers to the Actual Hours entered for all other employees.

View Schedule Information

To View Schedule Information, select Schedule Hours. The Schedule Hours Information window will display immediately. This view will display actual hours against what was entered for the Schedule.


Submit Timesheet for Approval

The Submit for Approval option is utilized on an individual date basis. The individual employee may enter the hours worked and submit the hours for Supervisor Approval. Once the Supervisor approves or denies the Timesheet, the employee can view the status and comments within the Timesheet application. Setup is required.

To submit Timesheet for Supervisor Approval, click the Set Approval (Submit/Un-submit time for Supervisor Approval) button. The Timesheet Approval screen displays the approval status and action link for each day of the week being viewed.

If Comments are required during time entry, all comments must be added in order for the timesheet to be submitted for approval.

 The Timesheet will be available for approval from the assigned supervisor (based on the supervisor code in the Employee record).

Timesheet records that have been Approved are unable to be un-submitted. To view Approved Timesheets comments, click the Comment icon.

Once the supervisor approves, denies or enters Approval Comments to a pending Timesheet record, the Supervisor comment is available. Click the Comment icon to view the Supervisor Comments. To close the Supervisor Comments, click the Close button.

To edit a Timesheet that is in a pending or denied status click the  Unsubmit Week or Pending button.

To edit a Timesheet that has been submitted for approval or denied, click the Pending button for that day or click the Unsubmit Week button. This will remove the Timesheet from the Supervisor Approval queue and place it back into a 'Submit-able' status.

Once the Timesheet has been edited, resubmit the timesheet for approval.

Approved time cannot be edited.  Approved time may only be edited by the supervisor from the Supervisor Approval screen in Advantage.

When the Timesheet Approval Status has been updated, the Supervisor may elect to send an Alert notification. A link is included in the Alert that will open the Timesheet application for that day.


Refresh

Click the Refresh button or use the keyboard shortcut Shift + r  to refresh the timesheet record. Any unsaved changes will be discarded.


Printing Timesheets

To print the Timesheet, click the Print button to display a print window.

Report Type

On the print Timesheet popup, select to print either a Summary or a Detail with Comments report.

Summary - The Summary report will always include Saturdays & Sundays even if there isn't any time entered for those days, regardless if the days to display is set to 1, 5 or 7 (in My Timesheet Settings / Agency Timesheet Settings).

Sort By - Select if the timesheet print should be sorted by Client, Division, Product, Job/Component, Function/Category, Department or none.

Detail with Comments - When the Detail with Comments is selected, enter or select from the Calendar the Start Date and End Date to be included when printing the Timesheet. This report will include Saturdays & Sundays if hours were entered for selected days, regardless of the number of days to display. The Detail Report provides timesheet details broken out by day and sorted by job component in ascending order.

Exclude Employee Signature - The Timesheet will automatically include the employee signature and date the Timesheet is printed. To exclude the employee signature, check the Exclude Employee Signature checkbox on the print window. The Employee Signature is maintained in Advantage Maintenance.

The signature is for the employee that is logged into Webvantage, not of the employee whose Timesheet is being printed.

Once selected, click Print to generate the Timesheet report in a PDF format.


Settings

Initially, settings are dependent on what is selected as the default display days in Webvantage | Maintenance | Project Management - Agency Timesheet Settings.  Any modification to the settings through the Timesheet module is saved per individual user. Click on the Settings button or use the keyboard shortcut Shift + e to open the settings.

Time Entry

Week View

Description Display Options

Check to display following in Timesheet:

When done, click the Save button. Use the Cancel button to disregard changes.


Security and Setup